Note: The job is a remote job and is open to candidates in USA. Infinite Computer Solutions is seeking a PostgreSQL Engineer to support healthcare clinical systems. The role focuses on managing, optimizing, migrating, securing, monitoring, and automating enterprise PostgreSQL database environments in healthcare and cloud infrastructure settings.
Responsibilities
- 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)
Skills
- 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)
- Extensive experience managing enterprise Postgres (PostgreSQL) databases in production, high volume environments (installation, configuration, patching, backup/recovery, and high availability/replication setups)
- Proven track record in Postgres performance tuning, query optimization, indexing strategies, analyzing execution plans, and resolving concurrency bottlenecks
- Strong background in relational and dimensional data modeling for complex enterprise applications, ensuring data integrity, scalability, and optimal query performance
- 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
- Hands-on experience deploying, managing, and scaling database environments within cloud platforms (e.g., AWS, Azure, or GCP—such as AWS RDS/Aurora Postgres)
- Experience implementing HIPAA-compliant data security measures, including encryption at rest/in transit, robust role-based access control (RBAC), and audit logging
- Experience integrating database schema migrations and CI/CD pipelines using tools like Flyway, Liquibase, or Terraform
- Familiarity with modern database monitoring and APM tools (e.g., Datadog, Prometheus, Grafana, or pg\_stat\_statements)
Benefits
- Remote work arrangement in the USA
Company Overview
Company H1B Sponsorship