VDOT Tolling Senior MS SQL DBA

This position is listed on behalf of a partner company, who manages all applications and next steps. Our partner is looking for a VDOT Tolling Senior MS SQL DBA based in the United States. We are seeking an experienced Senior Microsoft SQL Server Database Administrator to support critical tolling systems and enterprise database infrastructure. In this role, you will oversee database installation, administration, performance tuning, and availability to ensure reliable and efficient operations. You will work with large-scale SQL Server databases, high-availability configurations, and cloud data platforms. Your expertise will help troubleshoot complex database and application issues, optimize query performance, and maintain secure, resilient environments. The position offers opportunities to work with modern SQL Server technologies and cloud solutions, including Azure, Snowflake, and Databricks. This role is ideal for a technically strong database professional who values reliability, problem-solving, and continuous improvement. Accountabilities: You will manage and optimize SQL Server database environments supporting essential business applications and tolling operations. Your responsibilities will include maintaining database availability, implementing database infrastructure changes, resolving technical issues, and ensuring reliable performance across on-premises and cloud-based environments. - Install and configure Microsoft SQL Server, including SQL Server 2022 and newer versions, with failover clustering. - Administer, maintain, and support SQL Server databases to ensure stability, security, and operational efficiency. - Monitor database health, performance, uptime, and availability, proactively identifying and resolving potential issues. - Troubleshoot database and application problems involving connectivity, access permissions, security, and related dependencies. - Analyze and optimize long-running SQL queries to improve database performance and responsiveness. - Implement and maintain SQL Server clustering, mirroring, and high-availability configurations. - Perform database upgrades, patching, migrations, and other lifecycle management activities.

- Work with large SQL databases and apply database tuning techniques to improve performance and resource utilization. - Support cloud database technologies, including Azure, Snowflake, and/or Databricks. - Apply data modeling principles to support effective database design and management. - Work with Windows-based environments and relevant SQL Server Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS) technologies. - Communicate technical findings and solutions using standard requirements documentation, design artifacts, and other established documentation practices. Requirements: The ideal candidate will have hands-on experience administering Microsoft SQL Server databases, strong troubleshooting and performance optimization skills, and familiarity with cloud data platforms. A solid understanding of database architecture, high availability, and enterprise database operations is essential. - At least 2 years of experience working with Microsoft SQL Server databases. - At least 1 year of experience with Azure, Snowflake, or Databricks; a relevant certification may substitute for this experience. - A bachelor's degree in computer science, information systems, or a related field, or equivalent skills, knowledge, and professional experience. - Experience working in a Windows environment. - Exposure to SSIS, SSAS, and SSRS. - Demonstrated experience tuning SQL Server databases and working with large database environments. - Experience with Azure Cloud and cloud-based database technologies. - Strong knowledge of SQL Server 2019 or later, with expertise in SQL Server database administration. - Expertise in writing Transact-SQL (T-SQL).