Oracle Database Administrator with Goldengate
Core
Design, implement, and maintain real-time database replication solutions using Oracle GoldenGate to ensure data integrity, availability, and high availability between disparate systems.
Role type
Senior Oracle Database Administrator (GoldenGate Specialist)
Builds
Real-time data replication pipelines, CDC transaction transformations, and data integration solutions
Domain
Enterprise Data Management, Financial Services, Banking
Deliverable
production ML models | product features | dashboards & analysis | infrastructure
Required skills
Oracle GoldenGate (Microservices Architecture), CDC (Change Data Capture), JSON Canonical Message Model transformation, Oracle GoldenGate Adapters (JMS, Big Data), Extract/Load/Transform, GG Veridata, Database Replication, Disaster Recovery, Performance Tuning, Troubleshooting
Preferred skills
Cross-functional collaboration, Technical Documentation, Security Best Practices, Patch Management
Technologies
Oracle GoldenGate, Oracle Database, MSSQL, JMS, Big Data Adapters
Responsibilities
Install, configure, and maintain Oracle GoldenGate software across development, testing, and production environments; Design and implement database replication solutions for high availability and disaster recovery; Monitor and optimize GoldenGate replication processes; Develop/configure/test GG Veridata for functional data verification between Oracle and MSSQL; Collaborate with data modelers to transform CDC data by introducing business rules into GG code; Perform regular backups, restores, and recovery procedures; Implement and enforce security best practices; Stay up-to-date with Oracle GoldenGate features, patches, and upgrades.
