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.
Requirements:
• Graduate degree in IT/Computer Science or equivalent
• 6+ years of total experience with last 5 years as Database application performance specialist,
• Expertise in Oracle 19C,Database Product
• Expertise in the Oracle database runtime configuration and optimization parameters.
• Exposure to Relational database Object Mapping frameworks such as iBatis and Hibernate.