Ashish M.

Background

About Ashish M.

Responsible for managing Backup, Restore, and managing Maintenance plans• Troubleshooting Performance Problems in SQL Server 2008 such as CPU utilization, Memory, I/O, Tempdb, Slow running queries, blockings and deadlocks.• Responding to SQL server related alerts• Monitoring of database size and disk space in Production and Development environments• Performing database refresh and restore activity• Updating with latest service packs and security patches• Performing daily and weekly database check activities• Managing SQL Server Logins, Server roles, Database roles, Schema and Object permissions.• Handled 24/7 Production Issues and managing Incidents assigned to queue• Working with Incident Management/Change Management as per ITIL process• Creation of new databases, planning the location of data and Transaction log files on disks• Installation of Microsoft SQL Server 2008/2012 on new Production and Test servers with latest Security updates involving Service Packs and Security patches.• Knowledge of Window Clustering and Failover Clustering• Monitoring and performance tuning of database using Performance Monitor and DMV’s• Experience with providing high availability and disaster recovery service like clustering, mirroring and log shipping.• Managing Indexes fragmentation by reorganizing and rebuilding with ONLINE in Microsoft Soft SQL 2008 server.• Managing the size of the DBs by observing the size of actual data file and space occupied by them and shrink DB accordingly.• Decommissioning Server/Instance on demand.• Importing/Exporting and attaching/detaching DBs as per user request.