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.