Principal Database Performance Engineer

About the Team

Join Oracles 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

Career Level - IC4