C

Staff Data Reliability Engineer - India

CME Chicago Mercantile Exchange · Bangalore - Bagmane Tridib · posted 16 Oct 2026
Full-timeEngineering

About the job

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 tuningDatabase Mastery: Deep understanding of Database internal architecture. Willing to learn new DB technologies with Cloud first mindsetExecution 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…

Read the full description on CME Chicago Mercantile Exchange's site ↗

Skills

Upload your CV on LitCareer to see which of these you match.

Similar jobs

Engineer
Ingersoll Rand · Bangalore, KA, IN, 560 029 · 15 Nov 2026
Engineer
Ingersoll Rand · Bangalore, KA, IN, 560 029 · 15 Nov 2026
Modern Workplace Engineer
Ingersoll Rand · Bangalore, KA, IN, 560 029 · 15 Nov 2026
Modern Workplace Engineer
Ingersoll Rand · Bangalore, KA, IN, 560 029 · 15 Nov 2026

Collected from CME Chicago Mercantile Exchange's official careers site by LitCareer. Always apply on the employer's own site; LitCareer never charges you to apply.