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