IT Programmer Analyst 4 (VA804326)
Resource Management Associates Bullhorn ·www.rmallcga.com
Apply direct IT Programmer Analyst 4 (VA804326)
Key Responsibilities
• Develop and optimize T-SQL queries, stored procedures, functions, and viewsto support new application capabilities.
• Perform advanced performance tuning, indexing strategies, and queryoptimization for a business-critical SQL environment.
• Modernize existing SQL components while supporting legacy SQL code andstructures.
• Support new feature development aligned with the microservices-basedapplication modernization approach.
• Collaborate with .NET Core/C# developers to ensure efficient data accesspatterns and API/database integrations.
• Participate in modernizing existing database models to support modular,scalable architecture.
• Support and maintain high availability environments using Always Onavailability groups.
• Develop migration scripts, ETL logic, and integration solutions using SSISand Databricks.
• Ensure PCI compliance requirements are followed and implement data retention rules as required.
• Contribute SQL-related changes through CI/CD pipelines using Azure DevOps and GitHub workflows.
• Participate in Agile ceremonies and deliver assigned work within established sprint cycles.
Required Skills
• 7–10+ years of SQL Server development experience in enterprise environments.
• Advanced T-SQL development skills including query tuning and performanceoptimization.
• Experience developing in SQL Server on Azure VM (IaaS) environments.
• Hands-on experience supporting high availability architectures using AlwaysOn availability groups.
• Experience modernizing database code and schemas, including legacy SQLsupport.
• Experience building ETL solutions using SSIS and Databricks.
• Experience collaborating with .NET Core/C# development teams.
• Experience deploying SQL updates through Azure DevOps and GitHub CI/CDpipelines.
• Ability to work effectively within Agile/Scrum teams.
• Knowledge of PCI compliance and database security requirements.
Preferred Skills
• Experience with Terraform or infrastructure-as-code to support SQLdeployments.
• Experience working with microservices architectures and domain-driven design.
• Knowledge of scaling strategies for high-transaction SQL environments.
• Experience modernizing SQL workloads in cloud-hosted environments.
Work Environment & Arrangement
This role follows a hybrid work schedule requiring the developer to be onsite 1day per week. Only local candidates will be considered for this position.