VDOT Tolling Senior MS SQL DBA
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).
Experience implementing and maintaining SQL clustering, database mirroring, and high-availability solutions.
Practical experience installing, upgrading, patching, and migrating SQL Server databases.
Strong analytical and troubleshooting skills, including the ability to investigate database performance and application connectivity issues.
Effective communication skills and the ability to document technical requirements, designs, and solutions clearly.
Benefits:
Medical, dental, and vision insurance.
401(k) retirement plan.
Competitive compensation.
Opportunities to support enterprise technology environments and work with modern database and cloud technologies.
Potential for professional development and career growth through client engagements.
Specific salary ranges, paid time off, and additional benefits are not detailed in the provided job description.
How Jobgether works: We use an AI-powered matching process to ensure your application is reviewed quickly, objectively, and fairly against the role's core requirements. Our system identifies the top-fitting candidates, and this shortlist is then shared directly with the hiring company. The final decision and next steps (interviews, assessments) are managed by their internal team. We appreciate your interest and wish you the best! Why Apply Through Jobgether?
Data Privacy Notice: By submitting your application, you acknowledge that Jobgether will process your personal data to evaluate your candidacy and share relevant information with the hiring employer. This processing is based on legitimate interest and pre-contractual measures under applicable data protection laws (including GDPR). You may exercise your rights (access, rectification, erasure, objection) at any time.
#LI-CL1