Senior Oracle Database Administrator

Millennium Technology Services; Singapore; On-site; SGD 180,000 - 240,000; Full time

Job summary

A technology services company in Singapore is seeking a Senior Oracle Database Administrator with over 7 years of experience. The candidate must possess an Oracle OCP certification and have strong skills in database tuning, backup and recovery, and scripting. Responsibilities include architecting high availability solutions, performing installations, and troubleshooting various database technologies. The role requires working in a 24/7 support environment and strong command over communication.

Qualifications

• Must have Oracle 10g/11g/12c/18c/19c OCP certification.
• Experience with additional database technologies like MSSQL or DB2 is a plus.
• 7+ years of experience in Oracle database administration.
• Strong experience with backup utilities (RMAN, EXPDP/IMPDP), CRSCTL, SRVCTL, NetBackup.

Responsibilities

• Architect HA and DR Solutions for PAAS services.
• Perform installation and upgrade of Oracle databases.
• Troubleshoot and configure physical standby databases.
• Collaborate with customers and support teams on operational issues.

Skills

Oracle DBA

Database tuning

Scripting

Backup and recovery

SQL queries tuning

Automation scripting

SRVCTL

CRSCTL

Dataguard broker

Education

Bachelor's degree in Computer Science

OCP certification in Oracle

Tools

RMAN

Dataguard

Oracle OEM

Golden Gate

Job description

About the job Senior Oracle Database Administrator

Job Description

Having experience of 7+ years as senior oracle DBA. Architect HA and DR Solutions for PAAS services like Exadata, Autonomous Databases (ATP, ADW), RAC & Dataguard. Installation and upgrade of Oracle and RAC on 10g/11g/12c/18c/19c version under Linux/AIX platforms. Must have oracle ASM/ACFS implementation experience. Good scripting skills to automate regular DBA admin tasks. Strong experience on backup utilities or tools like RMAN & EXPDP/IMPDP, CRSCTL, SRVCTL, NetBackup, Networker. Applying grid and DB PSU patch in standalone and multi-node RAC cluster servers. Should have good command over speaking and writing. Strong experience on database and SQL queries tuning for Oracle and RAC databases. Should have knowledge of oracle OEM 12C/13C. He will be customer facing for all operational issues and activities. Strong experience on configure and troubleshoot physical standby database using dataguard broker. Strong experience on configure and troubleshoot golden gate replication components. Good Grip over Tables fine tuning and troubleshooting. Implement backup and recovery of Oracle databases for various scenarios. Administration over DB Objects including Tables , Clusters , Views , Procedures etc. Good in Impact Analysis of DB Change / DB Design Change etc. In-depth understanding of Advanced Architectures (Multi-Node, RAC, ASM). Good understanding of core support processes and change management, maintain documentation standards. Must have experience in Database tuning including I/O, Load Analysis, ADDR, AWR, SQL Profiling etc. Responsible for installation, upgrades (Database and RAC), patches, SR support, database tuning, concurrent manager administration, cloning. Able to work in 24 by 7 Support.

Requirements

• Candidate must possess at least a bachelor's degree, Post Graduate Diploma, Professional Degree (MCA / BE / BSC or SC computer science).
• Oracle 10g/11g/12c/18c/19c OCP certification is must.
• Having oracle RAC certification will be added advantage.
• Having previous banking BAU support will be added advantage.
• Having experience on additional database technologies MSSQL or DB2 or Sybase will be added advantage.
• At least 7 year(s) of working experience in the related field is required for this position.
• Preferably Senior Executives specializing in IT/Computer Network / System/ Database Admin or equivalent.
• Full-Time position