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.
