Ms Sql Server Database Administrator

Tata Consultancy Services; Dadri, Gurugram District, Delhi; On-site; INR 1,500,000 - 2,800,000; Full time

Job summary

Tata Consultancy Services in India seeks an experienced SQL Server Database Administrator to manage enterprise production SQL Server environments. The role focuses on high-availability, performance tuning, secure access, and automated operations.

Responsibilities include backups, migrations, capacity planning, and enforcing ITIL-aligned processes, while collaborating with cross-functional teams to ensure data integrity and compliance.

Qualifications

• 8+ years of hands-on experience administering Microsoft SQL Server in enterprise production environments.
• Expertise in installing, configuring, patching, upgrading, and maintaining SQL Server instances.
• Experience with SQL Server Agent, PowerShell, and automation of routine DBAs tasks.

Responsibilities

• Administer MS SQL Server in enterprise production environments.
• Plan and execute upgrades, migrations, and lifecycle activities with minimal business disruption.
• Implement Always On Availability Groups, WSFC, and Log Shipping.

Skills

SQL Server administration

Always On Availability Groups

Performance tuning

Backup & recovery

Security & compliance

SQL Server Agent

T-SQL

PowerShell

Capacity planning

Cross-functional collaboration

Tools

SSRS

SSIS

SSAS

Windows Server

Job description

Role & responsibilities

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.

Strong 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.