Balbinder Singhmailto: %adoc86@r.postjobfree.com

-

Career Profile Summary: - Senior PeopleSoft Administrator

Detailed Oriented PeopleSoft System Administrator with over 20 years of consulting experience. Specializing in ERP Technical Architecture, technology assessments, client-server infrastructure, database systems, performance tuning, support, and troubleshooting during the entire lifecycle of the project and provide quality implementation services. Worked in the areas of architecture (end-to-end), infrastructure sizing, Production Support, administration (i.e., installation, configuration, upgrade, pre-and post-production maintenance, troubleshooting, and performance tuning) of PeopleSoft applications and its associated components, Expert level knowledge of Oracle database, PeopleSoft’s Tuxedo based middle-tier application server and WebLogic web servers. Recognized for technical mastery, superior problem-solving, leadership, quick troubleshooting, relationship building, and strategic planning skills.

Technical Skills: -PeopleSoft Systems Administrator

Expert-level knowledge of the PeopleSoft technology platform and related technologies. (Versions 7 - 9.2)

PeopleSoft Financials, Supply Chain, Campus Solutions, HRMS, Learning Solutions, CRM, EPM, and Portal.

Extensive hands-on experience in PeopleSoft implementations and application upgrades. Have done more than 10 Tools only Upgrades and 5 full application Upgrades. Have worked on many Implementations.

Expertise installing, configuring, maintaining PeopleSoft Application, Application Servers (Tuxedo), Process scheduler servers, Web Servers (WebLogic Versions 6 through 12c), file servers, data archiving, SQR, PeopleCode, App Engine, Crystal Reports, PIA, Security, Upgrade Assistant, Change Assistant

Expert level Experience in applying PeopleSoft patches and fixes, Tax Updates, Updates, and Fixes using Change Assistant.

Expert level PeopleSoft Performance tuning (Identify and fix performance bottlenecks and tune the applications).

Experience in proactively capacity planning and performance sizing of PeopleSoft applications.

Expertise with networking, firewalls, Proxy servers, and Load balancers.

Setup and administer SSL and certificates.

Version Control: - STAT, PHIRE administration, and migrations. UC4, Control-M, Tivoli Schedulers,

Expert-level knowledge setting up or upgrading Elastic Search

Technical Skills: -Senior Oracle Database Administrator

Worked on Versions 7.3 – 19c

Experience maintaining over 60 instances on some occasions.

Expert Level Knowledge on Oracle Performance Tuning, SQL Tuning

Done multiple Oracle upgrades from Version 7 to Oracle 19c.

Database security, Oracle advanced security, data scrambling, Oracle data masking, Transparent Data Encryption

Database monitoring with Oracle Enterprise Manager/Grid Control.

Expect level knowledge on Oracle Database Tuning.

Expertise in setting up DR solutions, standby databases, Data Guard and Active data-guard, and Golden Gate.

Developed backup and disaster recovery plans. setup RMAN backup etc.

Hands-on experience on Oracle Clusterware; Installed CRS, upgrade and patch management of CRS

Installed/Configured 10g/11gR2 RAC and ASM on AIX, Solaris, and Linux

Expert knowledge on database migrations from on-prem to OCI cloud

Oracle Database Administrator Certified Professional: - Oracle 8i to 12c

Oracle Cloud Infrastructure 2019 Certified Architect Associate

Oracle Database Cloud Administrator 2019 Certified Professional

Oracle Certified Expert, Oracle Database 12c: RAC and Grid Infrastructure Administrator

Sr. PeopleSoft Admin – US Department of the Treasury, DC

Feb 2014 - Current

Technologies: PeopleSoft People tools 8.58/8.55, Oracle 11g/12c/19c, Linux 6/7, WebLogic 10.3-12.2, LDAP, RMAN, Tuxedo 10.3/12.2, HRMS 9.0/9.2, STAT 5.7/5.8, SOA suite, Control -M, OEM 13c, SES, PSCBO, Elastic Search, Visual COBOL, Oracle Gov Cloud OCI gen-2

Worked as a PeopleSoft infrastructure lead and designed the Cloud compartments, security lists, policies, groups and worked with the cloud architect/s for the HRMS 9.2 cloud migration (On-prem to OCI Gov Cloud).

