Database SME & Performance Engineer ( MS SQL)

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 strong 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 management, and data-purging mechanisms.
• Validate performance improvements through repeatable testing, measurement, and documentation.

Database Subject Matter Expertise & Governance

• Serve as the Database SME for MS SQL Server, providing guidance on database design, performance, configuration, scalability, and reliability.
• Define and enforce database development standards, including schema design, naming conventions, indexing, constraints, query design, and release-readiness criteria.
• Act as the mandatory technical reviewer for database-related changes and participate in architecture and design discussions involving the data layer.
• Maintain performance-tuning guidelines, troubleshooting playbooks, operational runbooks, known-error documentation, and recovery procedures.
• Provide coaching and technical guidance to developers and support teams on database engineering best practices.

Proactive Monitoring & Issue Prevention

• Partner with DBAs and monitoring teams to implement alerts, automated health checks, diagnostic logging, and early-warning mechanisms.
• Identify recurring risks and establish preventive controls to reduce performance degradation, capacity issues, blocking, failed jobs, and data-related incidents.
• Set up and monitor database jobs and automated maintenance activities such as indexing, vacuuming, statistics updates, consistency checks, and purging.
• Conduct periodic database health assessments and recommend improvements to capacity, stability, resilience, and operational readiness.
• Lead the technical diagnosis of complex database incidents affecting application performance, stability, availability, or data integrity.
• Participate actively in critical incident war rooms and work under pressure with application, infrastructure, product, and DBA teams to restore services.
• Troubleshoot slow queries, blocking, deadlocks, connection exhaustion, high resource utilization, disk latency, failed jobs, transaction issues, and database contention.
• Perform or support root cause analysis, document technical findings, and implement permanent corrective and preventive actions.
• Communicate incident status, technical findings, risks, and recommended actions clearly to technical and non-technical stakeholders.
• Work with DBAs to define, validate, and improve backup, restore, recovery, replication, high-availability, and disaster-recovery mechanisms.

Required Skills & Experience

• 8+ years of hands-on experience in database engineering, database development, performance tuning, or database administration, with strong expertise in MS SQL Server.
• Expert-level SQL skills with extensive experience writing and optimizing complex stored procedures, functions, views, triggers, and queries.
• Strong knowledge of SQL fundamentals and database performance parameters, including execution plans, indexing, statistics, transactions, locking, blocking, deadlocks, concurrency, memory, CPU, storage I/O, waits, and connection management.
• Proven experience in query optimization, query fine-tuning, workload analysis, database configuration, and performance troubleshooting.
• Hands-on experience diagnosing and resolving database-related production incidents in war-room environments.
• Experience with data recovery, backup and restore, replication, high availability, disaster recovery, and post-recovery validation.

Experience implementing database monitoring, alerting, health checks, automated maintenance, and preventive controls.

Email : [email removed] - Please share your updated resume