Oracle Database with Goldengate Administration

Act as Lead Oracle GoldenGate Administrator for enterprise production and non-production environments

Lead Oracle GoldenGate Consultant / Lead Replication DBA (Oracle, MS SQL & Open-Source Databases)
8+ years of overall database experience
4+ years of hands-on Oracle GoldenGate experience
3+ years in a lead or senior replication role in enterprise environments

Provide 24x7 operational support with end-to-end ownership of SLAs, KPIs, and service availability
Handle L3/L4 GoldenGate incidents, performance issues, and escalations
Lead and mentor a multi-shift GoldenGate / DBA support team
Manage shift schedules, on-call rotations, and workload distribution

Design and implement Oracle GoldenGate architectures, including:

Unidirectional and bidirectional replication
Active-active and active-passive configurations
Integrated Extract, Classic Extract, and Replicat
Configure GoldenGate components (Extract, Pump, Replicat, Trails)
Implement checkpointing, conflict detection, and error handling mechanisms

Implement and support cross-database and heterogeneous replications, including:
Oracle to Oracle
Oracle to MS SQL Server
Oracle to Open-Source databases (PostgreSQL, MySQL, MariaDB)
MS SQL Server to Oracle (where applicable)
Ensure schema evolution support and minimal data latency
Troubleshoot data mismatches, lag, and replication conflicts

Plan and execute Oracle GoldenGate upgrades and migrations
Design and validate HA/DR replication topologies
Implement security best practices, including encryption of trails and secure credential management