Oracle GoldenGate Specialist

Job Overview :

We are looking for a highly skilled and experienced Oracle GoldenGate Specialist to join our enterprise technology team, supporting SBI Bank's core database replication and data migration projects. The ideal candidate will have hands-on experience in setting up and managing Oracle GoldenGate environments, ensuring real-time data replication, high availability, and business continuity.

Key Responsibilities :

- Design, implement, and support Oracle GoldenGate replication across heterogeneous database platforms.

- Perform installation, configuration, and troubleshooting of GoldenGate components in production and non-production environments.

- Monitor and optimize replication performance, latency, and throughput.

- Work closely with DBA teams, developers, and business stakeholders to define replication requirements and strategies.

- Participate in data migration and disaster recovery planning using GoldenGate.

- Create and maintain technical documentation for all GoldenGate configurations and procedures.

- Handle incident, change, and release management processes related to replication systems.

- Ensure security, data integrity, and compliance standards are maintained across replicated environments.

Required Skills & Experience

- Minimum 5 years of hands-on experience with Oracle GoldenGate in enterprise environments.

- Strong SQL and PL/SQL skills with experience in Oracle Database Administration.

- Knowledge of high availability and disaster recovery architectures.

- Proficiency in troubleshooting data replication issues, monitoring lag, and applying patches or upgrades.

- Experience working with heterogeneous replication (e.g., Oracle to MySQL, Oracle to PostgreSQL) is a plus.

- Familiarity with Unix/Linux scripting for automation tasks.

- Good understanding of database backup/recovery, performance tuning, and system maintenance.

- Prior experience in the BFSI domain (preferably banking) is desirable.

Preferred Qualifications :

- Oracle GoldenGate certification is a plus.

- Exposure to cloud-based replication solutions (OCI, AWS RDS with GoldenGate) is an added advantage.

- Experience with data masking or secure replication practices.

Soft Skills :

- Strong communication and documentation skills.

- Ability to work independently and in cross-functional teams.

- Problem-solving mindset with attention to detail.