Database Administrator

A
Accanto HealthHealthcare data
Must be US based, and able to work with no restrictions in the US in a remote home office.Full-TimeSenior
Salary150,414 - 184,970 USD per year
Apply NowOpens the employer's application page

Job Details

Experience
Five or more years administering relational databases in production, including SQL Server or Azure SQL.
Required Skills
SQLMicrosoft Power BIMicrosoft SQL ServerHIPAA

Requirements

  • 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.
  • Experience troubleshooting synchronization between a source system and a downstream warehouse.
  • Ability to work with poorly documented, denormalized, or hierarchically structured source data and document findings.
  • Working knowledge of HIPAA safeguards for database and platform administration.
  • Bachelor’s degree in information technology, Healthcare Administration, Health Information Management, Healthcare Informatics, Computer Science, Business, or a related field; an associate degree and seven years of equivalent experience may be considered in lieu of a degree.
  • Healthcare (EHR or revenue cycle) or financial systems experience preferred.
  • Microsoft Fabric and/or Synapse experience preferred.
  • Experience supporting site or entity consolidation preferred.
  • Infrastructure-as-code or scripted deployment and source control for database objects preferred.
  • Travel up to 10%.

Responsibilities

  • Administer Azure SQL and data warehouse environments across development, test, and production, including capacity, storage, and platform cost.
  • Manage non-production environment refreshes, vendor requests, and refresh cadence.
  • Monitor data ingestion from the EHR, Salesforce, and financial systems; triage failures and document rerun procedures.
  • Tune ETL/ELT transformations and SSRS and Power BI reporting queries.
  • Own indexing, statistics, and partitioning strategies for large tables, and establish performance baselines.
  • Implement role-based access controls, least-privilege access, encryption, masking, audit logging, and periodic access reviews.
  • Maintain backup, restore, and disaster recovery processes, including restore tests and RPO and RTO targets.
  • Investigate synchronization gaps and data inconsistencies between source systems and the warehouse.
  • Create platform documentation, runbooks, and data lineage, and develop written procedures and cross-training.
  • Coordinate with data, EHR, application, finance, vendor, and analytics teams on platform reliability and changes.
View Full Description & ApplyYou'll be redirected to the employer's site
150,414 - 184,970 USD per year
Apply Now