Senior Database Administrator, MS SQL Server

This is a fully remote position, open to applicants in Virginia.

📋 Description

• Oversee, sustain, monitor, and provide support for Microsoft SQL Server database environments.

• Conduct installations, upgrades, patching, migrations, and configuration tasks for SQL Server.

• Provide support for SQL Server 2022, SQL Server 2025, and later versions, including configurations for failover clustering.

• Monitor the health, availability, connectivity, and operational performance of databases.

• Manage extensive SQL Server databases while ensuring scalability, stability, and efficiency.

• Evaluate database implementations and suggest, implement, or coordinate enhancements.

• Support high-availability technologies such as clustering, mirroring, and failover setups.

• Analyze and optimize databases to enhance performance and resource utilization.

• Identify, troubleshoot, and enhance long-running SQL queries.

• Write, debug, and maintain T-SQL queries and scripts.

• Diagnose and resolve issues related to databases and applications, including connectivity, access, security, and performance.

• Utilize Windows operating system scripting tools for database maintenance, diagnostics, troubleshooting, and administration.

• Provide support for cloud database environments, including Microsoft Azure and other relevant data platforms.

• Implement data modeling principles in database design, maintenance, and optimization.

• Collaborate on database architecture, implementation, and operational enhancements.

• Participate in rotating help desk and application support duties.

• Troubleshoot incidents related to database applications and ensure timely resolution.

• Assist in maintaining operational continuity and system availability for tolling applications.

• Work collaboratively with engineering, operations, application development, and technical support teams.

• Communicate technical insights, recommendations, and solutions to stakeholders effectively.

• Prepare and keep technical documentation up to date using standard requirements and design artifacts.

• Independently plan, prioritize, and execute complex database administration tasks.

• Stay updated with the latest technical knowledge of database technologies and VDOT-supported systems.

⛳️ Requirements

• Minimum of 2 years of experience in managing and administering Microsoft SQL Server databases.

• At least 2 years of experience in installing, upgrading, patching, and migrating SQL Server databases.

• A minimum of 1 year of experience in performance tuning and optimization of SQL Server databases.

• At least 1 year of experience in writing, coding, and debugging Transact-SQL (T-SQL).

• A minimum of 1 year of experience with Microsoft Azure, Snowflake, or Databricks; an applicable certification may substitute for this experience.

• Bachelor's degree in Computer Science, Information Systems, or a related field, or equivalent skills and professional experience.

• Proficiency in SQL Server database administration and support.

• Knowledge of SQL Server clustering, database mirroring, and high-availability configurations.

• Experience in supporting large SQL Server databases and complex database environments.

• Experience administering SQL Server databases on Windows operating systems.

• Ability to troubleshoot issues related to database connectivity, security, access, and applications.

• Familiarity with database maintenance procedures, SQL Server installations, and system upgrades.

• Experience in communicating technical information through standard requirements and design documentation.

• Strong analytical, troubleshooting, problem-solving, and technical communication skills.

• Capability to independently manage complex tasks and work collaboratively with engineering and operations teams.

• Must pass a fingerprint-based background check successfully.

• Must be willing to enhance knowledge of current VDOT technologies through continuing education at personal cost.

• Must physically reside in the United States during the assignment; offshore IT contractors are not allowed.

• Must have legal authorization to work in the United States without employer sponsorship, both now and in the future.

• Preferred: At least 1 year of experience with SSIS, SSRS, and SSAS.

• Preferred: At least 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 in supporting cloud-based data platforms in enterprise settings.

🏝️ Benefits

• Flexible remote work arrangement.

• Opportunities for continuing education to maintain knowledge of VDOT technologies, at the contractor’s own expense.