Senior SQL Server DBA — Hybrid, Cloud & High Availability

ADP, Inc.; Richmond (VA); Hybrid; USD 83,000 - 96,000; Full time

Job summary

Virginia Department of Transportation (VDOT) ITD Tolling group seeks a Senior MS SQL Database Admin to administer SQL Server and cloud databases. The role includes help desk support and a rotation with the Tolling team for application support.

The candidate will monitor database uptime, troubleshoot issues, tune SQL, and implement migrations with a focus on high availability. Hybrid work arrangement available in the Tolling group.

Qualifications

• Minimum 6 years of Microsoft SQL Server database experience.
• At least 1 year with Azure, Snowflake, or Databricks (cert acceptable).
• Master’s degree or equivalent in a related field is required.
• Experience upgrading Tolling SQL Server environments and tuning queries.

Responsibilities

• Monitor databases to ensure uptime and availability.
• Troubleshoot connectivity, access, and security issues.
• Tune long running SQL and optimize performance.
• Review and refine existing database tasks to align with priorities.
• Perform SQL Server installations and migrations (2022+).
• Leverage OS scripting for maintenance and diagnostics.
• Propose changes after evaluating current implementations.

Skills

MS SQL Server

SQL tuning

Deadlock analysis

Azure Cloud

Snowflake/Databricks

Transact-SQL

Database migrations

SSIS/SSAS/SSRS

Education

Master’s degree in computer science or information systems

Tools

None

Job description

Virginia Department of Transportation (VDOT) ITD Tolling group seeks a Senior MS SQL Database Admin to administer SQL Server and cloud databases. The role includes help desk support and a rotation with the Tolling team for application support.

The candidate will monitor database uptime, troubleshoot issues, tune SQL, and implement migrations with a focus on high availability. Hybrid work arrangement available in the Tolling group.