[LPS] Oracle Database Administrator - AWS

LPS; Singapore; On-site; SGD 90,000 - 150,000; Full time

Job summary

LPS in Singapore is seeking an experienced Oracle Database Administrator to maintain high availability, perform health checks, and ensure security compliance across PROD/DR/DEV/QA/UAT environments.

You will manage Oracle RAC clusters, RMAN backups, patches, migrations and tuning, while documenting policies and architecture. Strong English communication and vendor collaboration are essential.

Qualifications

• Experience maintaining Oracle databases across PROD/DR/DEV/QA/UAT environments.
• Experience in high availability Oracle RAC environments (2/3/4 node clusters) and data guard tools.
• Strong troubleshooting for database integrity, performance, blocking, deadlocks, connectivity and security issues.
• Proven ability to monitor performance with Oracle utilities (AWR/ASH/ADDM) and custom scripts.
• Documentation skills for processes, runbooks and topology.

Responsibilities

• Maintain high availability and reliability of databases.
• Perform daily Health Check, maintenance and security self-assessment.
• Perform database creation, configuration and migration, apply patches and upgrades.
• Database capacity planning and resource management.
• Ensure adherence to security policies and standards; conduct account reviews.
• Document database policies, architecture and design artefacts.
• Provide technical expertise and solutions based on user requirements for database projects.

Skills

Oracle Database

Oracle RAC

RMAN

AWR/ASH/ADDM

Windows/Unix

Security policies

Documentation

English communication

Education

AWS Certified Database – Specialty

AWS Certified Solutions Architect – Associate

Tools

Oracle GoldenGate

Oracle Data Guard

Job description

• 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).