· Installation of Oracle 11g/12c/19c on Windows, Solaris and Linux OS
· Installation of PeopleSoft Application and PeopleTools on Linux/windows environments.
· Database Administration, Tuning and support for the application systems as per the database requirements.
· Maintenance of Prod and Non-Prod environments in Peoplesoft
· Create and maintain Users, Profiles, Roles and Privileges and Prod and Non- Prod.
· Setup PeopleSoft Web server, Application server domains, Process Scheduler, SQR, Crystal Reports, COBOL compiler installation/configuration.
· Installed, configured Web server, Application server, Process Scheduler, Report Servers.
· Upgrade and patches on java and Oracle Weblogic for Webserver.
· Upgrade and patching of Tuxedo for application server.
· Configuration and renewal of SSL and Forgot Password feature.
· Download and apply PeopleSoft bundles and patches using PUM image.
· Apply required People Tools patches.
· Apply critical database patches when release by Oracle.
· Perform people Tools Upgrade to latest PT version (8.60) and point patches whenever required by team.
· Migration of PeopleSoft application and database from existing server to another server across the different OS platform.
· Help OS support team (SIS Team) for PeopleSoft /Oracle related kernel parameter tuning.
· Setup new PeopleSoft environment whenever required.
· Create backup & Recovery procedures, copying databases and setup new PeopleSoft environments.
· Taking care of table space related issues like increasing the storage parameter values, resizing the data files, adding new data files etc.
· Enabled/Disable the Database in Archive Log Mode.
· Taking Backup & Recovery using Hot & Cold Backups for oracle Database (Prod and Non-prod).
· Listener and client connectivity configuration and troubleshooting.
· Troubleshooting in case of any problem related to OS / RDBMS / Application.
· Handling day-to-day DBA activities using Oracle utilities and tools, monitoring space and memory requirements.
· Checking Alert Logs, Archive Logs, Trace files and backup verifications
· Cloning the database from existing Database.
· People Books installation.
· Kibana Analytics and Global Search. SES
· Single Sign on for PeopleSoft Applications with other Applications.
· Implementation of LDAP between PeopleSoft and Microsoft AD.
· Troubleshooting PeopleSoft application performance as and when required
Coral
USASJB
Bounteous