Role & responsibilities

Must-Have Microsoft SQL Server Database Administrator

8+ years of hands-on experience administering Microsoft SQL Server in enterprise production environments.

Strong expertise in installing, configuring, patching, upgrading, and maintaining SQL Server instances.

Hands-on experience with SQL Server Always On Availability Groups, Windows Server Failover Clustering, and Log Shipping.

Strong knowledge of backup, restore, recovery, point-in-time recovery, and database consistency validation.

Experience administering and supporting SQL Server Reporting Services (SSRS), Integration Services (SSIS), and Analysis Services (SSAS).

Proficiency in performance monitoring and tuning, including query optimization, execution plans, indexing, statistics, blocking, deadlocks, and wait analysis.

Experience with capacity planning, storage management, database growth forecasting, and resource optimization.

Solid knowledge of SQL Server security, authentication, authorization, role-based access, encryption, auditing, and compliance controls.

Experience planning and executing database migrations, consolidations, version upgrades, and lifecycle activities with minimal business disruption.

Proficiency with SQL Server Agent, T-SQL, PowerShell, and automation of routine database administration activities.

Experience with proactive monitoring, alerting, incident, problem, change, and service management processes in an ITIL-aligned environment.

Ability to produce and maintain operational documentation, standard operating procedures, recovery runbooks, and technical reports.

Strong troubleshooting, analytical, stakeholder communication, and cross-functional collaboration skills.





SN Responsibility of / Expectations from the Role

1 Provide end-to-end administration and operational support for Microsoft SQL Server instances across development, test, staging, and production environments.

2 Install, configure, patch, upgrade, and maintain SQL Server database engines and related components, including SSRS, SSIS, and SSAS.

3 Design, configure, monitor, test, and troubleshoot High Availability and Disaster Recovery solutions, including Always On Availability Groups, Failover Clustering, and Log Shipping.

4 Define and manage backup and recovery strategies; perform restore validation, point-in-time recovery, disaster recovery drills, and recovery readiness reviews in line with agreed RPO and RTO targets.

5 Monitor and tune database and instance performance through query analysis, execution plans, indexing, statistics maintenance, wait analysis, blocking and deadlock resolution, and resource optimization.

6 Manage database capacity, storage utilization, file growth, tempdb, maintenance plans, jobs, alerts, and housekeeping activities to maintain service stability and availability.

7 Administer database security and access, including logins, users, roles, permissions, service accounts, encryption, auditing, vulnerability remediation, and compliance evidence.

8 Plan and execute database migrations, consolidations, platform upgrades, decommissioning, and lifecycle management activities while minimizing downtime and operational risk.

9 Deliver proactive monitoring, incident and problem resolution, root cause analysis, change implementation, automation, documentation, stakeholder communication, and continual service optimization.

📌 Walk-in || Sql Database Administrator (Delhi)
🏢 Tata Consultancy Services
📍 Delhi