Talent.com
Oracle 19C Admin

Oracle 19C Admin

Pan Asia GroupKuala Lumpur, Kuala Lumpur, Malaysia
29 hari lalu
Penerangan pekerjaan

Overview

Nationality : Malaysian

Location : MBB Tower, Kuala Lumpur, Malaysia

Contract Duration : 12 Months ,extendable also.

Budget : Open

Responsibilities

  • Take a lead role in analyzing the current application design and Database model for performance point of view.
  • Be the main contributor in auditing the Database queries and procedure / packages that are (potential) source of performance issues of application.
  • Propose / suggest improvements techniques / schemas of the Database model and queries.
  • Work in a tight collaborative environment with an Offshore vendor (locate in India) to improve Database assets and resources.
  • Identify the 20% of the queries that cause 80% of the slowness issues.
  • Analyze the possibility of cartesian product in the SQL queries used.
  • Pinpoint the queries which involve full table scan.
  • High ability to read and analyze AWR reports.
  • Interact with teams and communicate findings and areas of improvements.

Qualifications

  • Graduate degree in IT / Computer Science or equivalent
  • 6+ years of total experience with last 5 years as Database application performance specialist
  • Expertise in Oracle19C, Database Product
  • Expertise in theOracle database runtime configuration and optimization parameters.
  • Exposure to Relational database Object Mapping frameworks such as iBatis and Hibernate.

    • #J-18808-Ljbffr

    Buat amaran kerja untuk carian ini

    Admin • Kuala Lumpur, Kuala Lumpur, Malaysia