Senior Microsoft SQL Server Programmer Analyst (Azure T-SQL)

Rose International

Mechanicsville, Virginia

Apply

JOB DETAILS

SALARY

$75–$82 Per Hour

JOB TYPE

Temporary

SKILLS

Agile Programming Methodologies, Analysis Skills, Application Programming Interface (API), Career Development, Cloud Architecture, Cloud Computing, Continuous Deployment/Delivery, Continuous Integration, Database Design, Database Extract Transform and Load (ETL), Database Technology, DevOps, Editing, GitHub, High Availability, Information Technology & Information Systems, Information/Data Security (InfoSec), Infrastructure as a Service (IaaS), Microservices, Microsoft .NET, Microsoft C# (C Sharp), Microsoft SQL Server, Microsoft Transact-SQL (T-SQL), Microsoft Windows Azure, PCI, Performance Management, Performance Tuning/Optimization, Process Improvement, Query Optimization, Regulatory Compliance, SQL (Structured Query Language), SQL Server Integration Services (SSIS), Scripting (Scripting Languages), Scrum Project Management and Software Development, Security Compliance, Server Programming/Applications, Software Administration, Software Engineering, Stored Procedures, Test Plan/Schedule, Virtual Machine (VM)

LOCATION

Mechanicsville, Virginia

POSTED

1 day ago

Senior Microsoft SQL Server Programmer Analyst (Azure T-SQL)Position Location: Mechanicsville, VA, USAWork Model: HybridEmployment Type: Temporary Full-TimeEstimated Duration: 12 monthsMin Hourly Rate: $75.00Max Hourly Rate: $82.00Must Have Skills/Attributes: .Net, C#, ETL, SQL Server ExperienceDesired Experience: SQL Server development experience in enterprise environments (7 yrs); Experience developing in SQL Server on Azure environments (5 yrs); Experience building ETL solutions using SSIS and Databricks (5 yrs); Knowledge of PCI compliance and database security requirements (5 yrs); Experience with Terraform or infrastructure-as-code to support SQL deployments (3 yrs); Knowledge of scaling strategies for high-transaction SQL environments (5 yrs); Minimum of 10 years of IT experience (10 yrs)Required SkillsSQL Server development experience in enterprise environments (7 Years)Advanced T-SQL development skills including query tuning and performance optimization (5 Years)Experience developing in SQL Server on Azure environments (5 Years)Hands-on experience supporting high availability architectures using Always On availability groups (5 Years)Experience modernizing database code and schemas, including legacy SQL support (5 Years)Experience collaborating with.NET Core/C# development teams (5 Years)Experience deploying SQL updates through Azure DevOps and GitHub CI/CD pipelines (5 Years)Ability to work effectively within Agile/Scrum teams (5 Years)Experience modernizing SQL workloads in cloud-hosted environments (5 Years)Preferred SkillsKnowledge of PCI compliance and database security requirementsExperience with Terraform or infrastructure-as-code to support SQL deploymentsExperience working with microservices architectures and domain-driven designKnowledge of scaling strategies for high-transaction SQL environmentsExperience building ETL solutions using SSIS and DatabricksAbout the RoleThe Senior Microsoft SQL Developer will support the modernization of an enterprise tolling transaction platform undergoing a partial rewrite using microservices and modularization. This role is a critical part of the Agile/Scrum project team and is responsible for developing, optimizing, and modernizing SQL components within a business-critical, high-availability SQL Server environment running on Azure Virtual Machines (IaaS). The developer will collaborate with solution architects, cloud engineers, API developers, and testers to ensure high performance, scalability, and maintainability of the database platform, reporting to the Development Manager.Job ResponsibilitiesDevelop and optimize T-SQL queries, stored procedures, functions, and views to support new application capabilitiesPerform advanced performance tuning, indexing strategies, and query optimization for a business-critical SQL environmentModernize existing SQL components while supporting legacy SQL code and structuresSupport new feature development aligned with the microservices-based application modernization approachCollaborate with.NET Core/C# developers to ensure efficient data access patterns and API/database integrationsParticipate in modernizing existing database models to support modular, scalable architectureSupport and maintain high availability environments using Always On availability groupsDevelop migration scripts, ETL logic, and integration solutions using SSIS and DatabricksEnsure PCI compliance requirements are followed and implement data retention rules as requiredContribute SQL-related changes through CI/CD pipelines using Azure DevOps and GitHub workflowsParticipate in Agile ceremonies and deliver assigned work within established sprint cyclesInterview ProcessBoth Phone and in-person

About the Company

Rose International

Founded in 1993 by Sue Bhatia, Rose International is one of the nation's leading minority- and woman-owned providers of Staffing and Total Talent Solutions. We serve companies in all 50 states and employ thousands of people across the country.

COMPANY SIZE

2,500 to 4,999 employees

INDUSTRY

Staffing/Employment Agencies

WEBSITE

https://www.roseint.com/