Oracle DBA candidate in Redmond, Washington, United States

Summary

Certified Oracle DBA with 8 ½ years of experience and Certified Oracle cloud (IaaS, OCI, DBCS & IDCS), (WebLogic, Web Tier (OHS, Apache), DBA (RAC, Data Guard) and MS SQL DBA and Enterprise Manager Cloud Control on Unix/Linux.

Worked on diversified application areas such as ERP, Medical and shipping etc.

Proficient in analyzing and translating business requirements to technical requirements and architecture of the database design.

Extensive experience in RMAN setup, cloning & configuration for backup, restore & recovery maintenance, high availability solutions like Data guard, Streams.

Expertise in solving complex performance issues along with production support knowledge.

Expertise in installation of Oracle on standalone/RAC environment on various Operating Systems and migration or upgrade from one version/platform to another as well as migration of standalone database to RAC and vice versa.

Hands-on with logical database, schema, object refresh and maintenance of database storage and infrastructure using cron jobs.

Experience in configuring & implementation of high availability solutions like Data guard, Streams, Mirroring, Always On implementation and troubleshooting the same.

First-rate skills in database administration, backup and recovery activities, performance tuning of Oracle RDBMS using STATPACK/AWR/OEM/Trace and tkprof.

Experience in Undo optimization, making remedial measures for TEMP and memory pool issues to improve application processes performance. This includes rebuilding and review of database objects and tuning of SGA, open threads, cursors.

Expertise in installation, Upgrade and migration of Oracle and SQL Server Databases. Hands-on with upgrade of oracle database versions from 10g, 11g to 12c ,19c & EXADATA

Extensive experience in planning Backup/Restoration strategy - hot, cold or logical backups and performing incomplete or complete recovery using user managed backups.

Managing Database Structures, Storage Allocation, Constraints, Database Access, Roles, Privileges, user auditing & schema design were in-practice.

Experience in administering, configuring & migration of Oracle Enterprise Manager (OEM) till latest of version 13c. Played key role in implementation of latest version install.

Database cloning on 11g, 12c and 19c.

Database patching on 11g, 12c and 19c.

Backup and recover the database.

Maintains database system security

PDB and CDB database creation.

Experience in troubleshooting Golden Gate issues by investigating replication failures using ggserr.log, report files.

Configure error handling for restart, logging, production support and status reporting in Golden Gate.

Trouble shooting and performance tuning Golden Gate replications.

Deep understanding Oracle GoldenGate internal mechanism, OGG new features such as Integrated capture, native DDL capture, coordinate apply mode, multi-threaded replicate.

Configure and build Golden Gate Extracts/replicate for multiple databases.

Oracle Database migration from Solaris to Exa server.