Principal Database Performance Engineer

Job Location: Bangalore, Noida & Pune

About the Team Join Oracle's cutting-edge Data Platform team, where innovation meets scale. We build and support high-performance, enterprise-grade database solutions that power mission-critical applications for customers across the globe. Our team partners closely with Engineering, Product Management, Customer Success, and Support to solve complex database performance challenges while ensuring exceptional scalability, reliability, and availability. We thrive in a collaborative, fast-paced environment focused on delivering world-class database performance for enterprise workloads.

Role Overview As a Principal Site Reliability Developer, you will play a critical role in improving the performance, scalability, and reliability of Oracle Database environments supporting enterprise-scale applications. This role is primarily focused on Performance Engineering, where you will analyse complex production workloads, investigate database performance issues, optimize SQL execution, and drive proactive performance improvements across large-scale Oracle environments. You will work closely with engineering teams to diagnose performance bottlenecks across SQL, PL/SQL, database architecture, and application interactions. While experience with PL/SQL development is essential, it is primarily required to optimize existing database logic and improve application performance rather than build new database applications.

Who Will Be an Ideal Fit You are an experienced Oracle Database Performance Engineer with a passion for solving complex performance problems at scale. You have deep expertise in Oracle database internals, SQL optimization, execution plan analysis, and production performance diagnostics. You enjoy investigating challenging database issues, identifying root causes, and implementing scalable performance improvements. You possess strong analytical skills, excellent troubleshooting abilities, and a customer-first mindset.

Why You Should Accept This Role: Work on Oracle Database technologies including Oracle 19c, 21c, and 23ai Solve complex database performance challenges for enterprise customers Influence performance improvements across mission-critical production systems Collaborate with world-class Engineering, Product, and Customer Success teams Gain exposure to distributed databases, large-scale workloads, and cloud-native architectures Continuous learning opportunities in Oracle Database technologies and Performance Engineering

Must-Have Skills: Strong SQL tuning and performance optimization skills (AWR/ASH, ADDM, SQL Monitor, SQL Trace, TKPROF, Performance Diagnostics, Root Cause Analysis, Explain Plans, Optimizer Hints) Experience with partitioning, Indexing, materialized views, and analytical functions Deep understanding of Oracle Optimizer and Cost-Based Optimization Hands-on experience with PL/SQL development and Oracle database internals Expertise in Oracle versions 19c, 21c, and 23ai Proficiency in programming languages such as C, C++, Java, or Python Experience with relational and NoSQL databases (e.g., MongoDB, Cassandra) Knowledge of distributed databases, sharding, and massively parallel processing systems Experience with high availability, backup/recovery, and disaster recovery strategies Strong troubleshooting and debugging skills across database and application layers Ability to manage multiple priorities in a fast-paced environment

Nice-to-Have Skills: Experience with internet-scale applications Familiarity with Oracle Globally Distributed Database Experience working with Oracle Cloud Infrastructure (OCI) Exposure to DevOps practices and tools such as Terraform Experience writing and publishing technical white papers

Responsibilities Lead database performance engineering initiatives across large-scale Oracle environments. Analyze and troubleshoot complex SQL performance issues using AWR, ASH, ADDM, SQL Monitor, SQL Trace, TKPROF, and execution plan analysis. Perform root cause analysis for production performance incidents and recommend long-term solutions. Identify performance bottlenecks across SQL, PL/SQL, database architecture, memory, storage, and application interactions. Optimize SQL execution plans, indexing strategies, optimizer statistics, and database configurations. Conduct proactive database health assessments and performance reviews. Perform workload analysis and capacity planning for enterprise systems. Drive continuous improvements in database scalability, stability, and performance. Collaborate with engineering teams to ensure applications are designed for optimal database performance. Recommend best practices around SQL coding standards and database performance optimization. Work with customers, partners, and internal teams (sales, support) to drive successful product adoption Design, develop, and maintain complex Oracle database objects including packages, procedures, functions, and triggers using PL/SQL Architect and implement efficient database schemas to support both transactional and analytical workloads Develop demos and technical showcases to highlight product capabilities Troubleshoot and debug issues across databases, applications, and related systems Support high availability, backup/recovery, and disaster recovery strategies in enterprise environments