Sr. SQL Server Developer

Crescens Inc.

Mechanicsville, VA, VA

Apply

JOB DETAILS

SKILLS

Agile Programming Methodologies, Application Programming Interface (API), 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), Maintain Compliance, 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, VA, VA

POSTED

1 day ago

Job Title: Sr. SQL Server Developer
Location: Mechanicsville, VA (Hybrid)
Duration: 12+ Months

Note: 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

Job Description:
The 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.

Key Responsibilities:

Develop and optimize T-SQL queries, stored procedures, functions, and views to

support new application capabilities.

Perform advanced performance tuning, indexing strategies, and query optimization for a business-critical SQL environment.
Modernize existing SQL components while supporting legacy SQL code and structures.
Support new feature development aligned with the microservices-based application modernization approach.
Collaborate with .NET Core/C# developers to ensure efficient data access patterns and API/database integrations.
Participate in modernizing existing database models to support modular, scalable architecture.
Support and maintain high availability environments using Always On availability groups.
Develop migration scripts, ETL logic, and integration solutions using SSIS and 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

Minimum Requirements:

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)

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.

About the Company

Crescens Inc.

Crescens Inc. is an industry leader in providing IT staffing services and tailored workforce solutions to meet the demanding expectations and distinctive needs of clients across the United States and Canada. We have grown tremendously in the past years and have been applauded by our clients for the quality of workforce and the quick turnaround time. We have evolved from good service to great service and all management plans are geared towards quality.

Our vision is to be the best in Talent Acquisition and strive for excellence consistently by focusing on four performance dimensions; Quality, Efficiency, Cost and Risk. A satisfied client and candidate are the backbone to our continued success. Headquartered in New Jersey, we are a team with unique expertise to deliver exceptional results to our clients by setting benchmarks and establishing best practices.

COMPANY SIZE

20 to 49 employees

INDUSTRY

Computer/IT Services

FOUNDED

2002

WEBSITE

http://crescensinc.com/

Sr. SQL Server Developer

Crescens Inc.

Mechanicsville, VA, VA

About the Company

Crescens Inc.

Similar Job Searches