Job Opportunities API

Job Title : Programmer Analyst 4 Work Type : Hybrid Location : Mechanicsville, VA 23116 Start Date : 08/03/2026 End Date : 06/30/2027 Industry Category : Information Technology / Government Employment Type : 1099 Contract Requisition 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, ma