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