Job Description
Job Description
Summary
The SQL DBA will report directly to the Product Architect and work daily with the engineering team, the Senior AWS Systems Administrator, and product management. In this hands-on role, you will write the SQL, build and run the pipelines,read the execution plans, set the backup policies, and get paged when a migration goes sideways. You will also sit with product and operations to figure out which numbers matter to a facility administrator and build the reporting that puts those numbers in front of them.
What you will be doing:
- Map the data model to the schemas of 3rd-party EMRs, pharmacy and lab systems, billing clearinghouses, payer feeds, and regulatory reporting programs.
- Design and build the ETL and ELT pipelines that move data into, out of, and between systems, including facility onboarding migrations from legacy EMRs
- Analyze platform and facility data to produce reporting that operators use to run their buildings and that leadership uses to run the company.
- Own query and schema performance across our AWS databases and the database layers in the applications. Indexing strategy, execution plan analysis, query rewrites, partitioning, connection pooling, caching decisions, and capacity planning
- Own backup policy, point-in-time recovery, replication, failover, and disaster recovery testing.
- Set the standards for how schema changes are designed, reviewed, versioned, and deployed
- Maintain the data dictionary, the integration mappings, the runbooks, and the architecture documentation in Confluence
What you need to qualify:
- 7+ years' hands-on work with relational databases in production
- 3+ years with direct database administration responsibility
- 3+ years building data integration, transformation, or migration pipelines
- Expert level SQL knowledge to write complex analytical queries without reaching for a tool
- Deep experience with PostgreSQL is strongly preferred
- Experience with SQL Server, MySQL, or Oracle; legacy EMR migrations will include all of them
- Production experience administering databases on AWS, including Amazon RDS and Aurora
- Familiarity with the surrounding services: IAM, KMS, CloudWatch, Secrets Manager, S3, and the networking model that governs who can reach the database
- Hands-on experience with ETL and ELT tools and frameworks such as AWS Glue, dbt, Apache Airflow, or equivalent
- Scripting experience with Python
- Strong understanding of relational and dimensional modeling, normalization
- Demonstrated ability to take a business question, find the data that answers it, and present the answer in a form a non-technical operator can use
- Experience with a reporting or BI layer such as Amazon QuickSight, Metabase, Power BI, or Tableau
- Working knowledge of database security practices and of HIPAA requirements as they apply to data at rest, in transit, and in use.
- Ability to sit among an engineer, a product manager, and a facility billing lead and keep all 3 in the same conversation
- Hands-on experience tracking work in Jira and maintaining technical documentation in Confluence
- Comfort using AI tools as part of your daily workflow, Anthropic Claude in particular. We use AI throughout our process
- Bachelor's Degree in Computer Science, Information Systems, or a related; or equivalent practical experience.
• Preferred Experience:
- Healthcare data and interoperability standards, including HL7 v2, FHIR, CCD and C-CDA, X12 837 and 835, NCPDP, and the MDS 3.0 data set used in skilled nursing.
- Prior EMR or EHR data migration work, especially from legacy long term care systems such as PointClickCare, MatrixCare, or American HealthTech
- Familiarity with clinical and billing code sets: ICD-10, CPT, HCPCS, LOINC, SNOMED CT, RxNorm, NDC
- AWS certifications such as Database Specialty, Solutions Architect, or Data Engineer
- Experience in an early-stage company where you were the only database person
- Exposure to NoSQL or document stores and to streaming or event based data movement
What's in it for you:
- Competitive salary
- Excellent bonus program
- Cutting-edge technology
- Be a part of a growing start-up!
DISCLAIMER: The compensation range represents a good faith estimate of what our client may pay for the position at the time of posting. Our client may ultimately pay more or less than the posted compensation range. The salary offered to the selected candidate will be determined based on factors such as the qualifications of the selected candidate, departmental budget availability, internal salary equity considerations, and available market information, but not based on a candidate’s gender or any other protected status.
\nCompany Description
We are an AI native EMR platform built for operators of skilled nursing and assisted living facilities.
Company Description
We are an AI native EMR platform built for operators of skilled nursing and assisted living facilities.