Senior MS SQL DBA – Tolling & Azure Expert (Onsite)

Transcend IT Solutions; Mechanicsville (VA); Presencial; USD 165 000 - 234 000; Tempo parcial

Resumo da oferta

Transcend IT Solutions seeks a Senior MS SQL Database Administrator for an onsite contract in Mechanicsville, VA. The role requires deep SQL Server expertise, tolling system experience, and strong tuning skills.

The candidate will work in a demanding tolling environment with deadlock analysis, large databases, and Azure familiarity. The position emphasizes upgrading SQL Server environments, performance tuning, and hands-on DBA duties across 2 TB+ databases with SSIS/SSRS/SSAS usage.

Qualificações

• 6+ years of MS SQL Server Database Management experience.
• 3+ years SQL Server tuning experience.
• 2+ years upgrading E-Z Pass tolling databases.
• 3+ years diagnosing and resolving deadlocks and blocking in Tolling workloads.
• 2+ years tuning Very Large Databases (2 TB+) with index optimization and workload analysis.
• 3+ years working with SSIS, SSRS & SSAS.

Conhecimentos

Azure

SQL Server

SSAS

SSIS

SSRS

T-SQL

Formação académica

Master's degree in CS/IS or related field

Ferramentas

Query Tuning Assistant

Database Migration Assistant

Extended Events

Descrição da oferta de emprego

Transcend IT Solutions seeks a Senior MS SQL Database Administrator for an onsite contract in Mechanicsville, VA. The role requires deep SQL Server expertise, tolling system experience, and strong tuning skills.

The candidate will work in a demanding tolling environment with deadlock analysis, large databases, and Azure familiarity. The position emphasizes upgrading SQL Server environments, performance tuning, and hands-on DBA duties across 2 TB+ databases with SSIS/SSRS/SSAS usage.