Oracle Goldengate Consultant
Job Description
Oracle Database Administrator GoldenGate Specialist Onsite
Location USA Onsite
Experience 8 - 15 Years
Employment Type FullTime
Shift Customer Business Hours Production Support Coverage
Role Summary
We are seeking an experienced Oracle Database Administrator DBA with deep expertise in Oracle GoldenGate to support missioncritical enterprise applications and largescale database environments The role will be responsible for Oracle database administration GoldenGate replication architecture performance optimization disaster recovery planning database migrations and ensuring high availability of businesscritical systems
The ideal candidate should have strong experience managing Oracle databases in complex enterprise environments including Oracle RAC Data Guard Exadata and GoldenGate implementations supporting realtime data replication and migration initiatives
Key Responsibilities
Oracle Database Administration
Administer monitor and maintain Oracle Database environments 12c 19c and above
Install configure patch upgrade and maintain Oracle databases across Production DR UAT and Development environments
Manage Oracle RAC ASM Data Guard and Exadata platforms
Perform capacity planning storage management and database health assessments
Implement and manage RMAN backup restore and recovery strategies
Ensure database security compliance and governance standards are maintained
Oracle GoldenGate Administration
Design implement configure and support Oracle GoldenGate replication solutions
Manage Extract Pump and Replicat processes across heterogeneous environments
Monitor replication performance and resolve latency synchronization and data consistency issues
Configure bidirectional and unidirectional replication architectures
Support zerodowntime database migration and cutover activities using GoldenGate
Perform GoldenGate patching upgrades performance tuning and troubleshooting
Lead replication testing validation and disaster recovery exercises
High Availability Disaster Recovery
Design and support High Availability HA and Disaster Recovery DR solutions
Plan and execute Data Guard switchovers failovers and role transitions
Ensure replication integrity and business continuity across primary and DR environments
Conduct periodic DR drills and validate recovery processes
Performance Incident Management
Troubleshoot complex database and replication issues
Perform Root Cause Analysis RCA and implement permanent corrective actions
Analyze AWR ASH OEM and GoldenGate reports to optimize database performance
Participate in critical incident Major Incident Review MIR and Post Incident Review PIR calls
Provide proactive monitoring and preventive maintenance recommendations
Migration Transformation Initiatives
Support database migration projects involving Oracle DB2 Exadata cloud and hybrid environments
Participate in application modernization and cloud migration programs
Develop migration runbooks cutover plans and rollback strategies
Ensure successful execution of database and replication migration activities with minimal downtime
Stakeholder Management
Act as the primary onsite DBA liaison for customer teams architects infrastructure teams and application owners
Coordinate with offshore database and middleware teams
Provide technical guidance mentoring and operational oversight
Participate in governance architecture and operational review meetings
Required Technical Skills
Oracle Database
Oracle Database Administration 12c19c21c
Oracle RAC
Oracle Data Guard
Oracle ASM
Oracle Enterprise Manager OEM
RMAN Backup Recovery
Performance Tuning
Database Security Auditing
Database Upgrades and Patch Management
Oracle GoldenGate
Oracle GoldenGate Administration
GoldenGate Microservices Architecture
Replication Design Implementation
ActiveActive and ActivePassive Replication
Data Migration and Synchronization
Replication Monitoring Troubleshooting
Heterogeneous Database Replication
Infrastructure Cloud
Oracle Exadata
LinuxUnix Administration
Shell Scripting
Oracle Cloud Infrastructure OCI
Google Cloud Platform GCP knowledge preferred
Networking concepts related to database replication
Tools Automation
OEM Monitoring
Ansible
Automation Scripting
ITSM Tools ServiceNow preferred
DevOps and CICD awareness
Preferred Experience
Experience supporting large healthcare pharmaceutical supply chain or ERP environments
Experience with JD Edwards JDE environments
Experience with OracletoOracle and DB2toOracle migration projects
Experience supporting Exadata and cloudhosted Oracle worklo
Knowledge of ControlM and enterprise batch processing environments
Soft Skills
Strong customerfacing communication skills
Ability to lead technical discussions and architecture reviews
Excellent troubleshooting and analytical skills
Strong ownership