OBJECTIVE:

To obtain a challenging position in Database Administration that utilizes my skills to contribute to the company's success.

SUMMARY:

• Over Eleven plus years of expertise in Real Application Clusters (RAC), CRS resource management and Cluster management.
• Extensive performance tuning experience, specializing in instance tuning.
• Expert in Database management and storage management.
• Team lead for IPD Change DBA Team and recognized for excellent written and verbal skills.
• OS: Experienced with multiple platform like AIX, Linux, HP - UX, Solaris and open VMS.
• CRS: Extensive experience in Installing, upgrading, patching and troubleshooting.
• CRS resource management: Experienced in Adding/Deleting/Relocating Instances, DB, Listener, Node apps, Services.
• Managing OCR and Vote disk backup.
• Clusters: Experienced with managing HACMP on AIX, Service Guard for HP-UX and Clusterware on Linux.
• Migration expert in Migrating databases from 10.2.0.5 to 11.2.0.2 and 11.2.0.2 to 11.2.0.4 and 11.2.0.4 to 12.1.0.2 on all platforms using GoldenGate software and Oracle Datapump.
• Clusterware: Installed 10gr2, 11gr2 and 12c RAC clusterware.
• GoldenGate: Experienced on GoldenGate 10/11/12 version in configuring extract and replicate process and troubleshooting.
• RDBMS: 9i/10g/11g/12c - Extensive experience in installing, upgrading, patching and troubleshooting.
• Database creation: Experienced with RAC database and Standalone database.
• ZDLRA: Worked extensively on backup remediation and ZDLRA on boarding as part of strategic team, remediating and on boarding restoring very large databases (100 TB +)
• Database Restore: Experienced in using Expdp/Impdp, RMAN and ZDLRA for building Standby Database, Reporting Database, PITR, Platform Migration.
• Backup and Recovery: Experienced in using Export/Import, RMAN,ZDLRA with MML VERITAS Netbackup, EMC Networker.
• Disaster Recovery: Experienced with Dataguard setup, Physical and Logical standby database creation.
• Storage Management: Experienced with LVM (RAW device) and ASM, SAN Migration and Vormetrics Encryption.
• Character set conversion.
• Installing OEM agents and maintaining databases using GRID Control, Installed 12C GRID Control.
• Managing:
• Creating Change requests and Service requests internally for any Production change and also raising Oracle OneStop SR's and General SR's.

EXPERT IT SKILLS:

Database Systems: Oracle 9i, Oracle 10g, Oracle 11g, Oracle 12c Clusterware, DB Administration and Management.

Languages: HTML, SQL, PL/SQL, shell scripting.

Operating Systems: Windows, HP/UX, Solaris, AIX, RHEL

Platform: HP RX servers, HP blade server, Alpha servers, IBM blade servers, IBM Power series, Solaris, HP, Storage XP and EVA

Tools: /Utilities: OEM, GoldenGate, Toad, NMON, OSW, RDA, Prowatcher, Remedy, Siebel, Navigator, Erwin, Vivio.

EMPLOYMENT HISTORY:

Confidential, Columbus, OH

Oracle DBA

Responsibilities:

• Migrated databases from 11.2.0.4 to 12C using Oracle Datapump.
• Installed Oracle 12C RAC Database and created Standby Databases using active duplicate method.
• Upgraded several RAC clusters to 11.2.0.4 from 11.2.0.2 and upgraded several databases to 11.2.0.4 using manual upgrade method.
• Applied PSU patches on 11.2.0.4 GRID and RDBMS homes.
• Restored Standby Database by taking incremental backup from Primary Database to fix out of sync issue in 12C using service name method.
• Did switchover of several database during patching to avoid outage.
• Improved performance of databases by introducing partition strategy in bid OLTP databases.
• Resolved several production issues by working directly with Oracle Support and ensured the high availability of databases all the time.
• Troubleshoot databases, provide reports on the database health check, capacity plan follow up and recommendations.
• Worked closely with Application Development team to fix the performance issues related to "row lock contention" caused by delete batch job by introducing partition strategy.
• Resolved DB hang issue due to Redo log configuration issue by assigning extra DB writer process in mission critical application.
• Did failover of database due to storage issue and rebuilt the standby using Active duplicate method.
• Applied several one off Patches for Bug fixes.
• Worked on several mission critical code deployment and major releases and monitored health check of databases.
• Participation in an On Call rotation to provide database support for resolving production issues.
• Worked with Oracle support in resolving business critical issues.
• Monitored databases using 12C Grid Control (OEM)
• Worked on RMAN backup and restore strategies.

