Database Administrator(PeopleSoft on Oracle RDBMS) - Remote
ARCHIVED
We can't find an active application page for this role right now. It may reopen or be listed elsewhere. Use Next Steps to search for an active apply link and similar live jobs.
Database AdministratorLocation: Remote Client: State of GA (USG) Pay rate: $161/hr on W2Job Summary: USG'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 hoursSchedule: RemoteSpecific 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 RDBMSMinimum 10 years PeopleSoft PSCBOOracle RDBMS 19cPeopleTools 8