Note: The job is a remote job and is open to candidates in USA. Enterprise Solutions Inc. is seeking an Oracle GoldenGate Consultant responsible for end-to-end GoldenGate administration, replication monitoring, troubleshooting, and performance tuning across multi-system data pipelines. The role involves managing replication processes, monitoring pipeline health, and coordinating with various teams for issue resolution.
Responsibilities
- Manage GoldenGate replication processes Extract Pump Replicat across environments
- Monitor replication lag trail files disk usage and pipeline health
- Handle GoldenGate incidents including ABEND trail corruption and checkpoint issues
- Perform restart recovery and failover procedures
- Conduct pipeline validation and data reconciliation across hops
- Manage DDL replication and onboarding of new tables
- Perform GoldenGate performance tuning parallelism batching checkpoint tuning
- Support change and release management for replication pipelines
- Coordinate with DB network and application teams for issue resolution
- Maintain runbooks for recurring failure scenarios
Skills
- Strong expertise in Oracle GoldenGate Classic Microservices
- Handson experience in Extract Pump Replicat configuration
- Lag management and troubleshooting
- ABEND analysis and recovery
- Experience in multihop replication architectures
- Knowledge of Oracle DB internals required for coordination
- Understanding of heterogeneous replication environments
- Experience in Oracle AlloyDB replication
- Downstream integrations Snowflake
- Exposure to large environments 150 jobs pipelines
- Shell scripting automation
- Monitoring tools and costuming
- Strong hands-on experience in Oracle GoldenGate replication across homogeneous and heterogeneous environments (Oracle, DB2, SQL Server, Snowflake, Kafka)
- Expertise in Oracle GoldenGate 19c/23ai, including Classic and Microservices Architecture (MA) installation, configuration, administration, and troubleshooting
- Experience implementing and supporting unidirectional, bidirectional, active-active, DR, and high-availability replication solutions
- Strong knowledge of Extract, Pump, Replicat, Trail Files, Integrated/Parallel Replicat, replication monitoring, performance tuning, and lag management
- Proven experience in troubleshooting Extract/Replicat abends, replication lag, collision handling, data consistency issues, DEFGEN, and large-volume initial loads/migrations
- Experience securing and managing GoldenGate environments, including encryption, authentication, credential management, monitoring, and multi-cloud deployments (OCI, GCP, Azure, On-Premises)
Company Overview