SQL Developer (MSSQL Developer/DBA)

Ovation Healthcare

10m ago • Remote

Mid

Remote

82,555 - 132,089 USD/yr

  1. Select offer
  2. Add resume
  3. Analyze
  4. Improve
  5. Apply
  6. Auto-send · soon

Match your resume with similar open roles

Upload your resume to automatically match with active openings similar to this role.

PDF up to 10 MB

Your resume is private & secure

Potential salary for SQL Developer (MSSQL Developer/DBA) role

Improve your resume now

$82,555 – $132,089/year

Quick Facts

  • Role: Mid-level MSSQL Developer / DBA

  • Focus: SQL Server and Azure SQL database development, administration, ETL pipelines, and reporting for Revenue Cycle Management (RCM)

  • Working model: Remote

Description

You will develop, support, and maintain SQL Server and Azure SQL databases and ETL pipelines that power RCM operations. The role includes writing and tuning T-SQL, building ETL pipelines, day-to-day DBA tasks, troubleshooting production issues, supporting enterprise reporting, and helping migrate legacy ETL workflows to Microsoft Fabric and Azure. You will handle healthcare data (PHI/PII) in compliance with HIPAA and follow a “first-time right” approach with rollback planning for production changes.

Responsibilities

  • Design, write, and maintain T-SQL stored procedures, functions, views, and tables for applications, ETL pipelines, and reporting

  • Build, maintain, and troubleshoot ETL pipelines to extract, transform, and load healthcare and financial data into SQL Server (validation, error handling, scheduling)

  • Manage backups and restores, SQL Agent jobs, index and statistics maintenance, user access/permissions, and capacity monitoring

  • Diagnose and resolve performance issues (blocking, deadlocks, failed jobs, data inconsistencies) and escalate complex issues with clear summaries

  • Author, test, peer-review, and execute production data scripts with a rollback script for every data or schema change

  • Review execution plans, indexes, and stored procedures to refactor inefficient T-SQL and prevent recurring issues

  • Build and troubleshoot SQL Server Reporting Services (SSRS) reports, subscriptions, and datasets

  • Convert legacy ETL processes (PowerShell and stored procedures) to Microsoft Fabric and Azure and provide operational support after migration

  • Apply least-privilege access and protect PHI/PII under HIPAA; follow Azure DevOps standards for source control, code review, and change management; track work in JIRA

Requirements

  • 3-5 years of hands-on MS SQL Server database development and administration in a production environment

  • Strong T-SQL skills (set-based queries, stored procedures, functions, views, CTEs, transactional logic)

  • Experience with parameterized dynamic SQL using sp_executesql safely, with judgment on set-based vs iterative approaches

  • Proven ETL experience with SQL Server backend (staging, transformations, incremental loads, validation, failure recovery)

  • Database administration knowledge: backups/restores, SQL Agent jobs, index/statistics maintenance, security/permissions, monitoring

  • Understanding of explicit transaction management (BEGIN TRAN/COMMIT/ROLLBACK), TRY...CATCH error handling, and backout script patterns

  • Troubleshooting performance using DMVs, Query Store, Extended Events, and execution plans

  • Understanding of isolation levels, locking/blocking, and indexing strategies

  • Experience with Azure SQL Database or Azure SQL Managed Instance

  • Experience developing/supporting SSRS reports with parameters and datasets

  • Hands-on experience using AI-assisted development tools (Claude Code, Codex, GitHub Copilot)

  • Proficiency with SSMS, Azure Data Studio, Git-based version control, and JIRA

  • Clear written and verbal communication

  • Remote work readiness and a HIPAA-compliant secure workspace (no public Wi‑Fi unless via secure company VPN)

Benefits

  • Comprehensive health and wellness benefits (medical, dental, vision, life insurance, short/long-term disability)

  • HSA with employer contributions; flexible spending accounts; dependent care accounts

  • Wellness platform with premium incentives

  • Employee assistance support; voluntary supplemental plans

  • Robust paid time off and company-paid holidays

  • 401(k) with discretionary employer match

  • Professional development opportunities

  • Company-issued equipment

See similar jobs

Explore similar jobs and use your resume score to choose where to apply next

See more

Unlock Full Resume Report