Job Description

PostgreSQL Database Administrator (On-Prem)

6-Month Contract | Fully Remote (U.S.)

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.

What You’ll Do

• 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

Must-Have Qualifications

• Strong experience administering PostgreSQL in on-prem environments
• Candidates with only cloud-managed Postgres experience (RDS, Cloud SQL, etc.) will not be a fit
• 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)