PostgreSQL Database Administrator

N2P Systems is seeking an experienced PostgreSQL Database Administrator to join our enterprise technology delivery team in Jersey City, NJ, USA. At N2P Systems, you will put 5-8 years of hands-on experience with PostgreSQL Architecture, Database Internals and SQL to work on mission-critical enterprise systems. This is an existing contract, on-site vacancy with N2P Systems.

N2P Systems is seeking an experienced PostgreSQL Database Administrator to oversee the administration, maintenance, performance, and reliability of enterprise database environments. This role focuses on PostgreSQL database architecture, optimization, high availability, disaster recovery, and production database operations. The ideal professional will bring strong practical expertise in maintaining secure, scalable, and highly available database infrastructure.

This is a long-term contract opportunity requiring an on-site presence five days per week in Jersey City, New Jersey.

N2P Systems uses AI to help screen and assess applications for this role. N2P Systems is an enterprise technology consulting and digital solutions firm operating across Canada, the United States and India.

Key Responsibilities:

• Install, configure, administer, and maintain PostgreSQL database environments.

• Monitor database health, availability, resource utilization, and overall performance.

• Optimize SQL queries, implement indexing strategies, and improve database performance.

• Develop and maintain database backup, recovery, replication, and disaster recovery processes.

• Configure and manage PostgreSQL streaming replication and high-availability environments.

• Investigate database incidents, troubleshoot technical issues, and eliminate performance bottlenecks.

• Execute database upgrades, security patches, and migration activities.

• Administer database accounts, roles, permissions, and access controls.

• Track database capacity, storage consumption, and infrastructure resource utilization.

• Collaborate with application development, infrastructure, and DevOps teams on database-related activities.

• Maintain production database environments and participate in incident management.

• Ensure database consistency, reliability, scalability, and data integrity.

Required Skills & Qualifications:

• Strong hands-on experience in PostgreSQL database administration.

• Solid understanding of PostgreSQL architecture and internal database mechanisms.

• Practical expertise in SQL, PL/pgSQL, query optimization, and indexing.

• Experience implementing database backup and recovery strategies.

• Working knowledge of database replication, clustering, and high-availability configurations.

• Experience monitoring database performance and troubleshooting complex database issues.

• Hands-on experience with Linux/Unix administration and shell scripting.

• Experience performing database upgrades, patching, and migrations.

• Understanding of database security, user administration, and access management.

• Demonstrated experience supporting production database environments.

Preferred Qualifications:

• Familiarity with PostgreSQL administration and performance tools, including pgAdmin, Patroni, PgBouncer, and pgBackRest.

• Exposure to cloud infrastructure platforms such as AWS, Azure, or equivalent cloud environments.

• Experience working with Docker and Kubernetes.

• Familiarity with database monitoring solutions such as Prometheus and Grafana.

• Exposure to database automation and scripting practices.

• Strong problem-solving and communication capabilities.