Description
Manage SQL Server environments, ensuring high availability, performance, and reliability through proactive monitoring and automation.
This role is on-site.
Responsibilities
- Monitor SQL Server health, including connectivity, CPU, memory, and disk utilization.
- Design and execute backup strategies, maintenance plans, integrity checks, and index rebuilds.
- Perform database migrations, upgrades, patching, and configure high availability and disaster recovery.
- Troubleshoot locking, deadlocks, and blocking issues to maintain OLTP availability.
- Automate administrative tasks using PowerShell scripts, stored procedures, and triggers.
Required Skills
- 6+ years of experience in MSSQL administration.
- Proficiency in SQL Server installation, configuration, and patching.
- Experience configuring High Availability and Disaster Recovery solutions.
- Strong T-SQL skills for writing complex queries, views, and triggers.
- Hands-on experience with PowerShell scripting for task automation.
- Ability to perform capacity planning and physical database architecture design.
- Experience managing database schema changes and controlled development environments.
- Proven track record of resolving production incidents and performing root cause analysis.
Preferred Skills