Environment: Oracle 10g/11g/12C RAC, GoldenGate, ASM, RMAN,EXPDP,IMPDP,ACFS,OEM12C,TOAD,AIX,LINUX,SOLARIS,Dataguard,AWR,ADDM.

Confidential, San Antonio, TX

Oracle DBA

Responsibilities:

• Participating in code and design reviews to ensure quality and conformance to product standards.
• Participate in Oracle Best Practices and new product web presentation.
• Installed 10g/11g databases and Client on RHEL and other win/*nix platform.
• Configure ASM packages on Linux.
• Manage ASM disk groups via ASMCMD and database control.
• Troubleshoot RAC issues with olsnode, crs stat, crs register, crs unregister, crsctl, cssd, crsctl, srvctl etc.
• Multiplex OCR and Voting Disk to different location for higher availability.
• Reconfiguring Services via srvctl utility.
• Worked with Oracle to solve multiple RAC issues.
• Configured and Administered Oracle 10g/11g RAC high availability on ASM.
• Upgrading database from Oracle version 10g to 11g.
• Optimal sizing of Instance memory pools like SGA, db buffers, shared SQL area, log buffer based on the requirements.
• Maintained different homes for Oracle 10g/11g and ASM.
• Created and maintained additional ASM diskgroups according to necessity.
• Build and configure physical standby Dataguard.
• Database cloning/refresh from Production to Production reporting, Backup and SIT.
• Implemented and Maintained full, incremental and cumulative RMAN backups using crontab.
• Monitoring various scripts and alert log files to ensure that Dataguard and the database are healthy.
• Monitoring and troubleshooting space related issues.
• Implementing Oracle security as per the company standards.

Environment: Oracle 10g/11g RAC, Dataguard, OEM, RMAN, AIX,TOAD

Confidential, Laurel, MD

Oracle DBA

Responsibilities:

• Perform backup and recovery activities on RAC databases;
• Experience in taking backup of OCR.
• Experience in adding and removal of nodes in a RAC environment.
• Daily database administration tasks including backup and recovery through RMAN, Import/Export.
• Performed data transfer using command line as well as interactive mode and through Datapump.
• Designed the database schema and created any necessary database objects.
• Monitor production and non-production database through Grid Control, Optimize queries, startup shutdown and configure agents to communicate with grid control for various maintenance tasks.
• Configure and maintain Grid Control Repository and Deployed OMS Agents on different database servers.
• Added nodes to the RAC cluster for the increased load balancing and removed it.
• Applied patches or upgrades to database as needed.
• Created number of Linux shell scripts for various tasks.
• Worked with Oracle Metalink in case of problems.
• Performance Tuning of Application/Database using various Oracle tools like SQL trace, TKPROF, Explain Plan, AWR, ADDM.
• Tuned memory structure such as the database buffer cache, shared pool and library cache.
• Setup physical standby database to protect mission critical from any failures, errors or corruption.
• Configured ASM for RAC setup and non RAC databases.
• Worked closely with application developers and system administrators to ensure all databases needs are being met.
• Managed databases with size more than 2 TB.
• Used TOAD for various database Administration tasks.
• Applied various database and Application patches.
• Used Grid Control for Backup and Recovery tasks.
• Solved database connection issues using Oracle Net Services.
• Applied various patches which includes quarterly critical patch.
• Update Oracle clients as per application needs.
• Applied DST patches on multiple platforms.
• Configured Agents on different platforms to communicate with Grid Control.
• Configured and maintained Grid Control Repository.
• Configured Listener from multiple homes in one server.
• Provided full DBA support for Oracle Applications in Production, Test and Development environments.
• Worked closely with Oracle for Dataguard implementation and other major issues.

Environment: s: Oracle 9i/10g, RHEL 4, IBM-AIX 5L, OEM (Grid Control), RMAN, RAC, Dataguard, ASM, PL/SQL, TOAD and SQL *PLUS