Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Oracle Team. If you also belong to the team, you can get access from here

Oracle Verified Tick

Compare button icon Compare button icon Compare
filter salaries All Filters

1420 Oracle Jobs

Principal DBA (GoldenGate & Performance Tuning Expert)

10-12 years

₹ 17.5 - 30L/yr (AmbitionBox estimate)

tooltip
This is an estimate of the average salary range for this position. It has not been reviewed by the company, and the actual salary may differ.

Kolkata, Mumbai, New Delhi + 4 more

1 vacancy

Principal DBA (GoldenGate & Performance Tuning Expert)

Oracle

posted 1d ago

Job Role Insights

Flexible timing

Job Description

Database administration
  • Design and implement database migration strategies using OCI Data Pump, GoldenGate, and Oracle Cloud MAA best practices .
  • Database RU Patching in Exadata DB systems.
  • Database upgrade.
GoldenGate Administration & Data Replication
  • Deploy, configure, and manage Oracle GoldenGate for real-time data replication and transformation across heterogeneous environments.
  • Troubleshoot GoldenGate replication issues , ensuring data synchronization, conflict resolution, and high availability .
  • Perform database migrations using GoldenGate , OCI Data Transfer, Data Pump , and GoldenGate Cloud Service .
  • Implement GoldenGate streaming to Kafka, Snowflake, and other data lake services for real-time analytics and event-driven architectures.
  • Ensure seamless data integration, migration, and replication between ATP, ADW, and on-prem databases .
Oracle Cloud Infrastructure (OCI) Database Management (Oracle 23ai ATP & ADW Expertise)
  • Deploy and manage OCI-based database services , including DBaaS, Exadata, and Oracle Autonomous Database .
  • Configure OCI networking, IAM roles, security groups, and database encryption for a secure database environment.
  • Automate database provisioning and management using Terraform, Ansible, or OCI CLI .
  • Implement automated performance tuning, auto-scaling, and security policies for ATP & ADW.
Performance Tuning & Optimization
  • Conduct advanced SQL query tuning using AWR, ADDM, ASH, TKPROF, and execution plans .
  • Optimize Exadata Smart Scan, Hybrid Columnar Compression (HCC), and storage indexes to maximize performance.
  • Design and implement high-performance database architectures for mission-critical applications.
High Availability (HA) & Disaster Recovery (DR) Solutions
  • Design and implement HA/DR strategies using Data Guard, GoldenGate, and Oracle Maximum Availability Architecture (MAA) best practices.
  • Troubleshoot HA, replication failures, and latency issues across distributed environments.
Automation, DevOps & Cloud-Native Database Administration
  • Develop automation scripts using Shell, Python, Perl, Ansible for routine database maintenance, patching, and monitoring.
  • Integrate DevOps practices using CI/CD pipelines, GitHub, Jenkins, and Terraform for cloud infrastructure automation.
  • Manage cloud-native databases on OCI, AWS, and Azure , ensuring security, scalability, and compliance .
Troubleshooting & Customer Escalation Management
  • Serve as the SME for critical customer issues , providing expert-level database troubleshooting and resolution .
  • Act as the technical lead in high-priority incidents, working closely with support, development, and cloud infrastructure teams .
Security & Compliance
  • Ensure database environments comply with security best practices, regulatory compliance, and enterprise policies .
  • Implement database auditing, encryption, and user access management to prevent unauthorized data access.
Collaboration & Leadership
  • Act as the Oracle SME in customer calls/escalations , providing clear technical solutions and recommendations.
BS degree in Computer Science, Information Systems, or equivalent work experience. Identifies and implements complex solutions in Technical Infrastructure support and server administration in a mid-sized environment; supporting and troubleshooting distributed applications, software, and operating systems; and administering and troubleshooting issues with messaging middleware and message brokers. Knowledge of enterprise platforms. Desire to keep up with modern technology and make recommendations. Knowledge of network architecture and protocols. Experience with enterprise administrative scripting using a major scripting language and experience with software deployment. Travel may be required in accordance with business needs. Related technical experience may be substituted for degree requirements, including Infrastructure support and server administration; supporting and troubleshooting distributed applications, software, and operating systems. Advanced knowledge of network architecture and protocols. Strong experience with enterprise administrative scripting using a major scripting language. 8+ years or more of related technical experience may be substituted for degree requirements, including Infrastructure support and server administration; supporting and troubleshooting distributed applications, software, and operating systems.
Required Qualifications:
  • 10+ years of experience in Oracle Database Administration , including Exadata, GoldenGate, and Performance Tuning .
  • Hands-on experience in Oracle RAC, Data Guard, and GoldenGate deployments .
  • Expertise in Oracle Autonomous Database (ATP/ADW) for performance optimization, monitoring, and security .
  • Strong knowledge of cloud-native databases and experience managing OCI, AWS, or Azure database services .
  • Hands-on experience in GoldenGate for real-time replication, data streaming (Kafka), and migration .
  • Proficiency in SQL, PL/SQL, and database performance tuning techniques .
  • Strong background in database migration, upgrades, and automation using Terraform, Ansible, and OCI CLI .
  • Experience in REST API integration for database automation and monitoring.
  • Deep understanding of HA/DR solutions including Data Guard, GoldenGate, and Active-Active replication .
  • Experience in cloud networking, security, and IAM best practices for databases.
  • Strong analytical and problem-solving skills, capable of troubleshooting complex, high-impact issues independently.
  • Excellent verbal and written communication skills , with experience presenting technical concepts to stakeholders.
