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.
Key Responsibilities
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.
- 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.
Zensar Technologies Hyderabad, Telangana, IND Office
Block 3, DLF Assets Pvt Ltd., DLF Cyber City, Gachibowli Village, Serilingampalli Mandal, , , Hyderabad, Telangana, India, 500019
Zensar Technologies Hyderabad, Telangana, IND Office
Hyderabad, India
Similar Jobs
Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
Leads AI transformation, governance, quality oversight, risk management, and responsible adoption across Pfizer Global Supply and QSEO. Establishes GxP-compliant AI lifecycle practices, inspection-readiness frameworks, governance forums, portfolio monitoring, inventory management, metrics, and reporting. Advises senior leaders on AI regulations, deployment risks, investment priorities, and compliance while leading cross-functional initiatives and influencing stakeholders across Quality, Digital, Operations, and R&D.
Top Skills:
Ai GovernanceAiqasAirifArtificial IntelligenceComputerized SystemsGxpImexLeanMachine LearningSix Sigma
Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
Develop and deploy AI, machine-learning, process-modeling, LLM, and agentic solutions for pharmaceutical manufacturing. Build real-time soft sensors, advanced process controls, monitoring systems, and decision-support workflows in GMP environments. Analyze large time-series datasets, improve process understanding, and support continuous improvement across manufacturing and quality operations while collaborating with cross-functional stakeholders.
Top Skills:
Advanced Process ControlAgentic AiAIAmazon RedshiftAws SagemakerFirst-Principles ModelingIndustrial Internet Of ThingsKnowledge GraphsLarge Language ModelsMachine LearningMathematical ModelingPep8PlotlyPythonSnowflakeSpotfireSQLStreamlit
.jpeg)
Artificial Intelligence • Hardware • Information Technology • Machine Learning
Lead site energy strategy and decarbonization efforts by developing energy roadmaps, implementing renewable projects (solar, wind, BESS), managing PPAs/open-access, driving ISO 50001 EnMS, performing energy audits, baselining and EnPI tracking, building dashboards and analytics, and coordinating with utilities, regulators, procurement, and cross-functional teams to optimize energy cost, reliability, and emissions.
Top Skills:
Advanced ExcelAgentic AiAnalytics ToolsBattery Energy Storage Systems (Bess)Building Management Systems (Bms)DashboardsFinancial ModellingGhg AccountingHybrid Energy SystemsIso 50001:2018Measurement & Verification (M&V)Open Access PpaPhysical PpaSolar PvVirtual PpaWind
What you need to know about the Hyderabad Tech Scene
Because of its proximity to leading research institutions and a government committed to the city's growth, Hyderabad's tech scene is booming. With plans to establish India's first "AI city," the city is on track to become one of the world's most anticipated tech hubs, with companies like TransUnion, Schrödinger and Freshworks, among others, already calling the city home.
