Database Administrator

The Emily Program; Saint Paul (MN); Remote; USD 150,000 - 185,000; Full time

Job summary

Accanto Health is seeking a Database Administrator to ensure the reliability, performance, and security of its Azure data platform, integrating data from the EHR, Salesforce, and financial systems to support enterprise reporting. You will manage Azure SQL and data warehouse environments, ensure data ingestion reliability, and protect PHI per HIPAA.

As the organization\'s first dedicated database administrator, you will establish platform standards, monitor backups, and document procedures while

Qualifications

• Five or more years administering relational databases in production, including SQL Server or Azure SQL.
• Demonstrated performance tuning on large transactional datasets.
• Hands-on experience with Azure data services, including pipeline monitoring and failure triage.
• Troubleshooting synchronization between a source system and a downstream warehouse.
• Working knowledge of HIPAA safeguards as they apply to database and platform administration.
• Healthcare or financial systems experience preferred.

Responsibilities

• Platform and environments: manage Azure SQL and warehouse environments across development, test and production; size compute/storage and monitor costs.
• Reliability: backup, restore, disaster recovery targets, and data lineage documentation.
• Security and compliance: implement RBAC, encryption, masking, audit logs, and HIPAA safeguards.
• Performance: tune ETL/ELT and reporting queries (SSRS, Power BI); optimize indexing and partitioning.
• Documentation and continuity: maintain runbooks and cross-train staff; ensure dependencies are documented.
• Partnership: collaborate with Data Architect, Data Modelers, Data Developers and Analytics leadership.

Skills

Azure SQL

SQL Server

Performance tuning

Data security

HIPAA compliance

ETL/ELT monitoring

Data ingestion monitoring

Education

Bachelor’s degree in IT or related

7+ years equivalent experience in lieu of degree

Tools

Azure data services

SSRS

Power BI

Azure Synapse

Infrastructure-as-code

Job description

Our vision is a world of peaceful relationships with food, weight, and body image, where everyone with an eating disorder can experience recovery. We believe that exceptional, individualized care leads to lasting recovery from eating disorders. That’s why our teams are comprised of compassionate, dedicated professionals from a variety of backgrounds who collaborate to provide the very best evidence-based care for our clients at all levels of care.

Position Overview

The Database Administrator is responsible for the reliability, performance and security of Accanto Health's Azure data platform, which integrates data from the electronic health record, Salesforce and financial systems to support enterprise reporting and analytics. As the organization's first dedicated database administrator, this position establishes and maintains platform standards, monitoring, backup and recovery, access controls and documentation. The role administers Azure SQL and data warehouse environments, ensures the reliability of data ingestion from source systems, tunes database and reporting performance, and safeguards protected health information in accordance with HIPAA. This position partners with the Data Architect, Data Developers, and the EHR and application teams, and reports to the Director of Health Data Analytics.

Schedule

• 8am-5pm, Monday to Friday

Salary Range

• $150,414- $184,970 commensurate with experience

Location:

• Remote- Must be US based, and able to work with no restrictions in the US in a remote home office.
• Travel up to 10%

Visa / work permit sponsorship is not available for this position

How Database Administrators Empower Recovery

Platform and environments

• Azure SQL and warehouse environments across development, test and production - compute and storage sizing, performance tiers, and platform cost.
• Environment lifecycle, including scheduled refreshes of non-production from production so that test data is current enough to surface real edge cases. This is currently unowned and refreshes have lapsed; you will own the cadence, the vendor request process, and the cost conversation that goes with it.
• Ingestion reliability from the EHR, Salesforce and financial systems - monitoring, alerting, failure triage, and documented re-run procedures.

Performance

• Tune ETL/ELT transformations and reporting queries (SSRS, Power BI).
• Own indexing, statistics and partitioning strategy for large tables such as claims, transactions and encounters.
• Establish performance baselines, so that "the report is slow" becomes a measurement rather than an argument.

Security and compliance

• Role-based access control, least-privilege design, and periodic access review.
• PHI safeguards under HIPAA: encryption in transit and at rest, data masking, audit logging.
• Vendor and contractor access management, including access paths covered by business associate agreements.
• Participation in incident response for data-related events.

Reliability

• Backup, restore and disaster recovery - including published RPO and RTO targets and restore tests that are actually performed, not just documented.
• Detection and resolution of source-to-warehouse synchronization gaps.
• Root-cause analysis of data inconsistencies, including cases where the source system holds several conflicting copies of the same fact.

Documentation and continuity

• Platform documentation, runbooks, and data lineage from source through to the reporting layer. This is a first-class responsibility, not an afterthought - undocumented dependencies are our single largest operational risk today.
• Cross-training and written procedures, so no critical process depends on one person.

Partnership

• Data Architect, Data Modelers, Data Developers and Analytics leadership.
• The EHR and application teams, and our EHR vendor's technical staff. Configuration changes are made in the application land in our warehouse, so this role is one of the few that has to see both sides. These teams currently plan separately; helping to close that gap is part of the job.
• Finance, on platform cost and forecasting.

Education Qualifications

• Bachelor’s degree required in information technology, Healthcare Administration, Health Information Management, Healthcare Informatics, Computer Science, Business, or related field preferred; Associate Degree and 7 years equivalent experience may be considered in lieu of degree.

Professional Qualifications

• Five or more years administering relational databases in production, including SQL Server or Azure SQL.
• Demonstrated performance tuning on large transactional datasets.
• Hands-on experience with Azure data services, including pipeline monitoring and failure triage.
• Troubleshooting synchronization between a source system and a downstream warehouse.
• Comfort working with source data that is poorly documented, denormalized or hierarchically structured - and the discipline to write down what you learn.
• Working knowledge of HIPAA safeguards as they apply to database and platform administration.
• Healthcare (EHR or revenue cycle) or financial systems experience preferred.
• Microsoft Fabric and/or Synapse preferred.
• Experience supporting a site or entity consolidation - merging, mapping or retiring facility-level data preferred.
• Infrastructure-as-code or scripted deployment, and source control for database objects preferred.

Competencies

• Administers relational database platforms in production - backup and recovery, high availability, capacity and storage planning, patching and upgrades
• Diagnoses performance problems using execution plans, indexing, statistics and partitioning; establishes baselines rather than reacting to complaints
• Writes and tunes SQL fluently, and reads code written by others
• Implements database security: role-based access control, least privilege, encryption, masking, audit logging and periodic access review
• Safeguards protected health information in accordance with HIPAA at the database and platform layer
• Monitors data pipelines and integrations (APIs/web services, SFTP/file feeds, middleware), triages failures, and documents re-run and remediation steps
• Works effectively with poorly documented source systems - infers structure, validates findings with subject-matter experts, and records what is learned
• Owns platform reliability end to end, including escalation and incident response
• Applies change control discipline: release readiness, testing coordination, backout planning and deployment standards
• Treats documentation as a deliverable