Location: Remote (Onshore USA)
Employment Type: Contract
Experience Required: 6+ Years
Positions: 1
Position Overview
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 Node.js 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.
Key Responsibilities
- 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 Node.js 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.
Required Qualifications
- 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 Node.js.
- 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.
Sign in
To continue your applicationor continue with email
By continuing you agree to our Terms & Privacy Policy.
