✓ Setup Always On, performing failover/failback, Monitoring Always On Latency
✓ Installation of SQL server in standalone, clustered environment
✓ Proactively monitoring the critical databases and servers for any issues
✓ Supporting on call on weekends or planned activities, DR failover
✓ Implement database backup strategy, security strategy
✓ Troubleshooting basic SQL server issues like Login, blocking, performance, linked server etc
✓ Administration of 150+ SQL Servers in Clustered / Non-Clustered Environments
✓ Recover the databases from backup in disasters. Implementing Point-In-Time Recovery.
✓ Upgrade MS Sql Server 2014 to 2016.
✓ Perform deployments to Production and QA environments on scheduled and on demand basis.
✓ Provide 24x7 production support for SQL Server databases on Clustered Servers with database sizes ranging from 100 GB to 1 TB to achieve maximum performance and uptime in production environment
✓ Use SQL SSMS, SQL Server Profiler, SQL Server Agent, Database Engine Tuning Advisor (DTA) and other tools for day to day administration
✓ Implementing DB refresh activities to check data consistency regularly
✓ Implementing Change requests and working with the Incident management team for minimizing the alerts
✓ Creating databases, backup and restore, database email profile
✓ Experience in SQL Development and SSRS, T-Sql Queries