Senior Database Administrator - Oracle

About our client

Global supplier for cloud based on-demand software, expanding their IT Centre in Malaysia.

About the role

Hiring talented Database Administrators to join a growing global operations team.  As a member of the Database Operations team, you will be joining a high-powered collaborative team responsible for delivery and support of private cloud database technology required for mission critical applications used by major brands across the globe. 

Your responsibilities

• Be an active contributor in a geographically diverse team of database administrators.

• Responsible for Oracle database administration activities in support of development and production systems support web-deployed applications utilized in the global delivery of single and multi-tenant SaaS applications.

• Identify data sources, construct data decomposition diagrams, provide data flow diagrams and document processes.

• Write code for database access, modifications, and constructions including stored procedures.

• Create and maintain global and end-user accounts and access.

• Design and implement data archival and removal functions for maintaining database performance and efficiency.

• Maintain data files and monitor systems configuration to ensure data integrity.

• Perform database system back-up and recovery functions.

• Monitor and assess database performance, tuning and create improvement strategies.

• Execute, maintain and enhance Disaster Recovery procedures and strategies.

• Implement data models and database designs.

• Perform problem analysis and resolution tasks as part of an on-call support rotation.

• Collaborate with other Global IT teams to provide services and support.

You will have

Prior Experience

• 4-6 years’ hands-on experience with Oracle Database technology; inclusive of Enterprise Edition, RAC, Goldengate, Data Guard, and CLOBS/securefiles. Transparent Database Encryption (TDE), ASM

• Oracle 12c DB, Oracle 12c Grid, Oracle 18c

Skills & Qualities

• Demonstrated ability to analyze and research performance related issues.

• Proficient in RMAN inclusive of recovery execution and configuring nocatalog and catalog rman. 

• Proficient using SQL Explain and Statistics.

• Familiar with operating in a *nix environment.

• Familiar with encryption strategies and implementation.

• Familiar with OEM utility.

• Familiar with SQL Developer.

• Ability to write, monitor, and maintain shell scripts in a *nix environment.

• Highly motivated and demonstrate high level of initiative.

• Demonstrated problem solving skill with excellent written and oral communication skill.

• Shell Scripting in BASH.

• Minimum outage migration to new DB releases using Golden Gate.

• • Applicable for MALAYSIANS ONLY.

Education & Professional Qualifications

• B.S. Computer Science/Engineering or equivalent computer-related education.

Special Work Hours Requirement

• Participate in incident handling and off-hours/weekend maintenance activities, as necessary.