Mahesh Jadhav

• Expertise in Installation of SQL Server version 2012, 2014, 2016, 2017, 2019 & 2022 in production, test and development environments.
• Responsible for ensuring storage, backup recovery procedures and functioning properly using disk management and troubleshooting issues.
• Experience in monitoring database security by creating logins, users, roles and assigning permission as per requirements.
• Daily health check-up of database using performance tuning parameters like blocking/deadlocking, indexing, managing index fragmentation, updating statistics, checking disk-IO, CPU, memory.
• Implemented and monitored high availability and disaster recovery feature like Logshipping, Transaction Replication, Mirroring and Always On.
• Configured Always ON as well as have sound knowledge of Windows Clustering.
• Hands On experience on Upgrade/Migration and Patching activities.
• Improved performance of SQL queries and store procedure using SQL profiler and DTA.
• Experience of ticketing tool ServiceNow & BMC Remedy IT Service Management Tool.
• Roles and Responsibilities handled as SQL Server DBA:

Installation / Security / Maintenance Plan

Performance Tuning

DR plan – Log-Shipping, Mirroring, Replication, Always ON