Oracle Cloud Database Administrator

PCCW SOLUTIONS INSYS PTE. LTD.; Singapore; On-site; SGD 100,000 - 167,000; Full time

Job summary

PCCW Solutions Insys Pte. Ltd. is seeking an experienced Oracle Database Administrator to maintain high availability, perform health checks, and manage migrations and patches. You will ensure security, capacity planning, and policy documentation across PROD/DR/DEV/QA/UAT environments.

Candidates should have 5+ years in Oracle DB administration (11g/12c/18c/19c), RAC/GoldenGate/Data Guard experience, and strong troubleshooting skills. AWS-related certifications are a plus.

Qualifications

• Experience in supporting Oracle Database environments PROD/DR/DEV/QA/UAT with minimum 5 years of experience.
• Strong experience in Database Administration in Oracle version (11g/12c/18C/19C)
• Experience in supporting high availability Oracle RAC environment (2/3/4 node clusters), Oracle Golden Gate, Oracle Data Guard
• Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, connectivity issues, security issues
• Strong Knowledge in Operating systems like Windows and Unix
• Generating reports in Oracle database using tools like AWR, ASH, ADDM and manual scripts.
• Provide continuous monitoring, troubleshooting, historical and real time performance monitoring of the Oracle.
• Strong Experience of RMAN, expdp/impdp, Backup/Recovery
• Experience in evaluating and installing new software releases, patches, upgrade and Database cloning
• Experience in developing and executing database security policies, procedures
• Daily health monitoring of database system and data integrity checks
• Collect and analyse database performance information, identify and implement solutions for performance problems
• Experience with other RDBMS, NO SQL, cloud platforms will be added advantage
• Good communication skills English (written, spoken) and Documentation skills for processes and procedures (creating KBs, runbooks, topology)
• Work with users, vendors to take timely and appropriate steps to resolve and troubleshoot issues impacting service levels and conduct root cause analysis

Responsibilities

• Maintain high availability and reliability of databases
• Perform daily Health Check, database maintenance and database security self-assessment.
• Perform database creation, configuration and migration, apply patches and technology upgrade to keep the databases at supported level
• Database Capacity Planning
• Ensure that the database assets and systems are managed in accordance with the security policies and standards [This includes Account Reviews]
• Responsible for documenting database related policy, architecture and design artefact.
• Provide technical expertise and solutions based on user requirements for database-related project.

Skills

Communication skills

Documentation

Analytical thinking

Problem solving

Team collaboration

Education

Oracle Certification

AWS Certified Database – Specialty

AWS Certified Solutions Architect – Associate

Oracle Certification (general)

Tools

Oracle Database

RMAN

expdp/impdp

AWR/ASH/ADDM

Oracle Data Guard

Oracle GoldenGate

Oracle RAC

Windows/Unix

Job description

Responsibilities:

• Maintain high availability and reliability of databases
• Perform daily Health Check, database maintenance and database security self-assessment.
• Perform database creation, configuration and migration, apply patches and technology upgrade to keep the databases at supported level
• Database Capacity Planning
• Ensure that the database assets and systems are managed in accordance with the security policies and standards [This includes Account Reviews]
• Responsible for documenting database related policy, architecture and design artefact.
• Provide technical expertise and solutions based on user requirements for database-related project.

Requirements:

• Experience in supporting Oracle Database environments PROD/DR/DEV/QA/UAT with minimum 5 years of experience.
• Strong experience in Database Administration in Oracle version (11g/12c/18C/19C)
• Experience in supporting high availability Oracle RAC environment (2/3/4 node clusters), Oracle Golden Gate, Oracle Data Guard
• Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, connectivity issues, security issues
• Strong Knowledge in Operating systems like windows and Unix
• Generating reports in Oracle database using tools like AWR, ASH, ADDM and manual scripts.
• Provide continuous monitoring, troubleshooting, historical and real time performance monitoring of the Oracle.
• Strong Experience of RMAN, expdp/impdp, Backup/Recovery
• Experience in evaluating and installing new software releases, patches, upgrade and Database cloning
• Experience in developing and executing database security policies, procedures
• Daily health monitoring of database system and data integrity checks
• Collect and analyse database performance information, identify and implement solutions for performance problems
• Experience with other RDBMS, NO SQL, cloud platforms will be added advantage
• Good communication skills English (written, spoken) and Documentation skills for processes and procedures (creating KBs, runbooks, topology)
• Work with users, vendors to take timely and appropriate steps to resolve and troubleshoot issues impacting service levels and conduct root cause analysis

Certifications:

• AWS Certified Database – Specialty (required).
• AWS Certified Solutions Architect – Associate (required).
• Oracle Certification