Senior Microsoft SQL Developer.

Ampcus Incorporated

Mechanicsville, VA

JOB DETAILS
SKILLS
Agile Programming Methodologies, Analysis Skills, Application Programming Interface (API), Business Services, Cloud Applications, Cloud Architecture, Cloud Computing, Consulting, Continuous Deployment/Delivery, Continuous Integration, Database Design, Database Extract Transform and Load (ETL), Database Programming, Database Technology, DevOps, Editing, GitHub, High Availability, Information/Data Security (InfoSec), Infrastructure as a Service (IaaS), Maintain Compliance, Microservices, Microsoft .NET, Microsoft C# (C Sharp), Microsoft SQL Server, Microsoft SQL Server DBA (Database Administration), Microsoft Transact-SQL (T-SQL), Microsoft Windows Azure, PCI, Performance Tuning/Optimization, Query Optimization, Requirements Management, SQL (Structured Query Language), SQL Databases, SQL Server Integration Services (SSIS), Scripting (Scripting Languages), Scrum Project Management and Software Development, Security Compliance, Server Programming/Applications, Software Development, Software Engineering, Software Testing, Sprint Planning, Sprint Retrospective, Standup Meetings, Stored Procedures, Virtual Machine (VM)
LOCATION
Mechanicsville, VA
POSTED
2 days ago

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:

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 SkillRequired / DesiredAmountof ExperienceExpertise RatingMove
SQL Server development experience in enterprise environments.Required7Years  
Advanced T-SQL development skills including query tuning and performance optimizationRequired5Years  
Experience developing in SQL Server on Azure environments.Required5Years  
Hands-on experience supporting high availability architectures using Always On availability groupsRequired5Years  
Experience modernizing database code and schemas, including legacy SQL support.Required5Years  
Experience collaborating with .NET Core/C# development teams.Required5Years  
Experience deploying SQL updates through Azure DevOps and GitHub CI/CD pipelines.Required5Years  
Ability to work effectively within Agile/Scrum teams.Required5Years  
Experience modernizing SQL workloads in cloud-hosted environments.Required5Years  
Experience building ETL solutions using SSIS and Databricks.Desired5Years  
Knowledge of PCI compliance and database security requirements.Desired5Years  
Experience with Terraform or infrastructure-as-code to support SQL deployments.Desired3Years  
Experience working with microservices architectures and domain-driven design.Desired5Years  
Knowledge of scaling strategies for high-transaction SQL environments.Desired5Years  
Minimum of 10 years of IT experienceRequired10Years  


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.

About the Company

A

Ampcus Incorporated

Ampcus Inc is a global technology and business consulting firm specializing in Digital Transforrmation, Big Data, Analytics, Cyber Security, Testing, IV&V, Infrastructure Management and Enterprise Solutions. Ampcus Inc is an SBA 8(a) certified Women and Minority Owned global Provider of broad range of consulting Services. From strategy to execution, our disciplined yet flexible approach starts and ends with our clients. By listening hard and working harder, their goals become our goals. We are an ISO 9000, ISO 20000, ISO 27000 and CMMi Level certified company.

Ampcus consultants have significant business, engineering and technology experience. Our consultants have over 20 years of business experience and an average of over 10 years of engineering and technology experience. This means that the project teams understand how systems work and how the technology impacts the business processes of organizations.

We believe that success of an engagement is determined by strong project management, clear communication and mutual commitment working collaboratively. Our methodology begins by listening to the customer needs, then working with their teams to gain a clear understanding of the requirements, while providing a knowledge transfer of best practices for the organization. As a recognized leader providing customized software services, management and engineering solutions to companies around the world, our ability to deliver is a "granted"​ that makes companies put their trust in us to answer their day-to-day business challenges and put them on a path for greater success. We are the choice for our clients because we look at our clients business from a growth perspective.

Industry: Information Technology and Services

Specialties: Digital Transformation, Big Data and Analytics, Infrastructure Management Services, Testing and IV&V, Cyber Security, Active Directory and E-mail Infrastructure, Project Management, Training, and ERP, CRM. EAI, BI

COMPANY SIZE
500 to 999 employees
INDUSTRY
Staffing/Employment Agencies
WEBSITE
http://www.ampcus.com