SQL Server Development Engineer

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).

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:

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.

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.

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.

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.

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.

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!