{"schemaVersion":"jobsearcher.job.v1","id":"e9d4a800d6cb0e44b578632e","url":"https://jobsearcher.com/jobs/e9d4a800d6cb0e44b578632e","canonicalUrl":"https://jobsearcher.com/jobs/e9d4a800d6cb0e44b578632e","title":"Senior Microsoft SQL Developer","description":"Title: Senior Microsoft SQL Developer\nLocation: Mechanicsville, VA - Hybrid\nDuration: 12 months, with possible extension.\nInterview: Both Phone & In-person\n\nNote:\nThis role follows a hybrid work schedule requiring the developer to be onsite 1day per week. Only local candidates will be considered for this position.\n\nPosition Summary\nThe Senior Microsoft SQL Developer will support the modernization of an enterprise tolling transaction platform undergoing a partial rewrite using microservices and modularization. This role is a critical part of the Agile/Scrum project team and is responsible for developing, optimizing, and modernizing SQL components within a business-critical, high-availability SQL Server environment running on Azure Virtual Machines (IaaS). The developer will collaborate with solution architects, cloud engineers, API developers, and testers to ensure high performance, scalability, and maintainability of the database platform, reporting to the Development Manager.\n\nKey Responsibilities\n\" Develop and optimize T-SQL queries, stored procedures, functions, and viewsto support new application capabilities.\n\" Perform advanced performance tuning, indexing strategies, and query optimization for a business-critical SQL environment.\n\" Modernize existing SQL components while supporting legacy SQL code and structures.\n\" Support new feature development aligned with the microservices-based application modernization approach.\n\" Collaborate with .NET Core/C# developers to ensure efficient data access patterns and API/database integrations.\n\" Participate in modernizing existing database models to support modular, scalable architecture.\n\" Support and maintain high availability environments using Always On availability groups.\n\" Develop migration scripts, ETL logic, and integration solutions using SSIS and Databricks.\n\" Ensure PCI compliance requirements are followed and implement data retention rules as required.\n\" Contribute SQL-related changes through CI/CD pipelines using Azure DevOps and GitHub workflows.\n\" Participate in Agile ceremonies and deliver assigned work within established sprint cycles.\n\nRequired Skills\nMinimum of 10 years of IT experience\n7 10+ years of SQL Server development experience in enterprise environments.\nAdvanced T-SQL development skills including query tuning and performance optimization.\nExperience developing in SQL Server on Azure VM (IaaS) environments.\nHands-on experience supporting high availability architectures using Always On availability groups.\nExperience modernizing database code and schemas, including legacy SQL support.\nExperience building ETL solutions using SSIS and Databricks.\nExperience collaborating with .NET Core/C# development teams.\nExperience deploying SQL updates through Azure DevOps and GitHub CI/CD pipelines.\nAbility to work effectively within Agile/Scrum teams.\nExperience modernizing SQL workloads in cloud-hosted environments.\n\nPreferred Skills\nExperience with Terraform or infrastructure-as-code to support SQL deployments.\nExperience working with microservices architectures and domain-driven design.\nKnowledge of scaling strategies for high-transaction SQL environments.\nKnowledge of PCI compliance and database security requirements.","company":"Apollo Technology Solutions","rawCompany":"apollo technology solutions","city":"Mechanicsville","state":"VA","isRemote":false,"isActive":false,"createdAt":"2026-08-03T23:33:15.393Z","occupations":[{"code":"15-1252.00","title":"Software Developers","slug":"software-developers"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"},{"code":"15-1299.08","title":"Computer Systems Engineers/Architects","slug":"computer-systems-engineers-architects"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"513210","title":"Software Publishers","slug":"software-publishers"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Senior Microsoft SQL Developer","description":"Title: Senior Microsoft SQL Developer\nLocation: Mechanicsville, VA - Hybrid\nDuration: 12 months, with possible extension.\nInterview: Both Phone & In-person\n\nNote:\nThis role follows a hybrid work schedule requiring the developer to be onsite 1day per week. Only local candidates will be considered for this position.\n\nPosition Summary\nThe Senior Microsoft SQL Developer will support the modernization of an enterprise tolling transaction platform undergoing a partial rewrite using microservices and modularization. This role is a critical part of the Agile/Scrum project team and is responsible for developing, optimizing, and modernizing SQL components within a business-critical, high-availability SQL Server environment running on Azure Virtual Machines (IaaS). The developer will collaborate with solution architects, cloud engineers, API developers, and testers to ensure high performance, scalability, and maintainability of the database platform, reporting to the Development Manager.\n\nKey Responsibilities\n\" Develop and optimize T-SQL queries, stored procedures, functions, and viewsto support new application capabilities.\n\" Perform advanced performance tuning, indexing strategies, and query optimization for a business-critical SQL environment.\n\" Modernize existing SQL components while supporting legacy SQL code and structures.\n\" Support new feature development aligned with the microservices-based application modernization approach.\n\" Collaborate with .NET Core/C# developers to ensure efficient data access patterns and API/database integrations.\n\" Participate in modernizing existing database models to support modular, scalable architecture.\n\" Support and maintain high availability environments using Always On availability groups.\n\" Develop migration scripts, ETL logic, and integration solutions using SSIS and Databricks.\n\" Ensure PCI compliance requirements are followed and implement data retention rules as required.\n\" Contribute SQL-related changes through CI/CD pipelines using Azure DevOps and GitHub workflows.\n\" Participate in Agile ceremonies and deliver assigned work within established sprint cycles.\n\nRequired Skills\nMinimum of 10 years of IT experience\n7 10+ years of SQL Server development experience in enterprise environments.\nAdvanced T-SQL development skills including query tuning and performance optimization.\nExperience developing in SQL Server on Azure VM (IaaS) environments.\nHands-on experience supporting high availability architectures using Always On availability groups.\nExperience modernizing database code and schemas, including legacy SQL support.\nExperience building ETL solutions using SSIS and Databricks.\nExperience collaborating with .NET Core/C# development teams.\nExperience deploying SQL updates through Azure DevOps and GitHub CI/CD pipelines.\nAbility to work effectively within Agile/Scrum teams.\nExperience modernizing SQL workloads in cloud-hosted environments.\n\nPreferred Skills\nExperience with Terraform or infrastructure-as-code to support SQL deployments.\nExperience working with microservices architectures and domain-driven design.\nKnowledge of scaling strategies for high-transaction SQL environments.\nKnowledge of PCI compliance and database security requirements.","datePosted":"2026-08-03T23:33:15.393Z","dateModified":"2026-08-03T23:33:15.393Z","hiringOrganization":{"@type":"Organization","name":"Apollo Technology Solutions","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Mechanicsville","addressRegion":"VA","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"e9d4a800d6cb0e44b578632e"},"url":"https://jobsearcher.com/jobs/e9d4a800d6cb0e44b578632e"}}