MSSQL database admin

Location - Bengaluru/Pune/Coimbatore/ChennaiExperience - 4+ yearsExperience in installation of different version of SQL SERVER (2019, 2016, 2014, 2012) in both OLTP and OLAP lower regions and Production environments and SQL Azure.Played a leading role in database maintenance, Security, upgrading and Performance Tuning.Implemented High Availability & Disaster Recovery techniques like Always on Availability Groups, Clustering (Both Active-Active and Active-Passive) Database Mirroring.Upgraded and Migration of SQL Server databases from SQL Server 2014/2016 to SQL Server 2019 .Daily routine DBA tasks like handling user's permissions and database space issues on Production and Semi-Production Servers and handling maintenance Jobs.Hands on experience in working with MSSQL SERVER 2012, 2014, 2016, 2019 features and extensive knowledge on SQL 2019, 2022 new features.Exquisite skills in SSMS-Creating and scheduling jobs, alerts and operators with SQL Server Agent, handling Backup/Recovery of databases, Replication, Linked Servers, and databases Maintenance, Database MailsExperience in Performance Tuning, Index Tuning, Maintenance, Troubleshooting, Query Optimization, Client/Server connectivity and Database Consistency Checks using DBCC Utilities, DMVs and DMFs.Monitoring the different server alert including backup, disk space, Job failures, connectivity, and performances.Hands-on experience in resolving locks deadlocks, handling Isolation levels and performance issues like CPU, I/O, Memory bottlenecks.Experience in using DMV and dynamic management function for finding out long running Queries.Adept at proving database troubleshooting issues like Locking, Blocking and Deadlocking, fail over maintenance and database recovery.Extensively used tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor, Windows Performance Monitor for monitoring and tuning MS SQL Server performance.Experience on designing of Disaster Recovery Plan; knowledge on RPO, RTOExperience on Log shipping, DB Mirroring and Always on configurationsExperience on DR Drill Support for Mirroring/Always on and storage replication like SRDF.Following existing processes such as Incident handling, Change Management, Root-cause Analysis, Event Management, Assets ManagementStrong analytical abilities and strong communication skillsKnowledge of ITIL frameworkHas sound interpersonal skills to communicate with others (verbally and written).