Database Engineer

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. #J-18808-Ljbffr