PostgreSQL Database Admin

Prophecy Technologies

$100K — $130K *
Information Technology
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • Minimum 7+ years of hands-on PostgreSQL DBA experience
  • PostgreSQL as the primary area of expertise
  • Strong knowledge in PostgreSQL Architecture and Internals
  • Experience with Backup and Recovery processes
  • Skilled in Performance Tuning and Query Optimization
  • Proven capabilities in Production Troubleshooting and Root Cause Analysis
  • Familiarity with High Availability and Disaster Recovery solutions

Responsibilities

  • Manage PostgreSQL architecture and configuration for optimal performance
  • Conduct routine backup and recovery operations
  • Tune database performance and optimize queries
  • Troubleshoot production incidents and perform root cause analysis
  • Administer PostgreSQL patching, upgrades, and migrations
  • Implement and maintain high availability setups
  • Automate and streamline operational support tasks

Benefits

  • Flexible work arrangements
  • Professional development opportunities
  • Access to advanced technologies
  • Supportive work culture
  • Comprehensive health benefits
Full Job Description
Job Description:

Mandatory Requirements:
• Minimum 7+ years of primary, hands-on PostgreSQL DBA experience
• PostgreSQL must be the candidate's core skill and primary area of expertise
• Strong experience in:
• PostgreSQL Architecture and Internals
• Backup and Recovery
• Performance Tuning and Query Optimization
• Production Troubleshooting and Root Cause Analysis
• PostgreSQL Patching, Upgrades, and Migrations
  • High Availability and Disaster Recovery solutions
  • Solid experience in BSR, PGD/BDR, Barman, PEM, patching, upgrades, and production support
  • Strong enterprise-level PostgreSQL Infrastructure Administration experience


Mandatory Technology Experience:
• Hands-on experience with both BSR (Streaming Replication) and PGD/BDR clusters
• Strong experience with Barman backup administration and recovery procedures
• Good working knowledge of PEM for monitoring and database administration
• Proven experience performing major/minor version upgrades, patching activities, and cluster maintenance
• Experience handling production incidents, failovers, replication issues, and cluster synchronization issues

Infrastructure & Operational Experience:
• Strong Linux administration skills
• Experience supporting large-scale production PostgreSQL environments
• Operational support experience, including change management, maintenance activities, and automation
• Scripting experience (Shell/Python preferred)

Similar Jobs

More Jobs at Prophecy Technologies

More Information Technology Jobs

Find similar PostgreSQL Database Admin jobs: