Tcs is Hiring For MSSQL Database Admin

• 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.Role & responsibilities

Preferred candidate profile