Sydney, NSW
- Work Type: Contract
**Location: Sydney, NSW**
**Remote work available?** Hybrid-
**Contract Length**: Minimum of 12 months**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**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.
- Develop and maintain runbooks for High Availability and Disaster Recovery tests and is responsible for planning and running these tests.
- Work with the architecture team to provide technical expertise to define and implement a global infrastructure to support existing and future projects.
**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
- Capacity management
- Automation Experience
**Essential Requirements**:
- Expert SQL/Postgres DBA (minimum 8 year's experience)