Database Engineer (PostgreSQL)

First Soft Solutions
South Brunswick Township, NJ, United States
about 1 month ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
1 year minimum
Compensation
$93,254.0 - $112,504.0
Working hours
Regular working hours

Tech stack

.NET Framework Agile Methodology Artificial Intelligence Application Performance Management Program Optimization Databases Concurrency Controls Data Integrity Database Analysis Relational Databases Database Schema Database Security
+26 more
DevOps Disaster Recovery PostgreSQL Metadata SQL Azure Node.Js Object-Relational Mapping Operational Databases Performance Tuning Software Engineering SQL Databases Systems Integration Management of Software Versions Enterprise Software Applications Sql Optimization Spring Cloud System Availability Database Optimization Database Performance Backend Vue.js Database Migration Amazon Relational Database Service React Native Software Version Control Microservices

Job description

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.

Requirements

  • 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.

Benefits & conditions

  • $93,254-112,504 per year As a family-run, high-tech company with nearly 19,000 employees at 71 locations worldwide, we are looking for forward thinkers with unconventional ideas and drive to join our team.…

  • 1 month ago +

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.careerjet.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

2:05 min

Embracing high opinionation to simplify web application architecture

Daniel Hepper · LIVE

2:10 min

Analyzing the out-of-the-box security posture of Vue.js

Philippe De Ryck · LIVE

2:17 min

Mapping the maturity roadmap for scaled devops adoption

Dominik Krichbaum Dominik Krichbaum · WWC Europe 2026

1:52 min

Structuring and scaling the backend engineering team

Stefan Lingler Stefan Lingler +1 · Coffee With Developers

3:38 min

Connecting .NET to PostgreSQL with the Npgsql provider

Silvano Coriani Silvano Coriani · Europe 2026 Virtual

11:44 min

Live coding a test driven component feature

Markus Oberlehner · LIVE

Videos

See all

Related articles

See all