Location: NOVI, MI Duration: 6 months
Rate: 55/hr I need someone with these skills for a temporary contract position. Oracle 8i, 9i, 10g, 11g skills should include: Oracle Internals & Architecture, SQL, PL/SQL, Grid EM, Data Guard, RAC/OPS, RMAN, Constraints, Resource, Security, and Storage Mgmt, Tuning, DDL, data dictionary, dynamic SQL, and monitoring. High Availability & Disaster Recovery UNIX/Linux skills should include: CPU/Memory/I-O monitoring and tuning, ksh, csh, bash scripting, HA clustering and systems administration concepts. Ability to create PL/SQL stored procedures with solid error handling skills required. Creating PL/SQL with XMLGEN code is also required. MAIN JOB is this: Ability to create PL/SQL stored procedures with solid error handling skills required. Creating PL/SQL with XMLGEN code. * Move data from database tables based upon logical data representation (PO header, all PO Detail lines that belong to the PO Header) and route the data based upon field data to one of several linked databases. Once the records have been inserted into the destination table successfully the program must then update the source table as being processed. Then do the next logical transaction, etc until all transactions have been moved. This process will need to be done via trigger or interval time based execution. * Move data from database tables based upon logical data representation (Item Master, Item detail data) and be able to carbon copy data into several databases. Upon successful insertion in all destination databases update the source table as being processed. * Be able to extract information from a database tables using XMLGEN and have it created logical based transactions (Order Header, Order addresses, Order details, order item details, etc) then upon successful extract update source as being processed and/or update audit trail database that transaction was processed with date/time and other variable data extracted during the extract. -- Regards Mohan Rao 630-242-3952 ext 217 moh...@aesinc.us.com -- You received this message because you are subscribed to the Google Groups "US_IT.Groups" group. To post to this group, send email to us_itgro...@googlegroups.com. To unsubscribe from this group, send email to us_itgroups+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/us_itgroups?hl=en.