Principal Database Engineer - Performance Tuning, Oracle

Principal Database Engineer - Performance Tuning, Oracle
Written By:
Srinivas
Reviewed By:
Sankha Ghosh
Published on

Oracle is hiring a Principal Database Engineer – Performance Tuning for its offices in Bengaluru, Hyderabad, and Noida, India. This full-time, IC4 career-level role involves tuning and troubleshooting Oracle databases, implementing GoldenGate replication, managing Oracle 23ai ATP/ADW, and deploying databases on OCI with high availability, automation, and compliance.

Location: Multiple Locations (Bengaluru, Hyderabad, Noida, India)

Job ID: 301412

Job Category: Product Development

Role: Individual Contributor

Job Type: Regular Employee

Years: 6 to 10+ years

Apply: Click Here

Primary Responsibilities

As a Principal Database Engineer for Oracle, you will be responsible for:

  • Database performance tuning, optimizing SQL, or troubleshooting GoldenGate replication by utilizing AWR, ASH, and ADDM.

  • Designing and configuring GoldenGate replication and achieving full real-time, optimized, bidirectional data movements between heterogeneous environments.

  • Deploy and optimize Oracle 23ai ATP and ADW, along with configuring and optimizing auto-scaling of database services with O23ai features for secured mode and other forms of AI-driven analytics.

  • Managing OCI database services. Utilize Terraform for all provisioning and business unit migrations through GoldenGate Cloud.

  • Administering multiple versions of Oracle databases in a high-availability and recovery environment on OCI, while enhancing efficiency within the data processing layer of the OCI-based services.

  • Enforcing data encryption, masking, RBAC, and GDPR, HIPAA, and PCI-DSS compliance, all on top of OHAS patching.

Required Skills & Experience

  • 10+ years of experience as an Oracle Database Administrator and Engineer.

  • Experience with Oracle GoldenGate (OGG) for real-time data replication.

  • Experience with Oracle 23ai ATP (Autonomous Transaction Processing) and ADW (Autonomous Data Warehouse), and related optimizations.

  • In-depth knowledge of SQL, PL/SQL, optimization of queries, and tuning databases.

  • Familiarity in using RMAN, Data Guard, and Oracle Enterprise Manager (OEM).

  • Hands-on experience with OCI-based database solutions and some form of code repository/automation such as Terraform/Ansible.

  • Knowledge of cloud networking, security policies, and IAM roles in OCI.

Preferred Qualifications

  • Experience with Kafka, Oracle Stream Analytics, or other real-time data streaming technologies.

  • 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.

Educational Qualification

Bachelor’s / Master’s degree in Computer Science, IT, or a related field.

Qualifications

Career Level - IC4

Required Skills

  • Database Performance Tuning

  • Golden Gate OCI (Oracle Cloud Infrastructure)

  • Oracle Database Administration

  • SQL tuning

About Oracle

Oracle is a global leader in cloud solutions and enterprise technology, driving innovation for over 40 years. With expertise across databases, AI, and infrastructure, Oracle empowers businesses worldwide to modernize operations, secure data, and harness next-generation tools for growth and transformation.

Join our WhatsApp Channel to get the latest news, exclusives and videos on WhatsApp

Related Stories

No stories found.
logo
Analytics Insight: Latest AI, Crypto, Tech News & Analysis
www.analyticsinsight.net