Senior Microsoft SQL Developer.

Ampcus, Inc; Mechanicsville (VA); Hybrid; USD 82,656 - 123,984; Full time

Job summary

Ampcus Inc. is seeking a Senior Microsoft SQL Developer in Mechanicsville, VA, with hybrid work on-site one day per week.

The role focuses on modernizing Microsoft SQL Server components in an Azure IaaS environment, collaborating in an Agile/Scrum team of architects, cloud engineers, and QA to deliver scalable, secure database solutions. Responsibilities include tuning, schema design, ETL development with SSIS and Databricks, and deploying changes via Azure DevOps and GitHub CI/CD.

Qualifications

• 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.

Responsibilities

• 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 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 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.

Skills

SQL Server development

T-SQL development

Performance tuning

Azure IaaS / Azure VM

Always On Availability Groups

ETL with SSIS

Databricks

Azure DevOps

GitHub CI/CD

Agile/Scrum

Database security & PCI

Tools

Databricks

SSIS

Azure DevOps

GitHub CI/CD

Job description

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.

Job Title: Senior Microsoft SQL Developer.

Location(s)

Mechanicsville, VA

Hybrid: Onsite 1 day per week

Position Summary

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.

Key Responsibilities

• 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.

Required Qualifications

• 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.

Work Environment

• Hybrid work schedule with one onsite day per week.
• Only local candidates will be considered.

Contract Details

• 12-month contract with possible extension.
• Senior-level opportunity.
• Competitive hourly rate.

Skills

• 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

Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.