Sumesh Nair

Background

About Sumesh Nair

Analyzing stored procedures to reduce blocking/aborts for Sunrise application. • Using Microsoft PowerBI to collect blocking/aborts data. • Analyzing blocking/aborts data and open new incident in Service Now portal if any consistent blocking or aborts stored procedure is observed. • Proactively, analyzing DB logs, SentryOne Monitoring tool and AppDynamics to find root cause and raise a development assist task with suggestions. • Collecting Execution Plan for consistently blocking/aborts stored procedure and analyze execution plan to check queries that executes longer than expected time. • Monitored database performance and optimized queries, which led to a 43% reduction in average query response time within 15 weeks of implementation. • I have activated Database Monitoring tool (eToolkit and Monitor A) for 68 clients for which I have been recognized by company with Hosting Delivery Excellence Award for achieving breakthrough business performance. • Installed, configured, and maintained SQL Server instances across multiple environments • Performed routine maintenance tasks such as backups, restores, and database optimization • Create and managed different types of Indexes (Cluster/Non-Cluster) • Perform rebuild index, reorganize index and update Statistics for tables which are not fragmented. • Creating Problem Record and Knowledge base article for stored procedure that is blocking/aborting for multiple clients. • Working with different clients to resolve blockings/aborts/MLM for client custom stored procedure. • Maintains track of incident with regular updates for all open incidents. • Prepare PPT for weekly meetings to show improvements in performance for blocking/aborts stored procedures. • Manual, on Demand and setup jobs for Database Backup, and design backup strategy • Monitor Server Activity, Error Log, space usage and solving problem as needed. • Trained junior DBAs on best practices for database management