SQL Server Developer

We are seeking a Senior SQL Database Developer to support the modernization of an enterprise tolling transaction platform undergoing a microservices rewrite. Operating within an Agile/Scrum environment, this contract role focuses on developing, optimizing, and modernizing database components within a high-availability SQL Server platform hosted on Azure Virtual Machines (IaaS). You will collaborate with solution architects, .NET Core developers, cloud engineers, and testers to build high-performance data structures, streamline ETL pipelines, and ensure total compliance with PCI security standards. Location & Work Arrangement

• City, State: Mechanicsville, VA
• Work Arrangement: Hybrid (Onsite 1 day per week; local candidates only).
• Interview Mode: Web Cam or In-Person.
• Shift: EST., Database Development & Performance Tuning
• Write and optimize complex T-SQL queries, stored procedures, functions, and views to support new platform capabilities.
• Perform advanced performance tuning, indexing strategies, and execution plan optimization for high-transaction workloads.
• Modernize legacy database schemas and code to support a modular, microservices-based application architecture.

High Availability & Cloud Integration

• Maintain high-availability database environments using SQL Server Always On Availability Groups in Azure IaaS environments.
• Build, maintain, and migrate ETL logic and data pipelines using SSIS and Databricks.
• Collaborate with .NET Core/C# developers to refine data access patterns, APIs, and cross-system integrations.

DevOps, Security & Compliance

• Deploy database updates and schema changes through Azure DevOps and GitHub CI/CD pipelines.
• Implement data retention policies and enforce strict PCI compliance and security standards.
• Participate actively in Agile ceremonies, sprint estimations, and code reviews.

Skill Category Requirement Years of Exp. Total IT Exp. Overall experience in enterprise IT environments. 10+ Years SQL Server Enterprise database design and development. 7+ Years T-SQL & Tuning Advanced query tuning, indexing, and execution optimization. 5+ Years Azure IaaS SQL Server deployment/management on Azure VMs. 5+ Years High Availability Supporting Always On Availability Groups. 5+ Years DevOps Pipelines Database deployment via Azure DevOps or GitHub CI/CD. 5+ Years Application Integration Collaborating with .NET Core / C# dev teams. 5+ Years, * ETL & Data Engineering: Experience building ETL solutions with SSIS and Databricks (5+ years).

• Architecture: Familiarity with Domain-Driven Design (DDD) and microservices (5+ years).
• Compliance & Security: Practical knowledge of PCI compliance and database encryption.
• Infrastructure as Code: Experience with Terraform for database infrastructure provisioning (3+ years).

Ampcus

• Richmond, VA 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 Te…