TCS is Hiring for MSSQL Database Admin

Tata Consultancy Services; Chennai District; On-site; INR 900,000 - 1,300,000; Full time

Job summary

Tata Consultancy Services is hiring for a senior MSSQL DBA to manage SQL Server environments across 2016, 2017, 2019 and 2022. The role focuses on performance tuning, query optimization, and robust security practices.

The candidate will handle troubleshooting, high availability configurations, replication, log shipping, and backup/recovery strategies while ensuring data integrity and efficient operation of databases.

Qualifications

• Strong knowledge & experience in MSSQL Database Administration in SQL Server (2016, 2017, 2019 and 2022).
• Experience in Performance Tuning, Query Optimization using Performance Monitor, SQL Profiler, Query Store and other related monitoring and troubleshooting tools.
• Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues, Always-On configuration issues.
• Hands on experience in Clustering, Database Mirroring, Replication and Log Shipping and Always-On.
• Experience in implementing and managing database security (logins, roles, encryption, auditing).
• Hands-on experience with backup, restore, and recovery strategies (Full, Differential, Log backups).
• Strong knowledge of indexes, index management, integrity checks, configuration, patching.

Skills

MSSQL DBA

Performance Tuning

Query Optimization

Monitoring Tools

Troubleshooting

Always-On

Database Security

Backup and Recovery

Index Management

Replication

Tools

SQL Profiler

Query Store

Performance Monitor

Job description

• Strong knowledge & experience in MSSQL Database Administration in SQL Server (2016, 2017, 2019 and 2022).
• Experience in Performance Tuning, Query Optimization using Performance Monitor, SQL Profiler, Query Store and other related monitoring and troubleshooting tools.
• Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues, Always-On configuration issues.
• Hands on experience in Clustering, Database Mirroring, Replication and Log Shipping and Always-On.
• Experience in implementing and managing database security (logins, roles, encryption, auditing).
• Hands-on experience with backup, restore, and recovery strategies (Full, Differential, Log backups).
• Strong knowledge of indexes, index management, integrity checks, configuration, patching.