Staff Data Reliability Engineer - India

CME Group; Bengaluru; On-site; INR 4,000,000 - 7,000,000; Full time

Job summary

CME Group in Bengaluru, India is seeking an experienced Database Performance Engineer to optimize enterprise OLTP/OLAP systems. You will analyze SQL execution plans, tune indexing, partitioning, memory, and I/O, and implement caching strategies to maximize throughput.

Responsibilities include monitoring native performance views, establishing SLOs/SLIs for latency, and leading HA/DR improvements while aligning with cloud observability tools.

Qualifications

• 8+ years of core database engineering experience.
• 5+ years specializing in deep database tuning and mastery.
• Strong ability to analyze execution plans and optimize I/O bottlenecks.

Responsibilities

• Analyze and resolve severe database bottlenecks, latency, and deadlocks.
• Tune SQL, plans, indexing, partitioning, and memory for throughput.
• Monitor performance views and proactively identify slow queries and constraints.
• Architect table partitioning, indexing, materialization, and caching strategies.

Skills

Database tuning

Execution plan diagnostics

Scripting (Python, Shell)

HA/DR tools

Cloud observability

Tools

Terraform

KCC

Git CI/CD

Jenkins

Liquibase

Flyway

Job description

Database Performance Optimization

• Analyze and resolve severe database bottlenecks, high latency, lock contention, blockings, and deadlocks across enterprise OLTP and OLAP systems.
• Deep-dive into SQL execution plans, index strategies, partitioning, memory allocation, and I/O tuning to maximize database throughput, Parameters Tuning
• Monitor dynamic performance views (pg_stat_statements, pg_stat_activity, V$, DBA_, AWR, ADDM, execution plans) to proactively identify slow queries and system-level resource constraints.
• Architect and implement table partitioning, indexing, materialization, and caching strategies.
• Analyze complex EXPLAIN (ANALYZE, BUFFERS) execution plans to optimize slow queries, rewrite inefficient SQL, and design optimal indexing strategies (B-Tree, GIN, GiST, BRIN).

Monitoring, Reliability Observability

• Set up comprehensive database observability metrics using native GCP/CloudWatch/Azure Monitor platforms.
• Establish SLOs/SLIs for database latency, query response times, and connection pooling.
• Lead high-availability (HA) and disaster recovery (DR) setup, testing, and continuous optimization.

Nice-To-Have: Database DevOps Infrastructure

• Implement Database Infrastructure as Code (IaC) using tools like Terraform , KCC etc.
• Build automated database deployment pipelines using Git CI/CD, Jenkins.
• Manage automated database schema changes and migrations using tools like Liquibase or Flyway.

Qualifications Requirements

• Experience: 8+ years of core database engineering experience, with at least 5+ years specializing in deep Database tuning Database Mastery: Deep understanding of Database internal architecture. Willing to learn new DB technologies with Cloud first mindset Execution Plan Diagnostics: Advanced ability to analyze execution plans, join order decisions, index usage, and system-level disk I/O bottlenecks. Scripting: Automation proficiency in Shell or Python, High Availability Tools: Direct experience setting up and troubleshooting.

CME Group: Where Futures are Made

CME Group is the worlds leading derivatives marketplace. But who we are goes deeper than that. Here, you can impact markets worldwide. Transform industries. And build a career by shaping tomorrow. We invest in your success and you own it all while working alongside a team of leading experts who inspire you in ways big and small. Problem solvers, difference makers, trailblazers. Those are our people. And were looking for more.

At CME Group, we embrace our employees'' unique experiences and skills to ensure that everyones perspectives are acknowledged and valued. As an equal-opportunity employer, we consider all potential employees without regard to any protected characteristic.