Hi,
Please have a look at this *"Urgent Requirement"* and reply me ASAP.
*Position: Oracle DBA*
*Location: Sunnyvale, CA*
*Duration: 6 Months*
*Work Authorization : GC/USC is preferred*
*Experience: 9+ Years, with Strong experience in Oracle Data warehousing.*
*Mandatory Skills (MANDATORY):*
- *DBA in Data warehousing & Tuning experience*
- *Very good knowledge of oracle internals.*
- *Parameter set-up for Data warehousing environment*
- *Knowledge about Oracle Parallel execution, Oracle multi-level
partitioning (partition wise joins, split, merge, partition exchange, etc.)
and Oracle Wait Events*
- *UNIX Shell scripting*
*Desired Skills:*
- Experience working with Oracle Grid Control (good to have)
- Good knowledge of Data warehouse concepts. (good to have)
- Expert in database instance and query tuning. (good to have)
- Knowledge of NetApp storage knowledge and AIX background is preferred.
(Good to have)
*Detailed Job Description:*
- Should have very good knowledge of* oracle internals (Must have)* to
solve complex oracle database performance problems (good to have).
- In-depth knowledge of working on Oracle AWR, ASH and ADDM tools. (good
to have)
- Very good knowledge of Oracle 10/11g INIT parameters pertaining to
Oracle data warehouse.
- Oracle Data warehouse performance tuning in terms of understanding
query rewrite, materialized views, snapshots, aggregation, schema modeling,
resource and profile management (good to have)
- 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 Grid Control (good to have)
- Good knowledge of Data warehouse concepts. (good to have)
- Expert in database instance and query tuning. (good to have)
- Knowledge of NetApp storage knowledge and AIX background is preferred.
(Good to have)
*Responsibility:*
- Proactively monitor database instance and perform AWR report analysis.
- Proactively monitor ETL jobs performance, find offending queries /
jobs.
- Working closely with team to solve complex performance problems.
- Work with ETL team (DataStage / Pentaho) 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 & Regards,*
*Alex Fernandes*
*Technical Recruiter- Talent Management Group*
*|| IT-SCIENT || Phone: 510.972.5255 || Email: [email protected]
||Web:www.itscient.comll*
*
*
--
You received this message because you are subscribed to the Google Groups
"oraapps" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/oraapps.
For more options, visit https://groups.google.com/groups/opt_out.
