Job Description
PostgreSQL DBA Experienced Postgres Database Administrator to manage, maintain, and optimize PostgreSQL environments across on-premises and cloud platforms. The ideal candidate will have a strong understanding of PostgreSQL architecture, clustering technologies, and migration strategies, along with hands-on experience in performance tuning, backup/recovery, and disaster recovery procedures.
Key Responsibilities:
Database Administration:
Install, configure, and maintain PostgreSQL databases in production and non-production environments. Perform database refresh activities between environments as required. Execute patching and upgrade activities to ensure databases remain secure, stable, and up to date. Architecture & Performance:
Demonstrate a good understanding of PostgreSQL database architecture, including memory management, indexing, and query optimization. Handle performance issues by analyzing query execution plans, tuning configurations, and implementing best practices. High Availability & Clustering:
Implement and manage repmgr cluster technology for high availability and failover. Troubleshoot and resolve cluster node failure issues promptly to minimize downtime. Migration & Cloud Integration:
Design and execute migration strategies from on-prem to cloud environments. Knowledge of Google Cloud Platform (GCP) or Microsoft Azure for database hosting and services is a plus. Backup & Recovery:
Proficient in Database Backup, Recovery, and Disaster Recovery procedures, ensuring data integrity and business continuity. Implement logical and physical backup strategies using native PostgreSQL tools and third-party solutions. Replication:
Configure and manage logical replication for data synchronization across environments. Required Skills & Qualifications:
Proven experience as a Postgres Database Administrator in enterprise environments. Strong knowledge of PostgreSQL architecture, including WAL, MVCC, and vacuum processes. Hands-on experience with repmgr clustering, failover handling, and node recovery. Expertise in performance tuning, query optimization, and troubleshooting. Experience with migration strategies from on-premises to cloud platforms. Familiarity with Oracle DBA, RMAN, Goldengate, Exadata. Proficiency in backup, recovery, and disaster recovery planning. Working knowledge of logical replication and streaming replication. Excellent problem-solving and communication skills. Preferred Qualifications:
Experience with automation tools (Ansible, Terraform) for database deployments. Knowledge of monitoring tools like pgAdmin, Prometheus, or Grafana. Scripting skills in Shell, Python, or similar for automation. Salary Range•$95,000•100,000 a year #LI-SP3 #LI-VX1 PostgreSQL DBA Experienced Postgres Database Administrator to manage, maintain, and optimize PostgreSQL environments across on-premises and cloud platforms. The ideal candidate will have a strong understanding of PostgreSQL architecture, clustering technologies, and migration strategies, along with hands-on experience in performance tuning, backup/recovery, and disaster recovery procedures. Key Responsibilities:
Database Administration:
Install, configure, and maintain PostgreSQL databases in production and non-production environments. Perform database refresh activities between environments as required. Execute patching and upgrade activities to ensure databases remain secure, stable, and up to date. Architecture & Performance:
Demonstrate a good understanding of PostgreSQL database architecture, including memory management, indexing, and query optimization. Handle performance issues by analyzing query execution plans, tuning configurations, and implementing best practices. High Availability & Clustering:
Implement and manage repmgr cluster technology for high availability and failover. Troubleshoot and resolve cluster node failure issues promptly to minimize downtime. Migration & Cloud Integration:
Design and execute migration strategies from on-prem to cloud environments. Knowledge of Google Cloud Platform (GCP) or Microsoft Azure for database hosting and services is a plus. Backup & Recovery:
Proficient in Database Backup, Recovery, and Disaster Recovery procedures, ensuring data integrity and business continuity. Implement logical and physical backup strategies using native PostgreSQL tools and third-party solutions. Replication:
Configure and manage logical replication for data synchronization across environments. Required Skills & Qualifications:
Proven experience as a Postgres Database Administrator in enterprise environments. Strong knowledge of PostgreSQL architecture, including WAL, MVCC, and vacuum processes. Hands-on experience with repmgr clustering, failover handling, and node recovery. Expertise in performance tuning, query optimization, and troubleshooting. Experience with migration strategies from on-premises to cloud platforms. Familiarity with Oracle DBA, RMAN, Goldengate, Exadata. Proficiency in backup, recovery, and disaster recovery planning. Working knowledge of logical replication and streaming replication. Excellent problem-solving and communication skills. Preferred Qualifications:
Experience with automation tools (Ansible, Terraform) for database deployments. Knowledge of monitoring tools like pgAdmin, Prometheus, or Grafana. Scripting skills in Shell, Python, or similar for automation. Salary Range•$95,000•100,000 a year #LI-SP3 #LI-VX1 Location Mount Laurel, NJ Job Function TECHNOLOGY
Role Engineer Job Id 416180 Desired Skills Postgresql DBA Salary Range $95,000•100,000 a year