Note: The job is a remote job and is open to candidates in USA. Meritore Technologies is seeking an Oracle GoldenGate Consultant who will be responsible for end-to-end GoldenGate administration, replication monitoring, troubleshooting, and performance tuning across multisystem 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
- 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)
- Experience in Oracle AlloyDB replication
- Downstream integrations Snowflake
- Exposure to large environments 150 jobs pipelines
- Shell scripting automation
Company Overview
Company H1B Sponsorship