Post Job Free

Resume

Sign in

Peoplesoft Administrator Oracle Database

Location:
Denton, TX
Posted:
July 06, 2023

Contact this candidate

Resume:

Subhransu Mishra

adx44x@r.postjobfree.com 940-***-****

PeopleSoft Administrator/DBA

** ***** ** ********** ** PeopleSoft 9.x/PeopleTools 8.5x/8.60 Systems Administration and Oracle Database Administration on Windows 2019/2022 and Linux servers.

Strong PeopleSoft skills with experience in several Implementation, Migration, multiple major Upgrades to current Update Images of PeopleSoft HCM 9.2, FSCM 9.2, PeopleTools 8.60 and Production Support of PeopleSoft environments such as DEV, TEST, SIT, UAT and PROD.

Applied PeopleSoft Update Images through Change Assistant and PUM to various FSCM (through Update Image 46), IHUB (Update Image 8/9) and CS/HCM/ELM 9.2 (most current Update Images 45) 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/CS 9.2/PeopleTools 8.60 DPKs with Puppet/Hiera/Yaml, Oracle 19c client on Windows 2019/2022 R2 and Linux 7 servers.

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 and 2 state universities.

Install and deploy Elasticsearch including its administration and configuration and setting up the Environment Management Framework and Environment Management HUB.

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/issues, create SRs with Oracle Support.

Technical Skills Summary

ERP Packages: PeopleSoft HCM, FSCM 8.x and 9.x, Interaction Hub 9.1, OBIEE, Oracle EBS

Database Systems: Oracle 19c, SQL Server 2019/2022, Sybase, DB2

Tools: PeopleTools 8.5x/8.60, Oracle VirtualBox/Native OS, PUM, DPKs, Puppet, Hiera, Yaml, Change Assistant, BI Publisher, Web Center, AWS, Azure, Oracle SES, Elasticsearch, PeopleSoft Verity, App Designer, Data Mover, COBOL Compiler, Agile, UPK, Phire, STAT, Foglight, HP Load Runner, OEM, RMAN, RAC, Data Guard, Exadata, ServiceNow, Control M

Middleware Software: Java JDK 1.8/11, BEA Tuxedo (12c, 14c), WebLogic (12c, 14c)

Hardware: SUN, HP, IBM PCs, Dell PCs, HP & other laptops, Intel PCs

Web Technologies: ASP. NET, HTML, XML, Java Script

Operating Systems: Windows 2019/2022, Linux 7, HP-UX, Solaris, AIX

Languages: SQL, PeopleSoft/PeopleCode, C, Unix shell scripting

Networking Software: Citrix, VPN, TCP/IP, FTP, SFTP, DHCP

Professional Experience

TCS, New Jersey, NJ Aug 2019 – Jun 2023

PeopleSoft Administrator

Managed the PeopleSoft HCM 9.2 and FSCM 9.2 environments with Application Servers, Process Schedulers and Web Servers for DEV, UAT, SIT and PROD environments running with PeopleTools 8.58/8.59/8.60 on Windows 2019/2022 and Linux 7 platforms.

Performed a PeopleTools 8.60.03 upgrade from PeopleTools 8.58.10 on PeopleSoft Financials 9.2 application Image 46 using PUM, DPKs and Puppet.

Set up and configure Change Assistant and performed PUM upgrades, PeopleTools Upgrades on FSCM 9.2 environments for upgrade to 8.57 and 8.58 from 8.55 and 8.56.

Resolved trouble tickets created and assigned through GSEP (ServiceNow) ticketing system.

Created and configured PeopleSoft Application servers, WebLogic web servers, Process Scheduler servers on Linux 7 and Windows 2016/2019/2022 servers.

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 SQL queries and executed them in various Peoplesoft databases including Production.

Setup and configured Report Node Distribution, Integration Broker, Single Sign On, LDAP authentication, Elasticsearch and SSL certificates on WebLogic webservers.

Provided PeopleSoft Security roles and privileges to users based on their roles/duties and other security related issues including Query security.

Worked on PeopleSoft Workflow, AWE, Fluid Dashboards, Work Centers, Activity Guides.

Acro Corp at State of Indiana, IN May2017 – July 2019

PeopleSoft Administrator/DBA

Installed, applied 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 PeopleSoft Application servers, WebLogic web servers, Process Scheduler servers on Windows 2012 R2 and Linux RHEL 7 servers to support Development and Upgrade initiatives.

