Very Urgent Requirement for Oracle Data Warehouse Consultant Must be Local to Bay Area

Dear Partner,

Good Morning!

Please find the below job requirement and send the profiles to gurpreet@knowledgemomentum.com

Role: Oracle Data Warehouse Consultant

Location: Sunnyvale, CA

Duration: 6-12 Months

 

Note: Locals Only (Bay Area)

 

Skill set

• Should have very good knowledge of oracle internals to solve complex oracle database complex performance problems
• In-depth knowledge of working on Oracle AWR, ASH and ADDM tools
• Very good knowledge of Oracle 10/11g init.ora parameters pertaining to Oracle data warehouse
• Oracle Data warehouse performance tuning in terms of understanding query rewrite, materialized views, snapshots, aggregation, schema modeling, and resource and profile management
• Knowledge about Oracle Parallel execution, Oracle multi level partitioning (partition wise joins, split, merge, partition exchange, etc) and Oracle Wait Events
• Experience working with Oracle 10g Grid Control
• Good knowledge of Data warehouse concepts.
• Expert in database instance and query tuning
• Must be self-motivated and can work independently
• Must be a team player
• Knowledge of NetApp storage knowledge is preferable.

 

Responsibility

• Proactively monitor database instance and perform AWR report analysis.
• Proactively monitor ETL jobs performance, find offending queries / jobs.
• Working closely with onsite database architect to solve complex performance problems
• Work with DataStage and BI reporting team to guide, educate and tune queries
• Complex SQL tuning physical data modeling
• Design, manage and test materialized views and aggregates
• Provide L4 production support and solve on P1/ P2 issues.

Thanks

Gurpreet Singh

gurpreet@knowledgemomentum.com

--
You received this message because you are subscribed to the Google Groups "Jobs for USA consultants (Citizen G.C and H1B)" group.
To post to this group, send email to jobs-for-usa-consultants-citizen-gc-and-h1b@googlegroups.com.
To unsubscribe from this group, send email to jobs-for-usa-consultants-citizen-gc-and-h1b+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/jobs-for-usa-consultants-citizen-gc-and-h1b?hl=en.