SUMMARY

• 5 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
• IT Professional with 3+ years of experience as an Oracle DBA.
• Experience in database administration for production, development and test databases.
• Experience in Monitoring the Oracle Performance
• Good in RMAN backups.
• Expertise in Logical backups and Physical backups.
• Used OEM / BMC Explorer for database monitoring.
• Analyzing and resolving the issues related to table spaces (Undo & Temporary) in Oracle 10g and 11g.
• Experience in administering database security by creating users, grant/revoke roles, privileges to the users, creating and assigning profiles to the users.
• Implemented features like Database refresh and Cloning using cold backup and RMAN.
• Worked in the team of support spans across database, technical, functional, operating system with strict adherence to the predefined service level agreements in providing 24x7 remote support.
• Good communication and interpersonal skills. Highly motivated with strong commitment to quality and customer service.
• IT Professional with 2 years of experience as an Informix DBA.
• Experience in database administration for production, development and test databases.
• Good in Performing Startup / Shutdown procedures
• Performing standby database failover procedures
• Performing database refreshes, fragmentation,database audits.
• Managing resource allocations and structures (memory, disk, dbspaces etc.), chunk addition, disk space monitoring,backup location monitoring etc
• Performing database patching activity.

TECHNICAL SKILLS

RDBMS: ORACLE 10g, 11gTools Oracle Enterprise Manager, Sql *Plus, RMAN, Exp, Imp, Expdp, Impdp,BMC Remedy,HP Service Manager, TTRS (Testbed task request system) tool,Service now

OS: Linux, Windows 2000/2003/2008 , HP-UX

Languages: SQL, Unix Shell scripting

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Responsible for handling critical event and incident through HP service manager tool
• Performing 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.
• Perform standby database failover procedures
• Perform database table and index fragmentation
• Perform database refreshes: Refreshed included database refresh, table & instance refresh
• Monitoring & resolving the database locks,database connectivity issues,database availability issues,resource allocation.
• Monitor Shared memory hung issues.
• Monitor space usage within database and extend space when required
• Performing Database patching activity
• Performing restore tests on servers as per request from backup team.
• Resolving failures of ONBAR job/backup hanging issues.

Confidential

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

Confidential

Oracle DBA

Responsibilities:

• Responsible for providing business critical Incident Management and Event Management
• Responsible to escalate Oracle and MS-SQL and Sybase alerts with in SLA.
• Work with L2 Team for closing critical alerts on priority basis.
• Capture 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