Skip to main content
McCarthy Search

VDOT Programmer Analyst 4

L5

peoplentechMechanicsville, VAtoday

$112.95/hr

Occupations

Software DevelopersComputer Systems Engineers/ArchitectsComputer Systems Analysts

Industries

Custom Computer Programming ServicesComputer Systems Design ServicesSoftware Publishers
Job Description: VDOT Programmer Analyst 4 (804326)
Title/Role: VDOT Programmer Analyst 4Start Date: 08/03/2026
End Date: 06/30/2027 Worksite Address: 9120 Lockwood Blvd Mechanicsville, VA 23116 Agency Interview Type: Both Web Cam and In Person Interview
Work Arrangement: HybridShort Description:
Senior Microsoft SQL Developer. Maximum Vendor Submittal Rate is $112.95/hr.
Complete Description
Position Summary: The Senior Microsoft SQL Developer will support the modernization of anenterprise tolling transaction platform undergoing a partial rewrite usingmicroservices and modularization. This role is a critical part of the Agile/Scrum project team and is responsible for developing, optimizing, andmodernizing SQL components within a business-critical, high-availability SQLServer environment running on Azure Virtual Machines (IaaS). The developer willcollaborate with solution architects, cloud engineers, API developers, andtesters to ensure high performance, scalability, and maintainability of thedatabase platform, reporting to the Development Manager.
Key Responsibilities:
  • Develop and optimize T-SQL queries, stored procedures, functions, and viewsto support new application capabilities.
  • Perform advanced performance tuning, indexing strategies, and queryoptimization for a business-critical SQL environment.
  • Modernize existing SQL components while supporting legacy SQL code andstructures.
  • Support new feature development aligned with the microservices-basedapplication modernization approach.
  • Collaborate with .NET Core/C# developers to ensure efficient data accesspatterns and API/database integrations.
  • Participate in modernizing existing database models to support modular, scalable architecture.
  • Support and maintain high availability environments using Always Onavailability groups.
  • Develop migration scripts, ETL logic, and integration solutions using SSISand Databricks.
  • Ensure PCI compliance requirements are followed and implement data retention rules as required.
  • Contribute SQL-related changes through CI/CD pipelines using Azure DevOps and GitHub workflows.
  • Participate in Agile ceremonies and deliver assigned work within established sprint cycles.
Required Skills:
  • 7–10 years of SQL Server development experience in enterprise environments.
  • Advanced T-SQL development skills including query tuning and performanceoptimization.
  • Experience developing in SQL Server on Azure VM (IaaS) environments.
  • Hands-on experience supporting high availability architectures using AlwaysOn availability groups.
  • Experience modernizing database code and schemas, including legacy SQLsupport.
  • Experience building ETL solutions using SSIS and Databricks.
  • Experience collaborating with .NET Core/C# development teams.
  • Experience deploying SQL updates through Azure DevOps and GitHub CI/CDpipelines.
  • Ability to work effectively within Agile/Scrum teams.
  • Knowledge of PCI compliance and database security requirements.
Preferred Skills:
  • Experience with Terraform or infrastructure-as-code to support SQLdeployments.
  • Experience working with microservices architectures and domain-driven design.
  • Knowledge of scaling strategies for high-transaction SQL environments.
  • Experience modernizing SQL workloads in cloud-hosted environments. Work Environment & Arrangement This role follows a hybrid work schedule requiring the developer to be onsite 1day per week. Only local candidates will be considered for this position. Duration, Level, and Rate
  • Contract Length: 12 months, with possible extension.
  • CAI Skill Level: Level 4 (Senior Developer).Skill Required / Desired Amount of ExperienceSQL Server development experience in enterprise environments. Required 7 Years
Advanced T-SQL development skills including query tuning and performance optimization Required 5 YearsExperience developing in SQL Server on Azure environments. Required 5 YearsHands-on experience supporting high availability architectures using Always On availability groups Required 5 YearsExperience modernizing database code and schemas, including legacy SQL support. Required 5 YearsExperience collaborating with .NET Core/C# development teams. Required 5 YearsExperience deploying SQL updates through Azure DevOps and GitHub CI/CD pipelines. Required 5 Years Ability to work effectively within Agile/Scrum teams. Required 5 YearsExperience modernizing SQL workloads in cloud-hosted environments. Required 5 YearsExperience building ETL solutions using SSIS and Databricks. Desired 5 YearsKnowledge of PCI compliance and database security requirements. 5 YearsExperience with Terraform or infrastructure-as-code to support SQL deployments. Desired 3 YearsExperience working with microservices architectures and domain-driven design. Desired 5 YearsKnowledge of scaling strategies for high-transaction SQL environments. Desired 5 Years Minimum of 10 years of IT experience Required 10 Years
Apply now (opens in a new tab)
Apply now (opens in a new tab)

Level

SeniorL5

Salary

$112.95/hr

Location

Mechanicsville, VA

Occupation

Software Developers

Industry

Custom Computer Programming Services

Posted

today

To get sharper similar jobs, create your profile using the link below.

Create profile