Date:
Feb 25, 2026
Location:
Bangalore, IN, 562110
Company Name:
SLK Software Private Limited
Role Summary:
We’re seeking a PostgreSQL specialist with deep expertise in SQL query tuning to drive latency and throughput improvements across mission critical services.
You will analyze execution plans, optimize indexing strategies, reduce lock waits and deadlocks, and work closely with developers to improve ORM generated SQL.
Your work will measurably reduce response times and stabilize production workloads.
Key Responsibilities:
SQL Query Tuning & Execution Plans
• Profile queries using EXPLAIN ANALYZE, BUFFERS, TIMING and interpret plans seq scans, index scans, nested loops, hash joins, bitmap scans.
• Identify and eliminate performance anti patterns implicit casts, functions on indexed columns, wildcard LIKE, unnecessary ORDER BY, repeated DISTINCT, overuse of CTEs as optimization fences.
• Optimize joins join order, selective predicates, appropriate indexes on join keys.
• Rewrite queries for set based operati