> Markdown version of [/jobs/ext/1451823-senior-microsoft-sql-developer](https://www.wearedevelopers.com/jobs/ext/1451823-senior-microsoft-sql-developer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Senior Microsoft SQL Developer. - **Company:** Ampcus Inc - **Location:** Mechanicsville, VA, United States - **Experience:** Expert - **Contract:** Temporary to permanent - **Skills:** Agile Methodology, Applications Architecture, Microsoft Azure, C Sharp (Programming Language), Databases, Data Governance, Extract Transform Load (ETL), Data Retention, Data Security, Database Schema, Database Security, Database Storage Structures, Document-Oriented Databases, Github, Infrastructure as a Service (IaaS), Microsoft SQL Server, PCI Data Security Standards, Performance Tuning, Scrum Methodology, Query Optimization, Standard Sql, SQL Stored Procedures, SQL Databases, SQL Server Integration Services, Transact-SQL, Virtual Machines, Cloud Platform System, .NET Core, System Availability, Database Optimization, Indexer, Database Migration, Infrastructure Automation Frameworks, Information Technology, Terraform, Domain Driven Design, Sql Tuning, Api Management, Databricks, Microservices - **Published:** July 26, 2026 - **Apply:** https://jobs.localjobnetwork.com/apply/add/87844759/1 ## About the Role * 7-10+ years of Microsoft SQL Server development experience in enterprise environments. * Advanced expertise in T-SQL development, including stored procedures, functions, views, and query optimization. * Strong experience with SQL Server performance tuning and indexing strategies. * Experience administering and developing SQL Server in Azure Virtual Machine (IaaS) environments. * Hands-on experience with SQL Server Always On Availability Groups. * Experience modernizing legacy SQL code and database schemas. * Experience building ETL solutions using SSIS and Databricks. * Experience collaborating with .NET Core/C# development teams. * Experience deploying database changes using Azure DevOps and GitHub CI/CD pipelines. * Experience working within Agile/Scrum development methodologies. * Strong understanding of database security, PCI compliance, and data governance. Preferred Qualifications * Experience with Terraform or other Infrastructure as Code (IaC) tools. * Experience working with microservices architectures. * Knowledge of Domain-Driven Design (DDD). * Experience supporting high-volume, high-transaction database environments. * Experience modernizing SQL Server workloads hosted in cloud environments., SQL Server development experience in enterprise environments. Required 7 Years Advanced T-SQL development skills including query tuning and performance optimization Required 5 Years Experience developing in SQL Server on Azure environments. Required 5 Years Hands-on experience supporting high availability architectures using Always On availability groups Required 5 Years Experience modernizing database code and schemas, including legacy SQL support. Required 5 Years Experience collaborating with .NET Core/C# development teams. Required 5 Years Experience deploying SQL updates through Azure DevOps and GitHub CI/CD pipelines. Required 5 Years Ability to work effectively within Agile/Scrum teams. Required 5 Years Experience modernizing SQL workloads in cloud-hosted environments. Required 5 Years Experience building ETL solutions using SSIS and Databricks. Desired 5 Years Knowledge of PCI compliance and database security requirements. Desired 5 Years Experience with Terraform or infrastructure-as-code to support SQL deployments. Desired 3 Years Experience working with microservices architectures and domain-driven design. Desired 5 Years Knowledge of scaling strategies for high-transaction SQL environments. Desired 5 Years Minimum of 10 years of IT experience Required 10 Years ## Description We are seeking a Senior Microsoft SQL Developer to support the modernization of a mission-critical enterprise transaction platform undergoing a partial rewrite using microservices and modular architecture. This role is responsible for developing, optimizing, and modernizing Microsoft SQL Server components within a high-availability Azure Virtual Machine (IaaS) environment. Working as part of an Agile/Scrum team, the developer will collaborate with architects, cloud engineers, application developers, and QA engineers to deliver scalable, secure, and high-performing database solutions., * Develop, enhance, and optimize T-SQL queries, stored procedures, functions, and views. * Perform SQL performance tuning, query optimization, indexing, and execution plan analysis. * Modernize legacy SQL code and database structures while maintaining compatibility with existing applications. * Support development of new features for a modern microservices-based application architecture. * Collaborate with .NET Core/C# developers to implement efficient data access patterns and API integrations. * Design and improve database schemas to support scalable, modular applications. * Support high-availability SQL Server environments using Always On Availability Groups. * Develop database migration scripts and ETL processes using SSIS and Databricks. * Ensure compliance with PCI security standards and data retention requirements. * Deploy database changes through Azure DevOps and GitHub CI/CD pipelines. * Participate in Agile ceremonies including sprint planning, daily stand-ups, sprint reviews, and retrospectives. * Document database designs, deployment procedures, and technical solutions. ## Related Videos - [Automated MS SQL Server database deployments with dacpacs and Azure DevOps](https://www.wearedevelopers.com/videos/334-automated-ms-sql-server-database-deployments-with-dacpacs-and-azure-devops) - [Innovating Developer Tools with AI: Insights from GitHub Next](https://www.wearedevelopers.com/videos/1268-innovating-developer-tools-with-ai-insights-from-github-next) - [Optimizing Discovery: PostgreSQL's Role in Transforming GetYourGuide's Search](https://www.wearedevelopers.com/videos/1647-optimizing-discovery-postgresql-s-role-in-transforming-getyourguide-s-search) - [Infrastructure as Code: The Developer's Secret Weapon](https://www.wearedevelopers.com/videos/1221-infrastructure-as-code-the-developer-s-secret-weapon) - [Hacking MSSQL on Cloud. All of them. How I became sysadmin on Azure, AWS, GCP and Alibaba.](https://www.wearedevelopers.com/videos/100339-hacking-mssql-on-cloud-all-of-them-how-i-became-sysadmin-on-azure-aws-gcp-and-alibaba) - [Bringing AI Model Testing and Prompt Management to Your Codebase with GitHub Models](https://www.wearedevelopers.com/videos/1536-bringing-ai-model-testing-and-prompt-management-to-your-codebase-with-github-models) ## Related Articles - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [What’s the Difference between a Junior, Mid, and Senior Developer?](https://www.wearedevelopers.com/magazine/238-what-s-the-difference-between-a-junior-mid-and-senior-developer) - [7 Important Tips That Every Software Developer Should Know](https://www.wearedevelopers.com/magazine/101-7-important-tips-that-every-software-developer-should-know) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Why Upskilling And Reskilling is Important For Developers](https://www.wearedevelopers.com/magazine/428-why-upskilling-and-reskilling-is-important-for-developers) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)