.GoldenGate Implementation: Install, configure, and manage Oracle GoldenGate (19c and above) for real-time data replication.
2.Database Expertise: Work extensively with Oracle Database architecture and advanced SQL.
3.Heterogeneous Replication: Implement and manage replication across multiple source and target systems such as Oracle, SQL Server, and Azure-based data platforms.
4.Automation & Monitoring: Develop shell scripts for automation, monitoring, and alerting of GoldenGate processes.
5.Performance Optimization: Ensure replication efficiency, low latency, and high throughput while minimizing downtime.
6.Cloud Integration: Support integration with cloud platforms such as Azure (Event Hub, Data Lake, Databricks, etc.).
Key Responsibilities –
1.Design, implement and maintain Oracle GoldenGate replication solutions for various use cases including real-time and batch processing.
2.Perform installation, configuration, upgrades, and troubleshooting of Oracle GoldenGate environments.
3.Monitor replication processes and resolve issues such as lag, abends, and data inconsistencies.
4.Implement best practices to minimize downtime and ensure high availability of data pipelines.
5.Analyze and recommend infrastructure and database changes to optimize replication performance.
6.Develop automation scripts (Shell/Python) for operational efficiency and proactive monitoring.
7.Build reusable frameworks and patterns to enable rapid onboarding of new data sources or tenants.
8.Own and drive the technical roadmap for data ingestion and replication strategies.
9.Collaborate with cross-functional teams including DBAs, cloud teams, and application teams.
10.Prepare and maintain operational runbooks, SLA documents, and technical documentation.