Senior Database Engineer

Strategic Ventures-in; Chennai District; On-site; INR 1,500,000 - 2,100,000; Full time

Job summary

Strategic Ventures-in in Chennai invites a Senior Database Engineer to design, implement, and maintain enterprise PostgreSQL databases for healthcare platforms. You will create scalable schemas, support HL7 v2.x and FHIR resources, and collaborate with architects, backend, DevOps, AI, and integration specialists to deliver secure, high-performance data services.

This role covers migration projects, performance tuning, backup and DR, security, and compliance across cloud and on‑prem environments.

Qualifications

• 5+ years hands-on PostgreSQL administration and development.
• Experience with healthcare platforms and interoperability.
• Cloud and on-premises deployments.
• Strong data modelling and HL7/FHIR knowledge.
• Security and compliance awareness.

Responsibilities

• Design, develop, and maintain enterprise PostgreSQL databases.
• Create scalable, normalised schemas for multi-module healthcare apps.
• Design ER diagrams, relational models, constraints, indexes, views, stored procedures, functions, triggers.
• Review architecture for scalability and maintainability.
• Maintain database documentation and data dictionaries.
• Support HL7 v2.x messaging and FHIR resources.
• Work with Mirth Connect to process HL7/FHIR data.
• Collaborate with DevOps on deployments, HA, DR plans.

Skills

PostgreSQL

High availability

Data migration

DevOps tools

Education

Bachelor's degree in Computer Science/IT/Engineering

Tools

TimescaleDB

Job description

We are seeking a highly skilled Senior Database Engineer to join our engineering team in building and supporting enterprise healthcare platforms.

The ideal candidate will have strong expertise in PostgreSQL database administration, schema design, healthcare data modelling, HL7/FHIR interoperability, cloud and on-premises deployments, data migration, and database performance optimisation.

The role requires close collaboration with application architects, backend developers, DevOps engineers, AI teams, and healthcare integration specialists to design secure, scalable, and high-performance database solutions.

Key Responsibilities

• Design, develop, and maintain enterprise-grade PostgreSQL databases.
• Create scalable and normalised database schemas for multi-module healthcare applications.
• Design ER diagrams, relational models, constraints, indexes, views, stored procedures, functions, and triggers.
• Review database architecture and recommend improvements for scalability and maintainability.
• Maintain database documentation and data dictionaries.
• Design database structures supporting HL7 v2.x messaging and FHIR R4 resources.
• Support healthcare interoperability across HIS, EMR, EHR, LIS, RIS, PACS, and third-party healthcare systems.
• Develop database models for FHIR resources, including:
• Organization
• Encounter
• Appointment
• Observation
• Condition
• Procedure
• Medication
• CarePlan
• Device
• ServiceRequest
• Other FHIR resources as required
• Work with healthcare integration engines such as Mirth Connect to process HL7 messages and FHIR APIs.
• Support healthcare master data management and clinical data standardisation.

Database Administration

• Install, configure, upgrade, and maintain PostgreSQL databases.
• Monitor database health, availability, and performance.
• Configure replication, backup, recovery, and disaster recovery strategies.
• Manage users, roles, permissions, and security policies.
• Perform database patching and production maintenance activities.
• Ensure database availability for mission-critical healthcare applications.

Database Performance Optimisation

• Analyse slow-running SQL queries and optimise execution plans.
• Design indexing strategies and table partitioning.
• Tune PostgreSQL configuration for high-concurrency environments.
• Optimise transaction handling and large-volume data processing.
• Monitor database performance using enterprise monitoring tools.

Data Migration & Data Management

• Develop migration scripts from legacy systems to PostgreSQL.
• Perform ETL activities for healthcare datasets.
• Create and maintain module-wise master data and seed data.
• Design automated data seeding processes for multiple application modules.
• Validate migrated data for accuracy, completeness, and consistency.
• Support production database upgrades and schema versioning.

Deploy and manage PostgreSQL across:

• Amazon Web Services (Amazon RDS for PostgreSQL)
• Bare Metal / On-Premises Infrastructure

Work closely with DevOps teams to support:

• Containerised deployments
• Environment provisioning
• High Availability (HA)

Security & Compliance

• Configure encryption for data at rest and in transit.
• Maintain audit logging and database activity monitoring.
• Support healthcare compliance requirements, including PDPA, HIPAA, and GDPR (where applicable).
• Ensure secure handling of clinical and patient data.
• Work closely with Backend, Frontend, AI/ML, DevOps, QA, and Product teams.
• Participate in solution architecture and technical design discussions.
• Support production deployments and post-release validation.
• Troubleshoot database and integration issues in production environments.
• Provide database best practices and technical guidance to development teams.

Required Technical Skills

Database Technologies

• PostgreSQL (5+ years)

High Availability

Data Migration

DevOps & Tools

Preferred Skills

• Experience with TimescaleDB

Qualifications

• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related discipline.
• 5–6 years of hands‑on experience in PostgreSQL Database Administration and Development.
• Proven experience in enterprise database architecture and production support.
• Experience with healthcare platforms, clinical systems, or healthcare interoperability is highly preferred.
• Strong understanding of cloud and on-premises database deployments.

What We Offer

• Opportunity to build next-generation healthcare technology platforms.
• Exposure to enterprise-scale cloud and on-premises environments.
• Work with modern technologies including AI, Healthcare Interoperability, PostgreSQL, Docker, Kubernetes, and Cloud Platforms.
• Collaborative engineering culture focused on innovation, scalability, and healthcare transformation.