Senior MS SQL DBA
About The Position
The Senior MS SQL DBA supports SQL Server databases through administration, troubleshooting, tuning, installation, and maintenance. The role monitors databases to maintain uptime and availability, resolves application and database issues related to connectivity, access, and security, and reviews existing implementations and processes to recommend or carry out needed changes. The DBA also performs SQL Server installations, including versions 2022 and 2025+ with failover clustering, and uses operating-system scripting utilities to support database maintenance, diagnosis, and support. The successful candidate works independently on complicated tasks and relies on experience and judgment to plan and accomplish goals, while collaborating with Engineering and Operations professionals. Clear spoken and written communication is required. The contractor must complete continuing education at their own expense to stay current with VDOT technologies. A fingerprint-based background check is required.
Requirements
- At least 2 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.
- Bachelor’s degree in computer science, information systems, or another applicable field, or equivalent skills, knowledge, and/or work history.
- Demonstrated ability to communicate effectively using standard requirements and design artifacts.
- At least 1 year of SQL Server tuning experience.
- At least 1 year of experience coding and debugging Transact-SQL.
- At least 2 years of experience installing, upgrading, patching, and migrating SQL Server databases.
- Expertise working as a SQL Server DBA, including SQL clustering, mirroring, and high availability.
- Experience working with large SQL databases and on a Windows platform.
- Knowledge of data modeling principles.
Nice To Haves
- At least 1 year of experience working with SSIS, SSRS, and SSAS.
- At least 1 year of database administration experience on Azure Cloud, Snowflake, and/or Databricks.
- Knowledge of and experience with SQL Server 2019+ and cloud databases such as Azure, Snowflake, and/or Databricks.
Responsibilities
- Monitor databases to maintain and ensure uptime and availability.
- Troubleshoot application and database issues involving connectivity, access, security, and related concerns.
- Tune long-running SQL.
- Review and refine database tasks and processes to better align with agency and group priorities.
- Use operating-system scripting utilities for database maintenance, diagnosis, and support.
- Review existing database implementations and propose, execute, or direct necessary changes.
- Perform SQL Server installations, including versions 2022 and 2025+ with failover clustering.
- Administer, support, and tune SQL Server databases.
- Work with Engineering and Operations professionals.
- Communicate clearly and effectively in speech and writing.
- Complete continuing education at the contractor's own expense to stay current with VDOT technologies.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Career Level
Senior
