This description is a summary of our understanding of the job description. Click on 'Apply' button to find out more.

Role Description

We are seeking an experienced PostgreSQL Database Administrator to support application development teams in a heavily on-prem, command-line–driven environment. This role is hands-on and operations-focused, with a strong emphasis on ticket-based support, PostgreSQL administration, and major version upgrades from PostgreSQL 9 to PostgreSQL 16. This is not a cloud-only DBA role. Candidates must be comfortable working directly on Linux systems and managing PostgreSQL in traditional on-prem environments.

• Provide day-to-day PostgreSQL DBA support for internal application development teams
• Manage and resolve incoming tickets related to PostgreSQL environments
• Perform major PostgreSQL upgrades (PostgreSQL 9 → 16), including planning, execution, and validation
• Administer PostgreSQL databases in on-prem environments using the command line
• Handle all core DBA responsibilities:
  • Backups and restores
  • Performance tuning and query optimization
  • Vacuuming and routine maintenance
  • Patching and upgrades
  • Migrations and data movement
• Write, review, and troubleshoot SQL, DDL, and DML
• Communicate clearly with stakeholders and close the loop on tickets and requests
• Work independently once requirements and instructions are provided

Qualifications

• Strong experience administering PostgreSQL in on-prem environments
• Deep understanding of PostgreSQL internals and operational best practices
• Hands-on experience with:
  • Backups and restores
  • Performance tuning
  • Vacuuming and maintenance
  • Upgrades and migrations
• Strong ability to write and interpret SQL, including DDL and DML
• Comfortable working in a Linux command-line environment
• Professional, reliable, and responsive
• Follows instructions
• Works independently
• Communicates clearly and closes tickets effectively

Nice-to-Have Qualifications

• Experience with YAML and/or Puppet
• Shell or Bash scripting experience
• Prior experience upgrading PostgreSQL from older major versions to current releases
• Exposure to cloud platforms such as AWS or GCP (not required)