Senior PostgreSQL DBA

Ampstek

Sydney

On-site

AUD 120,000 - 180,000

Full time

19 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Ampstek is seeking two experienced Senior PostgreSQL Database Administrators to provide advanced-level database support, administration, troubleshooting, performance tuning and maintenance of PostgreSQL environments.

Ideal candidates will have hands-on experience managing enterprise PostgreSQL databases, handling production issues, performing RCA, and ensuring database availability, security and reliability across environments.

Qualifications

  • Hands-on PostgreSQL DBA with enterprise experience.
  • Experience with performance tuning and query optimization.
  • Experience with backup, PITR, and recovery procedures.
  • Experience with replication, HA, and failover configurations.
  • Experience in production troubleshooting and L2/L3 support.
  • Monitoring, maintenance, and capacity planning for PostgreSQL.
  • Strong Linux/Unix experience.

Responsibilities

  • Provide advanced L2/L3 PostgreSQL support.
  • Install, configure, upgrade, patch, and maintain PostgreSQL databases.
  • Tune performance, optimize queries, and troubleshoot.
  • Monitor health, availability, capacity, and performance.
  • Manage backups, recovery, and DR procedures.
  • Tackle RCA for complex production incidents.
  • Manage replication, HA, and failover configurations.
  • Handle security, access control, roles, and permissions.
  • Coordinate with apps, infra, and engineering teams.

Skills

PostgreSQL DBA
Performance tuning
SQL & PL/pgSQL
Backup & PITR
Replication & HA
L2/L3 support
Monitoring & capacity
Linux/Unix

Job description

We are looking for two experienced Senior PostgreSQL Database Administrators to provide advanced-level database support, administration, troubleshooting, performance tuning, and maintenance of PostgreSQL database environments.

The ideal candidates should have strong hands-on experience managing enterprise PostgreSQL databases, handling complex production issues, performing root cause analysis, and ensuring database availability, performance, security, and reliability.

Key Responsibilities:
  • Provide advanced-level (L2/L3) support for PostgreSQL database environments.
  • Install, configure, upgrade, patch, and maintain PostgreSQL databases.
  • Perform database performance tuning, query optimization, and troubleshooting.
  • Monitor database health, availability, capacity, and performance.
  • Manage database backups, recovery, and disaster recovery procedures.
  • Troubleshoot complex database issues and perform root cause analysis (RCA).
  • Manage replication, high availability (HA), and failover configurations.
  • Handle database security, user access management, roles, and permissions.
  • Perform database migrations, upgrades, and schema changes.
  • Monitor and resolve production incidents within agreed SLAs.
  • Work closely with application, infrastructure, and engineering teams.
Mandatory Technical Skills
  • Advanced hands-on experience with PostgreSQL Database Administration.
  • Strong experience in PostgreSQL performance tuning and query optimization.
  • Expertise in SQL, PL/pgSQL, indexing, and execution plans.
  • Experience in backup and recovery (PITR).
  • PostgreSQL replication and high availability.
  • Experience in production database troubleshooting and L2/L3 support.
  • Database monitoring, maintenance, and capacity planning.
  • Strong experience in Linux/Unix environments.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior PostgreSQL DBA | Performance Tuning & HA Expert
Senior PostgreSQL DBA | Performance Tuning & HA Expert

Ampstek • Sydney

On-site
AUD 120,000 - 180,000
Lead PostgreSQL DBA – High-Availability & Migration Expert
Lead PostgreSQL DBA – High-Availability & Migration Expert

Showtime Consulting • Australia

On-site
AUD 120,000 - 150,000
PostgreSQL Database Administrator
PostgreSQL Database Administrator

Showtime Consulting • Australia

On-site
AUD 120,000 - 150,000
Senior Database Reliability Engineer (PostgreSQL)
Senior Database Reliability Engineer (PostgreSQL)

Arctic Fox • Canberra

On-site
AUD 176,000 - 251,000
Senior Database Administrator - PostgreSQL & Enterprise DBMS
Senior Database Administrator - PostgreSQL & Enterprise DBMS

Unisys • Melbourne

On-site
AUD 110,000 - 140,000
Database Engineer
Database Engineer

NTT DATA, Inc. • Brisbane

On-site
AUD 110,000 - 140,000
Senior PostgreSQL Database Administrator - Government
Senior PostgreSQL Database Administrator - Government

APG Workforce • Sydney

Hybrid
AUD 152,000 - 207,000
Senior PostgreSQL & Database Infrastructure Engineer (Hybrid)
Senior PostgreSQL & Database Infrastructure Engineer (Hybrid)

APG Workforce • Sydney

Hybrid
AUD 152,000 - 207,000
Database Administrator Experts
Database Administrator Experts

Exclaim IT • Canberra

On-site
AUD 120,000 - 165,000
Senior PostgreSQL DBA — HA, Security & GitOps
Senior PostgreSQL DBA — HA, Security & GitOps

Exclaim IT • Canberra

On-site
AUD 120,000 - 165,000
Top locations