• Database Cluster Migration to virtual machines from physical machines to consolidate and save licensing costs
• Database server/instance installs (stand-alone and clustered), service-pack upgrades, hotfixes, client tool installs.
• Handle the Window Failover Cluster and Always on availability group
• Support latest SQL Server versions (SQL Server 2017/2016/2014) along with 2005, 2008 and 2012 including Database Engine, Integration Services, Reporting Services and Analysis Services.
• Proactive monitoring of database environment (AlwaysOn, replication, performance tuning) for stability, performance, availability and recoverability.
• Development, Testing, Implementation and Administration of Databases.
• Performance Tuning & Monitoring to address the bottleneck
• Migration of on-premises SQL databases to Azure VM
• Working on the separation of duties in SQL Server 2014 to minimize the possibility of error and fraud

• Worked on SQL Server Replication, Log-Shipping, Mirroring, AlwaysOn, Clustering and Backup/Recovery.
• Work closely with the Application Architecture and Development teams to ensure the consistency and integrity of database development.
• Detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention. Administering SQL Server High Availability and Disaster Recovery strategies.
• Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
• Deployment of T-SQL scripts by creating and running the batch file on multiple databases.
• Setup DB Mail and SQL Server Alerts (Disk Space, TLog Full, Replication, Backup, Schema Change, CPU, Indexing Fragmentation etc.)
• Worked extensively on Clustering, troubleshooting production issues and security management operations. Worked on SQL Server 2008 R2 Migration from SQL Server 2005.
• Worked on multiple DR tests including third-party DR test and native DR technologies, 24 X 7 Production Database on Call Support.