Designed, documented the new infrastructure for the cloud move for all the production and non-prod environments. Planned brainstorming sessions within the infrastructure team and reviewed the cloud infrastructure options with the management and various other technical teams.

Planned, participated, and finalized the Lifting and Shifting procedure for the PeopleSoft (HRMS 9.2), Oracle databases (oracle 12c rel 2) to Oracle Gov Cloud (OCI gen 2), and produced the document.

Installed and configured WebLogic, Tuxedo, COBOL, Elastic Search, Control-M, and all other PeopleSoft HRMS 9.2 components on the OCI cloud and successfully tested it.

Compared the baseline performance between on-prem and cloud and then worked on proper sizing and tuned the PeopleSoft Web and App domains on the Cloud. Supported the load test using OATS, Load runner and tuned all the application domains and WebLogic PIA web layer.

On the OCI cloud, Setup daily Oracle database refreshes, Oracle database back-ups, and Oracle data-guard

On the OCI Cloud, Set up PSCBO for PeopleSoft databases.

PeopleTools Upgrade: = Upgraded People tools many times. Upgraded tools from 8.49 to 8.53.06 on HRMS 9.0, upgraded from 8.53 to 8.55, and from 8.55.17 to 8.58.04 HRMS 9.2 after migrating to cloud. applied tools patches as required

Setup PUM server on the OCI Cloud and applied HRMS 9.2 PUM image PI34 on tools 8.58.04.

Upgraded Microfocus COBOL to Visual COBOL and tested all the jobs after the conversion successfully

Upgraded Elastic Search to 7.1 and successfully implemented search components

Created the process for the Peoplesoft Oracle database refreshes from Prod to dev/test environments. Created post-refresh scripts for PeopleSoft DEV/TEST refreshes.

Implemented PeopleSoft Performance monitoring and health center.

Upgraded HRMS 9.0 to 9.2 using PI 9 tools 8.54

Maintained PUM server and applied quarterly Tax updates and other fixes using recent PUM/Change assistant. Apply Change Packages across all development, UAT, and Prod servers

Applied and maintained SSL Certificates.

Created scripts for hourly status reports for Production PeopleSoft.

Fine-tuned integration broker to improve performance. It includes setting up load balanced gateway. Setting up multiple application servers for PUB/SUB in a dynamic slave configuration. Worked on creating queues for Performance tuning.

Configured virus scan (ICAP)for PeopleSoft attachment using Semantics software on new tools and replaced the legacy unixftp process.

Upgraded STAT from 5.6 to 5.7 and worked on the new workflow.

Elastic Search; Upgraded global search and replaced SES

Disaster Recovery Build: Installed and created the PeopleSoft DR environments on the secondary datacenter and delivered the failover document and participated in the DR table-top exercise. Configured Oracle Active data guard.

Database Upgrades: Upgraded Oracle database 11.2.0.4 to 12.1 and document it. Then upgraded 12.1 to 12.2. Upgraded 12.2 to 19c

Converted non-container databases to multitenant CDB/PDB on Oracle 12.2.

Performance tuned the architecture for 2500 user concurrency.

Regular maintenance: = Applied quarterly CPU patches and Grid infrastructure patches on Oracle databases. Also patched WebLogic, Tuxedo, and Java (CPU patches) regularly

Oracle Security: - Evaluated the security reports with the security team. Fixed all the Oracle databases vulnerabilities as per the security compliance required by the US Treasury. Implemented Oracle database hardening and advanced security to secure the databases from vulnerabilities. Worked with the security team, Oracle Support, auditors and resolved the Oracle database and PeopleSoft application security vulnerabilities

Provided PeopleSoft code-migration support, debugging, troubleshooting, and tracing

Provided 24/7 production and on-call PeopleSoft DBA/Admin support

Sr. PeopleSoft Admin – State of Connecticut, Hartford, CT

June 13 – Feb 14

Technologies: PeopleSoft Peopletools 8.52, Oracle 11g, Redhat Linux 5.7, WebLogic 10, NVision, COBOL, LDAP, RMAN, ASM, Tuxedo 10.3, FSCM 9.0, HRMS 9.0/9.2, STAT 5.6,

Unified Navigation, Portal, PSCBO, Oracle RAC, Data-guard, OBIEE 11.1

