VDOT Senior MS SQL Database Administrator

Join the Virginia Department of Transportation (VDOT) Information Technology Division (ITD) Tolling group as a SQL Server / Cloud DBA. This role is perfect for those who are passionate about database administration and support in a dynamic environment. Located in Mechanicsville, VA, this position offers the opportunity to work in a vibrant community with easy access to the state capital and various outdoor activities.

Responsibilities

• Administer and support SQL Server and cloud databases within the Tolling group.
• Participate in help desk and application support responsibilities as part of a rotation with the Tolling team.
• Monitor databases to ensure uptime and availability.
• Troubleshoot application/database issues related to connectivity, access, and security.
• Tune long-running SQL queries for optimal performance.
• Review and refine existing database tasks and processes to align with agency/group priorities.
• Utilize O/S scripting utilities for database maintenance, diagnosis, and support.
• Perform SQL Server installations, including failover clustering.
• Support SQL Server databases with administration, support, and tuning.
• Propose, execute, and/or direct necessary changes to existing database implementations.

Qualifications

• At least 6 years of experience with Microsoft SQL Server databases.
• At least 1 year of experience with Azure, Snowflake, or Databricks (a certification is acceptable in lieu of experience).
• Master's degree in computer science, information systems, or equivalent skills, knowledge, and work history.
• Demonstrated experience in effective communication using standard requirements and design artifacts.
• Minimum 3-4 years of hands-on experience upgrading E‐ZPass Virginia Tolling SQL Server environments from SQL 2012 to SQL 2019.
• Experience diagnosing and resolving deadlocks and blocking in Tolling production workloads.
• Experience tuning Very Large Databases (2 TB) including index optimization and minimizing resource contention.

Desired Experience

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

Special Instructions to Applicants

• This position requires a fingerprint-based background check.
• Successful candidates will be required to continue education at their own expense to stay current with VDOT technologies.