SQL DB Engineer

Zensar Technologies; Pune District; On-site; INR 1,800,000 - 2,400,000; Full time

Job summary

Zensar Technologies, Pune, seeks an experienced SQL Server specialist to design, optimize, and troubleshoot complex T-SQL patterns in enterprise environments.

You will analyze execution plans, tune high-volume workloads, and contribute to cloud modernization with Azure SQL, data pipelines, and automation tools. Collaboration and mentoring are expected.

Qualifications

• 7+ years of hands-on SQL Server database engineering or development in enterprise environments.
• Advanced T-SQL, stored procedures, indexing, data-modeling, and query-optimization skills.
• Deep knowledge of SQL Server execution plans, Query Store, statistics, locking, waits, and tempdb.
• Experience tuning high-volume transactional and batch workloads with before/after validation.
• Experience with upgrades, configuration assessment, performance testing, and troubleshooting.
• Working knowledge of high availability, disaster recovery, SQL Agent, replication, backup/restore, and monitoring.
• Strong analytical, documentation, collaboration, and incident-management skills.

Responsibilities

• Design, develop, review, and optimize complex T-SQL, procedures, functions, views, and indexes.
• Analyze execution plans, Query Store data, waits, blocking, and memory grants to resolve issues.
• Refactor processing to set-based designs with inline table-valued functions and staging.
• Tune long-running workloads while preserving data integrity and output equivalence.
• Design and validate database structures, keys, data models, and replication patterns.
• Support upgrades and configuration changes with testing and rollback plans.
• Engineer HA/DR, replication, monitoring, and maintenance practices.
• Troubleshoot incidents with cross-team collaboration and durable corrective actions.
• Contribute to cloud modernization involving Azure SQL, data pipelines, and workload offload.
• Provide technical leadership through reviews, standards, and mentoring.

Skills

SQL Server experience

T-SQL & indexing

Execution plans & Query Store

Performance tuning

Upgrades & testing

HA/DR & SQL Agent

Analytical & communication

Tools

Azure SQL Managed Instance

Azure SQL Database

SQL Server on Azure VM

Azure Data Factory

Microsoft Fabric pipelines

Snowflake

PowerShell

Job description

Job Description:

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 efficient 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 estimation, statistics, locking/blocking, waits, parallelism, memory grants, and tempdb.
• Experience tuning high-volume transactional and batch-processing workloads with measurable before-and-after validation.
• Experience with SQL Server upgrades, configuration assessment, performance testing, and production troubleshooting.
• Working knowledge of high availability, disaster recovery, SQL Agent, replication, backup/restore, maintenance, and operational monitoring.
• Strong analytical, documentation, collaboration, and incident-management skills

Nice To Have

• Azure SQL Managed Instance, Azure SQL Database, or SQL Server on Azure virtual machines.
• Azure Data Factory, Microsoft Fabric pipelines, Snowflake, or reporting/data-platform modernization.
• PowerShell or other automation for database deployment, validation, monitoring, or maintenance.
• Experience with financial-services transaction, compliance, reporting, or data-feed workloads

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 efficient 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.

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 efficient 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.

Qualifications

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 estimation, statistics, locking/blocking, waits, parallelism, memory grants, and tempdb.
• Experience tuning high-volume transactional and batch-processing workloads with measurable before-and-after validation.
• Experience with SQL Server upgrades, configuration assessment, performance testing, and production troubleshooting.
• Working knowledge of high availability, disaster recovery, SQL Agent, replication, backup/restore, maintenance, and operational monitoring.
• Strong analytical, documentation, collaboration, and incident-management skills

Nice To Have

• Azure SQL Managed Instance, Azure SQL Database, or SQL Server on Azure virtual machines.
• Azure Data Factory, Microsoft Fabric pipelines, Snowflake, or reporting/data-platform modernization.
• PowerShell or other automation for database deployment, validation, monitoring, or maintenance.
• Experience with financial-services transaction, compliance, reporting, or data-feed workloads

At Zensar, we’re “experience-led everything”. We are committed to conceptualizing, designing, engineering, marketing, and managing digital solutions and experiences for over 130 leading enterprises. We are a company driven by a bold purpose: Together, we shape experiences for better futures. Whether for our clients, our people, or the world around us, this belief powers everything we do. At the heart of our culture is ONE with Client - a set of four core values that reflect who we are and how we work: One Zensar, Nurturing, Empowering, and Client Focus.

Part of the $4.8 billion RPG Group, we’re a community of 10,000+ innovators across 30+ global locations, including Milpitas, Seattle, Princeton, Cape Town, London, Zurich, Singapore, and Mexico City. Explore Life at Zensar and join us to Grow. Own. Achieve. Learn. to be the best version of yourself.

We believe the best work happens when individuality is celebrated, growth is encouraged, and well-being is prioritized. We are an equal employment opportunity (EEO) and affirmative action employer, committed to creating an inclusive workplace. All qualified applicants will be considered without regard to race, creed, color, ancestry, religion, sex, national origin, citizenship, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteran status.

Requirements: