filter salaries All Filters (1)

Clear all

57 Perl Jobs in Kolkata

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 5d ago

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

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.
Lock Unlock
₹17.5 L/yr - ₹30 L/yr
At par with the average Principal DBA Salary in India
View more details

Compare Oracle with

SAP

4.2
Compare

MongoDB

3.7
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

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 Pine Labs

5-12 Yrs

₹ 30-40 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

10-12 Yrs

Kolkata, Mumbai, New Delhi +4 more

5d ago·via naukri.com

7-9 Yrs

Kolkata, Mumbai, New Delhi +4 more

1mon ago·via naukri.com

6-10 Yrs

Kolkata, Mumbai, New Delhi +4 more

1mon ago·via naukri.com

6-10 Yrs

Kolkata, Mumbai, New Delhi +4 more

1mon ago·via naukri.com

4-9 Yrs

Kolkata, Mumbai, New Delhi +4 more

20d ago·via naukri.com

5-7 Yrs

Kolkata, Mumbai, New Delhi +4 more

21d ago·via naukri.com

SENIOR ENGINEER-SOFTWARE TEST&RELEASE

Sasken Communication Technologies Ltd

2-5 Yrs

Kolkata, Mumbai, New Delhi +4 more

18d ago·via naukri.com

2-5 Yrs

Kolkata, Mumbai, New Delhi +4 more

20d ago·via naukri.com

0-5 Yrs

Kolkata, Mumbai, New Delhi +4 more

7d ago·via naukri.com

3-7 Yrs

Kolkata, Mumbai, New Delhi +4 more

7d ago·via naukri.com
How was your last interview experience?

Recently Viewed

JOBS

Gushwork

14 jobs

JOBS

Browse jobs

Discover jobs you love

JOBS

GroundTruth

33 jobs

PHOTOS

Growisto

7 office photos

JOBS

Intel

No Jobs

How was your last interview experience?
Rate your experience using AmbitionBox
Terrible
Terrible
Poor
Poor
Average
Average
Good
Good
Excellent
Excellent