Subhransu Mishra
PeopleSoft Administrator/DBA
Hire this person
Send a job offer directly to this candidate
About
20 years of experience in PeopleSoft 9.x/PeopleTools 8.5x–8.63 Systems Administration and Oracle Database Administration across Windows and Linux/RHEL environments.
Strong
PeopleSoft skills with experience in several Implementation, Migration to AWS and Oracle Cloud, multiple major Upgrades to current Update Images of PeopleSoft CS 9.2, HCM 9.2, FSCM 9.2, PeopleTools 8.62/8.63 and Production Support of PeopleSoft environments.
Deployed
PeopleSoft Update Images through Change Assistant and PUM to most current Images in FSCM, IHUB and Campus Solutions/HCM/ELM 9.2 environments creating Upgrade plans and documenting all tasks. Strong experience in automated Upgrade tools setting up Change Assistant, PUM and creating Change Packages including Tax Updates and all associated PRPs and apply them to FSCM/HCM/Campus Solutions 9.2/PeopleTools 8.61 DPKs with Puppet/Hiera/Yaml, Oracle 19c/23ai client on Windows 2019/2022 R2 and Linux 7 servers. Extensive experience with PeopleSoft Financials 9.2 and PeopleTools 8.61/8.62/8.63, including installation, configuration, administration, patching, upgrades, PUM, Change Assistant, DPKs, and production support on Red Hat Enterprise Linux (RHEL).
Hands-on experience with Oracle Database 19c/23ai, including SQL queries, stored procedures, database triggers, database refreshes, backup/recovery, performance monitoring, tuning, and Oracle Enterprise Manager.
Experience with Go (Golang) development and migration of existing Go programs to PeopleSoft Application Engines/SQR. Hands-on experience developing, configuring, enhancing, and supporting PeopleSoft Fluid pages, dashboards, Work Centers, and Activity Guides. Extensive experience using STAT migration tools for PeopleSoft object migration across DEV, TEST, and PROD environments, including STAT v7.0.
Experience integrating PeopleSoft with Oracle EPM, Coupa, and Okta security/SSO environments. Experienced in configuration and ERP business process improvement of PeopleSoft applications using Oracle 19c databases including 6 years of PeopleSoft implementation and upgrade in Public Sector environment such as US Air Force, US Army, 2 state universities and colleges.
Experience in Load Balancing, PeopleSoft application security, PeopleSoft object migration using Application Designer, STAT and Phire, and Stress Testing using HP LoadRunner. Strong knowledge in setup and configuration of LDAP, Integration Broker, Single Sign On, Application Messaging, PeopleSoft Data/Objects Migration using Application Designer and Phire and Data Mover, install and run COBOL compiler. Strong experience in PeopleSoft database refreshes in Oracle and SQL Server(using SQL Management Studio), backup/recovery, tablespace management, performance monitoring and tuning using Oracle Enterprise Manager 19c.
Provide knowledge transfer to PeopleSoft Administrators and DBAs in resolving application and database issues, resolve SYSAUDIT/DDDAUDIT exceptions, create SRs with Oracle Support.
Experience
PeopleSoft Administrator - State of Texas
(2025-08 - 2026-07)
- Created and managed the PeopleSoft FSCM 9.2 and HCM 9.2 environments on premise and in Oracle Cloud with Application Servers, Process Schedulers and Web Servers for non-PROD and PROD environments running with PUM images and PeopleTools 8.62/8.63 DPKs on Windows 2019/2022 and Linux 7/8/9 platforms and configuring Change Assistant to deploy PUMs into non-PROD and PROD environments.
- Performed a PeopleTools 8.62.03/8.62.07 upgrades from PeopleTools 8.59.18 on PeopleSoft Financials 9.2 application Image 48 using Change Assistant, Upgrade template etc.
- Performed PeopleTools 8.63 upgrades, patching, configuration, and administration for PeopleSoft Financials 9.2 environments, including development, test, and production instances.
- Administered Oracle Database 19c/23ai environments supporting PeopleSoft Financials 9.2, including development and optimization of SQL queries, stored procedures, database triggers, backup/recovery, database refreshes, and performance tuning.
- Developed and supported Go (Golang) programs and assisted with migration of Go-based functionality to PeopleSoft Application Engines/SQR.
- Used STAT v7.0 to migrate PeopleSoft objects and application changes across DEV, TEST, and PROD environments.
- Supported integrations between PeopleSoft Financials and Oracle EPM, Coupa, and Okta, including authentication, SSO, and security integration.
- Installed, configured and deployed Elasticsearch and Open Search after downloading and installing Elasticsearch/Open Search DPKs in dedicated Search Servers for non-PROD and PROD environments configuring PeopleSoft with Global search.
PeopleSoft Administrator - St. Petersburg College, FL
(2023-11 - 2025-06)
- Performed a PeopleTools 8.61.04 upgrade from PeopleTools 8.59.12 on PeopleSoft Financials and Campus Solutions 9.2 application Image 46 using PUM, Campus Solutions PUM 34, DPKs and Puppet.
- Set up and configure Change Assistant and performed PUM upgrades, PeopleTools Upgrades on FSCM and Campus Solutions 9.2 environments for upgrade to 8.57 and 8.58 from 8.55 and 8.56.
- Administered PeopleSoft Financials and Campus Solutions 9.2 on OCI with Red Hat Enterprise Linux, including installation, configuration, patching, environment refreshes, application server, web server, and Process Scheduler administration.
- Performed database administration activities on Oracle 19c, including SQL queries, stored procedures, triggers, performance monitoring, database refreshes, and troubleshooting.
- Developed and enhanced PeopleSoft Fluid pages and components supporting Fluid Dashboards, Work Centers, and Activity Guides.
- Provided PeopleSoft Security roles and privileges to users based on their roles/duties and other security related issues including Query security.
- Performed PeopleSoft Projects and Objects migration using Application Designer and Phire from DEV to TEST to PROD database/environment following proper workflow in place.
- Worked on PeopleSoft Workflow, AWE, Fluid Dashboards, Work Centers, Activity Guides.
PeopleSoft Administrator - TCS - New Jersey, NJ
(2019-08 - 2023-10)
Healthcare client - Covance
- Create and managed the PeopleSoft HCM 9.2 and FSCM 9.2 environments on-premise and in Oracle Cloud with Application Servers, Process Schedulers and Web Servers for non-PROD and PROD environments running on PeopleTools 8.56/8.57 on Windows 2016/2019 and Linux 6 platforms for multiple clients and configuring Change Assistant to deploy PUMs into DEV, TEST and PROD environments.
- Resolved trouble tickets created and assigned through GSEP (ServiceNow) ticketing system.
- Assisted in migration of on-premises PeopleSoft Database to AWS using the AWS Database Migration Service (AWS DMS) in continuous data replication mode for replicating the on-premises production database to the secondary database on AWS for second client.
- Worked with PeopleSoft integration with MuleSoft’s Any point platform.
- Coordinated the effort of creating and submitting ServiceNow requests/RITMs on various PeopleSoft issues and login access for resources for approval by upper management.
- Generated nVision reports and SQL queries and executed them in various Peoplesoft databases including Production.
- Setup and configured BI Publisher, CI, Report Node Distribution, Integration Broker, Single Sign On, LDAP authentication, and SSL certificates on WebLogic webservers.
PeopleSoft Administrator/DBA - Acro Corp at State of Indiana, IN
(2017-05 - 2019-07)
- Installed and deployed FSCM 9.2, HCM 9.2, and IHUB 9.1 current images, PeopleTools 8.57 DPKs with Puppet/Hiera/Yaml, Oracle 12c client on Windows 2012, Linux and AIX servers.
- Set up and configure Change Assistant and upgraded HCM 9.1 to 9.2 (through Update Image 24 – PUM).
- Resolved trouble tickets created and assigned through Phire and ServiceNow ticketing system.
- Created and configured PeopleSo
