Oracle 19C Admin

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