Upgraded Peopletools from 8.50 to 8.52 for HRMS, ELM and FSCM

Applied bundles using change assistant on HRMS environment.

Performance tuned the architecture for 3,000 user concurrencies.

Created scripts for hourly status reports for Production PeopleSoft.

Setup the new report repository server for HRMS and tested the reports on the new server.

Configured load-balanced gateway for integration broker and setup integration between HRMS and FSCM.

Architect, Install & Configure PeopleSoft HCM 9.2 along with PeopleSoft Upgrade Manager (PUM) and Secured Enterprise Search (SES) Engine.

Routinely downloaded HCM PUM images (DPK) and apply necessary patches including Tax updates

Fine-tuned integration broker to improve performance.

Configured virus scan for PeopleSoft attachment on new tools replacing unixftp.

Upgraded STAT from 5.6 to 5.7 and configured the workflow.

Fine-tuned the application server and helped with the new load balancer (F5) setup and configuration. Created new WebLogic domain PIA’s and configured new hardware load balancer. (F5)

Set up PSCBO for PeopleSoft databases.

Fine-tuned some of the SQL queries using hints, SQL profiles which were continuously showed up in the AWR reports.

Configured data guard broker and tested the fail-over and switch over, configured active data guard on oracle 11gr2 on Linux 6

Loaded data using oracle data pump. fine-tuned data pump jobs

Created shell database and supported the OBIEE 11.1.1.7 implementation activity

Converted the databases to advanced compression, configured and tested the performance

Setup the databases with the TSM tape backup and configured it on RMAN

Created the procedure to clone databases from production RAC to non-RAC ASM. This helped automate most of the manual processes and reduced the refresh timing to one-third.

PeopleSoft Production Support 24/7.

Sr. PeopleSoft Systems Admin– US Dept. of Housing and Urban Development, DC

June 11 – June 13

Technologies: PeopleSoft Peopletools 8.48.17- 8.51, Oracle 11g/10g, Redhat Linux 5, WebLogic 10.3, NVision, COBOL, LDAP, Linux Red Hat 5, RMAN, ASM, Tuxedo 10.3, FSCM 8.8, Revenue Mgt 8.9, FSCM 9.1, Foglight, Autosys, TWS, STAT

Plan, Architect, Installed, and configured PeopleSoft from scratch on all the new servers including tools, microfocus COBOL, WebLogic, Tuxedo, and created all the PeopleSoft Production, dev, test, and DR environments.

Migrated PeopleSoft database Oracle 10g from Solaris 10 to Red hat Linux 5.9

Upgraded PeopleSoft FSCM 8.9 PeopleTools 8.48.07 to FSCM 9.1 PeopleTools 8.51.07

Upgraded Oracle from 10g to Oracle 11g and migrated existing Demo and all the instances from Oracle10.2.0.4 to 11.2.0.3

Applied PeopleSoft Required-for-Install patches including maintenance packs, bundles as required.

Applied WebLogic and tuxedo patches

Perform code migrations using Application designer and with Quest STATS

Addressed the application vulnerability scan report with the Unix and security team

Setup Data-guard for 2 standby databases and opened one (DR Db) for daily reporting purposes. Created shell scripts for process scheduler, application, and web servers.

Performed extensive tuning on Application Servers and Web Servers for both FIN and Revenue Management

Assists team in analyzing requirements, change requests, does impact analysis, and provides estimation. Initiates change requests.

Automated the PeopleSoft nightly refresh for reporting purposes and Provide support of the database cloning from Prod to Dev, Test as required.

Created all monitoring scripts for PeopleSoft Application server, Web and Process Schedulers

Performed tuning on all Tiers: - Web and Application servers based on Load-runner results

Implemented automated RM Process by integrating PeopleSoft Revenue management with the federal treasury(pay.gov)

Provided Production support 7x24 for Tier-3

PeopleSoft Systems Admin/DBA -Government of the District of Columbia, DC

May 2005 – June 2011

