We provide IT Staff Augmentation Services!

Peoplesoft Admin/oracle Dba Resume

DC

SUMMARY:

  • A seasoned professional with over 25 years experience in database administration, ERP architecture, performance tuning and technical project management.
  • Has diverse expertise with several operating environments and database platforms. Very strong Peoplesoft and Oracle DBA skills. 18 years PeopleSoft experience participating in several HR, Financials, Campus Solutions, EPM and Portal implementations and upgrades. 22 years of experience as Oracle DBA.
  • Peoplesoft application upgrade FSCM 9.2/Peopletools 8.53.
  • Installation and upgrade of Peoplesoft HCM, Financials, Campus Solution, EPM, CRM and Portal.
  • Have recently installed and integrated Oracle SES 11.2 for Peoplesoft FSCM.
  • Multiple projects experience with architecture design, implementation and performance tuning of very high concurrent users Peoplesoft self service applications.
  • Have performed numerous architecture assessment, technical audit, system configuration, capacity planning for database and PIA.
  • Extensive SQL tuning experience for Peoplesoft applications, both online and batch. Also Oracle database tuning for high performance such as tablespace allocation; indexing; SGA and PGA sizing, statistics gathering, redo logs, undo management and I/O.
  • Configuration, load balancing, fail - safe over and tuning of Application Servers; Web Servers.
  • System Support - Support and troubleshooting Peoplesoft components. Application of patches and fixes; change management. Experience in use of PUM and Change Assistant.
  • Programming - Hands on programming experience with Peoplesoft V8.4 Peopletools; Peoplecode; Integration Broker; Application Engine and SQR.
  • Application Experience - Peoplesoft AM, GL, PO, AP, PC, HR, Payroll, Benefits, T&L, Student Records, Student Financials, Self Service applications and EPM.
  • Non Peoplesoft tools - Veritas i3; STAT 5.6, Load Runner; PVCS; Oracle Enterprise Manager, Informatica; Autosys and Tivoli Work Scheduler.
  • Oracle installation and Oracle database upgrade on UNIX up to version 11.2. Backup and recovery using RMAN. Oracle hot stand by database administration for replication and disaster recovery.
  • Operating Systems - Linux, Sun Solaris, AIX, HP UNIX, Windows 2008.
  • Project Management/Team Lead experience - Estimation of efforts, risk management, project planning and status reporting, defining roles and responsibilities. Technical team lead on many implementations.

PROJECT EXPERIENCE:

Confidential, DC

Peoplesoft Admin/Oracle DBA

Responsibilities:

  • Responsible for architecture, deployment, performance, configuration and update of Peoplesoft applications and Oracle databases.
  • Answerable directly to Government Technical Manager on issues listed above. In addition, as part of DBA team share responsibilities for maintenance and day to day operations of Peoplesoft environments and Oracle databases. Some major achievements on this project include
  • Peoplesoft application upgrade, Peopletools upgrade, Oracle upgrade, moving Peoplesoft application between data centers on different platforms, database performance tuning resulting in a gain of 67% in average batch job run times, devising a scheme for yearly data archiving to offload about 80GB of data using table partitions and transportable tablespaces, database size reduction of 70GB by tuning SQLs and reducing temporary tablespaces, setting up Integration Broker for consuming and providing Web Services to other agencies.

Confidential, DC

Peoplesoft Admin/Oracle DBA

Responsibilities:

  • As Peoplesoft Admin/Oracle DBA supported Payroll 8.8 implementation.
  • In addition to supporting Payroll implementation, I was responsible for complete re-assessment of Peoplesoft HRMS and Payroll Production architecture and subsequent re-deployment based on the assessment.
  • System architecture assessment was needed to prepare the system for rollout of ePay, eProfile and eBenefits catering for 2000 concurrent online users.
  • This entailed re-configuring Web, App and database tiers and load testing using Confidential LoadRunner.
  • Improved database performance significantly with tuning of 10G database.
  • Used RMAN for backup and recovery. Installed HRMS 9.0 demo for user evaluation.

