Mohammed Musa Nabisha (PeopleSoft DBA)

201-***-**** (acxjyj@r.postjobfree.com)

9+ years of hands-on experience in PeopleSoft Architect, Administrator/DBA, PUM (PeopleSoft Update Manager), DPK, Portal 9.1, HCM 9.1/9.2, CRM 9.0, FSCM 9.1 using WebLogic 11g/12c, Tuxedo 11g/12c and Oracle 10/11g, SQL Server, DB2 database environments. Expertise in administration, installation, maintenance, tax updates (using PUM/DPK), SES, performance tuning, upgrading, patches and production support for large PeopleSoft environments.

Administration expertise in People Tools 8.53.15, HCM 9.2 Payroll HR, Time and Labor, Benefits Administration, change management, CRM 9.0 (helpdesk and support).

Expertise in Oracle Database Administration, Oracle 10/11g, installation, upgrade, patching, RMAN, Schema export/import, setting up Oracle Data Guard for DR and failover database. Business Objects 6.1, IBM AIX 5.3, HP UNIX 11.31, RH Linux 6.6, Windows: XP/2000/2003/2008/2012 Server Edition, Toad, STAT 5.5/5.6/5.7.3, FTP, SFTP, WS_FTP, WINSCP, LDAP, Tomcat, Apache, Vista, Capture.

EDUCATION

Bachelor Degree,

PSG College of Technology, Anna University.

EXPERIENCE

Sep 2015 – Present JPMorgan Chase, Columbus, OH

Database Management Analyst

•Providing PeopleSoft DBA support for PeopleSoft HCM 9.2, Portal Solutions 9.1 for dev, Test, QA and production environments using Oracle 11g/10g on RHEL Linux 6.6 servers.

•Performing PeopleSoft database refresh as per the developer’s request and restoring from RMAN prod database backup.

•Helping developers in Oracle PeopleSoft Administrator/DBA skills in creating Oracle users, granting roles, executing SQL scripts, refreshing PeopleSoft databases using RMAN export/import.

•Installed, configured Oracle Enterprise Manager Cloud Control 12c for administration, performance tuning and monitoring number of oracle 11g databases.

•Implemented RMAN backup strategies and developed various shell scripts to take RMAN cold and incremental databases backup with backup success or failure email notification in shell scripts.

•Expertise in performance tuning of PeopleSoft batch processes with AWR, SQL Tuning, SQL Trace.

•Providing support for FSCM/Financials 9.1 with People Tools 8.53.11, WebLogic 10gR3 multi-server using Oracle 10g on AIX 6.0.

•Configured load balanced app servers using Tuxedo 10gR3 for Prod, user acceptance, test, dev and demo PeopleSoft environments using Oracle 10g.

•Configured load balanced web server and multi servers PIA using Web logic 10gR3 for Prod, user acceptance, test, dev and demo PeopleSoft environments.

•Expertise in Tuning app server configuration files for “Max clients per handlers”, “no of handlers” and max “PSAPPSRV” and other processes and configuring app server load balancing.

•Expertise in Tuning web server/load balancing for optimal performance of HCM and FSCM applications using appropriate “PIA” heap size configurations in multi-server web server environment.

•Configured SSL, active directory, configured certificates, Single sign on, apply Tax updates, bundles, and configuring application messaging using Integration broker for all PeopleSoft environments.

•Dell STAT 5.7.3 Administrator/migrator for People Tools/Downstream applications data object/File migrations and CSR tracking.

•Implemented PUM/DPK for regular Tax updates via Oracle virtual VM and Native OS methods and applying Tax updates on HCM9.2 (recent Image 17)

•Integrated and configured Tomcat/Vista/Capture/Apache with PeopleSoft for reporting purpose to Business users.

•Completed Architecture migration from VSI to PSI on Linux servers.

•Liaising with Oracle GSC to address product issues, and to deploy quality work-around to the problems

Oct 2011 – Sep 2015 Cushman & Wakefield Inc., NY

PeopleSoft DBA and UPG Administrator

•Successfully completed App Upgrade from PeopleSoft HCM 9.1 / PT8.51.05 to PeopleSoft HCM 9.2 / 8.54.05, Oracle 11g, Linux servers, working as PeopleSoft admin to upgrade, support and monitor PeopleSoft environments.

