Job Description
We are seeking a skilled and detail-oriented Database Administrator with strong hands-on experience in PostgreSQL to join our growing team. The ideal candidate will be responsible for maintaining the performance, integrity, and security of our databases, while also contributing to the planning and development processes to ensure data consistency and availability.
Key Responsibilities:
* Administer, maintain, and optimise PostgreSQL databases across development, testing, and production environments
* Monitor database performance and implement improvements to enhance efficiency and reliability
* Perform regular database backups and recovery, including disaster recovery planning
* Collaborate with developers and DevOps teams to design and implement database solutions
* Write and optimise complex SQL queries, stored procedures, and functions
* Ensure data security, integrity, and compliance with internal policies and external regulations
* Automate routine database tasks using scripting tools such as Bash or Python
* Troubleshoot and resolve database-related issues in a timely manner
* Contribute to database design and architecture discussions
Requirements:
* 3+ years of experience as a Database Administrator or in a similar role
* Strong hands-on experience with PostgreSQL in production environments
* Proficiency in writing and optimising SQL queries
* Experience with database monitoring and performance tuning tools
* Familiarity with Linux/Unix operating systems
* Understanding of database security best practices and data privacy regulations
* Experience with backup and recovery strategies
* Excellent problem-solving and communication skills
Benefits:
* A challenging and rewarding work environment
* Ongoing training and professional development opportunities
* A collaborative and supportive team culture
* The opportunity to work on a variety of projects and contribute to the growth and success of the organisation
Additional Requirements:
* Security Clearance
* This role requires Australian Citizenship. Candidates must either hold an active security clearance or be eligible to obtain one, as the role involves working with sensitive information.
* On-call and Shift Work
* As this is a managed services role, you may be required to:
o Work in shifts to provide ongoing support
o Be on call for urgent issues
o Perform some after-hours deployments