Senior MS SQL Database Administrator

Position: - Senior MS SQL Database Administrator Req ID: 812167

Location: 9120 Lockwood Blvd, Mechanicsville, VA 23116 – Hybrid

Interview type: Both Video & In-Perso Interview

Skill

Required / Desired

Amount

of Experience

MS SQL Server Database Management

Required

6

Years

SQL Server Tuning

Required

3

Years

Upgrading E-ZPass tolling databases

Required

2

Years

Diagnosing and resolving deadlocks and blocking in Tolling production workloads

Required

3

Years

Tuning Very Large Databases (2 TB+) including index optimization, long-running workload analysis, and minimizing resource contention

Required

2

Years

SQL Server / Cloud DBA to join the Tolling Eng and Ops Team to administer and support SQL Server and cloud databases in the Tolling group; the role also includes help desk and application support responsibilities.

The Virginia Department of Transportation (VDOT) Information Technology Division (ITD) Tolling group is seeking a SQL Server database /Cloud database administrator to join the Tolling Engineering and Operations Team. The selected candidate will administer and support SQL Server and cloud databases in the Tolling group. Additional help desk and application support responsibilities will be part of rotation with the Tolling team.

The selected candidate has:

* Expertise working as a SQL Server DBA * Expertise working with SQL clustering, mirroringand high availability * Experience working with large SQL databases * Expertise in writing Transact SQL * Experience tuning SQL Server databases * Expertise in installing, upgrading, patching andmigrating SQL Server databases * Experience working on a Windows platform * Exposure to SSIS, SSAS, & SSRS * Experience working with Azure Cloud