Certified SQL Database administrator with 7 years of IT Experience in Database Administration ON Premise an Azure cloud and Development for very large and complex databases in Microsoft SQL Server 2019/2017/2016/2014/2012/2008 R / 2000 in Development, Test and Production Environments. Extensively worked on installing, configuring, optimizing and managing different versions SQL Server 2005, 2008 R2, 2012, 2014, 2016 and 2017 updating with latest hot fixes and service packs as per CIS Standards. Expert in Migrating from SQL server 2005 to 2008/2008R2 and 2008/2008R2 to 2012, 2014,2016 and 2017 by using In - Place upgrade process as well as side-by-side upgrade process and documented the Upgrade Process. Proficiency and expertise in SQL Server Backup/Recovery, Disaster recovery planning and Security Management. Good exposure with SQL Server High Availability Always ON Availability Groups, DB mirroring, log shipping and clustering. Hands on experience on SQL SERVER 2016 new features like Query store, IN memory OLTP and database stretching to Azure platform. Experience in supporting Very Large Database (VLDB) more than 2 to 4 TB and troubleshooting problems. Expertise in implementation of security models, Database authentication modes, creation of logins, granting permissions and assigning roles to users on databases. Extensively worked on Locks, Deadlocks, Handling Isolation Level and Concurrency Effects, Detect CPU, I/O, Memory Bottlenecks . Expert in Monitoring, Optimization, Performance tuning of SQL Server databases using DMVs, Activity Monitor, SQL Profiler, DB Tuning wizard and third-party tools. Expertise in reading and understanding execution plan and fixing the query to execute with low cost. Experience in using Native tools like SQL Server Profiler, extended events, Database Tuning Advisor, Perfmon and third-party tools like IDERA.
