Oracle

Principal Database Engineer - Performance Tunning

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:

  • 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


Jobs at Bengaluru

Oracle

Sr. Financial Business Analyst - (G…

Professional

Bengaluru, Karnataka

View Details

Last Date: Oct. 29, 2025

Oracle

BI Reporting Analyst-3, GFO Ops Rep…

Professional

Bengaluru, Karnataka

View Details

Last Date: Nov. 7, 2025

Google

Video Specialist, gTech Ads Solutio…

Freshers/Experienced

Bengaluru, Karnataka

View Details

Last Date: July 3, 2025

Oracle

Principal Consultant - Oracle Middl…

Professional

Bengaluru, Karnataka

View Details

Last Date: June 24, 2025

Oracle

Oracle Supply Chain Planning Functi…

Professional

Bengaluru, Karnataka

View Details

Last Date: Aug. 20, 2025

Amazon

Senior Design Verification Engineer

Freshers/Experienced

Bengaluru, Karnataka

View Details

Last Date: July 1, 2025

Amazon

SDE-1

Freshers/Experienced

Bengaluru, Karnataka

View Details

Last Date: July 1, 2025

Amazon

Senior Financial Analyst, Delivery …

Freshers/Experienced

Bengaluru, Karnataka

View Details

Last Date: July 1, 2025

Oracle

QA Analyst 3-ProdDev

Professional

Bengaluru, Karnataka

View Details

Last Date: June 25, 2025

Amazon

WHS Manager

Freshers/Experienced

Bengaluru, Karnataka

View Details

Last Date: June 24, 2025

Oracle

Credit & Collections Analyst 2-Fin

Professional

Bengaluru, Karnataka

View Details

Last Date: Oct. 6, 2025

Oracle

Software Developer 3

Professional

Bengaluru, Karnataka

View Details

Last Date: Nov. 10, 2025




More Jobs at Oracle

Oracle

Materials Planner 1-Mfg&Dist

Professional

Bengaluru, Karnataka

View Details

Last Date: Aug. 10, 2025

Oracle

Software Engineer

Professional

Bengaluru, Karnataka

View Details

Last Date: Dec. 15, 2025

Oracle

Associate Technical Support Engineer

Professional

Hyderabad, Telangana

View Details

Last Date: Oct. 6, 2025

Oracle

Associate Consultant

Campus

Bengaluru, Karnataka

View Details

Last Date: April 8, 2026

Oracle

Oracle Fusion HCM Technical Analyst

Professional

Hyderabad, Telangana

View Details

Last Date: July 7, 2025

Oracle

Senior Analyst - Collections

Professional

Bengaluru, Karnataka

View Details

Last Date: Oct. 22, 2025

Oracle

Senior Consultant - EPM

Professional

Bengaluru, Karnataka

View Details

Last Date: Oct. 5, 2025

Oracle

Senior Analyst - Accounts Receivable

Professional

Bengaluru, Karnataka

View Details

Last Date: June 24, 2025

Oracle

Software Developer 3 - Identity Gov…

Professional

Bengaluru, Karnataka

View Details

Last Date: July 1, 2025

Oracle

Credit & Collections Analyst 1-Fin.

Professional

Bengaluru, Karnataka

View Details

Last Date: July 27, 2025

Oracle

Oracle Database Administrator

Professional

Bengaluru, Karnataka

View Details

Last Date: Nov. 15, 2025

Oracle

HCM Workforce Management Functional…

Professional

Bengaluru, Karnataka

View Details

Last Date: July 16, 2025




Actively Recruiting Companies at Bengaluru, Karnataka