Tolling Senior MS SQL DBA

Team: IT

Location: US

Commitment: Full-time

Workplace Type: remote

Accountabilities

• Administer, monitor, and support Microsoft SQL Server databases and cloud database environments to maintain high availability, reliability, security, and performance.

• Configure, manage, and troubleshoot SQL Server clustering, database mirroring, failover clustering, and other high-availability solutions.

• Install, upgrade, patch, migrate, and maintain SQL Server databases, including SQL Server 2022 and newer versions, as required.

• Analyze database performance, identify bottlenecks, and optimize long-running SQL queries and database workloads.

• Develop, troubleshoot, and maintain Transact-SQL scripts to support database operations, automation, and application requirements.

• Diagnose and resolve application and database issues involving connectivity, access permissions, security, and system performance.

• Support cloud database administration using Microsoft Azure and, where applicable, Snowflake or Databricks.

• Use operating system scripting utilities and related tools to automate database maintenance, diagnostics, and troubleshooting activities.

• Review existing database implementations, tasks, and operational processes, recommending and implementing improvements aligned with organizational priorities.

• Apply data modeling principles and support database design, maintenance, and optimization initiatives.

• Work with engineering and operations professionals to resolve technical issues, maintain service continuity, and support tolling applications.

• Participate in a rotating schedule of help desk and application support responsibilities as part of the broader technical team.

• Document technical requirements, design decisions, database changes, and operational procedures using established standards and artifacts.

• Maintain current technical knowledge through ongoing professional development and training.

Requirements:

• At least 2 years of experience working with Microsoft SQL Server database administration, including database support, maintenance, troubleshooting, and performance optimization.

• Demonstrated experience with SQL Server performance tuning, including query optimization and troubleshooting long-running SQL operations.

• Strong knowledge of SQL Server high-availability technologies, including clustering, mirroring, and failover configurations.

• Experience installing, upgrading, patching, and migrating SQL Server databases.

• Proficiency in writing, debugging, and maintaining Transact-SQL (T-SQL) scripts.

• At least 1 year of experience with Azure, Snowflake, or Databricks, or a relevant certification accepted in place of practical experience.

• Familiarity with SQL Server 2019 or later and an understanding of database administration in enterprise environments.

• Exposure to SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and SQL Server Reporting Services (SSRS); experience with these technologies is beneficial.

• Experience working with Windows operating systems and using scripting utilities for database administration and diagnostics.

• Knowledge of data modeling principles, database architecture, access management, and security best practices.

• A bachelor's degree in computer science, information systems, or a related field, or equivalent skills, knowledge, education, and professional experience.

• Demonstrated ability to communicate technical information clearly through written documentation, requirements, design artifacts, and verbal discussions.

• Strong analytical and problem-solving skills, sound technical judgment, and the ability to independently manage complex assignments.

• Ability to collaborate effectively with engineering and operations teams while prioritizing database reliability and service quality.

• Willingness to complete a fingerprint-based background check and pursue ongoing technical education at personal expense to remain current with relevant technologies.

Benefits:

• Contract duration: Initial 10-month full-time contract.

• Remote work: Remote working arrangement within the United States.

• Technical challenges: Hands-on experience supporting enterprise SQL Server environments, high-availability infrastructure, and cloud database technologies.

• Public-sector impact: Opportunity to contribute to the reliability and performance of technology supporting transportation and tolling operations.

• Professional development: Exposure to modern SQL Server versions, cloud platforms, database optimization, and enterprise systems support.

• Collaborative environment: Work alongside engineering and operations professionals on critical database and application support initiatives.

• Continuous learning: Opportunity to strengthen expertise in SQL Server administration, Azure cloud databases, and related data technologies.