Principal Database Engineer - Performance Tuning

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

  .

Required Skills & Experience:

10+ years

SQL, PL/SQL, query optimization, and database tuning

Preferred Qualifications:

Kafka, Oracle Stream Analytics, or other real-time data streaming technologies

DevOps tools (Jenkins, Docker, Kubernetes) for database automation

Educational Qualification:

Bachelors / Masters degree