Technologies: PeopleSoft HRMS 9.0, HCM 9.0, Enterprise Portal 9.0, Benefit Admin 9.0, ELM, Payroll 9.0, Time and Labor 9.0, Campus Solutions 9.0 for University of DC, Cobol 5, Peopletools 8.49.25, Oracle 11g/10g, AIX5.3, PVCS, Dimensions, PHIRE, BEA WebLogic 9.1, LDAP, FileNet, Linux Red Hat 5, Oracle Enterprise Linux, UC4, Resume Mirror, TAM, RAC, RMAN, ASM

DBA for the PeopleSoft Upgrade environment on PeopleSoft’s HRMS on PeopleTools 8.49.25/8.46.04 and Upgraded PeopleSoft HCM Environment from 8.8 SP1 to 9.0.

Upgraded Oracle from 10g to Oracle 11g and migrated existing Demo and all the HCM instances from Oracle10g to 11g.

Responsible for 24/7 database and PeopleSoft System Administration Production Support of all PeopleSoft applications in HA architecture configuration.

Capacity planning for 30k users performed for PeopleSoft environment

Participated in the planning of the data center move for PeopleSoft and PASS Environments.

Migrated PeopleSoft from AIX to Linux Platform. Designed the new architect layout of all the servers and physical layout for HA. This Linux move was on VM Ware.

Install PeopleSoft application 9.0 on Linux 5 and 8.8 version on AIX IBM p-series servers

Worked as a Technical lead for PeopleSoft HRMS implementation. Worked as a PeopleSoft

admin lead for Payroll implementation and other modules.

Installed PHIRE for PeopleSoft migration and created workflow and used it for migrations.

Written shell scripts for refreshing/cloning of development instances, backups, and restores

from the Production environment. Set up shell scripts for daily PIA maintenance and other

monitoring scripts for Application servers.

Configured the interfaces supported by PeopleTools 8.49.25 using the Gateway Integration

broker, web services that removed the need for flat-file transfers.

Implemented Resume Mirror (Talent Acquisition Manager) for eRecruit.

Worked on data conversion performance tuning during upgrades.

Applied bundles/upgrades, quarterly tax upgrades as required using change assistant, and then

Synced different environments

Applied SSL certificate on present production and maintained self-signed certificates for

other non-production environments.

Brought down Time & Labor & payroll time processes to 1/3 rd of time.

Set up DBMS_STATS and PSCBO for PeopleSoft databases.

Created training environment and masked data using Oracle data masking pack.

Implemented Oracle 10g two-node RAC for PeopleSoft and PASS. Converted single instance

to RAC.

Re-Architecture and Stabilize the current production environment for 3500 concurrent users

by Recommending web-servers clustering and adding a physical load balancer (Used BigIP

F5).

Database High Availability Failover Design: Implemented data guard in maximum

availability mode to provide reliability for disaster by implementing two different physical

locations (data centers) and/or switching over to any one of these sites for maintenance

purposes.

Troubleshooting and Performance Tuning: This is one of my major tasks here to troubleshoot

performance problems either at the Oracle level or PeopleSoft technology. I solved many

performance and system-related issues.

Sr. PeopleSoft Admin -Health Insurance Plan of NY (Independent Contractor), NY

Oct 03 –May 05

Technologies: PeopleSoft HRMS 8.8sp1, FCM 8.0, EPM8.0, CRM8.0, Enterprise Portal 8.0, Benefit Admin 8.0, ELM, Payroll 8.0, Time and Labor 8.0, People tools 8.49.16, Oracle 9i/10g, Solaris, WebLogic 8, LDAP, Kronos, FileNet, Hyperion, Linux, RAC, ASM, Foglight

PeopleSoft architect for designing all PeopleSoft environments including hardware and

architectural design and physical and logical layout

Analyzed and prepared the hardware specifications for PeopleSoft Application and other

Oracle instances on Solaris and NT servers.

Provided development and production support included replicating

production environments, applying patches, testing or troubleshooting new features

Upgrade and administrator lead all HCM, ELM, FDM, Enterprise Portal, and CRM upgrade.

(Upgraded PeopleSoft 8.8 sp1 to 9.0 using Change Assistant)

Created, monitored, and administered different PeopleSoft environments for Upgrades,

conversion and Implementation.

Configured remote and load-balanced Integration gateway for CRM and HCM integration.

Implemented e-performance, e-recruit, etc., for HR modules

Troubleshoot performance-related issues and all other technical issues for upgrade and

