Hi Kindly check the requirement and let me know if you have any consultants with the matching profiles.
*Senior Oracle DBA* *New York City*** *6 months* *Rates are open but send me the best competitive rate at your end.* *Please send me resume which are 100% match…* *At least 10 yrs or 10+ yrs exp candidate needed.* * * *Data Warehouse Initiative* *DBA Role Needs * *Linux Server Environment* * Validate Oracle Enterprise Linux setup according to best practices for Oracle RAC * Validate Linux Security configuration * Setup Linux Server health and performance monitoring *Oracle Database 11g* * Configure and optimize Oracle database for data warehouse environment * Setup data warehouse specific database monitoring * * * Oracle Streams* * Prepare HRDC database for Oracle Streams setup o Two major tables are currently compressed and need to be uncompressed. o Monitor performance of HRDC and related application with uncompressed tables. * Tune HRDC production if there are any performance issues. * Setup Oracle Streams to replicate data from production HRDC to data warehouse database * Monitor performance of Oracle Streams and make configuration changes to optimize the performance *Data Warehouse Architecture* * Dimensional Modeling - Work with architects to design dimensional model * ETL design - Work with ETL designer to develop ETL processes * Setup Oracle Change Data Capture to capture data changes and stage the changes in staging tables. * Setup ETL environment to load changed data from staging tables to dimensional model. * Create stored procedures if required to assist in the movement of data. * Monitor and tune performance of materialized views and partitioned tables. * Design and implement multi dimensional OLAP cubes based on reporting requirement * Setup and tune OLAP cubes refresh from base tables * Setup aggregates and summary using materialized views and partitioned tables *Oracle RAC Environment* * Monitor and tune Oracle RAC * Test impacts of node failure on data warehouse jobs *Stabilize and Deployment Tasks* * Performance and load testing * Setup and monitor various jobs for loading data warehouse * Monitor and tune performance of various components * Test and document recovery scenario's for the Oracle DW databases * Setup and monitor OS and database backup environments * Apply patches and security fixes *Thanks and Regards* * * *Prashant Mishra* * * *Technical Recruiter* Landmark Technologies Email : [EMAIL PROTECTED] Ph# 646-340-5856 Fax # 212-504-8320 www.landmark-technologies.com Visit our group at www.landmarkgoc.com *Being an ISO 14001:2004 certification and ISO 9001-2000 corporation we assure you high quality and superior level services.* --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "zilliontechnologies" group. To post to this group, send email to zilliontechnologies@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/zilliontechnologies?hl=en -~----------~----~----~----~------~----~------~--~---