SQL DBA and Data Transformation Expert
SQL DBA and Data Transformation ExpertMaxiCare LLCAbout the job MaxiCare is an AI native EMR platform built for operators of skilled nursing and assisted living facilities. The tagline says it plainly: the EMR that thinks. We are an early stage company building product alongside our first cohort of facility partners. The team is small and the work is real. What we build decides whether a nurse spends the shift charting or caring for residents, and whether an operator gets paid for care already delivered. We're hiring a SQL DBA and Data Transformation Expert who is as comfortable tuning a production database as reasoning about what the data inside it means. Half the role is data engineering: mapping the MaxiCare data model to third party schemas, moving data in and out faithfully, and turning it into reporting operators act on. The other half is administration: the performance, security, and stability of our AWS databases. Every facility arrives with history in another EMR and a web of outside systems. You'll understand both sides of every one of those conversations and prove that what arrived matches what left. MaxiCare Offers the Following Unlimited vacation: We don't count days. Take the time you need to rest and come back sharp, coordinated with your team so the work keeps moving. Career growth: MaxiCare is an AI first company, and this seat puts your hands on how one gets built. You'll work every day inside sophisticated product design where AI is part of the architecture, the workflow, and the product itself, and you'll build the skills the next decade of software will run on. Holiday gathering: Once a year the whole team comes together in person to celebrate the year and spend time together away from the screen. Health and fitness: We cover 50 percent of a monthly fitness and health club membership. Details are discussed during the interview process.
Compensation:
Competitive base compensation calibrated to the experience you bring and the market in your jurisdiction, plus performance based annual bonus participation. Specifics are discussed during the interview process.
Remote:
Fully remote within the United States. You share on call responsibility for production databases with engineering and systems administration. Cameras stay on for every video call. Reports to the Product Architect. Full time, exempt.
Responsibilities:
- Data Integration and Migration
- Map the MaxiCare data model to third party EMRs, pharmacy and lab systems, clearinghouses, payers, and regulatory programs
- Build ETL and ELT pipelines, including facility onboarding migrations from legacy EMRsHandle code set translation, identity matching, deduplication, and reconciliation on every load
- Analytics and Reporting
- Build reporting on census, revenue cycle, quality measures, staffing, and product usage
- Decide with product what ships inside the EMR and what stays internal
- Database Administration
- Own query and schema performance: indexing, execution plans, partitioning, and connection pooling
- Own access control, encryption, audit logging, and least privilege for PHIOwn backup policy, point in time recovery, failover, and disaster recovery testing
- Set schema change standards and review engineering migrations before they reach production
- Keep the data dictionary, integration mappings, and runbooks current in Confluence
Education
A four year college degree in computer science, information systems, or a related field from an accredited institution, or equivalent practical experience.
Experience
Seven or more years with relational databases in production, including three or more in direct DBA work and three or more building integration or migration pipelines (the years can overlap)
Expert SQL and fluent execution plan reading; deep PostgreSQL strongly preferred, with SQL Server, MySQL, or Oracle a plus
Amazon RDS and Aurora administration, plus IAM, KMS, CloudWatch, Secrets Manager, and S3AWS Glue, dbt, Apache Airflow, or equivalent, with Python for the gaps
Relational and dimensional modeling, and knowing when to break normalization
Reporting in QuickSight, Metabase, Power BI, or Tableau that a non technical operator can use
Database security practice and HIPAA requirements for data at rest, in transit, and in use
Backups you've restored from and failover you tested before you needed itJira, Confluence, and daily AI tool use, Anthropic Claude in particular
Authorized to work in the United States. Visa sponsorship is not available.
PreferredHL7 v2, FHIR, CCDA, X12 837 and 835, NCPDP, and the MDS 3.0 data setEMR data migrations from PointClickCare, MatrixCare, or American HealthTechClinical and billing code sets: ICD 10, CPT, HCPCS, LOINC, SNOMED CT, RxNorm, and NDCAWS Database Specialty, Solutions Architect, or Data Engineer certification
Time as the only database person in the room at an early stage company
NoSQL, document stores, or streaming data movement
TravelAs requested and needed, including occasional on site team meetings where we work through product design and architecture strategy together. Facility migrations sometimes go better with someone on site for go live, and some trips will come up on short notice.
How to Apply:
Along with your resume, tell us about the largest database you've administered and the hardest data migration you've delivered. Apply here on LinkedIn or at maxicare.io. We read every application. The SQL DBA and Data Transformation Expert succeeds when a facility's history arrives in MaxiCare intact, queries stay fast, and the data answers the questions operators actually ask.
Equal Employment Opportunity:
MaxiCare LLC is an equal opportunity employer. We make hiring decisions based on qualifications, experience, and fit for the role. We do not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran status, or any other category protected by applicable law.