Description
You will manage the installation, maintenance, and performance of SQL Server environments across all levels of support.
This role is on-site.
Responsibilities
- Monitor SQL Server health, including connectivity, CPU, memory, and disk space utilization.
- Manage backup strategies, including full, differential, and log backups, and implement maintenance plans for integrity checks and index rebuilds.
- Execute database migrations, upgrades, patching, and high availability/disaster recovery configurations.
- Troubleshoot locking, deadlocks, and blocking issues to maintain high 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