OBIEE Consultant - MUST skill (TimesTen and Exalytics) 8/27/2016

Confidential Company Washington, DC

Company
Confidential Company
Job Classification
Full Time
Company Ref #
29349480
AJE Ref #
576001265
Location
Washington, DC
Job Type
Regular

JOB DESCRIPTION

MUST SKILL

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