Responsibilities: · Supporting Production and Development databases in 24x7 Environment. · Installed and configured SQL Server in a standalone and Clustered Environment. · Handled Performance Tuning and Optimization of slow running queries. · Detected and resolved CPU, memory, I/O, disk space and other resource contention issues. · · Resolved Security related issues to logins, users and application roles and linked Servers. · Created SQL server Agent jobs and maintenance plans to automate tasks such as to run Index Maintenance, Index Defragmentation, Rebuild, Update statistics and capturing deadlocks using Trace flags. · Performing routine tasks like disk space check, Consistency checks, looking for slow/long running queries and hung jobs.· SQL server post-installation activities (Configuration changes) and best practices to improve the overall server and database performance. · Service packs update, security updates and hotfixes on clustered and standalone servers. · Monitored index usage and tuned them where appropriate. · Experts in Database refresh from prod to lower environment as per the business requirements. Automated quarterly/monthly database refresh. · Involved in SQL performance Tuning, identifying locking and blocking issues using Native and Third-party tools to enhance and boost performance of SQL Dbs. · Managed SQL server Logins, Database users & roles and involved in Daily User Maintenance. · Created Database Maintenance jobs to perform full & transaction log Backups and scheduled them with the SQL Server agent job scheduler. · Worked with Performance Tuning/Query tuning, execution plans, trace flags and SQL Profiler · Installation of Service packs to all environments. · Used log shipping for synchronization of databases. · Experience in migrating SQL Server 2012 and 2014 to SQL Server 2016 with AlwaysOn Availability