About the Role

We are seeking a highly experienced Database Subject Matter Expert (SME) who combines deep database administration knowledge with strong hands-on database development skills. The role has primary responsibility for writing and optimizing stored procedures, fine-tuning SQL queries, analyzing execution plans, and improving database performance MS SQL Server environments. The successful candidate will serve as the technical authority for database performance, troubleshooting, configuration, reliability, and recovery, while partnering closely with Development Teams, Product Teams, and DBAs to prevent issues and support business-critical applications.

Key Responsibilities

Database Development & SQL Engineering
- Design, develop, test, and maintain complex stored procedures, functions, views, triggers, and other database objects.
- Write efficient, maintainable SQL and fine-tune existing queries for performance, scalability, and correctness.
- Analyze query execution plans and optimize joins, filters, aggregations, indexing, statistics, and data-access patterns.




- Apply solid knowledge of SQL fundamentals, transactions, locking, concurrency, data types, constraints, and relational database concepts.
- Review database code submitted by developers and provide specific recommendations before production deployment.

Database Performance Engineering
- Establish database performance baselines and monitor key parameters including CPU, memory, I/O, connections, waits, locks, blocking, deadlocks, query duration, throughput, and storage growth.
- Identify performance bottlenecks and implement corrective actions through query tuning, indexing, schema improvements, workload optimization, and configuration changes.
- Review and adjust database configuration parameters according to the database platform, workload characteristics, application usage, and operational requirements.
- Optimize table structures, partitioning approaches, indexing strategies, statistics mana

📌 Database SME (Bengaluru)
🏢 Cai Info India
📍 Bengaluru