Staff Data Reliability Engineer - India

CME Group Inc.; Bengaluru; On-site; INR 1,000,000 - 1,300,000; Full time

Job summary

CME Group Inc. in Bengaluru seeks a Staff Data Reliability Engineer to optimize database performance across OLTP and OLAP systems. You will analyze execution plans, implement partitioning and indexing strategies, and monitor performance metrics using cloud monitoring tools.

The role focuses on high-availability, disaster recovery, and automation using Terraform, Liquibase, Flyway, Git CI/CD, and Jenkins. 8+ years of database engineering are expected.

Qualifications

• 8+ years of core database engineering experience.
• 5+ years specializing in deep database tuning.
• Deep understanding of database internal architecture.
• Advanced ability to analyze execution plans, join order decisions, index usage, and disk I/O bottlenecks.
• Automation proficiency in Shell or Python; HA/DR tools experience.

Responsibilities

• 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.
• Monitor dynamic performance views to proactively identify slow queries and resource constraints.
• Architect and implement table partitioning, indexing, materialization, and caching strategies.
• Analyze complex EXPLAIN (ANALYZE, BUFFERS) plans to optimize slow queries and rewrite inefficient SQL.
• Set up comprehensive database observability metrics across cloud platforms.
• Establish SLOs/SLIs for latency and response times; lead HA and DR setup and testing.

Skills

SQL tuning

Execution plans

Query optimization

Automation scripting

High availability

Cloud monitoring

Tools

Liquibase

Flyway

Terraform

Git CI/CD

Jenkins

Job description

## Staff Data Reliability Engineer - IndiaApply: Bangalore - Bagmane Tridib: Full time: Posted Today: 33459## **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.