SQL DB Engineer

Posted 21 Days Ago
Be an Early Applicant
2 Locations
In-Office or Remote
Senior level
Information Technology
The Role
Designs, develops, and optimizes complex SQL Server databases, T-SQL code, stored procedures, indexes, and data-access patterns. Analyzes execution plans and performance metrics, tunes transactional and batch workloads, supports upgrades, high availability, disaster recovery, replication, monitoring, and capacity management. Troubleshoots production incidents, contributes to Azure and data-platform modernization, and provides technical leadership through reviews, documentation, mentoring, and standards development.
Summary Generated by Built In
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.

About UsAt 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.

Skills Required

  • 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 and restore, maintenance, and operational monitoring
  • Strong analytical, documentation, collaboration, and incident-management skills
  • Experience with Azure SQL Managed Instance, Azure SQL Database, or SQL Server on Azure virtual machines
  • Experience with Azure Data Factory, Microsoft Fabric pipelines, Snowflake, or reporting and 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

Zensar Technologies Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Zensar Technologies and has not been reviewed or approved by Zensar Technologies.

  • Retirement Support — A 401(k) with company match and immediate vesting is highlighted, with broad fund options available.
  • Wellbeing & Lifestyle Benefits — Work-life balance, remote/hybrid flexibility, and supportive teams are emphasized as strengths that enhance the overall experience.
  • Parental & Family Support — Inclusive policies such as parental leave and access to EAP and dependent medical coverage are promoted across regions.

Zensar Technologies Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Pune, Maharashtra
10,000 Employees
Year Founded: 2001

What We Do

Zensar is a leading experience, engineering, and technology solutions company. We conceptualize, build, and manage digital products for Forbes Global 2000 clients across the hi-tech engineering, banking and financial services, insurance, manufacturing and consumer services verticals. With proven excellence across five core areas, including experience services, advanced engineering services, data engineering and analytics, foundation services, and application services, our solutions leverage industry-leading platforms to help our clients be competitive, agile, and disruptive while moving with velocity through change and opportunity. Zensar’s expansive ecosystem of 60+ technology partners, including Oracle, Salesforce, SAP, Guidewire, Automation Anywhere, Adobe, and UiPath, enables us to deliver comprehensive solutions to clients, facilitating seamless integration and allowing them to leverage cutting-edge technologies and tools for enhanced business outcomes. Zensar is part of the USD 4.4 billion RPG Group. With headquarters in Pune, India, our 10,500+ employees, representing over 50 nationalities, work from 30+ locations across North America, UK/Europe, and South Africa. Visit us at www.zensar.com

Similar Jobs

In-Office or Remote
2 Locations
10000 Employees

Hilton Logo Hilton

Commis I

Events • Food • Travel • Hospitality • Hotels & Resorts
Remote
2 Locations
500000 Employees

Mondelēz International Logo Mondelēz International

Platform Engineer

Big Data • Food • Hardware • Machine Learning • Retail • Automation • Manufacturing
Remote or Hybrid
India
90000 Employees

Rubrik Logo Rubrik

Sales Specialist Identity, APJ

Artificial Intelligence • Big Data • Cloud • Information Technology • Software • Cybersecurity • Data Privacy
Remote
India
3000 Employees

Similar Companies Hiring

NODA AI Thumbnail
Artificial Intelligence • Information Technology • Software • Cybersecurity • Defense • Defense Technology
Austin, TX
54 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
567 Employees
RapidScale Thumbnail
Cloud • Information Technology • Consulting
Raleigh, NC
600 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account