SQL Server Database Administrator (DBA) Expert - CPG Manufacturing / MES

Tata Consultancy Services; Bengaluru; On-site; INR 3,500,000 - 6,000,000; Full time

Job summary

Tata Consultancy Services (TCS) invites a seasoned SQL Server DBA Expert to support MES and manufacturing data environments in India. You will manage production databases, implement high-availability strategies, and optimize ERP-related workloads across development, UAT and production contexts.

Responsibilities include performance tuning, disaster recovery design, backups, and cross-team collaboration with MES, infrastructure, and cloud specialists.

Qualifications

• Minimum 10 years of hands-on Microsoft SQL Server DBA experience with 2016/2019/2022.
• Deep expertise in performance engineering and capacity optimization.
• Proven HA/DR experience with Always On, failover, log shipping, and recovery objectives (RPO/RTO).
• Experience with MES or manufacturing applications (CPG/ FMCG preferred).
• Strong incident, problem, change and release management skills and stakeholder communication.

Responsibilities

• Own administration and health of SQL Server databases for MES/manufacturing applications.
• Monitor availability, performance, capacity and jobs; proactively prevent bottlenecks.
• Troubleshoot with execution plans, Query Store, DMVs, Extended Events; deliver RCA and corrective actions.
• Design, test and operate HA/DR, backup/restore strategies and runbooks.
• Plan upgrades, migrations, and environment refreshes with rollback plans.
• Optimize MES workloads, interfaces, queries, indexes and archival strategies.

Skills

Incident management

Stakeholder communication

Performance tuning

Production support

Data integrity

Tools

Microsoft SQL Server

SSIS/SSRS

PowerShell

Always On Availability Groups

Backup & Recovery

Query Store

DMVs/Extended Events

T-SQL

MES integration

PLCs/OPC UA concepts

Job description

TCS IAE is redefining the future of industry by embedding intelligence across engineering, manufacturing, asset, and service value chains. Powered by AI, connected ecosystems, and autonomous operations, it transforms insights into action—creating self-optimising, resilient, and intelligent enterprises at scale. By seamlessly converging the physical and digital worlds, TCS IAE is enabling a new era of AI-first enterprises where systems continuously learn, adapt, and evolve—driving measurable outcomes and shaping how industries operate for the future.

Role: SQL Server Database Administrator (DBA) Expert - CPG Manufacturing / MES

Required Technical Skill Set: Microsoft SQL Server Administration, Performance Tuning, HA/DR, Always On Availability Groups, Backup & Recovery, Security, SSIS/SSRS, PowerShell, MES Database Support and Manufacturing Production Support

Desired Experience Range: 10-15 Years

Location of Requirement: India

Must-Have**

• Minimum 10 years of hands-on Microsoft SQL Server DBA experience, including SQL Server 2016/2019/2022, installation, configuration, patching, upgrades, migrations, backup/recovery and 24x7 production support.
• Deep expertise in performance engineering: execution-plan analysis, Query Store, wait statistics, blocking/deadlock analysis, indexing, statistics, partitioning, TempDB, memory/I/O and capacity optimization.
• Proven HA/DR experience with Always On Availability Groups, Failover Cluster Instances, log shipping, replication, automated backup validation, failover drills and recovery objectives (RPO/RTO).
• Experience supporting MES or manufacturing applications, preferably GE Proficy Plant Applications, AVEVA/Wonderware MES, Rockwell FactoryTalk, SAP MII or equivalent, with understanding of plant-floor data flows and high-volume historian/transaction workloads.
• Preferably from Consumer Packaged Goods (CPG/FMCG) manufacturing, with strong incident, problem, change and release management skills and effective customer/stakeholder communication.

Good-to-Have

• Azure SQL Database/Managed Instance, Azure VM SQL, AWS RDS for SQL Server and hybrid-cloud migration exposure.
• SSIS, SSRS, SQL Agent, PowerShell/T-SQL automation, database monitoring tools and DevOps/CI-CD deployment controls.
• Knowledge of PLC, SCADA, OPC/OPC UA, historians, edge integration and manufacturing KPIs such as OEE, downtime, throughput, yield, quality and genealogy/traceability.
• Microsoft SQL certifications, ITIL certification or experience in regulated/audited manufacturing environments.

Responsibility of / Expectations from the Role

• Own administration and operational health of SQL Server databases supporting business-critical MES and manufacturing applications across development, test, UAT and production environments.
• Monitor availability, performance, capacity and database jobs; proactively identify bottlenecks and execute preventive actions before plant operations are impacted.
• Perform advanced troubleshooting using execution plans, Query Store, DMVs, Extended Events, wait statistics, blocking/deadlock graphs and infrastructure metrics; deliver clear RCA and corrective/preventive actions.
• Design, operate and test HA/DR solutions, backup and restore strategies, failover procedures and recovery runbooks aligned with agreed RPO/RTO and business continuity requirements.
• Plan and execute database installation, configuration, cumulative updates, security patches, version upgrades, migrations, consolidation and environment refreshes with controlled rollback plans.
• Optimize MES workloads, interfaces, stored procedures, reporting queries, indexes and data-retention/archival strategies for high-volume production, downtime, quality and traceability data.
• Implement database security, access controls, service accounts, encryption, auditing, vulnerability remediation and compliance evidence in line with enterprise standards.
• Partner with MES, application, infrastructure, network, cloud, cybersecurity and plant teams during incidents, releases, deployments, cutovers and manufacturing-site onboarding.
• Automate repeatable DBA activities using T-SQL, PowerShell and approved monitoring/orchestration tools; maintain dashboards, alerts, operational SOPs and knowledge articles.
• Provide technical leadership, review database designs and deployment scripts, mentor junior DBAs, improve support maturity and communicate risks, status and recommendations to customer stakeholders.