Database Engineer

Medclinicx; Austin (TX); On-site; USD 110,000 - 160,000; Full time

Job summary

Med Clinic X is seeking a Database Engineer to design, develop, and maintain secure database architectures for healthcare SaaS platforms and clinical applications.

You will design schema layouts, optimize queries, implement indexing strategies, and ensure HIPAA privacy and data security while collaborating with software engineering, DevOps, and BI teams to sustain data integrity and performance.

Qualifications

• Bachelor's degree in CS or related field.
• Strong experience in database design, scaling, and administration.
• Proficiency in PostgreSQL, MySQL, MSSQL, or Oracle.
• Deep understanding of query tuning and index optimization.
• Experience configuring database clustering, replication, and backups.

Responsibilities

• Design schema layouts and data architectures.
• Create normalized tables and implement PHI isolation rules.
• Deploy cloud-managed databases (RDS, Aurora, Cloud SQL).
• Maintain transactional consistency and referential integrity.
• Analyze query execution plans to identify bottlenecks.
• Implement database partitioning and sharding policies.
• Design composite indexes matching filter ordering.
• Optimize slow clinical reporting and dashboard queries.
• Enforce HIPAA and SOC2 compliance controls for data.
• Implement column-level encryption for PHI data.
• Establish fine-grained database access control (RBAC).
• Set up multi-AZ primary/standby DB replication.
• Implement automated failover policies.
• Configure point-in-time recovery (PITR) pipelines.
• Isolate PHI and implement column-level encryption in database systems.
• Deploy primary/standby database architectures with multi-AZ failover and continuous backup pipelines.
• Analyze slow queries using execution plans (EXPLAIN ANALYZE), partitioning, and indexing strategies.
• Maintain CDC (Change Data Capture) pipelines to sync production databases with analytical warehouses.
• Migrate on-premise clinical databases to managed cloud database systems with zero downtime.
• Deploy Redis/Memcached cluster nodes to offload database query traffic for peak telemedicine hours.

Skills

PostgreSQL

MySQL

MSSQL

Oracle

Query tuning

Database design

Education

Bachelor's degree in Computer Science or related field

Tools

AWS Aurora

GCP Cloud SQL

MongoDB

Redis

Cassandra

Job description

Med Clinic X is a healthcare technology company building modern, scalable database systems that power healthcare organizations across the United States.

We develop healthcare SaaS platforms, AI-driven healthcare systems, patient portals, telemedicine solutions, automation workflows, and cloud-based digital health products for clinics, hospitals, and healthcare providers.

Our mission is to build secure, high-performance database systems that support mission-critical healthcare operations and real-time healthcare workflows.

Job Overview

We are seeking a Database Engineer to design, develop, and maintain secure database architectures for healthcare SaaS platforms and clinical applications.

In this role, you will design schema layouts, optimize queries, implement indexing strategies, and configure high-availability data replication. You will collaborate with software engineering, DevOps, and BI teams to ensure data integrity, privacy, performance, and HIPAA compliance.

Responsibilities

Database Administration & Design

• Design schema layouts and data architectures.


• Create normalized tables and implement PHI isolation rules.


• Deploy cloud-managed databases (RDS, Aurora, Cloud SQL).


• Maintain transactional consistency and referential integrity.

Query Optimization & Tuning

• Analyze query execution plans to identify bottlenecks.


• Implement database partitioning and sharding policies.


• Design composite indexes matching filter ordering.


• Optimize slow clinical reporting and dashboard queries.

Security & Compliance (HIPAA)

• Enforce HIPAA and SOC2 compliance controls for data.


• Implement column-level encryption for PHI data.


• Establish fine-grained database access control (RBAC).

Backup, Recovery & HA

• Set up multi-AZ primary/standby DB replication.


• Implement automated failover policies.


• Configure point-in-time recovery (PITR) pipelines.

Qualifications

Required

• Bachelor's in Computer Science, Information Systems, or related field.


• Strong experience in database design, scaling, and administration.


• Proficiency in PostgreSQL, MySQL, MSSQL, or Oracle.


• Deep understanding of query tuning and index optimization.


• Experience configuring database clustering, replication, and backups.

Preferred

• Experience in US healthcare environments or digital health platforms.


• Knowledge of HIPAA compliance and data security practices.


• Familiarity with cloud databases (AWS Aurora, GCP Cloud SQL).


• Experience with NoSQL data stores (MongoDB, Redis, Cassandra).


• Exposure to Change Data Capture (CDC) and ETL pipelines.

Why Join Med Clinic X?

At Med Clinic X, you will build database infrastructures that power real healthcare transformation. You will:

• Design secure HIPAA-compliant schema layouts


• Optimize databases for massive clinical datasets


• Establish automated disaster recovery pipelines


• Collaborate with backend, DevOps, and BI teams


• Utilize advanced query analysis and optimization tools


• Deploy modern cloud database clusters at scale

Technical Core

SQL Query Optimization PostgreSQL / MySQL / MSSQL HIPAA & PHI Security Protocols Database Partitioning & Sharding Multi-AZ replication & PITR NoSQL Databases (MongoDB/Redis)

Systems You Will Build

HIPAA-Compliant Schema Design

Isolate Protected Health Information (PHI) and implement column-level encryption in database systems.

High-Availability DB Clusters

Deploy primary/standby database architectures with multi-AZ failover and continuous backup pipelines.

Query Optimization Pipeline

Analyze slow queries using execution plans (EXPLAIN ANALYZE), partitioning, and indexing strategies.

Data Warehouse / BI Sync

Maintain CDC (Change Data Capture) pipelines to sync production databases with analytical warehouses.

Migrate on-premise clinical databases to managed cloud database systems with zero downtime.

NoSQL Caching Layers

Deploy Redis/Memcached cluster nodes to offload database query traffic for peak telemedicine hours.