Staff Data Reliability Engineer - India

INTEC CME India Pvt Ltd; Bengaluru; On-site; INR 3,000,000 - 6,000,000; Full time

Job summary

CME Group is seeking a senior Database Performance Engineer to optimize throughput and resolve bottlenecks across enterprise OLTP and OLAP systems. You will dive into execution plans, partitioning, indexing, and caching strategies, while building observability and reliability into the platform.

You will lead HA/DR initiatives, implement IaC for database infrastructure, and collaborate with cross-functional teams to ensure cloud-first reliability.

Qualifications

• 8+ years in core database engineering.
• 5+ years specializing in deep database tuning.
• Strong understanding of database internal architecture.
• Ability to analyze execution plans, join order, indexing and I/O bottlenecks.
• Automation proficiency in Shell or Python.
• Experience with HA/DR setup and troubleshooting.

Responsibilities

• Analyze and resolve severe database bottlenecks across OLTP/OLAP systems.
• Dive into SQL execution plans and optimize slow queries.
• Architect and implement partitioning, indexing, materialization, and caching strategies.
• Set up observability metrics and SLIs for latency and throughput.
• Lead HA/DR design, testing, and continuous optimization.

Skills

SQL tuning

Execution plan analysis

Indexing strategies

Partitioning

Shell scripting

Python scripting

High availability

Disaster recovery

Infrastructure as code (IaC)

Terraform

Liquibase/Flyway

KCC

Tools

Liquibase

Flyway

Terraform

KCC

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 world's 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 we’re looking for more. At CME Group, we embrace our employees' unique experiences and skills to ensure that everyone’s perspectives are acknowledged and valued. As an equal-opportunity employer, we consider all potential employees without regard to any protected characteristic.

As the world's leading derivatives marketplace, CME Group is where the world comes to manage risk. We enable clients to trade futures, options, cash and OTC markets, optimize portfolios, and analyze data - empowering market participants worldwide to efficiently manage risk and capture opportunities. CME Group exchanges offer the widest range of global benchmark products across all major asset classes based on interest rates, equity indexes foreign exchange energy agricultural products and metals. We meet uncertainty and volatility with confidence and clarity, across the trading lifecycle and around the world. Hear more about our employee experience Get a look inside CME Group and see what makes us tick A rewarding career is only the beginning Best Place to Work

For U.S. employment, CME Group is legally required to validate a new hire’s employment eligibility by having them complete an Employment Eligibility Verification (Form I-9) companied with legally acceptable proof of identity and work authorization (as listed on the Form I-9). CME Group uses E-Verify, which is an online system operated by the U.S. Department of Homeland Security in partnership with the Social Security Administration to verify employment eligibility and validate social security numbers. Through participation in the E-Verify program, information entered on Form I-9 will be provided and compared to information available at both of these agencies. See posters below for more details.

E-Verify Notice E-Verify Notice Español U.S. Right to Work Notice U.S. Right to Work Notice Español