Confidential, MD

Peoplesoft Admin/Oracle DBA

Responsibilities:

  • As a part of Peoplesoft Admin/DBA team, supported production, QA and development environments for all applications mentioned above.
  • Assisted with tuning and re-configuration of Student Admin system capable of supporting 9000 concurrent users.
  • This system consisted of a hardware load balancer, several physical Web and App servers. Performed extensive database and SQL tuning of Student Admin database.
  • Also involved in Financials & SCM Application upgrade from V8.4 - tools 8.43 to V8.9 tools 8.48. Used Veritas i3 for performance monitoring and tuning.
  • Used STAT for change management. Some involvement in STAT administration.

Confidential, MD

Peoplesoft DBA

Responsibilities:

  • As Peoplesoft DBA team lead, was responsible for installation, upgrade, maintenance of Peoplesoft HRMS, benefits and payroll systems.
  • Upgraded Peoplesoft HRMS 8SP1 - tools 8.20 to HRMS 8.8 - tools 8.43. For the purposes of downsizing, migrated Peoplesoft application and Oracle databases several times between Unix and Windows 2000 platforms.
  • Replicated Peoplesoft system for buyers of the power plants who needed system for historical data.
  • Functioned as the sole Peoplesoft/Oracle DBA for over a year supporting Peoplesoft applications and Oracle databases.

Confidential, Washington, DC

Consultant

Responsibilities:

  • Installed Portal 8.8 demo and development databases on Peopletools 8.43.
  • Client has the requirement to integrate 2 HRMS databases (8 SP1 and 8.8) with their Portal.
  • Built Portal registry so that Portal proxies the content from both databases.
  • Identified and resolved issues related to overlaps within Portal taxonomy (Portal registry and Peoplesoft security).

Confidential, MD

Peoplesoft DBA

Responsibilities:

  • As Peoplesoft System Administrator and Oracle DBA, patched, tuned and troubleshot Peoplesoft applications and Oracle databases.
  • Maintained Peoplesoft application server, web server, report and batch servers in production and development environments.
  • Managed about 12 Peoplesoft environments.
  • Applied Tax updates, installed Peoplesoft 8.42/HRMS 8.8, upgraded Peopletools (from V ).
  • Cloned Peoplesoft production instance for test and training. Implemented extensive automation for Peoplesoft and Oracle maintenance using shell scripts.
  • Designed and implemented Oracle backup and recovery procedures including hot standby database using Oracle Recovery Manager.
  • Installed Oracle 9.2 and upgraded database from version 8.16/8.17 to 9.2

Systems Engineer

Confidential, NJ

Responsibilities:

  • Performed HRMS 7.5 to HRMS SP3 application upgrade for a very large database.
  • Tuned data conversion Application Engine processes during each test move to production to reduce upgrade timings substantially.
  • Database size after the upgrade was about 450 G.
  • Configured and tuned Weblogic cluster to achieve 2000 concurrent users.
  • Used Confidential Load Runner for load generation.
  • Configured and tuned Application Servers.

Peoplesoft EPM Infrastructure Support

Confidential, NY

Responsibilities:

  • Installation and administration of Informatica server on Unix.
  • Troubleshooting and tuning EPM processes.
  • Providing support to development teams.

Peoplesoft Infrastructure Support

Confidential, NY

Responsibilities:

  • As a member of the infrastructure support team provided system support for Peoplesoft HRMS development, integration and stress test environments.
  • About 40 Peoplesoft databases and PIA environments supported.
  • Tasks include Peopletools upgrade from 8.1.2 to 8.1.4; Application and web server installation and configuration.

Peoplesoft Infrastructure Support

Confidential, OH

Responsibilities:

  • Helped in sizing and setting up of Peoplesoft Architecture for HRMS and Financials implementation.
  • Implementation involving several web servers and application servers.
  • Configured Weblogic cluster, involving 3 NT servers and a total of 9 Weblogic instances, for scalability, load balancing and fail-over.
  • Tuned Application servers. Tuned long running Time entry process

Hire Now