Connecting...

Senior Database Administrator - Oracle

Job Title: Senior Database Administrator - Oracle
Contract Type: Permanent
Location: Kuala Lumpur
Industry:
Salary: RM Negotiable
Reference: A000000 (ASEK-751684)
Contact Name: Priya Supramaniam
Contact Email: priya.supramaniam@ellwoodconsulting.com.my
Job Published: September 19, 2019 13:49

Job Description

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.