Database Administrator - PostGreSQL

Green Light; Ballarat; On-site; AUD 120,000 - 160,000; Full time

Job summary

Green Light Australia seeks a skilled Database Consultant (PostgreSQL) to maintain and optimise production databases from its Ballarat regional office. This permanent onsite role focuses on data integrity, performance, and reliability across production environments.

The successful candidate will design and implement PostgreSQL high availability, disaster recovery, replication, backups, and security, while enhancing data migration efforts and data lifecycle policies.

Qualifications

• 5–10 years’ experience in Enterprise Database Administration, Development, or Data Architecture.
• Experience migrating mission-critical databases from on-premises to the cloud.
• Strong PostgreSQL fundamentals and high availability / disaster recovery design.

Responsibilities

• Develop and execute data lifecycle policies and procedures.
• Ensure data currency, availability, and protection from loss.
• Apply data updates, backups, migrations, warehousing, replication, redundancy, and security.

Skills

PostgreSQL

Database Administration

Data Migration

High Availability

PostgreSQL Replication

UNIX/Linux

Security Management

Monitoring Tools

Tools

pg_dump

pg_restore

psql

pg_stat_statements

Job description

• PermanentOpportunity
• Immediate Start
• Ballarat offices, onsite role

Green Light Australia are looking to engage Database Consultant (PostgreSQL) to maintain and support production environments within our Database technologies division. The nominated Database Consultant (PostgreSQL) will require a minimum of five (5) years’ experience doing database administration, engineering and/or development of databases in production environments. As an experienced Database Consultant (PostgreSQL), you will be involved into data migration implementation with providing further indexing, recommendations and optimisation.

The role is unique as it is based in regional Victoria, and suited for individuals who are looking for a change in scenery and keen on the regional Victorian lifestyle.

Responsibilities:

• Develop and execute policies, practices and procedures that properly manage the full data lifecycle needs
• Ensure data currency, availability to users, and the protection of that data from loss
• Applying approved data updates, data protection (backups), availability, distribution, migration, warehousing, management, replication, redundancy, and security.

Requirements:

• 5-10 years’ experience in Enterprise Database Administration, Database Development/Engineering or Data Architecture/Engineering.
• Experience with Database migration techniques and experience migrating mission critical database platforms from on-premise data centres to the cloud
• Strong understanding of PostgreSQL database fundamentals
• Demonstrated ability to work in a complex organization to determine business and customer needs, providing the best solution to meet those needs
• Proven ability to design and implement PostgreSQL high availability and disaster recovery solutions
• Strong understanding of PostgreSQL streaming and logical replication & clustering
• Strong understanding of PostgreSQL database security management
• Experience with PostgreSQL tuning, and sizing ·
• Experience with PostgreSQL monitoring tools
• Experience with PostgreSQL backup and recovery
• Should have strong UNIX platform skills and understanding of network, storage, tiered application environments and security
• Experience in agile delivery methodologies

We are an Australian onshore services company that provides technology capability across ANZ and Asia. Our services range from day-to-day operational activities, through project delivery, to more strategic and transformational programs. At Green Light, we are committed to creating a diverse and inclusive workplace where everyone feels valued and respected. We are proud to be an equal opportunity employer and do not discriminate on the basis of race, religion, colour, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.

We encourage applications from all backgrounds and communities, and we are dedicated to providing a fair and accessible recruitment process for all candidates. During the recruitment process, if you require any accommodations or modifications please reach out to ***************@greenlightworldwide.com or call [phone].