Pavan H T

• As a production Associate support,we are responsible for resolving incident tickets escalated from L1 support and handling critical incidents(Sev1,Sev2 high).
• Providing SQL Server implementation changes requested from application teams.
• Responsible for installing, configuring, and maintaining as per supported LOB applications.
• Writing and improving SQL Server T-SQL queries.
• Created necessary T-SQL scripts, stored procedures, tables, views, functions, triggers and indexes.
• Responsible for providing SQL Server problem resolution and 24x7 production support and server outages.
• Responsible for disaster recovery and high availability solutions and large scale database migrations .
• Created and migrated partially contained databases within AlwaysOn Availability Groups.
• Created automation of day to day operations, critical SQL server alerts and repetitive tasks.
• Monitored the health and performance of SQL, server instances and home grown applications using Extended Events, SQL server Profiler, PerfMon and other third party tools.
• Tested newly built servers for performance impact with DB load simulators.
• Setup and maintained Log Shipping between various environments..
• Created necessary T-SQL scripts, stored procedures, tables, views, functions, triggers and indexes.
• Operated and oversaw database and log backups and restoration, planning backup strategies, and scheduling.
• Backed up master & system databases and restoring them when necessary.
• Optimized the Indexes, adding/deleting them when necessary for better performance.
• Verified backups and error logs on the servers and troubleshoot any failures or alert problems, and open trouble tickets if necessary to work with technicians from other departments.
• Responsible for Installing, configuring and maintaining SQL failover clustering for production environments.
• Deciding whether clustering, log shipping, mirroring, replication, etc are the right fit to solve a business problem.
• On-call troubleshooting for SQL Server service outages.
• Responsible for securing SQL Server, user management, and taking care of permissions and roles.

Environment: Microsoft SQL Server 2014/2012 and Standard Editions, Windows 2012, Clustering, Always On, Mirroring, replication, SQL Server Management Studio, SQL Profiler, Performance Monitor, Microsoft Visual Studio 2012, TOAD for MYSQL, Microsoft Office 2013.