Database Engineer (PostgreSQL)

Location: Remote (Onshore USA)
Employment Type: Contract
Experience Required: 6 Years
Positions: 1

We are seeking a highly skilled Database Engineer (PostgreSQL) with 6 years of experience in designing optimizing and maintaining enterprise PostgreSQL databases that support modern metadata-driven backend services and cloud-native applications.

The ideal candidate will have extensive expertise in PostgreSQL architecture database performance tuning schema design indexing strategies and production troubleshooting. This role will work closely with backend engineering teams supporting microservices while ensuring database scalability reliability security and high availability.

Experience with ORM frameworks such as Prisma Sequelize or TypeORM as well as AI-assisted database optimization tools is highly desirable.

• Design implement and maintain highly available PostgreSQL database environments.
• Lead database schema design normalization and data modeling for enterprise applications.
• Plan and execute database schema migrations while maintaining backward compatibility.
• Optimize SQL queries indexes execution plans and database performance for high-volume transactional systems.
• Configure and tune PostgreSQL for scalability reliability and optimal resource utilization.
• Design indexing strategies to improve application performance and reduce query latency.
• Support microservices by developing efficient database access patterns and integrations.
• Work with ORM technologies including Prisma Sequelize or TypeORM to optimize application performance.
• Monitor database health troubleshoot production performance issues and resolve bottlenecks.
• Implement database versioning backup recovery replication and disaster recovery strategies.
• Ensure data integrity consistency and security across enterprise systems.
• Collaborate with software engineers architects and DevOps teams during application development and deployments.
• Leverage AI-assisted database analysis and optimization tools to identify performance improvements.
• Create and maintain database documentation standards and operational procedures.
• Participate in database capacity planning and future scalability initiatives.

• Minimum 6 years of professional experience administering and engineering PostgreSQL databases.
• Advanced expertise in PostgreSQL administration configuration and performance tuning.
• Strong experience designing relational database schemas and data models.
• Expertise in SQL optimization indexing strategies and execution plan analysis.
• Experience performing database migrations and version management.
• Knowledge of PostgreSQL replication backup recovery and high-availability solutions.
• Experience supporting backend applications developed using .
• Working experience with ORM frameworks such as Prisma Sequelize or TypeORM.
• Strong understanding of ACID transactions concurrency control and database security.
• Experience troubleshooting complex production database performance issues.
• Familiarity with cloud-hosted PostgreSQL environments (AWS RDS Azure Database for PostgreSQL or similar).
• Experience working in Agile development environments.
• Strong analytical troubleshooting and communication skills.