05 Mar
Database Administrator - Remote / Telecommute
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.
- 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.
- 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!