Occupation:Database Administrator |
Location:Beaverton, OR |
Education Level:Bachelor |
Will Relocate:YES |
Description
Experience Summary 6 years of total IT experience as an Database Administrator (DBA){Oracle & Informix} supporting the databases and ensuring their performance, availability and security, with expertise in Event and Incident Management for database event for Oracle, Sybase & MS-SQL with actual participation in CSI and Incident Management Call Professional Summary Company: Cognizant Technologies Solutions India Pvt., Ltd Client: TSL Virage Job Profile: Informix Database Operations Duration- From Aug 2014 to Nov 2017 Responsibilities: * Responsible for handling critical event and incident through HP service manager tool * Performed startup & shutdown procedures. * Manage database initialization parameters. * Manage resource allocations and structures (memory, disk, dbspaces etc.), chunk addition, disk space monitoring, backup location monitoring etc. * Managing user accounts, privilege, roles and resources. * Performed standby database failover procedures * Performed database table and index fragmentation * Performed database refreshes: Refreshed included database refresh, table & instance refresh * Monitored & resolved issues related to database locks, database connectivity, database availability, resource allocation. * Monitored Shared memory hung issues. * Monitored space usage within database and extend space when required * Performed Database patching activity * Performed restore tests on servers as per request from backup team. * Resolved failures of ONBAR job/backup hanging issues. Company: Cognizant Technologies Solutions India Pvt., Ltd Client: Credit Suisse Job Profile: Database Operations Duration- From Aug 2012 to Aug 2014 Responsibilities: * Responsible for handling critical event and incident through BMC Patrol Agent tool monitoring to ensure 24/7 availability * Daily database health-check which includes space on tablespaces as well as on mount file systems, daily backups, trimming of various logs and trace files, trimming arch file systems. * Managing Database Mount Points on UNIX going beyond the warning level like 90% used space. * Routine checks of logs and trace file for database activity and for any issues during production hours * Daily / Weekly / Monthly backup and maintain of Production/Development database through CTRL M job scheduling tool * User ID management like locking, expiring password issues and resolving security issues related to logins, database users, and application roles * Expertise in RMAN related activities like handling database backups, restoring and recovering database * Database refreshes using Production backup on Test and Development environment * Creating Service Request to Oracle Support for critical issues like ora-600 * Resolving business user's technical queries pertaining to the Database. * Discuss performance issues with application developers if required involve the Incident Management team like MIM( Major Incident management), Crit Sit mgmt. (Critical Situation management team) via a chat rooms and the Bridge calls * Working on with the team for OLA/KPI management * Continuous Service Improvement (CSI) review with the L2 team and stakeholder to reduce the event hit on the monitoring tool Company: Cognizant Technologies Solutions India Pvt., Ltd Client: Barclays Capital Job Profile : Oracle DBA (Event Management) Duration- From August 2011 to July 2012 Responsibilities: * Responsible for providing business critical Incident Management and Event Management * Responsible to escalate Oracle and MS-SQL and Sybase alerts with in SLA. * Worked with L2 Team for closing critical alerts on priority basis. * Captured alert details and create INC to L2 Team. * Monitor Transaction terms jobs. * Making Daily reports. * Analysis to remove non production and Development alerts. * Worked on BMC BEM monitoring tool. * Worked on ITSM tool * Continuous Service Improvement Review * Reporting and analytics - Ad hoc reporting * Hotline Management * OLA/KPI management * Stakeholder Meeting
Accomplishments
Highlights:
Keywords
