22 Nov
|
Ampstek
|
Sydney
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.
- Solid 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.
📌 Senior PostgreSQL DBA (Sydney)
🏢 Ampstek
📍 Sydney