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
