Senior Cloud SQL Server DBA: Azure & High Availability

Zohorecruit; Richmond (VA); On-site; USD 110,000 - 140,000; Full time

Job summary

VDOT ITD Tolling seeks a SQL Server/Cloud DBA to administer and support SQL Server and cloud databases within the Tolling Engineering and Operations Team. The role includes help desk and application support duties in rotation.

The candidate will manage SQL Server and cloud databases, perform installations and migrations, and tune performance while collaborating with Engineering and Operations professionals. Strong T‑SQL, clustering, and deadlock analysis are essential.

Qualifications

• Master’s degree or higher in CS/IS or equivalent experience.
• 6+ years of MS SQL Server database experience.
• 3–4 years upgrading E‑ZPass Virginia Tolling SQL Server environments from SQL 2012 to 2019.
• Experience diagnosing deadlocks and blocking in Tolling workloads.
• Experience tuning Very Large Databases (2 TB+) including index optimization and workload analysis.

Responsibilities

• Monitor databases to ensure uptime and availability.
• Troubleshoot connectivity, access, and security issues.
• Tune long-running SQL and optimize performance.
• Review and refine database tasks to align with priorities.
• Utilize OS scripting for maintenance and diagnostics.
• Plan and execute changes to existing database implementations.
• Perform SQL Server installations (2022, 2025+) with failover clustering.
• Demonstrate data modeling knowledge.

Skills

MS SQL Server

SQL Performance Tuning

Azure Cloud

SSIS SSAS SSRS

Transact-SQL

Database Upgrades

Deadlock Analysis

VLDB Tuning

SQL Server Clustering

Windows Server

Education

Master’s degree in Computer Science / Information Systems

Tools

Azure Cloud Services

SQL Server Management Studio

Job description

VDOT ITD Tolling seeks a SQL Server/Cloud DBA to administer and support SQL Server and cloud databases within the Tolling Engineering and Operations Team. The role includes help desk and application support duties in rotation.

The candidate will manage SQL Server and cloud databases, perform installations and migrations, and tune performance while collaborating with Engineering and Operations professionals. Strong T‑SQL, clustering, and deadlock analysis are essential.