Job Description
1. Performance Tuning & Troubleshooting:
Must have expertise in Database performance tuning, SQL query tuning and performance optimization using AWR, ASH, and ADDM reports. Troubleshoot GoldenGate replication lag, database connectivity, and execution plan issues. Use Oracle Enterprise Manager (OEM) and OCI Monitoring tools for proactive monitoring. 2. Oracle GoldenGate (OGG) Implementation & Management:
Design and implement real-time data replication using Oracle GoldenGate for heterogeneous environments. Configure Extract, Pump, and Replicate processes for both unidirectional and bidirectional replication. Monitor, troubleshoot, and optimize GoldenGate replication performance. Implement conflict detection and resolution in multi-master replication environments. 3. Oracle 23ai ATP & ADW Expertise:
Deplo...