SQL Server Development Engineer

Location: McLean, VA, USA

Apply Refer a Friend

Requisition Number: RR-0005210

Position Title:

External Description:

SQL Server Development Engineer

Location: Remote - Global (Must be available for daily 9:00 AM ET team meeting)

Type: Full-Time Employee (FTE)

Role Overview

We are seeking a SQL Server Developer to focus on T-SQL development, production support, and performance optimization. This role is intended for a developer who prefers working directly with code, indexes, and execution plans. You will join a stable, long-tenured team managing a mission-critical healthcare application.

Our internal team is responsible for the schema, logic, and database performance, while our hosting provider manages the physical infrastructure and operating system.

System Administration and Database Maintenance

As a US-based FTE, you will handle instance-level management and serve as the technical backup for the Senior Architect during vacations or absences. You will be responsible for the following administrative and DBA duties:

Host Provider Liaison:Act as the primary point of contact for our hosting provider. You will investigate and respond to tickets regarding high CPU, RAM contention, and disk space alerts, determining if the cause is a rogue process, a specific query, or a genuine resource bottleneck.
Database Operations:Perform standard DBA tasks, including restoring backups for development or troubleshooting, monitoring log shipping status, and ensuring the health of all SQL Agent jobs.
Capacity Planning:Monitor disk space usage and track fast-growing or exceptionally large tables to prevent storage-related outages.
Environment Management:Manage Windows Task Scheduler and troubleshoot file or folder permission issues within the Windows Server 2025 environment.
Scripting and Automation:Maintain and run PowerShell scripts for automation, specifically utilizing dbaToolsand SQLServerDsc.
CI/CD Troubleshooting:Monitor Jenkinsconsole log output to identify and resolve environment-specific build failures.

Career Progression and Responsibilities

Your primary entry point will be Tier 2 Production Support. We believe identifying and fixing real-world data issues is the most effective way to master our complex business logic and schema.

Initial Phase (Approx. 12–18 Months):You will spend 100% of your time on Tier 2 support. You will be responsible for identifying and fixing the root cause of production data issues and bugs. This allows the senior team to focus on major project deliverables while you gain subject matter expertise.
Support Environment:Support tasks are assigned via Jira. There are no phone calls Most issues are categorized as SEV-3 or SEV-4, meaning you will generally work in a stable environment rather than a constant state of critical urgency.
Transition Phase:As you demonstrate mastery of the system and root-cause resolution, you will begin taking on significant project work. The timing of this transition depends on your demonstrated skill and performance.

Technical Requirements

Experience:5+ years of hands-on SQL development preferably with two or more companies/departments.
Advanced T-SQL:Proficiency in writing and debugging complex stored procedures, managing transactions, rollbacks, and deadlocks. We adhere to a modular code standard with shallow nesting (typically one level deep).
Source Control:Experience with Git/GitHub is highly desired. Candidates with verifiable Git experience will be prioritized.
Performance Tuning:Experience using SQL Profiler and analyzing execution plans to tune complex queries to a target of < 500ms.
Testing:Familiarity with tSQLt or Test-Driven Development (TDD) is a significant advantage. Our environment utilizes over 1,600 unit tests.
Local Environment:Experience installing and configuring SQL Server on a local machine for development and troubleshooting.

Collaboration and Compliance

Daily Stand-up:Participation in a daily team meeting at 9:00 AM Eastern Time (US) is mandatory.
Communication:Exceptional written communication skills in American English are required for Jira tickets, Slack/Google Chat, and code documentation.
Global Team:You will collaborate with developers and QA resources located in the US and Romania.
HIPAA:Because our client operates dialysis centers, you must adhere to HIPAA regulations. We provide the necessary formal training.
AI Tools:We encourage the use of GitHub Copilot or Gemini Pro to increase development efficiency.

System Environment

SQL Server:2022 Standard Edition.
OS:Windows Server 2025.
Tools:SSMS, SQL Profiler, Git/GitHub, Jira (Kanban), Jenkins.
Corporate Tools:Google Workspace and Microsoft Office (specifically Excel for reporting).

Remote: 1

City: McLean

State: Virginia

Ext Portal Job Header:

Community / Marketing Title: SQL Server Development Engineer

Company Profile:

Randstad Digital Advisory is a trusted digital enablement and consulting partner that facilitates accelerated transformation for businesses by providing tailored strategies, solutions, and partnerships to realize the most value from business objectives. We deliver for our clients to enable their businesses to thrive in today’s changing environment. It takes people, though, to support our clients and we pride ourselves on a workplace that thrives on collaboration and support. Our people are not only experts in their field but also kind, smart, fun and passionate about what they do. Teamwork isn't just encouraged - it's the way we operate. Join our team!

EEO Employer Verbiage: Join a workplace that thrives on collaboration and support, consisting of individuals who are not only experts in their fields but also kind, smart, fun, and passionate about what they do. Teamwork isn't just encouraged – it's the way we operate. At Randstad Digital Advisory, we strive to provide opportunities to learn and grow, from on-the-job coaching to online courses to continuous feedback. Our employees have the autonomy to do their best work, using their skills to make a meaningful impact both within the team as well as for our diverse clientele. We offer attractive pay, a well-rounded benefits package, and flexible working arrangements (including work-from-home when possible).

CountryEEOText_Description: We are proud to be an Equal Opportunity Employer. All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, veteran status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status or any other basis as protected by federal, state, or local law. Celerity is committed to providing veteran employment opportunities to our service men and women.