Description
You will manage the installation, maintenance, and performance of SQL Server environments across all levels of support.
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.
- Perform performance tuning through index optimization, stored procedure tuning, and T-SQL code reviews.
- Automate administrative tasks using PowerShell scripts, stored procedures, and triggers.
- Respond to P1 and P2 incidents by joining bridge calls and conducting root cause analysis (RCA).
- Manage database object deployments across Integration, QA, UAT, and Production environments.
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.
- Any Graduate degree.