Senior MS SQL Database Administrator

Position Overview

We are seeking a highly experienced Senior MS SQL Database Administrator to support the VDOT ITD Tolling group. The ideal candidate will have strong experience managing enterprise SQL Server databases, performance tuning, high availability, upgrades, migrations, and production troubleshooting.

Experience supporting E-ZPass / electronic tolling databases is highly important for this position.

Key Responsibilities

• Administer, maintain, and support enterprise Microsoft SQL Server databases.

• Support production databases for tolling and E-ZPass applications.

• Perform database installation, configuration, upgrades, patching, and migrations.

• Troubleshoot and resolve SQL Server performance issues, blocking, deadlocks, and connectivity problems.

• Perform SQL query and database performance tuning for large-volume databases.

• Support databases of 2TB+ and optimize performance for high-volume workloads.

• Manage backup, recovery, high availability, and disaster recovery solutions.

• Develop and maintain T-SQL scripts, stored procedures, and database objects.

• Support SSIS, SSRS, and SSAS environments.

• Monitor database health, capacity, performance, and availability.

• Troubleshoot production incidents and participate in application/help desk support rotations.

• Work with development, application, infrastructure, and business teams to resolve database issues.

• Create technical documentation, procedures, and operational runbooks.

• Support cloud database environments and database modernization initiatives.

Required Skills

• 8+ years of experience administering Microsoft SQL Server databases.

• 3+ years of SQL Server performance tuning.

• 2+ years of hands-on experience supporting E-ZPass / electronic tolling databases.

• 3+ years troubleshooting SQL Server deadlocks and blocking in production environments.

• 2+ years tuning and supporting 2TB+ SQL Server databases.

• 3+ years of experience with SSIS, SSRS, and SSAS.

• 1+ year of hands-on T-SQL experience.

• 4+ years performing SQL Server installation, upgrades, patching, and migrations.

• Strong knowledge of SQL Server 2019 or newer.

• Experience with SQL Server high availability and disaster recovery.

• Strong troubleshooting and production support experience.

• Experience with Azure/cloud database technologies or relevant certification.

Preferred Qualifications

• Experience with Azure SQL Database / Azure SQL Managed Instance.

• Experience with cloud database migration and modernization.

• Microsoft Azure Database Administrator certification such as DP-300.

• Experience with large-scale, high-availability production environments.

• Strong scripting experience with PowerShell or similar tools.

• Experience with monitoring, capacity planning, and database security.

• Experience working in government, transportation, tolling, or other high-volume transaction environments.

Ideal Candidate

The ideal candidate is a senior SQL Server DBA with strong experience in enterprise production databases, performance tuning, HA/DR, large databases, and E-ZPass/tolling systems. Candidates should be comfortable troubleshooting critical production database issues and working with cross-functional IT teams.