Database Administrator
Atlanta, Georgia, United States
• Installed and configured of GoldenGate on 11g/12c and 19c database for data replication.• Upgrade Oracle GoldenGate from 11gR2 to 19c. Implement OGG 19c new features in mission-critical production environments.• Wide-ranging experience in upgrade from 11g, 12c and 19c.• Experience using OEM for performance tuning in 13c.• Implementation of high availability solutions with 9i, 10g, 11g and 12c RAC, disaster recovery.• Diagnosed and resolved performance issues associated with SQL tuning and resource contention.Including locks and deadlocks.• Designed a high-performing database by creating multiplex control files, mirroring redo logs usingredo log groups and configuring table spaces.• Perform hot, cold backups and setup/utilize RMAN for backup and recovery.• Configured ASM on Window on development boxes and recommended implementation on Production sites as a High Availability feature.• Implementation and Configuration of Oracle Golden Gate replication.• Created user accounts and granted them appropriate roles and disk quotas for production usage.• Infrastructure (Physical and Logical Standby) using Oracle Active Data Guard, Materialized views,Golden Gate. The projects involve replication across geographical time zones.• Managed various users’ sessions both UNIX and WINDOWS environments.• Installed Oracle Software/Grid Infrastructure on UNIX and Windows platforms.• Setup jobs; create packages, triggers, functions and notification alerts.• Patch oracle databases with the latest Patch Security Updates (PSUs).• Perform daily administration task including managing system security, data integrity, monitoring anddeployment of objects in production.• Experienced in using database features such as Data pump, Flash-Back, AWR, ADDM & ASM.