We are looking for a skilled Oracle GoldenGate Specialist to join our team and work on advanced data replication and Change Data Capture (CDC) projects for a utility client. This role offers the opportunity to implement enterprise-grade data synchronization solutions that support real-time operations, business intelligence, and disaster recovery for critical infrastructure systems. The successful candidate will be responsible for designing high-availability data synchronization strategies and ensuring data consistency across heterogeneous database environments.
Key Responsibilities
- Design and implement Oracle GoldenGate solutions for data replication and CDC across our client's operational and analytical databases
- Configure and manage GoldenGate replication processes including Extract, Pump, and Replicat
- Set up bidirectional replication and active-active database configurations for high availability
- Implement data transformation and filtering logic using GoldenGate features
- Monitor replication lag and troubleshoot performance bottlenecks in 24/7 operational systems
- Perform initial data loads and maintain data consistency across production, disaster recovery, and analytics environments
- Configure GoldenGate for heterogeneous database replication (Oracle to non-Oracle platforms)
- Implement disaster recovery and high availability solutions using GoldenGate to support business continuity requirements
- Create and maintain technical documentation for replication architectures
- Provide production support and resolve replication-related incidents with defined SLAs
- Conduct capacity planning and performance tuning of GoldenGate infrastructure
- Ensure compliance with client security standards and data governance policies
- Collaborate with database administrators, infrastructure teams, application owners, and client stakeholders
- Mentor junior team members and share knowledge within InnovationTeam
Requirements
- Bachelor's degree in Computer Science, Information Technology, or related field
- 5-8 years of experience with Oracle GoldenGate (Classic and Microservices Architecture)
- Deep understanding of Oracle database architecture and internals (11g/12c/19c/21c)
- Strong knowledge of data replication concepts, CDC, and ETL processes
- Experience with conflict detection and resolution strategies
- Proficiency in SQL, PL/SQL, and shell scripting
- Knowledge of Oracle database features (RAC, Data Guard, ASM)
- Experience with Linux/Unix operating systems
- Strong troubleshooting and analytical skills in high-pressure environments
- Ability to work in 24/7 production support environments with on-call responsibilities
- Excellent communication and client-facing skills
- Fluency in English; Arabic proficiency is highly preferred
- Saudi national or valid Iqama holder
- Ability to obtain necessary security clearances for government projects
Preferred Qualifications
- Oracle GoldenGate certification
- Experience with Oracle GoldenGate for Big Data
- Knowledge of cloud-based replication (Oracle Cloud Infrastructure, Oracle Exadata)
- Familiarity with other replication technologies (Shareplex, SQL Server Replication)
- Experience with data warehousing and real-time analytics platforms
- Understanding of database security, encryption, and data masking
- Previous experience working with utilities, water sector, or critical infrastructure projects
- Experience working in consulting or IT services environments
- Project management or team leadership experience
- Knowledge of Saudi government IT standards and compliance requirements
- Strong client relationship management skills
Benefits
At InnovationTeam, we strive for excellence in everything we do. We offer a collaborative and inclusive work environment, where innovation and creativity are encouraged. We provide opportunities for professional growth and development, and believe in recognizing and rewarding our employees for their contributions.If you are a motivated and talented Solution Designer looking for a challenging and rewarding position, we would love to hear from you.
- Competitive Package and Allowance
- Paid Annual Vacation
- Family Status
- Private Health Insurance
- Paid Time Off
- Training & Development
