Current Openings

PeopleSoft Database Admin

, GEORGIA | Contract
Post Date: 02/25/21
Job ID: 21-00182
Job Type: Contract

Job Description

 Job title               :  PeopleSoft Database Admin
Type                     :  Remote                       
Duration              :  4 weeks – Short term
 
Job description :
 
Purpose of Engagement:  Retain subject matter expert to assist with SQL execution for PeopleSoft on Oracle database 19c. for the client.
 
Job Summary:
 
Client's PeopleSoft platform has had several updates over the past year including:  database upgrade to 19c, PeopleTools upgrade to 8.58 and the implementation via Active Data Guard of a database for reporting.
 
Estimated Duration:  160 hours
Schedule: Remote
 
Specific deliverables:
  • Review database configuration and identify discrepancies from the optimal configuration for PeopleSoft
  • FSCM and HCM.
  • Review approach to gathering statistics and identify discrepancies from the optimal configuration for
  • PeopleSoft FSCM and HCM.
  • Assist in setting up a proof of concept for recommended changes.
  • Review and address specific long running and underperforming SQL statements.
  • Address issue with long running SQL statements initiated from PeopleSoft Query self-replicating in the
  • database.
  • Review reporting database configuration and address SQL errors.
  • Conduct knowledge transfer on underutilized tools and features.
 
Requirements:
 
  • Minimum 10 years PeopleSoft on Oracle RDBMS
  • Minimum 10 years PeopleSoft PSCBO
  • Oracle RDBMS 19c
  • PeopleTools 8.58
  • Preferred: 19c and PSCBO
  • Minimum 5 years PeopleSoft Row Level Security
 
Estimated Duration:  160 hours

Required:
  • PeopleSoft on Oracle RDBMS
  • PeopleSoft PSCBO
  • Oracle RDBMS 19c
  • PeopleTools 8.58
  • PeopleSoft Row Level Security