Postgres DBA
3 weeks ago
Job Description-
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 Google Cloud or Azure database services.
- 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.
#J-18808-Ljbffr
