VDOT Programmer Analyst 4 – Senior Microsoft SQL Developer

Job overview

The VDOT Programmer Analyst 4 – Senior Microsoft SQL Developer role is hybrid in Mechanicsville, VA, with onsite work required one day per week; compensation is listed at a maximum vendor submittal rate of $112.95 per hour. The role supports modernization of an enterprise tolling transaction platform. As part of an Agile/Scrum project team, the developer modernizes and optimizes SQL components in a high-availability SQL Server environment on Azure virtual machines. The work supports a partial platform rewrite using microservices and modularization, with attention to performance, scalability, maintainability, and PCI requirements.

What you'll do

• Develop and optimize T-SQL queries, stored procedures, functions, and views
• tune performance and indexing
• modernize SQL components while supporting legacy code
• support microservices-aligned features and database models
• maintain Always On availability groups
• develop migration scripts and ETL logic using SSIS and Databricks
• follow PCI and data-retention requirements
• contribute changes through Azure DevOps and GitHub CI/CD
• participate in Agile ceremonies.

What we're looking for

Skills & competencies

vdot programmer analyst 4

senior microsoft sql developer

sql server

t-sql

azure virtual machines

always on

ssis

databricks

azure devops

hybrid

mechanicsville va

$112.95/hr

Work arrangement

• Weekend coverage required

Why this role

Hybrid schedule requires onsite work one day per week, and only local candidates are considered. The posting describes a 12-month contract with possible extension.

About the employer

PeopleNTech LLC is hiring for this role. Industry: Regulation and Administration of Transportation Programs. Sector: 92.