Specialist, Infrastructure (Oracle DBA) [Financial Institution]ID:48930

5,000 MYR ~ 7,000 MYRKota Damansara/Petaling JayaOver 3 months ago

Overview

  • Salary

    5,000 MYR ~ 7,000 MYR

  • Industry

    Finance(Other)

  • Job Description

    • Specialize in administrative and fine tuning multiple Oracle/MS SQL Database version, Database Security; familiar with multiple operating system platform (MS OS & Linus); able to setup new servers with OS, Database & Application for various Development/Test/Production environment.
    • Administer and maintain all activities associate with database management such as install, configure, upgrade, maintain, test, monitor, optimize and fine tune database/application servers’s performance/ Perform analysis, troubleshoot database related issues, monitor, allocate and plan database storage capacity requirements.
    Be part of infrastructure team to handle & provide after office hours on urgent incident support request/user support call.
    • Create, maintain and monitor end-of day scheduler jobs, perform end of day and month end system closing. Perform, monitor and ensure daily/weekly/monthly backup/replication or any restoration request is performed successfully. Monitor database/systems logs to proactively identify, report exception or error to minimize disruption and impact to the database/systems downtime.
    • Setup, configure, implement & maintain Application/Database related Development/Test/Production environment. Perform objects/programs migration, deploy bug-fix script/programs, deployed security patches; prepare and review monthly object migration change management report/logs. Protect database against threats or unauthorized
    access. Create and maintain users’ profiles and permissions.
    • Serve & being the in-house subject matter expert to participate in projects and evaluate database related solution/requirement, database requirement. To provide related advice, design, implement, managing database security/integrity, capacity, backup, replication, restore requirement and recommend improvements wherever is necessary.
    • Participate in IT DR/BCP preparation, setup and simulation. Establish IT DR/BCP plans, determine, document and ensure database related policies, procedures and standards are up to date & enforce. Facilitate and interacts with internal and external audit engagement, collect the audit sampling requirements facilitate remediation based on agreed recommendation and associated risks pertaining to SOX, Global Information Security Group or any others corporate requirement. Periodical tracking and follow-up with relevant party to ensure audit and compliance gaps are addressed and rectified according to committed timeline.

Qualifications

  • Requirement

    - Education : Degree in Computer Science, Information Technology or equivalent practical experience
    - Experience :
    > Minimum 5 years of technical hands-on experience in install, configure, administrate & maintain database/application server, Wintel & Linux Operating Systems & VMWare environment, database/system setup/backup/recovery/replication & restoration. User access management, implement and maintain database security & security patch deployment, perform end-of day and month end closing, maintain & monitor scheduler jobs and event logs, participate in IT DR/BCP setup and simulation, establish & maintain SOP/policy/procedure & documentation.
    > Min. 2 years of experience as a database administrator to setup, administrate, maintain & finetune Oracle (ver 12C and above), MY SQL & MS SQL (ver 2 & above)
    - Skill:
    > Good scripting skills to create and maintain shell scripts to automate various database related tasks and scheduler jobs.
    > Knowledge in setup, maintenance and troubleshoot of PC/Server OS, network connection issues an added advantage.
    - Certificate : MCSE, MCSA, MCDBA, Oracle Certified Professional (OCP)
    - Others :
    > To be part of infrastructure team to provide help desk support/user call (included after office hours incident support request)
    > Self-starter with excellent analytical and problem-solving skills, results oriented, good interpersonal skill and flexible
    > Excellent Presentation skill, written and communication skills
    > Ability to work on own initiative with minimal supervision, excellent time management, priorities and organizational skills to work on concurrent multi-tasks with high sense of urgency

  • English Level

    -

  • Other Language

    Malay, English

Additional Information

  • Benefit

    *Non fixed allowance
    - Bonus: Average 3 months salary (*subject to Company & Individual Performance)
    - Annual leave: 21 Days
    - MC: 28 Days

  • Working Hour

    8.00 ~ 17.30

  • Holiday

    -

  • Job Function