Database Engineer (PostgreSQL)

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.