SUMMARY

• More than 5 years of experience in implementing, upgrading and supporting PeopleSoft Database Administration (DBA), including HRMS, FSCM, ELM and Portal.
• Installed and Supported PeopleSoft Application on different operating systems like AIX, Linux and Windows.
• Solid understanding of PeopleSoft technical architecture and tools like, Application designer, Data mover and SQR.
• In - depth knowledge of Oracle Database Administration.
• Well experienced in applying PeopleSoft application bundles, Maintenance Packs and Fixes.
• Very good understanding of Integration broker configuration between PeopleSoft Applications and 3rd party applications.
• In-depth knowledge of creating users, roles and permission lists in PeopleSoft Security.
• Performed People tools only upgrade
• Configured and Supported Single Sign on, Application server high availability and Active directory authentication.
• Tuned and improved PeopleSoft Applications performance which includes Application Server and database.
• Well experienced in writing shell scripts to automate PeopleSoft and Oracle Database Activities.
• In-depth knowledge in Data refresh from Production to non-production environments and database cloning procedures.
• In-depth knowledge on migrating code from Development instance to Production systems using Application designer and Data Mover.
• Supported large user base globally and resolved critical issues in time.
• Excellent communication, interpersonal and analytical skills.
• Worked in 24/7 support teams and provided on call support.

TECHNICAL SKILLS

Databases: Oracle 11g,10g, MS SQL server

Servers: BEA WebLogic, BEA Tuxedo

Platform: AIX, Oracle Linux, Windows

Languages: SQL, PL/SQL, Unix Shell

Applications: People Tools 8.49, 8.5x. PeopleSoft HRMS,FSCM,ELM and Portal

PROFESSIONAL EXPERIENCE

Confidential, Raleigh, NC

PeopeSoft Database Administrator

RESPONSIBILITIES:

• Installing and Maintaining PeopleSoft Environment (DEV, TST and PRD) with People tools 8.52and HRMS 9.1ML instance.
• Applying Maintenance Pack and bundles for the HRMS 9.1 Environment using Change Assistant.
• Setup and configuration of Application server, web server and process scheduler domains for the DEV, TST and PRD environment.
• Responsible for cloning and refreshing development, test databases with production data.
• Migration of PeopleSoft code from non-production (DEV, TEST) environment to production database.
• Scheduling Oracle Database Exports for PeopleSoft environment.
• Installing People Books for PeopleSoft Instances and Configured help.
• Installing Weblogic and Tuxedo 10g on UNIX.
• Experienced in Applying Tuxedo rolling patches.
• Developed and automated shell scripts to monitor the application server and process scheduler performance.
• Troubleshoot and fix performance issues with Application server and Web server.
• Implemented Single Sign On between PeopleSoft Applications.
• Configured SSL for Production Instance with VeriSign 128 bit SSL Certificate.
• Configured high availability for Application Servers.
• Configured LDAP and Active directory Authentication.
• Configured integration broker between PeopleSoft Applications
• Adding Languages for PeopleSoft database, post installation of PeopleSoft Database.
• Monitoring the Production instance using Topaz monitoring tool and troubleshoot the performance issues.
• Maintaining PS-Databases and health monitoring, proactively working on space management issues with Database using shell scripts.
• Maintain all the hardware, software installations,modifications,implementations in TFS Request System.
• Supported large number of environments and provided on call support for critical issues.

ENVIRONMENT: People Tools 8.52/HRMS9.1ML, Web logic 11g,Tuxedo 11g, Oracle 11g

Confidential, Buffalo, New York

PeopleSoft Database & System Administrator

RESPONSIBILITIES:

• Creating and Maintaining PeopleSoft 8.50/HRMS 9.0environments.
• Applied Maintenance Packs for the DEV/TEST and PRD Environment.
• Installed Oracle 11g on windows and UNIX servers.
• Configured Application server, web server and process scheduler domains.
• Responsible for cloning and refreshing development, test databases with production data.
• Troubleshooting Application server, Process scheduler performance issues.
• Applied People tools 8.50 tools patch for the Environment.
• Involved in People Tools only upgrade
• Tuned Application servers, Web server and Process Scheduler performance issues.
• Configured Integration Broker and Application messaging.
• Configured People tools workstation clients for development team
• Exported PeopleSoft Security to preserve and import the security post refresh.
• Responsible for project migration, applying patches and fixes and tax updates, and database activities like Database Refresh, tuning and security tasks.
• Escalating critical issues to Oracle Support Analyst and following up the case.

ENVIRONMENT: People Tools 8.50/HRMS9.0ML, Web logic 11g,Tuxedo 10gR1, Oracle 11g

Confidential

Peoplesoft Database & System Administrator

RESPONSIBILITIIES:

• Installed and configured PeopleSoft 8.9HRMS, FSCM and PORTAL with People Tools 8.49
• Configured PeopleSoft Web serverdomain in DMZ Server Zone to host career website for HCM.
• Setup, configuring and administration of PeopleSoft Application server, Process Scheduler, Web Logic server.
• Load balancing App server domain based on User load.
• Maintaining People Tools and Application Backups and Installing People Books.
• Responsible for project migration, have applied fixes, patches and Maintenance Packs for PeopleSoft Instances using Change Assistant Tool.
• Responsible for refreshing non-production environments using production data, run the post refresh scripts to scramble data.
• Configured n-Vision report for Development Team.
• Created and implemented new procedures for Oracle Database backups and restore.
• Collecting Periodical Database Statistics for better performance.
• Set-up and maintain documents and standards.
• Escalating Issues related to PeopleSoft Applications to Oracle Support and coordinating with Analyst.

ENVIRONMENT: People Tools 8.49/HRMS8.9ML, People Tools 8.49/FSCM 8.9 and Portal 8.9 Web logic 10g,Tuxedo 9.1, Oracle 10g