[USA-Florida_jobs] Need Oracle DBA, looking at 9+ years resume needed

BEST WAY TO REACH ME IS THROUGH EMAIL sareen@prosoftgroup.com

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 | ProSoft Technology Group, Inc.

Emailsareen@prosoftgroup.com| Phone 630-689-2960 x 145| Fax 630.725.1900 | Toll free 630.725.1800

Alternate email id recruitersareen@gmail.com| 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 "USA-Florida_jobs" group.
To post to this group, send email to usa-florida_jobs@googlegroups.com.
To unsubscribe from this group, send email to usa-florida_jobs+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/usa-florida_jobs?hl=en.