*BEST WAY TO REACH ME IS THROUGH EMAIL [email protected]* *Client is considering at least 9 yrs + Oracle DBA experienced consultants for this position.*
*Qualifying Questions:* Oracle DBA and administrator with primary focus on BI Application (DB, ETL and Reporting) Oracle DBA - 8+ Years Datastage - 8+ Years Star Query Optimization - 8+ years experience *SKILLSET REQUIRED: *1.Should have very good knowledge of oracle internals to solve complex oracle database complex performance problems. 2. In-depth knowledge of working on Oracle AWR, ASH and ADDM tools. 3. Very good knowledge of Oracle 10/11g init.ora parameters pertaining to Oracle data warehouse. 4. Oracle Data warehouse performance tuning in terms of understanding query rewrite, materialized views, snapshots, aggregation, schema modeling, resource and profile management 5. Knowledge about Oracle Parallel execution, Oracle multi-level partitioning (partition wise joins, split, merge, partition exchange, etc.) and Oracle Wait Events. 6. Experience working with Oracle 10g Grid Control 7. Good knowledge of Data warehouse concepts. 8. Expert in database instance and query tuning. 9. Must be self-motivated and can work independently 10. Must be a team player. 11. Knowledge of NetApp storage knowledge is preferable. Responsibility 1. Proactively monitor database instance and perform AWR report analysis. 2. Proactively monitor ETL jobs performance, find offending queries / jobs. 3. Working closely with onsite database architect to solve complex performance problems. 4. Work with DataStage and BI reporting team to guide, educate and tune queries 5. Complex SQL tuning. 6. Physical data modeling 7. Design, manage and test materialized views and aggregates 8. Provide L4 production support and solve on P1/ P2 issues *Thanks & Regards* * * *Sareen Bhaskaran** **|** Sr. Resource Manager **|** **Pro**S**oft Technology Group, Inc.* *Email****[email protected]* <[email protected]>*|** Phone 630-689-2960 x 145**|** Fax 630.725.1900** |** Toll free **630.725.1800* Alternate email id [email protected]|* YIM sareen_recruiter ** * 2001 Butterfield Rd, Suite 305, Downers Grove, IL, 60515 | * * www.prosoftgroup.com This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to which they are addressed. If you have received this email in error please notify the system manager. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. Finally, the recipient should check this email and any attachments for the presence of viruses. ProSoft accepts no liability for any damage caused by any virus transmitted by this email. -- You received this message because you are subscribed to the Google Groups "Open Source J2EE frameworks" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/open-source-j2ee-frameworks?hl=en.
