PostgreSQL Database Engineer (Healthcare)

PostgreSQL Database Engineer (Healthcare Clinical Systems)

Location: Remote, USA

Core Requirements (Must-Haves)

• Healthcare Clinical Domain Experience: Deep understanding of healthcare workflows, clinical data structures, and electronic health record (EHR/EMR) systems. Familiarity with standard healthcare data exchange formats (e.g., HL7, FHIR).
• Database Management & Administration: Extensive experience managing enterprise Postgres (PostgreSQL) databases in production, high volume environments (installation, configuration, patching, backup/recovery, and high availability/replication setups).
• Advanced Performance Tuning: Proven track record in Postgres performance tuning, query optimization, indexing strategies, analyzing execution plans, and resolving concurrency bottlenecks.
• Data Modeling Expertise: Strong background in relational and dimensional data modeling for complex enterprise applications, ensuring data integrity, scalability, and optimal query performance.
• Data Migration & Integration (SQL Server / SSIS): Proven experience planning and executing complex enterprise data migrations. Strong hands-on familiarity with SQL Server Integration Services (SSIS) and migrating data from legacy SQL Server environments to modern PostgreSQL architectures.
• Cloud Infrastructure & DevOps: Hands-on experience deploying, managing, and scaling database environments within cloud platforms (e.g., AWS, Azure, or GCP—such as AWS RDS/Aurora Postgres).
• Compliance & Security: Experience implementing HIPAA-compliant data security measures, including encryption at rest/in transit, robust role-based access control (RBAC), and audit logging.
• Automation & CI/CD: Experience integrating database schema migrations and CI/CD pipelines using tools like Flyway, Liquibase, or Terraform.
• Troubleshooting & Monitoring: Familiarity with modern database monitoring and APM tools (e.g., Datadog, Prometheus, Grafana, or pg_stat_statements).