Tcs is Hiring

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.**Role & responsibilities** **Preferred candidate profile**