AmbitionBox
Jobs
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Oracle
Compare
All Filters
1382 Oracle Jobs
Principal Database Engineer - Performance Tunning
10-15 years
₹ 27 - 34L/yr (AmbitionBox estimate)
Kolkata, Mumbai, New Delhi + 4 more
1 vacancy
Principal Database Engineer - Performance Tunning
Oracle
posted 6hr ago
Job Role Insights
Flexible timing
Key skills for the job
Job Description
- 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.
- 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.
- 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 .
- 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 .
- 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 .
- 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 .
Expertise in Oracle GoldenGate (OGG) for real-time data replication .
Hands-on experience with Oracle 23ai ATP (Autonomous Transaction Processing) and ADW (Autonomous Data Warehouse) .
Strong knowledge of SQL, PL/SQL, query optimization, and database tuning .
Experience with RMAN, Data Guard, and Oracle Enterprise Manager (OEM) .
Hands-on experience with OCI-based database solutions and Terraform/Ansible for automation .
Familiarity with cloud networking, security policies, and IAM roles in OCI .
Knowledge of PostgreSQL, MySQL, or NoSQL databases like MongoDB, Cassandra .
Hands-on experience with DevOps tools (Jenkins, Docker, Kubernetes) for database automation .
Oracle Certifications (OCP, OCI Architect, or OGG Specialist) are highly desirable.
Employment Type: Full Time, Permanent
Read full job descriptionOracle Interview Questions & Tips
Prepare for Oracle roles with real interview advice
What people at Oracle are saying
Rating based on 1 Principal Database Engineer
review
Anonymous · Other
It was good when join this team but versatile learning is something missing here.
- Skill development - Good
Job security. Manager don't discuss much and impose decision...
- Job security - Bad
Principal Database Engineer salary at Oracle
What Oracle employees are saying about work life
Oracle Benefits
Career development and internal mobility Health and well-being Financial security Benefits that suit your lifestyle 
Compare Oracle with
SAP
MongoDB
Salesforce
IBM
Adobe
Wipro
Amazon
TCS
Accenture
Cognizant
Microsoft Corporation
Oracle Financial Services Software
JPMorgan Chase & Co.
Capgemini
Red Hat
SAS
Zoho
Deloitte
Cisco
Similar Jobs for you
Oracle Bangalore / Bengaluru Office Locations
560 066
Principal Database Engineer - Performance Tunning
10-15 Yrs
Kolkata, Mumbai, New Delhi +4 more
Oracle Fusion SCM Functional Lead
8-13 Yrs
₹ 18 - 33L/yr
Kolkata, Mumbai, Gandhinagar +6 more
Oracle Fusion SCM Sr Functional Consultant
4-7 Yrs
₹ 15 - 20L/yr
Delhi/Ncr, Thiruvananthapuram
Oracle Fusion SCM Sr Functional Consultant
4-7 Yrs
₹ 15 - 20L/yr
Gandhinagar, Hyderabad / Secunderabad, Bangalore / Bengaluru
Senior/Prinicpal BRM Developer
3-8 Yrs
₹ 13 - 23L/yr
Hyderabad / Secunderabad, Pune, Bangalore / Bengaluru
Oracle Fusion SCM Sr Functional Consultant
4-7 Yrs
₹ 15 - 20L/yr
Kolkata, Pune, Chennai
Principal Siebel Consultant
5-10 Yrs
₹ 15 - 30L/yr
Hyderabad / Secunderabad, Pune, Delhi/Ncr
