DIRECT CLIENT REQ Required Skillset - Oracle DBA (Datawarehouse DBA) Experience Range - 6+ yr Location - Columbus-Indiana Duration - Long term fulltime Rate : $50/hr c2c
Job Description Lead Oracle Database operations activities, schedule the work and communicate to BI/DW project managers, Development team & Support teams. Standardize & automate the process and Prepare standard documents ETL developers make source data available to the warehouse. Using either in-house developed or off-the-shelf tools, ETL developers ensure the warehouse is populated with timely and accurate data. Very large databases (VLDB) - Oracle DBA partitioning skills, administration and management of a large database with an analytical front-end Online analytical processing (OLAP) - Star schema design and DBA administration Responsible for the Database objects and performance of a data warehouse. DBAs are skilled in data administration, data modeling and tuning, ensuring development teams have the optimum environment in which to deliver applications. Materialized Views -The Oracles materialized views (MV) feature uses Oracle replication to allow you to pre-summarize and pre-join tables. Best of all, Oracle MVs are integrated with the Oracle 10g query re-write facility, so that any queries that might benefit from the pre-summarization will be automatically rewritten to reference the aggregate view, thereby avoiding a very expensive (and unnecessary) large-table-full-table scan. The Oracle10g dbms_advisor utility will automatically detect and recommend MV definitions, then create a materialized view to reduce disk I/O. - Mayank Sharma IDC Technologies Inc. Ph: 408-852-7193 Email: [email protected] GTalk: [email protected] www.idctechnologies.com Note : We respect your online privacy. If you have received this mail in error or are not interested in receiving this further, please accept our apology and reply with a request to be removed from our mailing list. -- You received this message because you are subscribed to the Google Groups "Oracle-Projects" 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/oracle-projects?hl=en.
