05 Mar
Database Administrator - Remote / Telecommute
Georgia, Atlanta , 30301 Atlanta USA

Vacancy expired!

We are looking for Database Administrator - Remote / Telecommute for our client in Atlanta, GA Job Title: Database Administrator - Remote / Telecommute Job Location: Atlanta, GA Job Type: Contract “United States Citizens and those authorized to work in the US for any employer are encouraged to apply. We are unable to sponsor visas at this time.” Job Description:

  • Purpose of Engagement - Retain subject matter expert to assist with SQL execution for PeopleSoft on Oracle database 19c. for the client.
  • The 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.
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.

Vacancy expired!


Related jobs

Report job