Department:
WFSFAAWFAO

Job nature:
(T26) Management of Database for Web-based Application Systems

Responsibilities:
(T26)
1. To assist manager to manage an in-house infrastructure team to enhance, configure and manage Oracle RDBMS 19c or above and Data Guard on a cloud platform
2. To supervise the members of in-house infrastructure team to configure and manage database, including backups, reorgs, statistics updates, Oracle-related patches, and any other required tasks
3. To manage Oracle environments containing replication
4. To set up and operate MariaDB using DBaaS
5. To advise application team to optimise the performance of Oracle and MariaDB database
6. To review and update relevant system documentation
7. To work with system administration staff to manage and maintain Oracle host machines; and
8. To carry out other duties as assigned by the supervisor.

Requirements:
1. Must be an Oracle Database Administrator Certified Professional
2. Must have minimum of 3 years of experience in providing operational Oracle DBA support to both production and non-production database environments
3. Must have solid work experience in Oracle 19c or above DBA activities including logical/physical database design, performance tuning, database security and PL/SQL programming
4. Must have strong hands-on experience in monitoring Oracle 19c or above database to provide a high availability service and optimum storage capability
5. Must have experience in diagnostic evaluation and performance tuning of Oracle database (advisors, SQL tuning, indexing, partitioning, etc)
6. Must have experience in Oracle database backup and recovery (RMAN, Cloning, Export/Import) as well as Oracle patch provisioning
7. Must have experience in Data Guard of Oracle
8. Must have experience in managing and operating MariaDB
9. Must have at least three years of work experience in the Government
10. Must have work experience in supporting web-based application hosted in Government Cloud Infrastructure Services (GCIS) using IaaS and DBaaS
11. Should be a team-player with good communication and interpersonal skills
12. Should have strong sense of analytical and problem solving skills; and
13. Should be hard-working and self-motivated with positive attitude.

Technical skills:
Oracle Database Tuning (72)
Oracle RDBMS (72)
Production Database Support (72)