Senior Sql Database Administrator

For more details, please connect with Sagar Kaushik at or call at x 168

• The Virginia Department of Transportation (VDOT) Information Technology Division (ITD) Tolling group is seeking an experienced SQL Server / Cloud Database Administrator (DBA) to join the Tolling Engineering and Operations Team.
• The selected consultant will administer, support, monitor, tune, upgrade, patch, and migrate SQL Server and cloud databases supporting VDOT's Tolling environment.
• The position will focus heavily on SQL Server database administration, performance tuning, high availability, troubleshooting, database migrations, and cloud database technologies.
• The consultant will also participate in help desk and application support responsibilities as part of the Tolling team's operational rotation.
• The selected candidate will work closely with Engineering and Operations professionals and will be expected to independently perform complex database administration and troubleshooting activities.

• Administer and support SQL Server and cloud databases within the VDOT Tolling environment.
• Monitor databases to maintain and ensure database uptime, availability, and performance.
• Troubleshoot application and database issues involving connectivity, access, security, performance, and availability.
• Tune long-running SQL queries and database workloads.
• Diagnose and resolve deadlocks and blocking within production Tolling workloads.
• Analyze Extended Events, Query Store, and wait statistics to identify and resolve database performance issues.
• Perform SQL Server installations, upgrades, patching, migrations, and configuration.
• Support SQL Server 2022, SQL Server 2019+, and future SQL Server versions with failover clustering.
• Upgrade and migrate E-ZPass Virginia Tolling SQL Server environments, including SQL Server 2012 to SQL Server 2019 migrations.
• Perform compatibility evaluations and utilize Query Tuning Assistant and Database Migration Assistant (DMA) during database upgrades and migrations.
• Tune Very Large Databases (2 TB+), including index optimization, long-running workload analysis, and minimizing resource contention.
• Design, configure, maintain, and troubleshoot SQL Server clustering, mirroring, and high-availability environments.
• Write, code, debug, and optimize Transact-SQL (T-SQL).
• Review and refine existing database tasks and processes to align with agency and team priorities.
• Utilize operating system scripting utilities to support database maintenance, diagnosis, and troubleshooting.
• Review existing database implementations and recommend, execute, or direct necessary technical changes.
• Work with Azure Cloud database technologies and cloud-based data platforms.
• Support and troubleshoot database connectivity, access, authentication, security, and application integration issues.
• Work with SSIS, SSAS, and SSRS environments.
• Apply data modeling principles to support database design and implementation.
• Provide application and help desk support as part of the Tolling Engineering and Operations team rotation.
• Collaborate with Engineering and Operations professionals to resolve production and operational issues.
• Communicate technical information clearly and effectively, both verbally and in writing.
• Independently plan and accomplish complex database administration and operational tasks.
• Support continuous improvement of database environments, processes, and operational procedures.
• Follow applicable VDOT security, operational, and technology standards.
• C…