OBIEE Consultant - MUST skill (TimesTen and Exalytics)
ORACLE TIMESTEN, IN-MEMORY DATABASE TECHNOLOGY (IMDB), ORACLE EXALYTICS, ORACLE FUSION MIDDLEWARE ADMINISTRATION
OBIEE CONSULTANT SHALL HAVE EXPERIENCE IN:
* Developing and deploying TimesTen for OBIEE and BIAPPS.
* In-Memory database technology (IMDB)
* Setting up and running summary advisor on an Exalytics Machine
* Leveraging BI Server Caching to get most benefits out of the Cached queries and return the same result without hitting the database multiple times.
* Removing Snowflake across dimensions and create the Foreign Key for each Dimension into Fact to create Star model, where applicable
* Applying Bitmap Index for all Foreign Key columns, and Bitmap Join Index
* Ensuring that the RPD is in sync with the database to avoid full outer joins
* Optimizing setting of NQSConfig.INI parameters such as sort memory size, sort buffer increment size, etc.
* Managing optimally some key values like maximum session limit, and database and server execution
* Fluency in SQL and dimensional modeling concepts
* Seven (7) or more years of experience in Oracle Fusion Middleware Administration
* Middleware Certification is preferred
* Ability to work closely with business partners, TS, and project manager
* Possess strong oral and written communication skills