PUNE · FULLTIME
SQL DB Engineer
Zensar Technologies
Pune · onsite · Posted 4d ago
Sourced from
Undisclosed7–12 yrsfulltimePune
Your match
?
Sign in to see your match score, skill gaps & tailored resume.
Section · 01
About this role
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.
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
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.
Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.
Sourced from naukri
Let the agent run this one for you.
Tailored resume, auto-apply, and referral lookup — in under 2 minutes.
Section · 02
Skills
IndexingAutomationExportDisaster recoveryAzure SQL DatabasePerformance TestingAzure SQLdata modelsdeploymentDatabase EngineeringAzure Virtual MachinescloudAzure Data FactorymaintenancecomplianceMicrosoft AzureData Pipeline
Section · Company
About Zensar Technologies
Zensar Technologies
IT Services & Consulting
10.0k+
employees
2001
25 years old
Pune, Maharashtra
India
About
Zensar is a global organization that conceptualizes, builds, and manages digital products through experience design, data engineering, and advanced analytics for leading companies.
Industries
IT Services & Consulting
Employee ratings
2,994 reviews
3.7/ 5
Culture
3.5
Career growth
3.0
Work-life
3.8
Employees rate it well for
Work Life Balance442Work Culture366Senior Management300Salary295Job Security229
Find them on