*Please send resume to **[email protected]* <[email protected]>*only with contact information and location of candidate **.*
Face to Face required after phone screening local or nearby consultant preferred Location : Cupertino, CA, Duration: 1 year+ *Java Oracle Programmer – Strong company in Cupertino CA.* This is a Server Appliance migration project, from an Oracle database to a PostgreSQL database. The current application supports Oracle and the project involves a change to support postgreSQL. This project will create a new team to complete the programming necessary to make this change. We need good programmers fast, the two types of consultants needed: *Java Oracle Programmer – * - This person must be familiar with framework, java, oracle and SQL. They will convert dynamically generated Oracle SQL statements to standard based SQL statements. Resolving the mapping between Oracle specific constructs to standard SQL constructs. Strong Oracle. - Expert with J2EE, SQL syntax, Dynamic SQL, Hibernate. The following is the high level tasks for these programmers and the team. It should give you an idea on what kind the skills that we are looking for: *Summary Description of Deliverable or Service * 1.0 Convert existing SA Oracle DDL to postgreSQL DDL. The new DDL should maintain the same functionality and minimum performance degradation for SA postgreSQL DB 2.0 Convert existing SA base data population statement to postgreSQL statements The new base data population process should maintain the same functionality and minimum performance degradation for SA postgreSQL DB 3.0 Convert the existing code so the application will support jdbc driver and connection configuration for multiple databases. The identified modules for this task are OI, TIU, Twist, Weblogic, multi-master replication and others 4.0 Convert PL/SQL statements in the application to standard SQL statements Identified oracle specific features: outer join, connect by, hint, functions, and sequences. Identified Modules: DB, OI/TIU, Spin, Twist, Multi-master replication and others The new SQL should maintain the same functionality and minimum performance degradation 5.0 Convert Oracle Trigger to Postgre trigger. Identified Modules: Multi-master replication and others The new Trigger should maintain the same functionality and minimum performance degradation 6.0 Implement database export and import capability similar to oracle data pump for postgreSQL. Data pump is used by SA to create secondary core. It is a replication of the main core database through oracle data pump tool. The new postgreSQL process should maintain the same functionality and minimum performance degradation 7.0 Replace Oracle native job scheduler to a common job mechanism. Oracle job scheduler is used in Spin and db to purge the old database records. It needs to be replaced by replaced by 3rd party scheduler or custom scheduler implementation *Regards,* * Ning* *West Coast Consulting, LLC** **Work – 949 743 0065 x 213 • Fax – 714 844 9091 * *ning**@westcoastllc.com* <[email protected]>* * *www.westcoastllc.com* <http://www.westcoastllc.com/> Yahoo IM: zavungn ** <http://www.westcoastllc.com/>** -- *************************************************************************************** For all SAP related tutorials,Articles,Faqs,Tips www.sapbrainsonline.com **************************************************************************************** You received this message because you are subscribed to the Google Groups "sapbrains" 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/sapbrains?hl=en
