SQL Database Administrator

InfoStride; Mechanicsville (VA); Hybrid; USD 110,000 - 160,000; Full time

Job summary

VDOT ITD Tolling is seeking an experienced SQL Server DBA to administer and optimize SQL Server and cloud databases supporting Tolling operations. Hybrid work arrangement in Mechanicsville, VA. Responsibilities include performance tuning, upgrades, and 24/7 support across on-premises and cloud platforms.

Requirements include 6+ years in SQL Server DBA, 3+ years tuning, 4+ years upgrading environments, and strong T-SQL skills. Experience with Azure, Snowflake, or Databricks is preferred.

Qualifications

• 6+ years of Microsoft SQL Server DBA experience.
• "3+ years of SQL Server performance tuning".
• "2+ years upgrading E-ZPass/Tolling SQL Server environments".
• "3+ years diagnosing and resolving deadlocks and blocking in production workloads".
• "2+ years tuning 2TB+ Very Large Databases".
• "3+ years experience with SSIS, SSRS, and SSAS".
• "4+ years installing, upgrading, patching, and migrating SQL Server".
• "Strong T-SQL coding and debugging skills".
• "Experience with Windows Server and SQL Server high availability/clustering".
• "1+ year of Azure, Snowflake, or Databricks experience; certification may substitute for experience".
• "Strong communication, troubleshooting, and problem-solving skills".
• "Master's degree in Computer Science, Information Systems, or equivalent education/experience"

Responsibilities

• Administer and support SQL Server 2019+ environments, including high availability, clustering, and failover.
• Perform SQL Server installation, patching, upgrading, migration, and maintenance.
• Monitor database health, uptime, availability, security, and connectivity.
• Troubleshoot and resolve deadlocks, blocking, performance, and application/database issues.
• Tune long-running SQL queries and Very Large Databases (2TB+), including indexing and resource contention.
• Support upgrades of E-ZPass Virginia Tolling databases, including compatibility assessment, DMA, and Query Tuning Assistant.
• Develop, debug, and optimize T-SQL.
• Utilize Extended Events, Query Store, wait statistics, and OS scripting for diagnosis and maintenance.
• Work with SSIS, SSRS, and SSAS.
• Support Azure and other cloud database platforms such as Snowflake and Databricks.
• Collaborate with engineering and operations teams and document technical requirements/designs.

Skills

SQL Server DBA

Performance tuning

2TB+ databases

SSIS SSRS SSAS

Windows Server

Azure

T-SQL

Deadlock resolution

Education

Master's degree in Computer Science or Information Systems

Tools

SSDT/SSMS

Job description

Job ID: 812167

Job Title: SQL Server DBA

Work Arrangement: Hybrid

Work Location: 9120 Lockwood Blvd, Mechanicsville, VA 23116

Interview Type: Both Web Cam and In Person Interview

Job Description:

VDOT ITD Tolling is seeking an experienced SQL Server / Cloud DBA to administer, support, and optimize SQL Server and cloud databases supporting Tolling operations. The role includes database administration, performance tuning, troubleshooting, upgrades/migrations, and rotational help desk/application support.

Key Responsibilities

• Administer and support SQL Server 2019+ environments, including high availability, clustering, and failover.
• Perform SQL Server installation, patching, upgrading, migration, and maintenance.
• Monitor database health, uptime, availability, security, and connectivity.
• Troubleshoot and resolve deadlocks, blocking, performance, and application/database issues.
• Tune long-running SQL queries and Very Large Databases (2TB+), including indexing and resource contention.
• Support upgrades of E-ZPass Virginia Tolling databases, including compatibility assessment, DMA, and Query Tuning Assistant.
• Develop, debug, and optimize T-SQL.
• Utilize Extended Events, Query Store, wait statistics, and OS scripting for diagnosis and maintenance.
• Work with SSIS, SSRS, and SSAS.
• Support Azure and other cloud database platforms such as Snowflake and Databricks.
• Collaborate with engineering and operations teams and document technical requirements/designs.

Required Qualifications

• 6+ years of Microsoft SQL Server DBA experience.
• 3+ years of SQL Server performance tuning.
• 2+ years upgrading E-ZPass/Tolling SQL Server environments.
• 3+ years diagnosing and resolving deadlocks and blocking in production workloads.
• 2+ years tuning 2TB+ Very Large Databases.
• 3+ years experience with SSIS, SSRS, and SSAS.
• 4+ years installing, upgrading, patching, and migrating SQL Server.
• Strong T-SQL coding and debugging skills.
• Experience with Windows Server and SQL Server high availability/clustering.
• 1+ year of Azure, Snowflake, or Databricks experience; certification may substitute for experience.
• Strong communication, troubleshooting, and problem-solving skills.
• Master's degree in Computer Science, Information Systems, or equivalent education/experience.

Preferred

• SQL Server 2022/2025+ and Failover Clustering.
• Azure cloud database administration.
• Experience supporting large-scale tolling/E-ZPass production environments.
• Knowledge of data modeling principles.