Company

Xpt SoftwareSee more

addressAddressSydney, NSW
CategoryAdministrative

Job description

Job Description:

As an Oracle GoldenGate Database Administrator, you will be responsible for ensuring the integrity, availability, and performance of our databases that utilize Oracle GoldenGate technology. You will play a critical role in designing, implementing, and maintaining database replication solutions to meet our business needs.

We would be using OGG for real time data replication between two disparate systems.

Key Responsibilities:

DBA with hands on experience using Oracle Golden Gate.

Experience with using the Oracle Golden Gate Microservices Architecture

Experience with installing the Oracle Golden Gate Microservices Architecture

Experience with using Oracle Golden Gate to transform CDC transaction into a JSON Canonical Message Model and vice versa

Experience with using Golden Gate Adapters such as the JMS Adapter and the Big Data Adapter

Experience with Extract/Load/Transform capabilities within Oracle Golden Gate

Develop/configure/test GG Veridata for the functional data verification between Oracle-MSSQL.

Collaboration with the data modeller and transforming the CDC by introducing the business rules into the GG code.

Install, configure, and maintain Oracle GoldenGate software across multiple environments (development, testing, production).

Design and implement database replication solutions using Oracle GoldenGate to ensure high availability, disaster recovery, and data integration.

Monitor and optimize the performance of GoldenGate replication processes, including troubleshooting and resolving issues as they arise.

Work closely with cross-functional teams to gather requirements and provide technical expertise in designing and implementing database solutions.

Develop and maintain documentation related to GoldenGate configurations, processes, and procedures.

Perform regular backups, restores, and recovery procedures to ensure data integrity and availability.

Implement and enforce security best practices to protect sensitive data within the GoldenGate environment.

Stay up-to-date with the latest Oracle GoldenGate features, patches, and upgrades, and make recommendations for their implementation.

Qualifications:

Minimum of 15+ years of experience working as an Oracle Database Administrator with a focus on GoldenGate.

In-depth knowledge of Oracle GoldenGate architecture, configuration, and troubleshooting.

Strong understanding of database concepts and principles, including replication, high availability, and disaster recovery.

Proficiency in SQL and scripting languages (e.g., Shell, Python) for automation and monitoring tasks.

Excellent problem-solving skills and attention to detail.

Strong communication and interpersonal skills, with the ability to work effectively in a team environment.

Refer code: 2244579. Xpt Software - The previous day - 2024-05-23 03:45

Xpt Software

Sydney, NSW
Jobs feed

Amazon Delivery Driver

Amazon Flex

Armadale, WA

Medical Laboratory Scientist - Research Assistant

Nsw Health Pathology

Sydney, NSW

Safety & Compliance Officer - Goondiwindi

National Heavy Vehicle Regulator

Goondiwindi, QLD

Research Assistant - EECS, Faculty of EAIT

The University Of Queensland

Queensland

Coordinator

Bunnings Warehouse

Mount Isa, QLD

Maintenance Team Leader - Residential Aged Care

Baptistcare Nsw & Act

Point Clare, NSW

Airport Services Officer

Shire Of Wyndham East Kimberley

Broome, WA

Warehousing Assistant

Flexiforce Australia

Goulburn, NSW

Sheet Metal Fabricator

Hays Recruitment

Parramatta, NSW

Sales Representative

Conquest Personnel

Altona, VIC

Share jobs with friends

Related jobs

Oracle Golden Gate Database Administrator

Oracle Database Administrator (DBA)

Amadeus

Sydney, NSW

a week ago - seen

Oracle Database Administrator

Boundary Consulting Pty Ltd

Haymarket, NSW

a week ago - seen

Oracle Database Administrator with Goldengate

Xpt Software

Sydney, NSW

a week ago - seen

Oracle GoldenGate Database Administrator

Manvision Consulting

North Sydney, NSW

3 weeks ago - seen

Oracle GoldenGate Database Administrator (DBA)

Ayan Infotech

Sydney, NSW

2 months ago - seen

Oracle GoldenGate Database Administrator (DBA)

Ayan Infotech

$550-580 per day

Sydney, NSW

2 months ago - seen

Oracle Database Administrator

Cotalent

Sydney, NSW

3 months ago - seen

Oracle Database Administrator

Cotalent

Permanent

Sydney, NSW

3 months ago - seen

Senior oracle database administrator

Ehealth Nsw

Chatswood, NSW

3 months ago - seen

Database Administrator Oracle / SQL

Osborne Richardson

$81 - $86 an hour

Canterbury, NSW

3 months ago - seen

Senior Oracle Database Administrator

Nsw Health

Contract

Chatswood, NSW

4 months ago - seen

Senior Oracle Database Administrator

Nsw Government

$124,152-140,163 per year

Sydney, NSW

4 months ago - seen

Database Administrator 3-IT

Oracle

North Ryde, NSW

4 months ago - seen

Oracle Database Administrator

Talent International

Sydney, NSW

5 months ago - seen