PostgreSQL Database Administrator - Parsippany, NJ

Qualifications
Mandatory Skills 10+ years relevant client experience in similar technology (does not include training period)
Including at least 5 years of on-site client experience in similar technology and domain –
Design and implementation of Postgres databases, high-availability solutions, replication, encryption, and disaster recovery solutions
Working experience with Postgres in AWS is must
2+ years of experience as a PostgreSQL DBA in an enterprise environment with 10+ years of overall DBA experience
Strong understanding of PostgreSQL architecture, administration, and tuning
Experience with backup recovery solutions such as pgBackRest, Barman, or similar tools
Expertise in performance tuning, query optimization, and indexing strategies
Hands-on experience with replication and high availability setups (e.g., Streaming Replication, Patroni, Pgpool-II, etc.)
Knowledge of Linux administration and shell scripting for database automation
Strong troubleshooting skills and ability to work under pressure
Excellent communication and collaboration skills
Must be local to New Jersey and available to work onsite
We are seeking an experienced PostgreSQL Database Administrator (DBA) to join our client's team in New Jersey
This role requires a local candidate who can work onsite and take ownership of the administration, optimization, and maintenance of PostgreSQL database environments
The ideal candidate will have expertise in database performance tuning, replication, backup recovery strategies, and high availability configurations
Responsibilities
Install, configure, and maintain PostgreSQL databases in on-premises and/or cloud environments
Monitor and optimize database performance, ensuring high availability and reliability
Implement backup, recovery, and disaster recovery strategies to prevent data loss
Manage database security, including user access controls, auditing, and encryption
Design and implement database replication, clustering, and high-availability solutions
Perform database migrations, upgrades, and patching as needed
Work closely with development teams to optimize SQL queries, indexing, and schema design
Automate database maintenance tasks using scripts and database tools
Troubleshoot database-related issues and resolve performance bottlenecks
Ensure compliance with data governance, security, and regulatory requirements
Job description
Skill/Experience/Education
• Mandatory Skills 10+ years relevant client experience in similar technology (does not include training period).
• Including at least 5 years of on-site client experience in similar technology and domain –
• Min Education - Bachelors degree in technology, Masters preferred
• Desired Skills : Administers, manages, and monitors all systems, including databases, in development, test, stage, and production environments.
• Design and implementation of Postgres databases, high-availability solutions, replication, encryption, and disaster recovery solutions.
• Working experience with Postgres in AWS is must.

Requirements:
• 2+ years of experience as a PostgreSQL DBA in an enterprise environment with 10+ years of overall DBA experience.
• Strong understanding of PostgreSQL architecture, administration, and tuning.
• Experience with backup recovery solutions such as pgBackRest, Barman, or similar tools.
• Expertise in performance tuning, query optimization, and indexing strategies.
• Hands-on experience with replication and high availability setups (e.g., Streaming Replication, Patroni, Pgpool-II, etc.).
• Knowledge of Linux administration and shell scripting for database automation.
• Familiarity with cloud-based PostgreSQL solutions (AWS RDS, Azure Database for PostgreSQL, or Google Cloud SQL) is a plus.
• Strong troubleshooting skills and ability to work under pressure.
• Excellent communication and collaboration skills.
• Must be local to New Jersey and available to work onsite.

Preferred Qualifications:
• Experience with database migration tools and strategies for PostgreSQL.
• Familiarity with NoSQL and other database technologies is a plus.
• Knowledge of DevOps practices, CI/CD pipelines, and Infrastructure as Code (IaC) is desirable.
• PostgreSQL certification is a plus.

We are seeking an experienced PostgreSQL Database Administrator (DBA) to join our client's team in New Jersey. This role requires a local candidate who can work onsite and take ownership of the administration, optimization, and maintenance of PostgreSQL database environments. The ideal candidate will have expertise in database performance tuning, replication, backup recovery strategies, and high availability configurations.

Responsibilities:
• Install, configure, and maintain PostgreSQL databases in on-premises and/or cloud environments.
• Monitor and optimize database performance, ensuring high availability and reliability.
• Implement backup, recovery, and disaster recovery strategies to prevent data loss.
• Manage database security, including user access controls, auditing, and encryption.
• Design and implement database replication, clustering, and high-availability solutions.
• Perform database migrations, upgrades, and patching as needed.
• Work closely with development teams to optimize SQL queries, indexing, and schema design.
• Automate database maintenance tasks using scripts and database tools.
• Troubleshoot database-related issues and resolve performance bottlenecks.
• Ensure compliance with data governance, security, and regulatory requirements. Read more