Oracle DBA (Golden Gate knowledge)

Unison Consulting Pte Ltd; Singapore; On-site; SGD 70,000 - 100,000; Full time

Job summary

A leading consulting firm in Singapore is seeking an experienced Oracle DBA to manage database installations, configurations, and optimizations. You will oversee Oracle GoldenGate implementations for real-time data replication, ensuring minimal downtime and high availability. Ideal candidates should possess strong troubleshooting skills and experience in database performance tuning. This role offers a long-term contract.

Qualifications

• Experience in managing Oracle databases in production, development, and testing environments.
• Proficient in Oracle GoldenGate implementation and management.
• Ability to troubleshoot performance issues and implement tuning strategies.

Responsibilities

• Install, configure, upgrade, and maintain Oracle databases.
• Manage Oracle GoldenGate implementations for real-time data replication.
• Provide 24/7 on-call support for database issues.

Skills

Oracle DBA

Oracle GoldenGate

Database performance tuning

Data synchronization

Disaster recovery

Job description

Role : Oracle DBA (Golden Gate)

Location : Singapore

Duration : Long term contract

Job Scope

• Install, configure, upgrade, and maintain Oracle databases across production, development, and testing environments to ensure high availability and optimal performance.
• Manage Oracle GoldenGate implementations for real-time replication, data synchronization, and disaster recovery across heterogeneous environments.
• Design, monitor, and optimize replication processes, ensuring minimal latency and seamless data flow between source and target systems.
• Perform database backup, recovery, patching, and security administration in alignment with organizational policies and industry best practices.
• Proactively monitor database health, troubleshoot performance issues, and implement tuning strategies for SQL queries, indexes, and replication processes.
• Develop and maintain database documentation, including architecture diagrams, replication topologies, and operational procedures.
• Collaborate with application developers, system administrators, and business stakeholders to support database design, deployments, and upgrades.
• Conduct capacity planning, implement database partitioning strategies, and optimize storage management to ensure scalability.
• Ensure compliance with data governance, security standards, and regulatory requirements while safeguarding sensitive information.
• Provide 24/7 on-call support for critical database and replication issues, ensuring minimal downtime and maximum business continuity.