Senior PostgreSQL DBA: Performance, HA & Migrations

N2P Systems; Jersey City (NJ); On-site; USD 120,000 - 180,000; Full time

Job summary

N2P Systems in Jersey City, NJ is seeking an experienced PostgreSQL Database Administrator to manage enterprise PostgreSQL environments, optimize performance, and ensure data integrity.

You will handle backups, replication, high availability, migrations, and work with DevOps and development teams. Strong SQL/PLpgSQL skills and Linux scripting required; familiarity with Patroni, PgBouncer, pgBackRest a plus.

Qualifications

• Hands-on PostgreSQL database administration experience.
• Strong knowledge of PostgreSQL architecture and internals.
• Expertise in SQL, PL/pgSQL, query optimization, and indexing.
• Experience with backup and recovery strategies.
• Knowledge of replication, clustering, and high availability.
• Data center operations: performance monitoring and troubleshooting.
• Experience with Linux/Unix administration and shell scripting.
• Experience with upgrades and migrations.
• Knowledge of database security and access management.

Responsibilities

• Install, configure, administer, and maintain PostgreSQL databases.
• Monitor performance, availability, and health.
• Perform SQL optimization and indexing for performance.
• Manage backups, recovery, replication, and DR.
• Configure streaming replication and high availability.
• Troubleshoot issues and resolve bottlenecks.
• Perform upgrades, patching, and migrations.
• Manage users, roles, permissions, and security.
• Monitor capacity, storage, and resource usage.
• Collaborate with development, infra, and DevOps teams.
• Support production environments and incident management.
• Ensure reliability, scalability, and data integrity.

Skills

PostgreSQL administration

SQL/PLpgSQL

Backup and recovery

Replication/HA

Linux scripting

Query optimization

Monitoring

Upgrades/migrations

Security/access mgmt

Tools

pgAdmin

Patroni

PgBouncer

pgBackRest

Job description

N2P Systems in Jersey City, NJ is seeking an experienced PostgreSQL Database Administrator to manage enterprise PostgreSQL environments, optimize performance, and ensure data integrity.

You will handle backups, replication, high availability, migrations, and work with DevOps and development teams. Strong SQL/PLpgSQL skills and Linux scripting required; familiarity with Patroni, PgBouncer, pgBackRest a plus.