conversion.

Supported and maintained several Oracle 10g RAC databases.

Installed and created All Oracle 10g instances. Upgraded existing Demo and CRM and all

instances from Oracle 9i to Oracle 10g.

Resolved issues in Production environments related to application administration, database,

web servers, application servers, process schedulers

Performance tuned Tuxedo and WebLogic Web servers

Benchmarked and monitored threshold for Performance using PeopleSoft performance

monitor and OEM.

Configured help and forgot password.

Implemented SSL using VeriSign certificates.

Installed and Validated Patches and fixes for PeopleSoft and applied CPU patches to Oracle.

Backup and Recovery Policies: - Created and implemented RMAN Oracle backup and

recovery methods and recovered databases many times using RMAN.

Setup Single Sign-on between Enterprise Portal with FCM, HCM, and CRM.

Configured Oracle 10g Data guard and Used 10g Data Guard for HA and did Fail-over

multiple times.

Developed the migration strategy and change control.

Oracle DBA – ADP, NY

January 2002–October 2003

Technologies: Oracle 8.1.7.1, WebLogic 5.10, PVCS, AIX 5.1, Solaris 8, Oracle 9i, RMAN, RAC, RAID, OEM, DBArtesan, Foglight

Oracle Database Performance Monitoring and Tuning: - Used various tools such as

DBArtisen, STATSPACK, OEM, Explain plan, TKPROF, etc.

Applied Patches and Fixes to PS environment as required.

Created PeopleSoft databases - Development, Demo, System, Test, QA, and Production

environments. All databases were created on Oracle 9i.

Setup High-level and technical component layout architecture for Financials & HR upgrades

projects.

Oracle database installation, patches, upgrades to 9i on RAW, RAID, VERITAS clustered

devices.

Refreshed, backed up, and recovered databases. Created, cloned, and configured new databases.

Performed SQL statement tuning on complex queries

Created a shell script for refreshing /cloning databases automatically using Oracle hot backup

which replaced the manual process of Daily refreshing or refreshing on-demand.

Helped the testing team with the load runner scripts and used load runner for load and

regression testing

Prepared and documented disaster recovery procedures for all Production systems and

participated in DR testing at the remote site.

On-Call Production Support, troubleshooting, and client support. Member of the Change

Control board (CCB).

PeopleSoft Oracle DBA - Juvenile Courts (Justice Center), WA

January 2001-January 2002

Technologies: PeopleSoft HRMS 8.8, Peopletools 8.19, Oracle 8/8i/9i, Web logic 5.10/6, PVCS, AIX 5.1, Solaris 8, PeopleSoft 8.8, App Designer, Data-mover

Implemented PeopleSoft HR8.8 and PeopleTools8.19 with Oracle8i/9i.

Installed and configured four-tier PeopleSoft HRMS8.3, financial8.42, portal8.4x and

EPM8.4x demo, development, test, and production databases.

Implemented Failover/Switchover site for production database

Written documentation for the various DBA activities such as Maintenance, Standby

database, Configuration, and installation

Reorganized/de-fragmented the databases using Imp/exp or rebuild where necessary.

Created and maintained batch jobs.

Upgraded Oracle from version and 8.1.7 to 9i (R2)

Configure Kernel parameters on Sun Solaris and Install Oracle9i binaries and created new

instances.

Troubleshooting: - One of my main responsibility is to troubleshoot, support and

Performance tune all the environments. This implementation is very big, and downtime is not

acceptable and for every ticket, I need to track time spent on the ticket and document the

process. I had the best record for closing tickets in the least time. 90% of tickets are resolved

by me.

Worked closely with development, conversion, and testing teams for granting them access,

applying their project, performance tuning for SQL

Patches, upgrades, and project migrations: helped development team with daily support,

migrations, tracing, and debugging.

Certifications:

Oracle Certified Database Administrator (OCP) Oracle 8i – 12c

Oracle Database Cloud Administrator 2019 Certified Professional

Oracle Cloud Infrastructure (OCI) Architect Associate 2019

Oracle Certified Expert, Oracle Database 12c: RAC and Grid Infrastructure Administrator

Academic:

Master of Business Administration, Amity University, India (MBA Specialization in IT)

Contact this candidate