20 Nov
|
Ampstek
|
Australia
Role: PostgreSQL DBA
Experience: 5–8 Years
Job Summary
We are looking for an experienced PostgreSQL Database Administrator (DBA) responsible for managing, maintaining, optimizing, and securing PostgreSQL database settings. The candidate should have strong expertise in database administration, performance tuning, backup and recovery, high availability, and troubleshooting.
Key Responsibilities
Install, configure, upgrade, and maintain PostgreSQL database servers.
Perform database monitoring, performance tuning, and query optimization.
Manage database backup, restoration, and disaster recovery activities.
Implement and maintain high availability (HA) and replication solutions.
Monitor database health, capacity, availability, and performance.
Identify and troubleshoot database-related issues and performance bottlenecks.
Manage database security, user roles,
permissions, and access controls.
Perform database migrations, upgrades, patching, and maintenance.
Optimize SQL queries, indexes, stored procedures, and database objects.
Work closely with application developers, infrastructure, and DevOps teams.
Mandatory Skills
Robust hands-on experience in PostgreSQL Database Administration.
Expertise in PostgreSQL installation, configuration, and maintenance.
Solid knowledge of SQL, PL/pgSQL, query optimization, and indexing.
Experience with database backup and recovery (PITR).
Knowledge of PostgreSQL replication and high availability.
Experience in performance monitoring and troubleshooting.
📌 Postgresql Database Administrator Sydney (Australia)
🏢 Ampstek
📍 Australia