JobCubby JobCubby
Sign up
SoHo Dragon

SQL Server / Cloud Database Administrator (DBA) - Expert

SoHo Dragon Richmond, Virginia, United States

IT Services and IT Consulting · 201-500 employees

Oct 07
dba Senior (5-10 yrs) Contractor United States
Create a free account to apply — email only, no card. You can also save this posting or score it against your profile with AI.

Applying here? Try the free cover letter tool — paste this posting and your résumé, no account needed.

About the role

The role involves administering, monitoring, and tuning SQL Server and cloud databases within the VDOT Tolling environment. Responsibilities include performing migrations, resolving performance issues, and collaborating with engineering teams on production support.

What they look for

SQL Server Cloud Database Administration Performance Tuning High Availability T-SQL Azure SSIS SSAS SSRS Database Migration Clustering Mirroring VLDB Extended Events Query Store Data Modeling

Requirements

Candidates must have over 6 years of SQL Server DBA experience and specific expertise in upgrading E-ZPass Tolling environments. A master's degree in a related field or equivalent experience is required, along with proficiency in cloud platforms and high availability configurations.

Full description

SQL Server / Cloud Database Administrator (DBA) – Expert - Mechanicsville, VA (Hybrid)

**Key Requirements:** - Local to Virginia candidates only - Prior State or Federal client experience

- Contract: 12 months

Role Summary Supporting VDOT’s Tolling environment by administering, monitoring, tuning, patching, and migrating SQL Server and cloud databases. The role includes performance tuning, high availability, troubleshooting, and help desk/operational rotation support.

  Key Responsibilities

  • Administer SQL Server & cloud databases; maintain uptime, performance, and availability
  • Diagnose/resolve deadlocks, blocking, and performance issues using Extended Events, Query Store & wait statistics
  • Perform SQL Server installs, upgrades, patching, and migrations (including SQL 2012 → 2019)
  • Tune Very Large Databases (2 TB+); optimize indexes and reduce resource contention
  • Configure and maintain clustering, mirroring, and HA environments
  • Write, debug, and optimize T-SQL; support SSIS, SSAS, and SSRS
  • Work with Azure Cloud and cloud-based data platforms
  • Collaborate with Engineering & Operations teams on production issues

  Required Qualifications

  • 6+ years of Microsoft SQL Server DBA experience (expert level)
  • 3–4 years hands-on upgrading E-ZPass Virginia Tolling environments (SQL 2012 → SQL 2019)
  • Strong experience with clustering, mirroring, HA, and VLDBs (2 TB+)
  • Proficiency in T-SQL, Extended Events, Query Store, DMA, and Query Tuning Assistant
  • 1+ year with Azure, Snowflake, or Databricks (relevant cert may substitute)
  • Experience with SSIS, SSAS, SSRS, and Windows platform support
  • Knowledge of data modeling principles
  • Master’s degree in CS, Information Systems, or related field (or equivalent experience)

Similar roles