02 Sep
|
Darumatic
|
New South Wales
02 Sep
Darumatic
New South Wales
Job Description
Location : Sydney, NSW
n
Remote work available? Hybrid
n
Rate : Great rate on offer for a suitable candidate
n
About Us
n
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".
n
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.
n
About the Role
n
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.
n
Responsibilities
n
n
Responsible for ensuring availability and performance of the Clearing database environment.
n
Manage non-production, production and disaster recovery database environments.
n
Works closely with support team colleagues to ensure that the associated hardware resources for the database environment are configured for optimum performance and availability.
n
Proactively monitors database environment to ensure minimum downtime.
n
Provides regular trend analysis to track database performance and throughput, for capacity planning purposes.
n
Responsible for enhancements, maintenance and upgrades to the database environment.
n
Works with business, architecture,
development and technical colleagues to manage and implement changes.
n
Carries out analysis of potential hardware problems prior to contacting third‐party support.
n
Ensures all system and application changes are approved via the appropriate Change Control methods.
n
Develop and maintain runbooks for High Availability and Disaster Recovery tests and is responsible for planning and running these tests.
n
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.
n
Work with the architecture team to provide technical expertise to define and implement a global infrastructure to support existing and future projects.
n
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.
n
n
Skills & Experience
n
n
Expert Postgres Enterprise and / or Community knowledge.
n
Red Hat Cluster experience, preferred in use of Postgres Databases.
n
Extensive experience implementing and supporting streaming replication between different sites.
n
Strong implementation and support experience of SQL and Postgres (e.g .PGPool, PGBouncer, PEM, DRITA, Failover Manager, Data Adapters, Replication Server, Migration Toolkit).
n
Must have a strong understanding of the architectural and operational complexities of solutions deployed within a Postgres and MS‐SQL environments.
n
RAC,rman,ASM,DG broker,Performance analysis.
n
High level Linux administration skills.
n
Experience with OEM.
n
Engineered systems experience (Exadata and ODA).
n
PostgresSQL (locted on RHEL).
n
Robust SQL PL / SQL skills.
n
Migration from non-cdb to cdb.
n
Configuration and support of TDE.
n
Bash / Python scripting.
n
📌 Postgresql Database Administrator (New South Wales)
🏢 Darumatic
📍 New South Wales