15 Sep
|
Boltin
|
New South Wales
15 Sep
Boltin
New South Wales
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
Strong 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
Robust 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 ***** 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