Key skills
SQLAIETLAngularNode.jsAWSPostgresMySQLMariaDBCI/CDCollaboration
About this role
BigRio is a Boston-based, remote-first technology consulting firm specializing in advanced data and software solutions. They are seeking a Database Engineer to design and integrate highly available, secure, and optimized solutions for healthcare applications, focusing on EMR/EHR workloads.
Responsibilities:
- Database Design & Architecture
- Design and implement MySQL, PostGres, or MariaDB schemas and data models optimized for EMR/EHR workloads
- Experience working with AI Voice Agent Integrations
- Create scalable solutions for patient records (PHI), appointments, billing, and clinical workflows
- Ensure compatibility with interoperability standards (HL7, FHIR, ADT)
- Database Development & Optimization
- Develop and maintain stored procedures, views, triggers, and indexing strategies
- Optimize query performance and database configurations for high-volume healthcare transactions
- Implement ETL processes for ingesting data from various healthcare systems (EHRs, lab systems, and third-party APIs)
- Data Security & Compliance
- Implement encryption, user access controls, and audit trails for sensitive patient data
- Ensure compliance with healthcare regulations (HIPAA, GDPR)
- Integration & Collaboration
- Collaborate with application development teams (Node.js/Nest.js, Angular) to ensure seamless API and data layer integration
- Support development of REST APIs for secure data retrieval and updates
- Work closely with QA teams to validate data integrity and performance
- Monitoring & Maintenance
- Set up database backup, recovery, and disaster recovery processes
- Monitor database health, capacity planning, and troubleshoot performance issues
- Provide on-call support as needed
Requirements:
- Bachelor's degree in Computer Science, Information Systems, or related field
- 5+ years of experience as a database engineer
- Strong Relational Database experience
- Understanding of HL7, FHIR, and healthcare data models
- Experience with database replication, partitioning, sharding, and high availability setups
- Advanced SQL performance tuning and optimization experience
- Familiarity with ETL workflows, data migrations, and healthcare data pipelines
- Working knowledge of API integrations and enterprise architecture for healthcare applications
- Experience with cloud-based AWS DB Deployment
- Knowledge of microservices architecture and REST APIs
- Experience working with Dockerized environments and CI/CD for database deployment