Created Unix Shell scripts for PeopleSoft database monitoring, start and stop App/Web/Batch server domains for non-Prod and Production databases via cron jobs.

Configured Report Node Distribution, Integration Broker setup and manage app messaging.

Performed PeopleSoft/Oracle database refreshes, performance monitoring including using PeopleSoft Performance Monitor and tuning.

Training and Webinars Dec 2016 - Apr 2017

Completed online training on PeopleSoft/Oracle Cloud, AWS and Azure.

Completed webinars on PeopleSoft Fluid technology, Oracle SES, PeopleSoft 9.2 and PeopleTools 8.55 and PeopleTools 8.56.

Collabera at Wells Fargo, Wisconsin May 2015- Nov 2016

Senior PeopleSoft Administrator/DBA

Installed and configured PeopleSoft FSCM 9.1, Oracle Utilities Customer Care & Billing (CC&B), integrated with FSCM and installed PeopleTools 8.52 on Windows/Linux servers.

Applied the PeopleTools 8.52 Upgrade to PeopleSoft FSCM 8.8 and FSCM 9.0 and PeopleTools 8.50 environments running with Oracle 11g on Windows 2008 R2 servers.

Upgraded the FSCM 9.0 environments to FSCM 9.1 and upgraded PeopleTools 8.52 to 8.54/8.55.

Applied Tax Updates and retrofitted customizations to FSCM 9.1/PeopleTools 8.55 environments.

Installed, configured, deployed Elasticsearch/EMF on Oracle 11g/12c databases for FSCM and HCM 9.1 to configure search application, monitor crawl progress, search quality, and customize search results.

Created Unix Shell scripts for PeopleSoft Database monitoring and maintenance .

IBM Corporation at US Air Force, San Antonio, TX Jan 2014 - Feb 2015

Senior PeopleSoft Administrator/DBA

Configured the Windows 2008 and Linux x86_64 servers, applying all Linux packages for Oracle 11g (11.2.0.4) databases, created logical volumes on Linux servers, performed Capacity planning, storage allocation, disk layout for Oracle databases for PeopleSoft FSCM, HCM, and IHUB 9.1.

Installed Tuxedo 11gR1, Java/JRE 1.7.0_65 and WebLogic 11g on Linux x86_64 servers.

Installed, integrated and implemented PeopleSoft Financials 9.2, HCM 9.2, CRM 9.2, PeopleTools 8.53 on Windows 2008 and Linux x86_64 servers.

Created, configured, and administered PeopleSoft Application Servers, Web Servers, Batch Servers, and Database Servers on all Windows and Linux servers.

Configured Report Node, Node definitions and integration gateways, Application Messaging, Single Sign On, and LDAP authentication, monitored and tuned the app/web servers and performed database refreshes.

Hewlett-Packard at Conway, Plano, Texas Oct 2011 - Dec 2013

Senior PeopleSoft Administrator

Installed and upgraded PeopleSoft 9.x Financials modules essentially AP, AR and GL, CRM, EPM, and HCM, integrated and implemented HR, Benefits Administration, Payroll, migration and SOA, HCM and People Tools 8.5x on Windows 2008 using Change Assistant, Linux, AIX, and HP/UX servers.

Created, configured, and administered PeopleSoft Application Servers, Web Servers, Batch Servers, and Database Servers on all Windows and Unix servers, and data integration.

Configured Integration Broker, Application Messaging, Single Sign On, and LDAP authentication, monitored and tuned the app/web servers and performed database refreshes.

Installed, configured and deployed Foglight Agents in PeopleSoft environments to monitor health of Web, Application and Process Scheduler Servers.

Accenture at US Military, San Antonio, Texas Oct 2007 - Oct 2011

Senior PeopleSoft Administrator

Installed and upgraded PeopleSoft 9.x Financials and EPM, integrated and implemented modules such as Benefits Administration, HR, Payroll, HCM and PeopleTools 8.5x on Windows 2008, Linux, AIX, and Solaris servers.

Assisted functional teams in creating test scripts, test cases for AP, AR, GL and HR and Payroll.

Created, configured, administered, monitored and tuned PeopleSoft Application Servers, Batch Servers and Web Servers processes and performed Oracle database monitoring and tuning.

Configured Integration Broker, Application Messaging, Single Sign On, and LDAP authentication, performed database refreshes, used STAT and Phire for migration.

Education

M.S. in Computer Science

San Diego State University, San Diego, California



Contact this candidate