•Configured PeopleSoft HCM 9.2 upgrade environment to start upgrade process i.e. setting up change assistant, setup PeopleSoft Update Manager (PUM), downloading template from oracle support, creating change assistant 8.54.05 job and follow through all the steps in change assistant job to finish the upgrade.

•Applied PeopleSoft updates into upgraded HCM 9.2 environments using Image 11 to HCM 9.2 DEMO, DEV and Test environments using PeopleSoft Update Manager (PUM).

•Installed and configured new Demo PeopleSoft HCM 9.2, PT 8.54.05 binaries, PeopleSoft Update Manager (PUM) Installed Tuxedo 12c configured application servers, configured PIA using WebLogic 12c web servers.

•Planning future releases, server maintenances, planning OS/ Oracle / PeopleSoft patches, fixes and bundles, applied Tax updates from PUM in HCM 9.2 upgraded environments.

•Successfully fixed on performance tuning on upgrade long running jobs to shorten the cutover upgrade timeline, fixed long running data conversion jobs by running Oracle AWR reports, finding long running SQL ID. Created Oracle database indexes, run STATS to improve SQL performances.

•Performed the Cloud migration from Oracle host (OMCS) to Customer On-premise.

•Successfully implemented the LDAP in Cushman Active Directory server.

•Automated the Daily refresh activity in SQL server 2000 for HR 8.8 and FIN 8.9 Non-Prod environments.

•Automated weekly maintenance using Windows batch and Linux Shell scripts.

Oct 2010 – Sep 2011 Norwegian cruise line, Miami, Florida

PeopleSoft DBA

•Proving PeopleSoft DBA support for PeopleSoft FSCM 8.8, HCM 9.0/9.1 using PT 8.45/ 8.49/ 8.50/ 8.51 for development Test, QA and production environments using Oracle 10g IBM AIX 5.3, HP Unix 11.31 servers.

•Upgraded the People Tools from 8.49.15 to 8.51.08.

•Installed and Configured the PeopleSoft Environments on Oracle 10g.

•Helping developers in Oracle PeopleSoft Administrator/DBA skills in creating Oracle users, granting roles, executing sql scripts, refreshing PeopleSoft databases.

•Expertise in performance tuning of PeopleSoft batch processes and SQL Tuning.

•Applied all the NA Payroll Tax Updates from 8A to 11C to the demo, development and Production databases.

•Deployed Critical Patch Updates as per Oracle release.

•Configured load balanced app servers using Tuxedo 10gR3 for Prod, user acceptance, test, dev and demo PeopleSoft environments.

•Configured load balanced web server and multi servers PIA using Web logic 10gR3 for Prod, user acceptance, test, dev and demo PeopleSoft environments.

•Expertise in Tuning app server configuration files for “Max clients per handlers”, “no of handlers” and max “PSAPPSRV” and other processes and configuring app server load balancing.

•Expertise in Tuning web server/load balancing for optimal performance of HCM and FSCM applications using appropriate “PIA” heap size configurations in multi-server web server environment.

•Configured SSL, active directory, configured certificates, Single sign on, apply Tax updates, bundles, and configuring application messaging using Integration broker for all PeopleSoft environments.

•Using Quest STAT for People Tools data object migrations.

May 2007 - Oct 2010 Cognizant, India

PeopleSoft DBA

•Installation, Upgrade and Configuration of PeopleSoft HRMS 8.9, FSCM 8.8, ELM 9.0, DB2 8.2 binaries, databases and optimizing all database performance including the design, creation and structural integrity of database objects in the production environment.

•Configured the People Books in Production Environment.

•Worked on Tuning the Database, web server, application server and Process schedulers.

•Installed and configured the Micro focus/Server express COBOL for HRMS.

•Installed and configured and worked as a BO Administrator.

•Planning future releases, server maintenances, planning OS/ Oracle / PeopleSoft patches, fixes and bundles.

•Installed and configured new Demo PeopleSoft HRMS 8.9, FSCM 8.8, ELM 9.0 with People Tools (8.46/8.49/8.50), Installed Tuxedo 8.1 and Web logic 9.1.

•Expertise in PeopleSoft objects migration using application designer, file copy on windows and Unix servers, used Quest STAT 5.X.

•Upgraded People tools from 8.49 to 8.50 for HRMS 8.9.

•Implemented the UNIX and Batch script to auto feed the HCM Production data to the third party.

Contact this candidate