Preferred Qualifications:
  • Experience in a Solutions Architect role , designing large-scale cloud database deployments .
  • Good to have experience in Oracle Middleware administration .
  • In Depth knowledge of storage, networking, and security principles in cloud environments.

Employment Type: Full Time, Permanent

Read full job description

Oracle Interview Questions & Tips

Prepare for Oracle roles with real interview advice

Top Oracle Principal DBA Interview Questions

Q1. Triplets with Given Sum Problem Given an array or list ARR consisting of N integers, your task is to identify all distinct triplets within ... read more
Q2. Minimum Cost to Connect All Points Problem Statement Given an array COORDINATES representing the integer coordinates of some points on a 2D ... read more
Q3. Square Root (Integral) Problem Statement Given a number N , calculate its square root and output the integer part only. Example: Input: 18 ... read more
View all 643 questions

What people at Oracle are saying

4.4
 Rating based on 5 Principal DBA reviews

Likes

Work balance and good learning skill

  • Salary - Good
  • +6 more
Dislikes

No salary hikes yearly

Read 5 Principal DBA reviews

Principal DBA salary at Oracle

reported by 38 employees with 10-17 years exp.
₹17.5 L/yr - ₹30 L/yr
At par with the average Principal DBA Salary in India
View more details

What Oracle employees are saying about work life

based on 5.2k employees
80%
89%
78%
73%
Flexible timing
Monday to Friday
No travel
Day Shift
View more insights

Oracle Benefits

Submitted by Company
Career development and internal mobility
Health and well-being
Financial security
Benefits that suit your lifestyle
Submitted by Employees
Work From Home
Cafeteria
Gymnasium
Health Insurance
Free Transport
Team Outings +6 more
View more benefits

Compare Oracle with

SAP

4.2
Compare

MongoDB

3.8
Compare

Salesforce

4.0
Compare

IBM

4.0
Compare

Adobe

3.9
Compare

Google

4.4
Compare

Wipro

3.7
Compare

Amazon

4.1
Compare

TCS

3.7
Compare

Accenture

3.8
Compare

Cognizant

3.7
Compare

Microsoft Corporation

4.0
Compare

Oracle Financial Services Software

3.5
Compare

JPMorgan Chase & Co.

4.0
Compare

Capgemini

3.7
Compare

Red Hat

4.3
Compare

SAS

4.4
Compare

Zoho

4.3
Compare

Deloitte

3.8
Compare

Cisco

4.1
Compare

Similar Jobs for you

Principal Database Engineer at Oracle India Pvt. Ltd.

Kolkata, Mumbai + 5

10-15 Yrs

₹ 25-30 LPA

Database Admin at Oracle India Pvt. Ltd.

Kolkata, Mumbai + 5

10-12 Yrs

₹ 20-24 LPA

Principal Engineer at Oracle India Pvt. Ltd.

Kolkata, Mumbai + 5

8-10 Yrs

₹ 27.5-31 LPA

Database Admin at Pine Labs

5-12 Yrs

₹ 30-40 LPA

Senior Oracle Database Administrator at Oracle India Pvt. Ltd.

Mumbai

7-10 Yrs

₹ 22.5-27.5 LPA

Senior Oracle Database Administrator at Oracle India Pvt. Ltd.

Mumbai

7-9 Yrs

₹ 22.5-27.5 LPA

Senior Oracle Database Administrator at Oracle India Pvt. Ltd.

Mumbai

7-10 Yrs

₹ 22.5-27.5 LPA

Database Admin at Servion

6-14 Yrs

₹ 18-38 LPA

Software Developer 4 at Oracle India Pvt. Ltd.

Kolkata, Mumbai + 5

8-10 Yrs

₹ 37.5-45 LPA

Software Developer 3 at Oracle India Pvt. Ltd.

Kolkata, Mumbai + 5

6-10 Yrs

₹ 25-27.5 LPA

Oracle Bangalore / Bengaluru Office Locations

View all
Bangalore Office
Oracle Technology Park No 3 Bannerghatta Road Bengaluru, KARNATAKA, 560 029 Bangalore
Bangalore Office
Global Axis Plot #152/1, EPIP Zone Whitefield Bengaluru, KARNATAKA, 560 066 Bangalore
560 066

Principal DBA (GoldenGate & Performance Tuning Expert)

10-12 Yrs

Kolkata, Mumbai, New Delhi +4 more

1d ago·via naukri.com

5G Core Tester

5-10 Yrs

Gurgaon / Gurugram

7hr ago·via naukri.com

Java Developer

3-6 Yrs

Hyderabad / Secunderabad

7hr ago·via naukri.com

Java Developer

3-8 Yrs

Hyderabad / Secunderabad

7hr ago·via naukri.com

Senior iOS/Android Developer

6-11 Yrs

Hyderabad / Secunderabad, Bangalore / Bengaluru

7hr ago·via naukri.com

HCM Cloud Consultant

3-5 Yrs

Kolkata, Hyderabad / Secunderabad, Bangalore / Bengaluru

17hr ago·via naukri.com

Fusion HCM Functional Consultant

5-10 Yrs

Gandhinagar, Chennai, Thiruvananthapuram

17hr ago·via naukri.com

PeopleSoft HCM Technical Consultant ( Hiring Across india)

5-10 Yrs

Kolkata, Pune, Bangalore / Bengaluru

17hr ago·via naukri.com

Cloud HCM Technical Consultant

5-10 Yrs

Pune, Chennai, Bangalore / Bengaluru

18hr ago·via naukri.com

Java Microservice Developer

4-9 Yrs

Bangalore / Bengaluru

19hr ago·via naukri.com
write
Share an Interview