Salary Range : Open

Nationality: Singapore

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.