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
(USA) Senior Technician, Facility Services, HVAC/Refrigeration
Walmart · Noblesville, IN · 15 Nov 2026
(USA) Senior Technician, Facility Services, HVAC/Refrigeration
Walmart · Noblesville, IN · 15 Nov 2026
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.