SQL Developer

Ovation Healthcare • Boise, ID

2d • $82,555 - $132,089 • Remote

About The Position

Ovation Healthcare is hiring a mid-level MSSQL Developer / DBA to develop, support, and maintain SQL Server and Azure SQL databases and ETL pipelines that power its Revenue Cycle Management (RCM) operations. The role involves writing and tuning T-SQL, building and supporting ETL pipelines, performing day-to-day database administration, resolving production issues, supporting enterprise reporting, and helping migrate legacy ETL workflows to Microsoft Fabric and Azure.

The SQL Developer works alongside senior engineers who set standards and handle top-tier escalations, while owning assigned databases, tickets, and changes end to end. The role requires a careful, first-time-right approach to production changes, preparing rollback plans, and clarifying incomplete requests into clear requirements. The work involves healthcare data containing PHI/PII and must comply with HIPAA requirements.

This is a remote position. A reliable high-speed internet connection and a secure, HIPAA-compliant workspace are required. The role includes virtual collaboration and team meetings, and may require travel depending on business and client needs.

Requirements

• 3–5 years of hands-on MS SQL Server database development and administration in a production environment.
• Strong T-SQL skills, including set-based queries, stored procedures, functions, views, CTEs, and transactional logic.
• Experience writing parameterized dynamic SQL (sp_executesql) safely and using WHILE loops and cursors for iterative and batch processing, with judgment about when a set-based approach is preferable.
• Proven experience building and supporting ETL pipelines using SQL Server as the backend, including staging, transformation logic, incremental loads, data validation, and failure recovery.
• Working knowledge of database administration, including backup and restore, SQL Agent jobs, index and statistics maintenance, security and permissions, and monitoring.
• Solid understanding of explicit transaction management (BEGIN TRAN, COMMIT, ROLLBACK), error handling (TRY...CATCH), and backout script patterns.
• Experience using DMVs, Query Store, Extended Events, and execution plans to troubleshoot performance issues.
• Understanding of isolation levels, locking and blocking, and indexing strategies.
• Experience with Azure SQL Database or Azure SQL Managed Instance.
• Experience developing and supporting SSRS reports, including parameters and datasets.
• Hands-on experience using AI-assisted development tools such as Claude Code, Codex, or GitHub Copilot.
• Proficiency with SSMS, Azure Data Studio, Git-based version control, and JIRA.
• Clear written and verbal communication skills, including the ability to explain technical findings in plain language to business partners.
• Reliable high-speed internet for remote work and a secure HIPAA-compliant workspace.
• Ability to sit for extended periods at a desk and work on a computer.

Nice To Haves

• Experience with PowerShell scripting for database automation.
• Practical experience with Microsoft Fabric (Data Factory pipelines, Warehouses/Lakehouses) or Azure Data Factory.
• Experience with high availability and disaster recovery, such as Always On availability groups, log shipping, or geo-replication.
• Experience in healthcare, Revenue Cycle Management, or another regulated industry handling PHI/PII.
• Microsoft Certified: Azure Database Administrator Associate (DP-300) or Fabric Analytics Engineer Associate (DP-600).

Responsibilities

• Design, write, and maintain T-SQL stored procedures, functions, views, and tables supporting applications, ETL pipelines, and reporting.
• Build, maintain, and troubleshoot ETL pipelines loading healthcare and financial data into SQL Server, including data validation, error handling, and job scheduling.
• Manage backups and restores, SQL Agent jobs, index and statistics maintenance, user access and permissions, and capacity monitoring across SQL Server and Azure SQL.
• Diagnose and resolve performance issues, blocking, deadlocks, failed jobs, and data inconsistencies; escalate complex issues to senior staff with a clear summary of findings.
• Author, test, peer-review, and execute production data scripts, preparing a rollback script before every data modification or schema change.
• Review execution plans, indexes, and stored procedures to refactor inefficient T-SQL and prevent recurring issues.
• Build, modify, and troubleshoot SSRS reports, subscriptions, and underlying datasets.
• Support conversion of legacy ETL processes built on PowerShell and stored procedures into Microsoft Fabric and Azure, and provide operational support after migration.
• Apply least-privilege access, protect PHI/PII under HIPAA, and follow team standards for source control, code review, and change management in Azure DevOps; track work in JIRA.
• Collaborate in virtual settings and participate in team meetings.
• Travel as required by business and client needs.

Benefits

• Comprehensive health and wellness benefits, including medical, dental, vision, life insurance, and short- and long-term disability coverage.
• HSA with employer contributions, flexible spending accounts for health care, and dependent care accounts.
• Wellness platform with premium incentives.
• Employee assistance support and additional voluntary supplemental plans, including accident, critical illness, hospital indemnity, and child disability insurance.
• Flexible paid time off offerings and company-paid holidays.
• 401(k) plan with discretionary employer match opportunities.
• Professional development opportunities.
• Company-issued equipment.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed