• Installation & Configuration of SQL Server 2005/2008/2008/R2/2012/2016 on Local System and Remote System. • Applying the service packs in regular intervals. • Having experience on database backup and restorations. • Deploying the scripts in production environments. • Implementation of Logins, creating Users, assigning responsibilities as a part of Security Policies for various categories of User Support. • Identifying/resolving fragmentation resulting in improved performance. • Hands on experience in High Availability such as Log-Shipping, Database Mirroring, Replication and Clustering, Always on sql server • Working on failover and failback activities in SQL cluster. • Upgrading databases & SQL server from Lower to Higher versions. • Monitoring SQL Server alerts at regular intervals • Monitoring SQL Server agent jobs/maintenance plans • Provided 7 x 24 Production support for the database and application issues. • Working with Transaction replication installation and maintenance. • Performing the failover and failback activities on cluster. • Having experience on Azure Cloud VMs , Storage and Network and Azure SQL ( IaaS and PaaS)Top 5 Key Skills:SqlServer2005 2008 2008 R2 2012 2016.2017.2019 and Azure SQL DBs

• Installing SQL server database in Production, Test and Development environment. • Creation of Logins, Users and giving appropriate permissions as per request. • Database Backup checks on a daily basis and following a strict backup strategy. • Recovering the databases from backup in case of disasters. • Database periodical refresh as per requirement. • Migration of database between the servers. • Performance Monitoring and Tuning. • Troubleshooting cases where the Log file full and TEMPDB full. • Establish and Maintain Healthy Backup & Recovery Strategies and Procedures. • Performing Health Checks of all the servers in Support Environment. • Evaluating the Backup & Recovery Procedures on a Test Database to Minimize the Loss on Real Time Scenario. • Maintaining High database availability for supporting non-stop Business Operations.