PeopleSoft Database Administrator (DBA)
Job Summary:EY is seeking a highly skilled Senior PeopleSoft DBA with 8+ years of experience to lead the administration, maintenance, and optimization of PeopleSoft environments (HCM, FSCM, or Campus Solutions). The ideal candidate will have deep expertise in Oracle/SQL Server database management, PeopleTools architecture, and proven experience managing complex 24/7 production environments.
Core Responsibilities:
Environment Management: Lead installation, configuration, and maintenance of PeopleSoft application servers, web servers (WebLogic), and process schedulers.
Upgrades & Patching: Manage full-cycle PeopleSoft Image (PUM) updates and PeopleTools upgrades; execute Oracle database patching and version upgrades.
Performance Tuning: Perform advanced performance tuning at both Oracle database level (SQL tuning, indexing) and PeopleSoft application level (App Server/Batch tuning).
Data Integrity & Security: Implement robust backup and recovery processes using Oracle RMAN; manage PeopleSoft security (roles, permission lists, SSO).
Automation: Develop automation scripts (Shell, Python, PowerShell) for environment refreshes, backups, and monitoring.
Disaster Recovery: Design and test Disaster Recovery (DR) plans using Oracle Data Guard or similar tools.
Mentorship: Provide leadership and guidance to junior DBAs; collaborate with PeopleSoft Developers and Functional Analysts.
Technical Skills Required
PeopleTools:Extensive experience with PeopleTools 8.5x – 8.6x (Application Designer, Data Mover, Change Assistant) Database:Mastery of Oracle 19c/21c, SQL, PL/SQL, RMAN.Experience with Exadata or OCI is a plus Middleware:Deep knowledge of Oracle WebLogic, Tuxedo, Integration Broker (IB) Operating Systems:Expert-level proficiency in Linux/Unix (OEL, RedHat) and shell scripting Tools:Hands-on experience with PeopleTools or Stat for version control and migrations