Database Engineer (PostgreSQL)

Largeton Group is seeking a Database Engineer to manage PostgreSQL database design and performance for backend services. The role involves leading schema design, optimizing queries, and ensuring data integrity while supporting Node.js microservices.

Responsibilities:

• Own and manage PostgreSQL database design, performance, and reliability for metadata-driven backend services
• Lead schema design, migrations, query optimization, indexing, and ORM tuning (Prisma/Sequelize/TypeORM)
• Enforce data integrity, versioning, and backward compatibility within database systems
• Troubleshoot and resolve production performance issues related to databases
• Support Node.js microservices, integrating with PostgreSQL and optimizing queries
• Leverage AI-assisted tools for query analysis and optimization as required
• Build and execute automated tests (using pytest, Postman, REST-assured) for APIs and backend services
• Develop and maintain regression, contract, and integration test suites, integrating them into CI/CD pipelines
• Collaborate with engineering teams to validate business logic, triage defects, and enhance platform reliability

Requirements:

• Own and manage PostgreSQL database design, performance, and reliability for metadata-driven backend services
• Lead schema design, migrations, query optimization, indexing, and ORM tuning (Prisma/Sequelize/TypeORM)
• Enforce data integrity, versioning, and backward compatibility within database systems
• Troubleshoot and resolve production performance issues related to databases
• Support Node.js microservices, integrating with PostgreSQL and optimizing queries
• Leverage AI-assisted tools for query analysis and optimization as required
• Build and execute automated tests (using pytest, Postman, REST-assured) for APIs and backend services
• Develop and maintain regression, contract, and integration test suites, integrating them into CI/CD pipelines
• Collaborate with engineering teams to validate business logic, triage defects, and enhance platform reliability
• Must have at least 7+ years of relevant experience
• Expertise required: Advanced PostgreSQL and DBA skills; intermediate Prisma experience
• Healthcare domain experience preferred
• Previous experience in AI & Data Testing, Automation, and Validation is highly valued