Key Responsibilities
• Design, develop, review, and optimize complex T-SQL, stored procedures, functions, views, tables, indexes, and data-access patterns.

• Analyze execution plans, Query Store data, waits, blocking, memory grants, parallelism, CPU, I/O, tempdb usage, and transaction-log behavior to isolate and resolve performance issues.

• Refactor row-by-row and scalar-function-heavy processing into effective set-based designs, including appropriate use of inline table-valued functions, temporary staging, indexing, and early filtering.

• Tune long-running batch, snapshot, compliance, reporting, and data-export workloads while preserving data integrity and output equivalence.

• Design and validate database structures, keys, identity strategies, data models, and replication patterns for large, tightly coupled transactional workloads.

• Support SQL Server upgrades and configuration changes through representative performance testing, execution-plan comparison, regression validation, and documented rollback or fix-forward plans.

• Engineer and support high availability,



disaster recovery, transactional replication, monitoring, maintenance, archival, purge, and capacity-management practices.

• Troubleshoot production incidents with application, infrastructure, SRE, QA, and vendor teams; preserve evidence and translate findings into durable corrective actions.

• Contribute to cloud and platform modernization involving Azure SQL Managed Instance, Azure SQL, data pipelines, and workload offload from monolithic SQL platforms.

• Provide technical leadership through design reviews, code reviews, standards, documentation, mentoring, and knowledge transfer.

RequiredRequired
Required Skills
7+ years of hands-on SQL Server database engineering or development experience in enterprise environments
Advanced T-SQL, stored procedure, function, indexing, data-modeling, and query-optimization skills
Deep knowledge of SQL Server execution plans, Query Store, cardinality estima

📌 SQL DB Engineer (Pune)
🏢 Zensar
📍 Pune