Oracle Database Administrator

APAR TECHNOLOGIES PTE. LTD.; Singapore; On-site; SGD 50,000 - 70,000; Full time

Job summary

A technology solutions provider in Singapore is seeking a Database Administrator to manage Oracle Database systems including installation, performance tuning, and data safety strategies. The ideal candidate will have over 3 years of experience, a Bachelor's degree in a technical field, and familiarity with Linux/Unix scripting. The role includes troubleshooting and enhancing database performance while collaborating with development teams. Competitive salary and benefits are offered.

Qualifications

• 3+ years of experience with Oracle Database systems.
• Experience in installation, configuration, patching, and upgrading Oracle Database.
• Familiarity with RMAN backup and recovery strategies.

Responsibilities

• Install, configure, patch, and upgrade Oracle Database systems.
• Optimize performance through SQL and PL/SQL queries.
• Manage database security and enforce access controls.
• Troubleshoot database errors and performance bottlenecks.

Skills

Performance tuning

SQL optimization

PL/SQL

Backup and recovery

Database security

Troubleshooting

Collaboration with development teams

Capacity planning

Education

Bachelor's degree in relevant technical field

Tools

Linux/Unix

Oracle Enterprise Manager

Job description

• Responsible for the installation, configuration, patching, and upgrading of Oracle Database systems (e.g., 19c).

• Perform proactive performance tuning and monitoring, including optimizing complex SQL and PL/SQL queries.

• Implement and manage reliable RMAN backup and recovery strategies to ensure data safety and integrity.

• Maintain and support High Availability (HA) solutions such as Oracle RAC, ASM, and Data Guard.

• Manage database security, user privileges, and enforce access controls.

• Troubleshoot and resolve complex database errors, performance bottlenecks, and service outages promptly.

• Collaborate with application development teams on database design and optimization.

• Conduct capacity planning and manage storage, tablespaces, and database objects efficiently.

• Requires 3+ years of experience and a Bachelor\'s degree in a relevant technical field.

• Familiarity with Linux/Unix shell scripting and Oracle Enterprise Manager (OEM) is required. EA Number: 11C4879