03 Sep
|
Darumatic
|
New South Wales
03 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