Hi,
Please find the requirement below and answer ASAP with updated resume and
contact details to sad...@sentiertech.com ...Thanks a lot...
Resumes with the following information will be given preference.
Full Name:
Current Location:
Relocation:
Availability:
Work Authorization in US:
Contact Number:
Email:
Rate on C2C:
Please ensure all candidates have all skills listed under "Required Skills"
on their resume.
----
Title: *Sr. Oracle 11g/RAC DBA (with Data Warehouse experience on resume)
*Duration: 3 months + option for additional time
Start: ASAP
Location: Columbus, OH
Rate: Open + Expenses
REQUIRED:
1. Candidate must have 8-10 or more years DBA experience, implementing
decision support systems, Data Warehouses, preferably involving very large
databases and multiple RAC nodes.
2. Experience with 11g versions of the Oracle database is critical.
3. A deep understanding of DW and DSS architecture, design,
implementation is required.
4. Prior experience doing performance work reviewing database is
required.
5. Must have experience working in a Data Warehouse environment.
• DataWarehouse architecture setup and configuration review.
• Reviewing of database table space structure..
• Reviewing of use of B*Tree, Bit-Mapped and Bit-Mapped Pre-Join Indexes.
• Reviewing of use of materialized view and summary tables.
• Reviewing Oracle parameters logs and errors messages.
• Review the layout of the database on disk.
• Measuring the Input Output(IO) rate, wait events and statistics
associated with the Oracle Database instance.
• Reviewing the definition of temp space, redo logs, rollback segments and
other database instance specific objects.
• Reviewing the existing environment and make recommendations of new
features that may be available.
Query tuning experience in large databases (> 100TB)
Assess current database statistics gathering procedures
Discuss and create an automated statistics gathering procedures
Provide Oracle best practices for database statistics gathering
Assess current index and table reorganization requirements
Discuss and assist creation of index and table reorganization procedures
that minimize downtime
Discuss and assist creation of a testing plan for the reorganization
procedures
Indexes and tables reorganization on routine basis
Review Log file growth patterns
Discuss and create procedures to manage log file growth / pruning
--
Regards,
Sadiq md
Sentier Technologies
Voice : 614-408-3430
Email : sad...@sentiertech.com
www.sentiertech.com
--
You received this message because you are subscribed to the Google Groups
"oraapps" group.
To post to this group, send email to oraapps@googlegroups.com.
To unsubscribe from this group, send email to
oraapps+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/oraapps?hl=en.