Oracle
Principal Database Engineer - Performance Tuning
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
Business Analyst 2-Ops
Professional
Bengaluru, Karnataka
Last Date: Dec. 16, 2025
Amazon
AVS Consultant, AVS Consultant Prog…
Freshers/Experienced
Bengaluru, Karnataka
Last Date: Sept. 16, 2025
Oracle
Senior Network Developer
Professional
Bengaluru, Karnataka
Last Date: Sept. 20, 2025
Oracle
Cloud Consultant - Finance/PPM Func…
Professional
Bengaluru, Karnataka
Last Date: Nov. 23, 2025
Oracle
Contracts Administrator 1-Fin
Professional
Bengaluru, Karnataka
Last Date: Sept. 13, 2025
Amazon
Risk Manager (2LoD), Risk and Compl…
Freshers/Experienced
Bengaluru, Karnataka
Last Date: Sept. 9, 2025
Product Manager, YouTube PrimeTime …
Freshers/Experienced
Bengaluru, Karnataka
Last Date: Sept. 4, 2025
Amazon
Business Intelligence Engineer III,…
Freshers/Experienced
Bengaluru, Karnataka
Last Date: Sept. 9, 2025
Amazon
WFS Staffing Manager
Freshers/Experienced
Bengaluru, Karnataka
Last Date: Sept. 16, 2025
Oracle
Software Developer 4
Professional
Bengaluru, Karnataka
Last Date: Sept. 24, 2025
Oracle
Assistant Financial Controller
Campus
Bengaluru, Karnataka
Last Date: Nov. 3, 2025
Oracle
SCM Lead / Solution Architect
Professional
Bengaluru, Karnataka
Last Date: Sept. 9, 2025
More Jobs at Oracle
Oracle
Principal Technical Analyst
Professional
Bengaluru, Karnataka
Last Date: Sept. 29, 2025
Oracle
Customer Success Specialist, CSS Pl…
Professional
Bengaluru, Karnataka
Last Date: Oct. 21, 2025
Oracle
Technical Analyst 3-Support
Professional
Bengaluru, Karnataka
Last Date: Oct. 14, 2025
Oracle
Software Developer IC3
Professional
Bengaluru, Karnataka
Last Date: Feb. 8, 2026
Oracle
Professional Services Development S…
Professional
Bengaluru, Karnataka
Last Date: Oct. 28, 2025
Oracle
MySQL Cloud Sales Representative
Professional
Bengaluru, Karnataka
Last Date: Dec. 21, 2025
Oracle
Senior Principal Consultant
Professional
Bengaluru, Karnataka
Last Date: Oct. 21, 2025
Oracle
Oracle HCM Tehno- Functional consul…
Professional
Bengaluru, Karnataka
Last Date: Dec. 28, 2025
Oracle
Oracle Fusion HCM Technical Consult…
Professional
Bengaluru, Karnataka
Last Date: Sept. 9, 2025
Oracle
Senior Oracle Cloud SCM/HCM/ERP Tec…
Professional
Hyderabad, Telangana
Last Date: Sept. 30, 2025
Actively Recruiting Companies at Bengaluru, Karnataka