Programmer Analyst 4

Job Title: Programmer Analyst 4Work Type: HybridLocation: Mechanicsville, VA 23116Start Date: 08/03/2026End Date: 06/30/2027Industry Category: Information Technology / GovernmentEmployment Type: 1099 ContractRequisition ID: 804326

Overview

We are seeking an experienced Programmer Analyst 4 (Senior Microsoft SQL Developer) to support the modernization of a mission-critical enterprise tolling transaction platform. This role is responsible for developing, optimizing, and modernizing SQL Server components within a high-availability Azure infrastructure while collaborating with cross-functional Agile teams to deliver scalable, high-performance database solutions supporting a microservices-based application architecture.

Application

Applications will be reviewed as received.

Candidates must:

• Be legally authorized to work in the United States without employer sponsorship, now or in the future.
• Physically reside within the United States for the duration of the assignment.
• Be local to the Mechanicsville, Virginia area, as only local candidates will be considered.
• Provide a valid candidate email address with submission.
• Successfully complete both phone and in-person interviews.

Job Description

The Senior Microsoft SQL Developer will play a key role in the modernization of VDOT's enterprise tolling transaction platform as it transitions to a modular, microservices-based architecture. Working as part of an Agile/Scrum development team, this position is responsible for designing, optimizing, and maintaining Microsoft SQL Server solutions hosted on Azure Virtual Machines while supporting both modernized and legacy database environments. The successful candidate will collaborate closely with solution architects, cloud engineers, .NET developers, API developers, testers, and project leadership to deliver secure, scalable, and high-performing database solutions that support business-critical operations.

Responsibilities

Technical Duties

• Develop, maintain, and optimize advanced T-SQL queries, stored procedures, functions, and database views.
• Perform SQL Server performance tuning, indexing optimization, and query optimization for high-volume enterprise applications.
• Modernize legacy SQL code, database objects, and schemas while maintaining compatibility with existing systems.
• Support the development of new database functionality aligned with a microservices-based architecture.
• Design and maintain scalable database models supporting modular application development.
• Support high-availability SQL Server environments utilizing Always On Availability Groups.
• Develop database migration scripts and assist with database modernization initiatives.
• Contribute SQL-related code changes through Azure DevOps and GitHub CI/CD pipelines.

Integration & Data Management

• Collaborate with .NET Core/C# development teams to optimize application data access and API integrations.
• Support database integration initiatives and data migration activities.
• Assist with SQL platform modernization efforts within Azure-hosted environments.

Security & Compliance

• Ensure database solutions align with PCI compliance requirements.
• Implement and support data retention policies and database security standards.

Collaboration

• Work closely with architects, cloud engineers, developers, testers, and project stakeholders throughout the software development lifecycle.
• Participate actively in Agile/Scrum ceremonies, sprint planning, backlog refinement, reviews, and retrospectives.
• Deliver assigned work within established sprint timelines while maintaining high quality standards.

Operational Support

• Maintain business-critical SQL Server environments supporting enterprise tolling operations.
• Troubleshoot database performance issues and provide ongoing production support as needed.
• Support continuous improvement initiatives focused on scalability, maintainability, and platform reliability.

Requirements

• Develop enterprise SQL Server solutions supporting a high-availability Azure environment.
• Optimize database performance through advanced T-SQL development and tuning techniques.
• Modernize existing SQL components while maintaining legacy database functionality.
• Support Agile software development initiatives within a microservices modernization program.
• Collaborate effectively across multidisciplinary technical teams.
• Maintain secure, scalable, and reliable database solutions supporting mission-critical applications.

Minimum Qualifications

• Minimum of 10 years of overall IT experience.
• 7 years of SQL Server development experience in enterprise environments.
• 5 years of advanced T-SQL development experience, including query tuning and performance optimization.
• 5 years of experience developing in SQL Server on Azure environments.
• 5 years of hands-on experience supporting high-availability architectures using Always On Availability Groups.
• 5 years of experience modernizing database code and schemas, including legacy SQL support.
• 5 years of experience collaborating with .NET Core/C# development teams.
• 5 years of experience deploying SQL updates through Azure DevOps and GitHub CI/CD pipelines.
• 5 years of experience working effectively within Agile/Scrum teams.
• 5 years of experience modernizing SQL workloads in cloud-hosted environments.
• Must be legally authorized to work in the United States without employer sponsorship, now or in the future.
• Must physically reside within the United States for the duration of the assignment.
• Only local candidates will be considered.
• Must successfully complete both phone and in-person interviews.

Preferred Qualifications

• 5 years of experience building ETL solutions using SSIS and Databricks.
• 5 years of knowledge of PCI compliance and database security requirements.
• 3 years of experience with Terraform or infrastructure-as-code supporting SQL deployments.
• 5 years of experience working with microservices architectures and domain-driven design.
• 5 years of knowledge of scaling strategies for high-transaction SQL environments.

Compensation

This is a 1099 Contract opportunity.

Pay Rate:$70 – $90 per hour

Schedule

• Start Date: 08/03/2026
• End Date: 06/30/2027
• Assignment Duration: Approximately 11 months
• Hybrid work arrangement.
• On-site presence required 1 day per week.

Work Location Mechanicsville, VA

• Hybrid position with one required on-site day each week.
• Only local candidates will be considered.