Job Description

Core Skills and Experience

n

n
- 10+ years of database administration and engineering experience.
n
- 5+ years of advanced PostgreSQL administration in enterprise environments.
n
- Deep expertise in:
n
- Performance tuning and optimisation
n
- Replication technologies
n
- High Availability and Disaster Recovery
n
- Backup and Recovery
n
- Partitioning and indexing strategies
n
- Security and encryption
n
- Capacity planning
n
- Robust understanding of physical database design and data modelling.
n
- Experience supporting transactional databases, data warehouses, and analytical platforms.
n
- Ability to assess and implement database architecture improvements.
n
- Knowledge of database lifecycle management and governance.
n

n

Automation & DevOps

n

n
- Experience automating database administration activities.
n
- Strong scripting skills using Bash, Python, PowerShell, or similar.
n
- Experience with Infrastructure as Code and configuration management tools.
n
- Familiarity with CI/CD pipelines and release automation.
n

n

Required Technical Skills

n

n
- SQL Performance Tuning
n
- Database Security
n
- High Availability & Disaster Recovery
n
- Shell Scripting
n
- Python or PowerShell
n
- Monitoring & Observability Tools
n
- Backup & Recovery Solutions
n
- Database Automation Frameworks
n
- Oracle Administration
n
- Microsoft SQL Server Administration
n
- Terraform
n
- Design and implement PostgreSQL database architectures aligned with enterprise standards.
n
- Deliver database upgrades, migrations, consolidations, and modernisation initiatives.
n
- Implement High Availability (HA), Disaster Recovery (DR), replication, backup, and recovery solutions.
n
- Produce architecture, design, and operational documentation.
n

n

Automation & DevOps Enablement

n

n




- Develop and implement automation for:
n
- Patching and upgrades
n
- Backup and recovery
n
- Monitoring and alerting
n
- Establish CI/CD practices for database deployments where applicable.
n
- Reduce manual operational effort through automation and process standardisation.
n

n

Operational Excellence

n

n
- Define and implement database operational standards, governance models, and best practices.
n
- Review and improve incident, problem, change, and release management processes related to database services.
n
- Establish operational runbooks and support procedures.
n
- Support critical incidents and provide root cause analysis (RCA) reports for major issues.
n

n

Team Capability Uplift (Key Deliverable)

n

n
- Develop and execute a structured DBA capability uplift program for a team of 20-25 DBAs.
n
- Create PostgreSQL training materials, operational guides, and knowledge repositories.
n
- Conduct workshops, mentoring sessions, and hands-on coaching.
n
- Establish PostgreSQL Administration Standards and DBA Best Practice Guides.
n
- Deliver measurable improvement in team capability and independence in managing PostgreSQL environments.
n

n

Governance & Stakeholder Reporting

n

n
- Provide technical leadership across project and operational initiatives.
n
- Prepare executive-level status reports, risk assessments, and recommendations.
n
- Participate in architecture reviews and technical governance forums.
n
- Provide regular reporting on platform health, capacity, risks, and improvement initiatives.
n

n

Knowledge Transfer & Handover

n

n
- Produce comprehensive technical and operational documentation.
n
- Deliver knowledge transfer sessions to internal teams.
n
- Ensure sustainable operational support capability is established before completion of the engagement.
n

📌 Database Engineer (New South Wales)
🏢 Boltin
📍 New South Wales