Sr. Oracle Database Admin (with Peoplesoft upgrade exp) (100% REMOTE) (Webcam Interviews)

Sr. Oracle Database Admin (with Peoplesoft upgrade exp) (100% REMOTE) (Webcam Interviews)

01 Mar 2024
Georgia, Atlanta, 30304 Atlanta USA

Sr. Oracle Database Admin (with Peoplesoft upgrade exp) (100% REMOTE) (Webcam Interviews)

Vacancy expired!

Please note that this position is with our direct client We are looking for a Sr. Oracle Database Admin (with Peoplesoft upgrade exp) (100% REMOTE) (Webcam Interviews) POSITION DESCRIPTION DIRECT CLIENT Position Number of positions: 1 Length: 1 months with possible extension Location: REMOTE ONLY Immediate interviews Webcam Interviews
Purpose of Engagement: Retain subject matter expert to assist with SQL execution for PeopleSoft on Oracle database 19c. 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:
1. Review database configuration and identify discrepancies from the optimal configuration for PeopleSoft
FSCM and HCM.
2. Review approach to gathering statistics and identify discrepancies from the optimal configuration for
PeopleSoft FSCM and HCM.
3. Assist in setting up a proof of concept for recommended changes.
4. Review and address specific long running and underperforming SQL statements.
5. Address issue with long running SQL statements initiated from PeopleSoft Query self-replicating in the
database.
6. Review reporting database configuration and address SQL errors.
7. 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

Candidates must have ALL the "Required" skills in order to be considered for the position. "Desired" or "Highly Desired" skills are a PLUS but may NOT be required.
Skill Matrix Experience with Business workflow processes Required / Desired Amount of Experience PeopleSoft on Oracle RDBMS Required 10 Years PeopleSoft PSCBO Required 10 Years Oracle RDBMS 19c Highly desired 1 Years PeopleTools 8.58 Highly desired 8 Months PeopleSoft Row Level Security Required 5 Years

Related jobs

Job Details

  • ID
    JC10445806
  • State
  • City
  • Job type
    Permanent
  • Salary
    $DOE
  • Hiring Company
    Advanced American Technologies, Inc
  • Date
    2021-03-01
  • Deadline
    2021-04-30
  • Category

Jocancy Online Job Portal by jobSearchi.