Cassandra DBA

N2P Systems; Jersey City (NJ); Sur place; USD 120 000 - 180 000; Plein temps

Résumé du poste

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.

Responsabilités

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

Connaissances

PostgreSQL administration

SQL/PLpgSQL

Backup and recovery

Replication/HA

Linux scripting

Query optimization

Monitoring

Upgrades/migrations

Security/access mgmt

Outils

pgAdmin

Patroni

PgBouncer

pgBackRest

Description du poste

We are seeking an experienced PostgreSQL Database Administrator (DBA) to manage, maintain, and optimize enterprise PostgreSQL database environments. The ideal candidate will have strong hands‑on experience in database administration, performance tuning, troubleshooting, backup and recovery, and high availability.

Key Responsibilities

• Install, configure, administer, and maintain PostgreSQL databases.
• Monitor database performance, availability, and overall health.
• Perform SQL query optimization, indexing, and performance tuning.
• Manage database backups, recovery, replication, and disaster recovery.
• Configure and maintain PostgreSQL streaming replication and high availability.
• Troubleshoot database issues and resolve performance bottlenecks.
• Perform database upgrades, patching, and migrations.
• Manage database users, roles, permissions, and security.
• Monitor database capacity, storage utilization, and resource consumption.
• Work closely with application development, infrastructure, and DevOps teams.
• Support production environments and participate in incident management.
• Ensure database reliability, scalability, and data integrity.

Mandatory Skills

• Strong hands‑on experience with PostgreSQL database administration.
• Good understanding of PostgreSQL architecture and database internals.
• Expertise in SQL, PL/pgSQL, query optimization, and indexing.
• Experience with backup and recovery strategies.
• Knowledge of replication, clustering, and high availability.
• Strong database performance monitoring and troubleshooting skills.
• Experience with Linux/Unix administration and shell scripting.
• Experience with database upgrades and migrations.
• Knowledge of database security and access management.

Preferred Skills

• Experience with PostgreSQL tools such as pgAdmin, Patroni, PgBouncer, and pgBackRest.
• Exposure to AWS, Azure, or other cloud platforms.
• Experience with Docker and Kubernetes.
• Knowledge of monitoring tools such as Prometheus and Grafana.
• Experience with database automation and scripting.
• Strong problem‑solving and communication skills.