Ankit Modi Email & Phone Number

 Configuring Monitoring and troubleshooting Replication, clustering issue on Production/Test/Dev environments Analyzing and troubleshooting the SQL Servers and scheduled backup jobs.  Worked on Performance and Blocking issues on servers on the basis of reports from the different application teams. Maintaining of Backup Strategies for the production/Test/Dev server. Applying SQL Hot fixes, builds, Cumulative updates on servers as appropriate. Analyzing and troubleshooting the SQL Server processes and jobs.  Solving the High CPU utilization issue. Solving Disk space, Log files full and database file full related issues on SQL servers. Managed and Administrated the SQL Server 2008R2/2008/05/00 production and Non-production servers. Installation of SQL Server 2008R2/2008/05 on Windows Server stand-alone environment. Migrated/ Upgraded SQL Server 2000 databases to SQL Server 2008 databases. Created, scheduled database backup maintenance plans. Database refresh from prod to Dev/Testing. Performed day-to-day tasks like monitoring jobs, Alerts, SQL Server Error logs, Event logs, Disk spaces, Alert logs including backup and restore.  Created, Schedule and maintain the SQL Profiler for monitoring purpose  Managed Security like Windows/SQL Logins, Roles, permissions and Security Modes for various users. Expertise in Monitoring and Batch Scheduling , checking the new potential client requirements for the product  Good exposure of all the phases of SDLC. Creating Incident and Solving them using CA-Service desk (CASD) and HP service desk (HPSD). ITIL V3.0 certified.

Listed skills include Sql, Microsoft Sql Server, C++, C, and 12 others.

• 

  Sims Indore