Senior MS SQL Database Administrator (Only Local)

Position Title: Senior MS SQL Database Administrator

Job Location: Mechanicsville, VA, USA

Work Model: Onsite

Employment Type: Contract

Estimated Duration (In Months): 9

Shift: Mon-Fri, 8:00AM - 5:00PM

Must have Skills/Attributes: Azure, SQL Server, SSAS, SSIS, SSRS

In Person Interview Required.

Position Description

REQUIRED EDUCATION:

* Master s degree in computer science, information systems or other applicable and/or equivalent skills, knowledge and/or work history

REQUIRED SKILLS/ EXPERIENCE:

MS SQL Server Database Management: 6 Years

SQL Server Tuning: 3 Years

Upgrading E-Z Pass tolling databases: 2 Years

Diagnosing and resolving deadlocks and blocking in Tolling production workloads: 3 Years

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

Experience working with SSIS, SSRS & SSAS: 3 Years

Coding & debugging Transact SQL: 1 Years

Expertise in installing, upgrading, patching and migrating SQL c-Server databases: 4 Years

At least 1 year of Azure, Snowflake, or Data bricks experience

Demonstrated experience in communicating effectively using standard requirements and design artifacts

Minimum 3 4 years hands-on experience upgrading E-Z Pass Tolling SQL Server environments from SQL 2012 to SQL 2019, including compatibility evaluations, Query Tuning Assistant, and Database Migration Assistant

Experience diagnosing and resolving deadlocks and blocking in Tolling production workloads, including extended events, Query Store, and wait statistical analysis

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