Job Title: Oracle DBA (Ref Code: 32312 MURSWA)

Location: Cincinnati, Ohio

Duration: 6 months to extent.

Rate :DOE

 

This is an H1 and C2C position.

 

Required Skills / Responsibilities:

·         Oracle 10/11g DBA with Cognos / Datastage experience

·         Database tuning and performance monitoring.

·         Application tuning and performance monitoring.

·         Maintain application performance at its peak level by capturing the wait events and resource intensive SQL statements from AWR and ASH reports. Perform root cause analysis on these items and implement appropriate measures to optimize them. Gather trace information by setting events like 10046, 10704, etc and process the trace files with tkprof utility to analyze the wait events and the resource intensive SQL statements. Apply various SQL tuning techniques, data volume and distribution analysis, indexing options, join validations, pre summarization and aggregation of data, set-based processing, Top-N SQL, query rewrite, etc, to optimize such SQL statements. Investigate the occurrences of bind peeking in the database environments and resolve them by implementing SQL outlines and profiles. Capture AWR baselines at various stages of batch and online processing and compare them to identify the root cause behind the performance difference between a normal system response and a slower one.

·         Design and implement materialized views by consolidating operational data from various data sources and organize them to a state which would help the data warehouse queries by avoiding resource intensive operations like summarization, aggregation, complex joins, etc. Leverage the power of DBMS_MVIEW package to assess the possibility of fast refresh of materialized views (MVs), tune the MVs, and validate the execution plans to ensure the implementation of query rewrite. Apply data compression techniques as appropriate to conserve space and optimize database performance.

·         Do general technical trouble shooting and give consultation to BI Operations and the Project teams.

·         Building queries, stored procedures, materialized view, refreshes etc. that meets business needs / BI team.  

·         Design schemas, build tables, FKs, PKs, etc. Work to build a structure that meets the business needs in general and the BI team.

·         Installation, configuration and upgrading Oracle database software and related products.

·         Establish and maintain backup and recovery policies and procedures.

·         Take care of the Database design and implementation.

·         Implement and maintain database security (create and maintain users and roles, assign privileges).

·         Setup and maintain documentation and standards.

·         Plan growth and changes (capacity planning).

·         Work as part of a team and provide 7×24 supports when required.

·         Collaborate with other support groups (e.g. DBA, Platform, etc.) to establish proper support for BI team and meeting SLA.

·         Excellent communication and process skills

Skills Desired:

• PeopleSoft Finance/HCM/HR, Portal, and EPM applications.

• Knowledge of RAC, CRS, StandbyE
• Experience with routine Database Management tasks – Backups, Alerting, Monitoring etc.
• Knowledge of Enterprise Management, Grid Control