Oracle DBA

Location: San Francisco, CA
Date Posted: 05-02-2014

Our Company is independently owned and all our work is supported by research and data which gives us the freedom and confidence to make courageous recommendations to our clients. We take a holistic approach, looking at organizations from all angles – jobs, reward, leadership and organizational effectiveness. We encourage individuality and initiative and support our people through continuous development and feedback. We want our people to have a life outside work and respect the job/ life balance. For some this means flexible working arrangements and for others it’s about making the most of our flexible benefits offerings.

This position will design a solution to take a Peoplesoft SQL Server database in one location and replicate it (all 30K tables) to a PeopleSoft Oracle database in another location plus replicate the tables BACK from one location to the other for fail back protection.

--- Review PeopleSoft Finance 8.9 Production - Architect the process of how to get the bulk data migrated, considering the size, complexity, cutover downtime, network latency, and the nature of Peoplesoft.
--- Teach/Show how to build the scripts and get the bulk data migrated from the source to destination.
--- Design/Build the method to sync up data from source/target real-time by capturing the change thru transactional logs.
--- Run thru one complete exercise of both methods (simulating cut-over time) to see the setup, script execution, data flow, review and error correction.
--- Discussion of potential errors that may come up in the future.
--- Discussion of items that may need to be changed for Target as RAC databases.
--- Documentation of the process.

Our Company people can shape their careers in the manner that they choose. Career progression is based on performance, with clearly defined expectations and a performance management process to help shape individual growth. This is backed by training and skills development which draws on both internal and external opportunities and providers. Educational assistance is also available to those seeking to further qualifications.

this job portal is powered by CATS