oracle golden gate SME - Mumbai /Bangalore -F2F

Job Description

Role & responsibilities JOB DESCRIPTION**Total Years of Experience : 6-8 Years Relevant Years of Experience : 6-8 Years Mandatory Skills : Oracle Golden Gate SME Detailed JD : 1.Oracle GoldenGate Architecture & Implementation Design and implement high-availability and fault-tolerant GoldenGate solutions across multiple environments (on-prem, cloud, hybrid). Install, configure, and optimize Oracle GoldenGate 21c/23ai for heterogeneous databases (Oracle, MSSQL, MySQL, PostgreSQL). S et up Extract, Pump, and Replicat processes for source-to-target data replication.Implement downstream mining for redo log-based replication in Active Data Guard environments.Configure GoldenGate for Big Data to integrate with platforms like Kafka, and AWS S3. 2. Performance Tuning & Optimization Fine-tune GoldenGate Extract, Pump, and Replicat processes to handle high-transaction loads (~20TB logs/day).Optimize ACFS, XAG, and RAC configurations for high availability.Implement multi-threaded Replicat (MTR) for parallel processing and improved performance.Configure compression techniques for efficient data transfer between hubs. 3. Monitoring & Troubleshooting Set up OEM GoldenGate Plugin for real-time monitoring of replication health and performance.Troubleshoot latency issues, data integrity errors, and replication lag.Monitor Kafka offsets to ensure efficient data consumption by downstream systems.Validate data integrity using Oracle Veridata or manual comparison techniques. 4. Cloud & Big Data Integration Implement Oracle GoldenGate for Big Data (OGG-BD) for streaming replication to Kafka and AWS S3.Design data lakehouse architectures for real-time data ingestion into cloud platforms.Configure Parquet and Avro file formats for efficient storage in AWS S3. 5. Security & Compliance Implement TLS encryption and secure log transport between source, downstream, and target systems.Ensure compliance with enterprise data governance policies.