Senior MS SQL Database Administrator (Only Local)

Transcend IT Solutions; Mechanicsville (VA); On-site; USD 165,000 - 234,000; Part time

Job summary

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.

Qualifications

• 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.

Skills

Azure

SQL Server

SSAS

SSIS

SSRS

T-SQL

Education

Master's degree in CS/IS or related field

Tools

Query Tuning Assistant

Database Migration Assistant

Extended Events

Job description

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