- Total 9 t o12 years of experience into installation and Configuration of SQL server versions 2008 R2; 2012; 2014;2016 (both Stand alone and cluster Instances)User and monitoring ticket management and ensuring teams adherence to SLA.
• This is for an inventory of almost 1200 servers for each client. 850 of them being production.
• Protecting the databases by taking different kinds of Backups such as Full; Differential; and Transactional log backups.
• Maintained \& Monitored Alert/Schedule to make smooth replication process.
• Performing data refresh activities from production to Dev/Test on need basis Working closely with application development and support team to understand their requirements and provide timely solutions; for both current and future projects.
• Configuring replication; mirroring; SQL clusters and troubleshooting issues.
• Creating Jobs and Sending Alerts using SQL Mail.
• Ensuring Data consistency in the database through DBCC commands.
• Repetitive issues analysis and proposals for permanent resolutions.
• Monitoring SQL Server agent jobs/maintenance plans Provide 24 \* 7 Production support for the database and application issues.
