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 Expert...