PostgreSQL Database Administrator

darumatic; Sydney; On-site; AUD 110,000 - 140,000; Full time

Job summary

A leading IT consultancy in Sydney is seeking an experienced Database Administrator to manage Clearing applications using Postgres and MS-SQL technologies. The ideal candidate will ensure the performance and availability of the database environments, contribute to disaster recovery processes, and work within a collaborative team. This role offers competitive rates and a hybrid work arrangement.

Qualifications

• Expert knowledge of Postgres database management.
• Extensive experience with database replication between different sites.
• Strong understanding of operational complexities within Postgres and MS-SQL environments.
• Strong implementation and support experience of SQL and Postgres (e.g .PGPool, PGBouncer, PEM, DRITA, Failover Manager, Data Adapters, Replication Server, Migration Toolkit).
• Must have a strong understanding of the architectural and operational complexities of solutions deployed within a Postgres and MS‑SQL environments.
• RAC,rman,ASM,DG broker,Performance analysis.
• High level Linux administration skills.
• Experience with OEM.
• Engineered systems experience (Exadata and ODA).
• PostgresSQL (locted on RHEL).
• Strong SQL PL / SQL skills.
• Migration from non-cdb to cdb.
• Configuration and support of TDE.
• Bash / Python scripting.

Responsibilities

• Manage database environments for Clearing applications and ensure performance.
• Monitor database for availability and proactively manage downtime.
• Develop and maintain runbooks for High Availability and Disaster Recovery.
• Proactively monitors database environment to ensure minimum downtime.
• Provides regular trend analysis to track database performance and throughput, for capacity planning purposes.
• Responsible for enhancements, maintenance and upgrades to the database environment.
• Works with business, architecture, development and technical colleagues to manage and implement changes.
• Carries out analysis of potential hardware problems prior to contacting third‑party support.
• Ensures all system and application changes are approved via the appropriate Change Control methods.
• Develop and maintain runbooks for High Availability and Disaster Recovery tests and is responsible for planning and running these tests.
• Handle the implementation of the bank clearing’s business applications running in development, test and production environments. This will include installation of applications, releases and patch management as well as upgrades.
• Work with the architecture team to provide technical expertise to define and implement a global infrastructure to support existing and future projects.
• Provide database expertise to the development team (internal and external) regarding development around database technology, covering deployment best practice and configuration for AAC Clearing applications.

Skills

Postgres Enterprise and/or Community knowledge

Red Hat Cluster experience

Experience with SQL and Postgres

High level Linux administration skills

Strong SQL PL/SQL skills

Bash/Python scripting

OEM

Exadata

Data replication

Migration toolkit

Tools

PGPool

PGBouncer

PEM

Migration Toolkit

Exadata

ODA

Replication Server

Migration Toolkit

Job description

Location : Sydney, NSW

Remote work available? Hybrid

Rate : Great rate on offer for a suitable candidate

About Us

Darumatic is an IT Consultancy and Recruitment Services Company that focuses on cloud native technologies and software development. Our mission is to help clients to "Build better software".

We are passionate about working with clients to transform their development and infrastructure teams to become cloud-native. Our supportive culture will open up a variety of opportunities for you to develop your knowledge and skills whilst providing opportunities to connect with a range of IT professional networks. We believe in mutually beneficial professional working relationships and your employment with us is no exception.

About the Role

Our client is currently seeking a Database Administrator to join our team. The primary role of the Database Administrator is managing database management of the Clearing applications utilising Postgres and / or MS‑SQL DB technologies including performing administration, configuration, installation, maintenance, tuning, and support of the database environments. This position will be within a team of existing DBAs that cover Postgres and SQLServer.

Responsibilities

• Responsible for ensuring availability and performance of the Clearing database environment.
• Manage non-production, production and disaster recovery database environments.
• Works closely with support team colleagues to ensure that the associated hardware resources for the database environment are configured for optimum performance and availability.
• Proactively monitors database environment to ensure minimum downtime.
• Provides regular trend analysis to track database performance and throughput, for capacity planning purposes.
• Responsible for enhancements, maintenance and upgrades to the database environment.
• Works with business, architecture, development and technical colleagues to manage and implement changes.
• Carries out analysis of potential hardware problems prior to contacting third‑party support.
• Ensures all system and application changes are approved via the appropriate Change Control methods.
• Develop and maintain runbooks for High Availability and Disaster Recovery tests and is responsible for planning and running these tests.
• Handle the implementation of the bank clearing’s business applications running in development, test and production environments. This will include installation of applications, releases and patch management as well as upgrades.
• Work with the architecture team to provide technical expertise to define and implement a global infrastructure to support existing and future projects.
• Provide database expertise to the development team (internal and external) regarding development around database technology, covering deployment best practice and configuration for AAC Clearing applications.

Skills & Experience

• Expert Postgres Enterprise and / or Community knowledge.
• Red Hat Cluster experience, preferred in use of Postgres Databases.
• Extensive experience implementing and supporting streaming replication between different sites.
• Strong implementation and support experience of SQL and Postgres (e.g .PGPool, PGBouncer, PEM, DRITA, Failover Manager, Data Adapters, Replication Server, Migration Toolkit).
• Must have a strong understanding of the architectural and operational complexities of solutions deployed within a Postgres and MS‑SQL environments.
• RAC,rman,ASM,DG broker,Performance analysis.
• High level Linux administration skills.
• Experience with OEM.
• Engineered systems experience (Exadata and ODA).
• PostgresSQL (locted on RHEL).
• Strong SQL PL / SQL skills.
• Migration from non-cdb to cdb.
• Configuration and support of TDE.
• Bash / Python scripting.