Database Administrator
A
Accanto HealthHealthcare data
Remote—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
- Have five or more years administering relational databases in production, including SQL Server or Azure SQL.
- Demonstrate performance tuning experience with large transactional datasets.
- Have hands-on experience with Azure data services, including pipeline monitoring and failure triage.
- Be able to troubleshoot synchronization between a source system and a downstream warehouse.
- Work effectively with poorly documented, denormalized, or hierarchically structured source data and document findings.
- Have working knowledge of HIPAA safeguards for database and platform administration.
- Hold a 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.
- Be able to administer production database platforms, including backup and recovery, high availability, capacity and storage planning, patching, and upgrades.
- Write and tune SQL, read code written by others, and diagnose performance using execution plans, indexing, statistics, and partitioning.
- Apply change control practices, including release readiness, testing coordination, backout planning, and deployment standards.
- Preferred: healthcare (EHR or revenue cycle) or financial systems experience; Microsoft Fabric and/or Synapse; site or entity consolidation experience; and infrastructure-as-code or scripted deployment with source control for database objects.
Responsibilities
- Administer Azure SQL and data warehouse environments across development, test, and production, including compute, storage, performance tiers, and platform cost.
- Own non-production environment refresh cadence, vendor requests, and related cost discussions.
- Monitor 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; manage indexing, statistics, and partitioning strategies.
- Establish performance baselines for databases and reporting.
- Implement role-based access controls, least-privilege access, encryption, masking, audit logging, and periodic access reviews to safeguard PHI under HIPAA.
- Manage backup, restore, disaster recovery, synchronization-gap detection, and data inconsistency investigations.
- Create and maintain platform documentation, runbooks, data lineage, and written procedures; cross-train colleagues.
- Coordinate with data, EHR, application, finance, and analytics teams and manage vendor technical relationships.
View Full Description & ApplyYou'll be redirected to the employer's site