Senior Database Administrator, MS SQL Server
Posted 2hrs ago
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Senior SQL Server DBA supporting Virginia transportation tolling systems. Administering, optimizing, and troubleshooting Microsoft SQL Server and cloud database environments.
Responsibilities:
- Administer, maintain, monitor, and support Microsoft SQL Server database environments
- Perform SQL Server installations, upgrades, patching, migrations, and configuration activities
- Support SQL Server 2022, SQL Server 2025 and later versions, including failover clustering configurations
- Monitor database health, availability, connectivity, and operational performance
- Manage large SQL Server databases and support scalability, stability, and efficiency
- Review database implementations and recommend, execute, or coordinate improvements
- Support high-availability technologies, including clustering, mirroring, and failover configurations
- Analyze and tune databases to improve performance and resource utilization
- Identify, troubleshoot, and optimize long-running SQL queries
- Write, debug, and maintain T-SQL queries and scripts
- Diagnose and resolve database and application issues involving connectivity, access, security, and performance
- Use Windows operating system scripting utilities for database maintenance, diagnostics, troubleshooting, and administration
- Support cloud database environments and Microsoft Azure and other applicable data platforms
- Apply data modeling principles to database design, maintenance, and optimization
- Collaborate on database architecture, implementation, and operational improvements
- Participate in rotating help desk and application support responsibilities
- Troubleshoot database-related application incidents and support timely resolution
- Assist with operational continuity and system availability for tolling applications
- Collaborate with engineering, operations, application development, and technical support professionals
- Communicate technical findings, recommendations, and solutions to stakeholders
- Prepare and maintain technical documentation using standard requirements and design artifacts
- Independently plan, prioritize, and complete complex database administration assignments
- Maintain current technical knowledge of database technologies and VDOT-supported systems
Requirements:
- 2+ years of experience managing and administering Microsoft SQL Server databases
- 2+ years of experience installing, upgrading, patching, and migrating SQL Server databases
- 1+ year of experience with SQL Server database performance tuning and optimization
- 1+ year of experience writing, coding, and debugging Transact-SQL (T-SQL)
- 1+ year of experience with Microsoft Azure, Snowflake, or Databricks; an applicable certification may be accepted in place of this experience
- Bachelor's degree in Computer Science, Information Systems, or a related discipline, or equivalent skills, knowledge, and professional work experience
- Expertise in SQL Server database administration and support
- Knowledge of SQL Server clustering, database mirroring, and high-availability configurations
- Experience supporting large SQL Server databases and complex database environments
- Experience administering SQL Server databases on Windows operating systems
- Ability to troubleshoot database connectivity, security, access, and application-related issues
- Knowledge of database maintenance procedures, SQL Server installations, and system upgrades
- Experience communicating technical information using standard requirements and design documentation
- Strong analytical, troubleshooting, problem-solving, and technical communication skills
- Ability to independently manage complex assignments and collaborate with engineering and operations teams
- Must successfully complete a fingerprint-based background check
- Must be willing to maintain knowledge of current VDOT technologies through continuing education at personal expense
- Must physically reside within the United States throughout the assignment; offshore IT contractors are not permitted
- Must be legally authorized to work in the United States without employer sponsorship, now or in the future
- Preferred: 1+ year of experience with SSIS, SSRS, and SSAS
- Preferred: 1+ year of experience administering cloud databases using Microsoft Azure, Snowflake, and/or Databricks
- Preferred: Familiarity with Microsoft SQL Server 2019 and later versions
- Preferred: Knowledge of cloud database architecture, administration, and operational support
- Preferred: Experience supporting cloud-based data platforms in enterprise environments
Benefits:
- Remote work arrangement
- Continuing education to maintain VDOT technology knowledge, at the contractor’s own expense

















