SQL Developer

This is a fully remote position, open to applicants in United States.

📋 Description

• Design, develop, and maintain T-SQL stored procedures, functions, views, and tables that support applications, ETL pipelines, and reporting.

• Construct, sustain, and troubleshoot ETL pipelines for healthcare and financial data, ensuring comprehensive validation, error handling, and job scheduling.

• Oversee backups and restorations, SQL Agent jobs, index and statistics maintenance, user access and permissions, as well as capacity monitoring across SQL Server and Azure SQL.

• Identify and resolve performance challenges, including blocking, deadlocks, failed jobs, and data inconsistencies.

• Escalate intricate issues to senior staff, providing a clear summary of the findings.

• Create, test, peer-review, and execute production data scripts, ensuring rollback scripts are ready prior to any modifications or schema changes.

• Analyze execution plans, indexes, and stored procedures to refactor inefficient T-SQL and avert recurring issues.

• Create, adjust, and troubleshoot SSRS reports, subscriptions, and datasets.

• Assist in converting legacy PowerShell and stored-procedure ETL processes into Microsoft Fabric and Azure.

• Offer operational support post-migration.

• Implement least-privilege access and safeguard PHI/PII in accordance with HIPAA regulations.

• Adhere to source control, code review, and change management standards within Azure DevOps.

• Monitor tasks in JIRA.

• Manage assigned databases, tickets, and changes from end to end, collaborating with senior engineers.

⛳️ Requirements

• 3–5 years of practical experience in MS SQL Server database development and administration within a production setting.

• Strong proficiency in T-SQL, including set-based queries, stored procedures, functions, views, CTEs, and transactional logic.

• Experience in safely writing parameterized dynamic SQL (sp_executesql) and using WHILE loops and cursors for iterative and batch processing.

• Demonstrated experience in building and supporting ETL pipelines using SQL Server as the backend, covering staging, transformation logic, incremental loads, data validation, and failure recovery.

• Familiarity with database administration tasks such as backup/restore, SQL Agent jobs, index and statistics maintenance, security and permissions, and monitoring.

• Strong understanding of explicit transaction management, error handling, and backout script patterns.

• Experience utilizing DMVs, Query Store, Extended Events, and execution plans to troubleshoot performance issues.

• Knowledge of isolation levels, locking and blocking, and indexing strategies.

• Experience with Azure SQL Database or Azure SQL Managed Instance.

• Proficient in developing and supporting SSRS reports, including parameters and datasets.

• Hands-on experience with AI-assisted development tools such as Claude Code, Codex, or GitHub Copilot.

• Proficient in SSMS, Azure Data Studio, Git-based version control, and JIRA.

• Excellent written and verbal communication skills, capable of articulating technical findings in clear language for business partners.

• Preferred: experience with PowerShell scripting for database automation.

• Preferred: practical experience with Microsoft Fabric or Azure Data Factory.

• Preferred: experience with high availability and disaster recovery.

• Preferred: experience in healthcare, Revenue Cycle Management, or another regulated industry dealing with PHI/PII.

• Preferred: Microsoft Certified: Azure Database Administrator Associate (DP-300) or Fabric Analytics Engineer Associate (DP-600).

• Reliable high-speed internet connection.

• Stable Wi-Fi with adequate bandwidth for video conferencing, cloud-based tools, and online work.

• HIPAA-compliant work environment with a secure workspace.

• Ability to sit for extended periods at a desk and work on a computer.

🏝️ 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 healthcare and dependent care.

• Wellness platform offering premium incentives.

• Employee assistance support.

• Additional voluntary supplemental plans such as accident, critical illness, hospital indemnity, and child disability insurance.

• Robust and flexible paid time off offerings.

• Company-paid holidays.

• 401(k) plan with discretionary employer matching opportunities.

• Opportunities for professional development.

• Company-issued equipment.