Hi Greetings!!!

We have an urgent requirement for BI Architech @ Rochester, NY. Duration : 4 Weeks. Rate : $/hr + Exp.

Scope of Tasks:

Details:  Work with team to assist in tuning Analytics.

The candidate must have the following 11g experience: 

Data Warehouse 11g DBA with experience using and optimizing  SQL Aggregations features of the 11g database.
Experience designing, implementing and tuning the Cube, Rollup and groping set features.
Aggregation is a fundamental part of data warehousing. To improve aggregation performance in your warehouse, Oracle Database provides the following functionality:

• CUBE and ROLLUP extensions to the GROUP BY clause
• Three GROUPING functions
• GROUPING SETS expression
• Pivoting operations

Experience implementing the CUBE feature  to do efficient analysis across multiple dimensions without performing a CUBE operation.

Computing a CUBE creates a heavy processing load, so replacing cubes with grouping sets can significantly increase performance.

Thanks & Regards,

John Dennis. N

john.dennis@sierratec-us.com