Experience Summary: • Over 12 Years of experience in IT Industry exclusively as an Oracle DBA. • Duties included database creation, up-gradation, Patching ,cross platform database migration, database tuning/reorganization, SQL statement tuning, backup/recovery, general troubleshooting, script development, and documentation. • Established best practices and best procedure for database administration & maintenance. • Implementation, administration & maintenance of DELL Shareplex Replication. • Setup, administration & troubleshooting of Oracle Goldengate 11g & 12c replication both one and bi directional. • Expert in Oracle clusterware RAC 11.2 & 12.1 Installation, configuration, administration & troubleshooting. • Setup and administration of Physical & Logical standby DR setup, 12c Snapshot Standby, 12c Active data guard, bi-direction stream replication. • Manage Backup and Recovery Program for Oracle Databases using RMAN & Storage solution EMC Replication Manager and NetApp. Performed several complex recovery scenarios. Performing and troubleshooting database backup, recovery & cloning using RMAN. • Proficient in sql tuning – SQLT, explain plan review and recommendations. • Experienced in 24x7 database production support. • ASM administration and migration of non ASM database to ASM using RMAN. • Expert in Oracle OEM 12c Cloud control- configuration, managing OMS. • Technical design and architecture for Exadata systems, Exadata expert with network, system administration, storage. • Provide technical troubleshooting on issues requiring rapid resolution related to Oracle Engineered Systems, Exadata Patching & general troubleshooting. • Migrating database to Oracle Exadata X6 Model. • Managing 800 databases & administration of large DW databases of sized 20TB. • Experience as a Database Administrator for Oracle 10g, 11g, 12c. • Experienced with RAC/ASM, 12c Pluggable databases, Advanced partitioning. • IT Security policy enhancement, Implementation of PCI & SOX compliance. • Oracle 10g, 11g,12c RAC Database administration, configuration and maintenance. • Proficient in structuring complex SQL queries, • Strong SQL performance Tuning experience. • Experienced in leading several critical DBA related projects. • Expert in Database Export/import, RMAN cloning, duplication, DR setup. • Expert in oracle database migration, upgrade & patching. • Database Tuning – Expert in Oracle database tuning, Tuning Applications, Tuning Memory, and Tuning Disk Usage. • Proficient in UNIX Shell scripting. • Implementation of LDAP , Active Directory tool. • Strong Troubleshooting, Problem solving, Analytical & Design Skills. • OEM Cloud upgrade to 13c. • Worked in Oracle Database Administration, Maintenance, Creation, Configuration, Installation, Up-gradation, Patching, Cloning, Migration, Performance Tuning, Backup/ Recovery, Troubleshooting and other core DBA related activities.
©