Senior SQL Database & Cloud DBA | Azure Expert

Mbi Llc; Mechanicsville, Northern (VA, KY); Hybrid; USD 100,000 - 150,000; Full time

Job summary

The Virginia Department of Transportation (VDOT) ITD Tolling group is seeking a SQL Server / Cloud DBA to administer and support SQL Server and cloud databases in the Tolling group. The role includes help desk and application support in rotation with the Tolling team, monitoring uptime, troubleshooting connectivity and security issues, and tuning long-running SQL workloads to meet agency priorities.

Experience with Azure Cloud, SQL clustering, and data modeling will help drive improvements

Qualifications

• At least 6 years of experience w/ Microsoft SQL Server database.
• At least 1 year of Azure, Snowflake, or Databricks experience.
• Master’s degree in computer science, information systems or related field.
• Experience communicating requirements and design artifacts.
• 3–4 years upgrading Tolling SQL Server environments from SQL 2012 to 2019.
• Experience diagnosing deadlocks and blocking in Tolling workloads.
• Experience tuning Very Large Databases (2 TB+) and reducing contention.

Responsibilities

• Administer and support SQL Server and cloud databases.
• Monitor databases to maintain uptime and availability.
• Troubleshoot connectivity, access, and security issues.
• Tune long running SQL and optimize queries.
• Review and refine database tasks to align with priorities.
• Utilize OS scripting for maintenance and diagnostics.
• Plan changes to existing database implementations and execute them.
• Perform SQL Server installations (2022, 2025+) with failover clustering.
• Apply data modeling principles.

Skills

MS SQL Server Database Management

SQL Server Tuning

Upgrading E-ZPass tolling databases

Diagnosing and resolving deadlocks and

Tuning Very Large Databases

SSIS, SSRS & SSAS

Transact-SQL

Installing, upgrading, patching and

Migration of SQL Server databases

Education

Master’s degree in computer science, information systems or other applicable and/or equivalent skills

Tools

Azure Cloud

Snowflake

Databricks

SSIS

SSAS

SSRS

Job description

The Virginia Department of Transportation (VDOT) ITD Tolling group is seeking a SQL Server / Cloud DBA to administer and support SQL Server and cloud databases in the Tolling group. The role includes help desk and application support in rotation with the Tolling team, monitoring uptime, troubleshooting connectivity and security issues, and tuning long-running SQL workloads to meet agency priorities.

Experience with Azure Cloud, SQL clustering, and data modeling will help drive improvements