Senior MS SQL DBA

• Monitor databases to maintain/ensure database uptime and availability.

• Troubleshoot application/database issues related to connectivity, access, security, etc.

• Tune long running SQL

• Review & refine existing database tasks and processes to better align with agency/group priorities.

• Leverage & utilize O/S scripting utilities in support of database maintenance/diagnosis/support.

• Review the existing database implementation and propose, execute, and/or direct necessary changes.

• Perform SQL Server installations (2022,2025+ w/ failover clustering).

• Support SQL Server databases (administration, support, tuning).

• Knowledgeable of data modeling principles

• Expertise working with SQL clustering, mirroring and high availability

• Experience working with large SQL databases

• Expertise in writing Transact SQL

• Experience tuning SQL Server databases

• Expertise in installing, upgrading, patching and migrating SQL Server databases

• Experience working on a Windows platform

• Exposure to SSIS, SSAS, & SSRS

• Experience working with Azure Cloud

The selected candidate will, * At least 2 years of experience w/ Microsoft SQL Server database

• At least 1 year of Azure, Snowflake, or Databricks experience (a certification is acceptable in lieu of experience)

• Bachelor’s degree in computer science, information systems or other applicable and/or equivalent skills, knowledge and/or work history

• Demonstrated experience in communicating effectively using standard requirements and design artifacts

Desired knowledge of and experience with the following technologies:

• SQL Server 2019+

• Cloud databases (Azure, Snowflake, and/or Databricks)

Special Instructions to Applicants:

• This position requires a fingerprint-based background check.

• The successful contractor will be required to continue education at own expense to stay current with VDOT technologies.

Required/Desired Skills

Skill Required/Desired Amount of Experience MS SQL Server Database Management Required 2.0 Years SQL Server Tuning Required 1.0 Years Experience working with SSIS, SSRS & SSAS Desired 1.0 Years Coding & debugging Transact SQL Required 1.0 Years Expertise in installing, upgrading, patching and migrating SQLServer databases Required 2.0 Years DB Administration on Azure Cloud, Snowflake, and/or Databricks Nice to have 1.0 Years