Info Origin Inc.
Website:
infoorigin.com
Job details:
Job Title: Oracle GoldenGate Consultant / Engineer
Experience: 5+ Years
Location: India, Remote
Employment Type: Full-Time
Job Summary
We are seeking a highly skilled Oracle GoldenGate Consultant/Engineer with 5+ years of hands-on experience in data replication, database administration, and real-time data integration. The ideal candidate should possess strong expertise in Oracle GoldenGate, robust database administration skills, and experience in implementing high-availability, data migration, and replication solutions across enterprise environments.
The candidate will be responsible for designing, configuring, troubleshooting, and supporting Oracle GoldenGate environments while collaborating with cross-functional teams to ensure seamless data synchronization, performance optimization, and business continuity.
Key Responsibilities
• Design, implement, configure, and support Oracle GoldenGate replication solutions for real-time and batch data synchronization.
• Install, configure, monitor, and troubleshoot Oracle GoldenGate environments across development, QA, and production.
• Manage and optimize heterogeneous and homogeneous database replication scenarios.
• Perform database performance tuning, troubleshooting, and optimization activities.
• Work closely with application, infrastructure, and business teams to support data migration, replication, and disaster recovery initiatives.
• Monitor replication lag, process performance, and resolve synchronization issues proactively.
• Perform database upgrades, patches, and GoldenGate version upgrades.
• Create and maintain technical documentation, replication architecture diagrams, and operational procedures.
• Support high availability and business continuity strategies.
• Troubleshoot data consistency issues and implement corrective actions.
• Collaborate with DBAs, cloud, and middleware teams for enterprise integration projects.
• Participate in on-call production support and incident resolution as needed.
Required Qualifications
• 5+ years of IT experience with strong expertise in Oracle GoldenGate administration and implementation.
• Strong hands-on experience with Oracle Database Administration (DBA).
• Experience configuring and supporting Oracle GoldenGate for Oracle databases.
• Strong expertise in:
o Oracle Database (11g/12c/19c or higher)
o SQL, PL/SQL
o Database Performance Tuning
o Backup & Recovery
o Replication & High Availability
• Experience in data migration, CDC (Change Data Capture), and replication architecture.
• Strong troubleshooting and debugging skills for replication failures and latency issues.
• Experience with Linux/Unix shell scripting.
• Strong understanding of database security, data integrity, and governance.
• Ability to analyze logs and troubleshoot Extract, Replicat, Pump, and Trail file issues.
• Experience working in enterprise production support environments.
Preferred Qualifications
• Experience with heterogeneous replication (Oracle to SQL Server, PostgreSQL, Snowflake, etc.).
• Exposure to cloud platforms such as AWS, Azure, or OCI.
• Experience with Oracle RAC, Data Guard, ASM, and high-availability architecture.
• Knowledge of Kafka, CDC pipelines, or modern data integration tools is a plus.
• Experience with DevOps/automation scripting for database deployments.
• Oracle certifications are preferred.
Required Technical Skills
• Oracle GoldenGate
• Oracle Database Administration
• SQL / PL-SQL
• Linux/Unix
• Performance Tuning
• Database Replication
• CDC (Change Data Capture)
• Shell Scripting
• High Availability & Disaster Recovery
Soft Skills
• Strong analytical and troubleshooting skills.
• Excellent communication and stakeholder management abilities.
• Ability to work independently in a fast-paced environment.
• Strong documentation and knowledge-sharing mindset.
• Collaborative team player with problem-solving attitude.
Nice to Have
• Experience in healthcare, finance, or enterprise-scale environments.
• Exposure to cloud-native data architectures and streaming technologies.
Click on Apply to know more.