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:

Deploy, configure, and optimize Oracle Autonomous Transaction Processing (ATP) and Autonomous Data Warehouse (ADW) on OCI. Implement automated performance tuning, auto-scaling, and security policies for ATP & ADW. Utilize Oracle Machine Learning (OML) features in 23ai ADW for data analytics and AI-driven insights. Ensure seamless data integration, migration, and replication between ATP, ADW, and on-prem databases.

4. Oracle Cloud Infrastructure (OCI) Database Management:

Deploy and manage OCI-based database services, including DBaaS, Exadata, and Oracle Autonomous Database. Configure OCI networking, IAM roles, security groups, and database encryption. Automate database provisioning and management using Terraform, Ansible, or OCI CLI. Implement database migration strategies using OCI Data Transfer, Data Pump, or GoldenGate Cloud Service.

5. Oracle Database Engineering & Administration:

Install, configure, and manage Oracle databases (19c, 21c, and 23ai ATP/ADW) in OCI environments. Perform database performance tuning, indexing, and optimization for high efficiency. Implement backup and recovery strategies using RMAN and OCI Backup Service. Ensure high availability (HA) and disaster recovery (DR) with Data Guard, Flashback, and OCI-based solutions.

6. Security & Compliance:

Implement data encryption, masking, and role-based access control (RBAC) in ATP, ADW, and OCI databases. Ensure compliance with industry security standards (GDPR, HIPAA, PCI-DSS, and CIS benchmarks). Conduct database patching, security updates, and vulnerability assessments.

Career Level - IC4