Job Description
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:
- Oracle Database (11g/12c/19c or higher)
- SQL, PL/SQL
- Database Performance Tuning
- Backup & Recovery
- 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.
