Description
Installed and configured SQL Server 2016/2019 on Windows Server, ensuring optimal performance and reliability of the database environment. Implemented and administered robust backup/restore and disaster recovery plans for production servers, ensuring data integrity and availability. Conducted regular health checks on the databases, monitoring critical factors such as lock escalation, deadlocks, and resource utilization. Utilized advanced troubleshooting techniques to identify and resolve incidents proactively.
Roles and Responsibilities
Installation of SQL 2016/2019 on Windows Server. Implemented and administered backup/restore, disaster recovery plans for production servers. Performed regular database health checks. Monitored lock escalation, deadlocks, resources utilization, and captured long-running SQL queries. Worked as part of a team providing 24x7 support. Configured database mail profiles and created SQL Server traces for performance monitoring. Resolved incidents proactively and performed health checks of production servers. Monitored SQL jobs on Production and Pre-Production environments. Experienced in SQL installation, up-gradation, applying patches, file movement of Secondary Server databases in HA and DR. Successfully conducted various DR switchover and switchback on Always On. Created Linked Servers between SQL Servers and other Heterogeneous environments. Experience in creating automated backups, indexing, and update stats through SQLAgent Jobs and Maintenance plans. Monitored the status of Maintenance jobs scheduled to run daily and on weekends. Created Indexes and performed Maintenance, checking the fragmentation percentage.
Technologies: SQL Server 2012, 2016, 2017, 2019
Industry: Transportation