PostgreSQL DBA

N2P Systems is seeking an experienced PostgreSQL DBA 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 SQL and PL/pgSQL, Database Backup and Recovery and Linux/Unix Administration 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 manage and optimize enterprise database environments. This role focuses on maintaining database reliability, availability, performance, security, and data integrity across production systems. The ideal professional brings substantial hands-on PostgreSQL administration experience and can independently handle database operations, performance optimization, troubleshooting, and high-availability configurations.

This is a long-term contract opportunity requiring a full-time onsite presence in Jersey City, New Jersey, five days per week.

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.

• Continuously monitor database performance, availability, and operational health.

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

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

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

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

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

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

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

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

• Maintain production database environments and contribute to incident management activities.

• Ensure database systems remain reliable, scalable, and consistent while protecting data integrity.

Required Skills & Qualifications:

• Strong practical experience in PostgreSQL database administration.

• Sound understanding of PostgreSQL architecture and internal database operations.

• Hands-on expertise in SQL, PL/pgSQL, query optimization, and indexing techniques.

• Practical experience implementing database backup and recovery strategies.

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

• Demonstrated ability to monitor database performance and troubleshoot complex database issues.

• Experience administering Linux/Unix environments and writing shell scripts.

• Hands-on involvement in database upgrades and migration projects.

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

• Experience maintaining and supporting enterprise production databases.

• Seven or more years of professional experience is preferred.

• Availability to work onsite five days per week in Jersey City, NJ.

Preferred Qualifications:

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

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

• Experience working with containerization and orchestration technologies, particularly Docker and Kubernetes.

• Familiarity with database monitoring and observability tools such as Prometheus and Grafana.

• Experience developing database automation workflows and scripting solutions.