Novalink Solutions LLC logo

Senior Microsoft SQL Developer - Hybrid Richmond, VA

Novalink Solutions LLC

  • Richmond, VA
  • 9 days ago
    Want to know if you’re a fit?
    Upload your resume and let our AI show you.

    Skills

    • Agile Programming Methodologiesunmatched
    • Application Programming Interface (API)unmatched
    • Cloud Architectureunmatched
    • Cloud Computingunmatched
    • Continuous Deployment/Deliveryunmatched
    • Continuous Integrationunmatched
    • Database Designunmatched
    • Database Extract Transform and Load (ETL)unmatched
    • Database Technologyunmatched
    • DevOpsunmatched
    • Editingunmatched
    • GitHubunmatched
    • High Availabilityunmatched
    • Information/Data Security (InfoSec)unmatched
    • Infrastructure as a Service (IaaS)unmatched
    • Maintain Complianceunmatched
    • Microservicesunmatched
    • Microsoft .NETunmatched
    • Microsoft C# (C Sharp)unmatched
    • Microsoft SQL Serverunmatched
    • Microsoft Transact-SQL (T-SQL)unmatched
    • Microsoft Windows Azureunmatched
    • PCIunmatched
    • Performance Managementunmatched
    • Performance Tuning/Optimizationunmatched
    • Regulatory Complianceunmatched
    • SQL (Structured Query Language)unmatched
    • SQL Server Integration Services (SSIS)unmatched
    • Scripting (Scripting Languages)unmatched
    • Scrum Project Management and Software Developmentunmatched
    • Security Complianceunmatched
    • Server Programming/Applicationsunmatched
    • Software Administrationunmatched
    • Software Engineeringunmatched
    • Stored Proceduresunmatched
    • Test Plan/Scheduleunmatched
    • Virtual Machine (VM)unmatched

    Description

    Position Summary
    The Senior Microsoft SQL Developer will support the modernization of anenterprise tolling transaction platform undergoing a partial rewrite usingmicroservices and modularization. This role is a critical part of theAgile/Scrum project team and is responsible for developing, optimizing, andmodernizing SQL components within a business-critical, high-availability SQLServer environment running on Azure Virtual Machines (IaaS). The developer willcollaborate with solution architects, cloud engineers, API developers, andtesters to ensure high performance, scalability, and maintainability of thedatabase platform, reporting to the Development Manager.

    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.



    Requirements

    Skill
    Required / Desired
    Amount
    of Experience
    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
    Year


    Numbers & Facts

    LocationRichmond, VA
    IndustryStaffing/Employment Agencies
    Company Size20 to 49 employees
    Year Founded2004
    Websitehttp://www.novalink-solutions.com/

    About Company

    Novalink, founded in 2003 , is a leading consulting and staffing company serving clients in public and private sectors in Information Technology, Telecommunications (IT/Telecom), Technical Networks, Finance, and Administration. With government agencies as our primary clientele, our team has a proven track record of success in providing temporary personnel solutions and managing government deliverables-based projects over the past 20 years.

    Similar Jobs