We provide IT Staff Augmentation Services!

Lead Peoplesoft Oracle Database Administrator Resume

SUMMARY:

  • Confidential has 23+ years of professional experience in the IT industry, including nearly 20 years as an Oracle/DB2/SQL Server DBA.
  • He has extensive experience in PeopleSoft ERP implementations and customizations, including supporting development of customized applications.
  • He is expert in conducting Performance Tuning including Performance Testing of PeopleSoft applications.
  • He is extremely proficient in performance tuning in large OLTP and data warehouse environments.
  • He has specific experience utilizing LoadRunner for conducting Performance Testing
  • He has an excellent ability to streamline normal DBA tasks to reduce time spent on daily database monitoring to include: alert log entries, backup completion, space monitoring, performance bottlenecks and connection - related issues.
  • He has been the Technical Lead on many successful ERP implementations.
  • Confidential is well-versed in all aspects of DBA-related tasks, including installation, configuration, maintenance, security, performance tuning and monitoring, capacity planning, disaster recovery planning, and implementation and testing.

CORE COMPETENCIES:

Databases: ORACLE 7.x/8i/9i/10g 11g, SQL Server 6.5, 7.0 2008, DB2 8.4-9.7, MS Access, Postgres

Tools: Toad Database Management, Quest Shareplex, FTP Voyager, Secure CRT, Oracle (Replication, RAC, Data Guard, Enterprise Manager Performance/ Diagnostic/Tuning Packs,STATSPACK, Parallel Server, RMAN, Standby Database Platinum Tsreorg, Platinum SQL Plan Analyzer, SQL Navigator

Platforms: AIX, HP UNIX, UNIX Solaris 7/9/10, Windows, Mac

Languages: PL/SQL, SQL, Visual Basic, C++, HTML, XML, Korn, Perl, Access, SQR, PeopleCode, Oracle Forms, Microsoft .NET

PeopleTools: V8.x,SQR, App Engine, Process Scheduler, Integration Broker App Messaging

IBM: InfoSphere Optim (Data Growth, TDM, Privacy, Retirement), InfoSphere Guardium

PROFESSIONAL EXPERIENCE:

Confidential

Lead PeopleSoft Oracle Database Administrator

Responsibilities:

  • Install and configure Peoplesoft Financials 9.2 and PeopleTools 8.53 on an EXADATA platform using Oracle 11g.
  • Created 4 environments from scratch for a hosted client.
  • Image 5 was downloaded and applied Image 7 via the PUM for client requirements.
  • During the engagement applied multiple bugs patches for another hosted client in San Diego via the PUM.
  • Setup and configured Change Assistant to work with multiple target databases.

Confidential

Lead PeopleSoft Oracle Database Administrator

Responsibilities:

  • Support upgrade to PeopleSoft Financials 9.2 and PeopleTools 8.53, evaluating overall system performance, load testing, recommending improvements and executing changes.
  • Analyze all upgrade processes to ensure all upgrade processes fit within the go live window.
  • Identify tuning solutions to improve performance, and worked with staff to analyze and manage performance.
  • Create comprehensive analysis of the testing results for the Oracle database, the application, SQL, as well as the database, web, and application servers and tuning solutions for each.
  • Through extensive knowledge of Oracle internals and parameters I was able to Alter, convert and load a 1.5 billion row table in 23 minutes, using only SQL commands reducing the original time of 24 hours.
  • This was accomplished by my expert ability to analyze current wait conditions and making appropriate changes to reduce the waits to get desired results. Oracle 11g, PS 9.1, OEM, Toad, TKPROF, AWR ASH

Confidential

Lead PeopleSoft Oracle Database Administrator

Responsibilities:

  • Work with functional teams to identify processes that require tuning
  • Execute a tuning process and plan for migration into multiple production environments
  • Responsible for conducting Performance
  • Conduct knowledge transfer session with DBA staff to explain tuning methodology, changes to processes and tuning approach
  • Train staff on Oracle 11g features as they pertain to clients functional requirements
  • Train current staff on PeopleSoft architecture and features as it pertains to DBA related tasks; Oracle 11g, DB2 9.7, PS FIN, HCM and CIS.

Confidential

Lead PeopleSoft Oracle Database Administrator

Responsibilities:

  • Work with functional teams to identify processes that require tuning
  • Execute a tuning process and plan for migration into multiple production environments
  • Review Oracle parameters and recommend changes for optimum performance in a Peoplsoft 9.1/Oracle 11g environment.
  • Review backup and restore procedures for DR.

Confidential

Oracle/PeopleSoft Performance Tuning Consultant

Responsibilities:

  • Support upgrade to PeopleSoft Financials 9.1 and PeopleTools 8.52, evaluating system performance, load testing, recommending improvements and executing changes.
  • Development and execute load runner scripts and analyze performance testing results.
  • Identify tuning solutions to improve performance, and worked with staff to analyze and manage performance.
  • Create comprehensive analysis of the testing results for the Oracle database, the application, SQL, as well as the database, web, and application servers and tuning solutions for each. Oracle 11g, PS 9.1

Confidential

Oracle/PeopleSoft Performance Tuning Consultant

Responsibilities:

  • Work with functional teams to identify processes that require tuning
  • Execute a tuning process and plan for migration into multiple production environments
  • Responsible for conducting Performance Testing of PeopleSoft utilizing LoadRunner; Conduct knowledge transfer session with DBA staff to explain tuning methodology, changes to processes and tuning approach
  • Train staff on Oracle 11g features as they pertain to clients functional requirements
  • Train current staff on PeopleSoft architecture and features as it pertains to DBA related tasks; Oracle 11g, DB2 9.7, PS FIN, HCM and CIS.

Confidential

Oracle/PeopleSoft Performance Tuning Consultant

Responsibilities:

  • Primary responsibility Analyst current Oracle/PeopleSoft Architecture; Identify specific areas for improvements to current design
  • Recommend new architecture based on performance analysis of current system
  • Responsible for conducting Performance Testing utilizing LoadRunner - Oracle 11g

Confidential

Optim Performance Tuning Consultant

Responsibilities:

  • Primary responsibility was identifying bottlenecks in performance of archiving process
  • Develop implementation strategy of performance enhancements - Oracle 11g, DB2 9.7

Confidential

Optim Consultant

Responsibilities:

  • Optim Implementation; Primary responsibility was implementation of Optim archiving
  • Develop custom archiving definitions - SQL Server 2008

Confidential

PeopleSoft System Architect and Optim Consultant

Responsibilities:

  • Optim Implementation and SQL Server Performance Tuning; Primary responsibility was implementation of Optim archiving in the PeopleSoft financials environment
  • Develop custom archiving definitions for delivered and customized PeopleSoft modules; Secondary role was performance tuning SQL Server/PeopleSoft environment related to archiving procedures and end user reporting queries; Oracle 11, Oracle OEM Grid Control 11.2 SQL Server 2008, Windows 2008, PeopleSoft Financials 9.0, Optim 7.0

Confidential

PeopleSoft Systems Architect & Optim Consultant

Responsibilities:

  • Optim Implementation and Performance Tuning DB2; Primary responsibility was implementation of Optim archiving in the PeopleSoft financials environment; Custom development of Native Application Architecture for PeopleSoft online system accessing archive data for end user reporting
  • Secondary role was performance tuning DB2/PeopleSoft environment related to archiving procedures and end user reporting queries.
  • DB2 9.5, AIX, PeopleSoft Financials 8.8, Optim 7.0

Confidential

Oracle/Peoplesoft Tuning/Optim Consultant

Responsibilities:

  • Optim Implementation for PeopleSoft Financials 9.1; Implement IBM’s Optim Data Management Solution for PeopleSoft 9.1; Performance tuning of Access Definitions; Oracle 11, AIX, PeopleSoft Financials 8.8/9.1

Confidential

Upgrade Lead

Responsibilities:

  • PeopleSoft Financials Upgrade 8.4 to 9.1 and DB2 Upgrade; Primary responsibility was lead upgrade consultant for PeopleSoft Upgrade from version 8.4 to 9.1
  • Responsible for designing, executing, testing and implementation of performance enhancements to ensure upgrade scripts executed in the clients allotted time for cut-over weekend; DB2 DBA for Confidential ’s upgrade lab, creating, maintain, troubleshooting and tuning all aspects of DB2 databases
  • PeopleSoft Technical Architect, designing and developing lab environment in preparation for PeopleSoft upgrade and support of development environment
  • Support development activities during reapplication of several hundred customizations - DB2 9.7, Linux 5.4, PeopleSoft Financials 8.4 to 9.1, PeopleTools 8.50

Confidential

PeopleSoft Systems Architect & Optim Consultant

Responsibilities:

  • Optim Implementation and Performance Tuning SQL Server; Primary responsibility was implementation of Optim archiving in the PeopleSoft financials environment
  • Develop custom archiving definitions for delivered and customized PeopleSoft modules
  • Secondary role was performance tuning SQL Server/PeopleSoft environment related to archiving procedures and end user reporting queries; Oracle 11, Oracle OEM Grid Control 11.2 SQL Server 2008, Windows 2008, PeopleSoft Financials 9.0, Optim 7.0

Confidential

PeopleSoft Systems Architect & Optim Consultant

Responsibilities:

  • Optim Implementation and Performance Tuning DB2; Primary responsibility was implementation of Optim archiving in the PeopleSoft financials environment
  • Custom development of Native Application Architecture for PeopleSoft online system accessing archive data for end user reporting
  • Secondary role was performance tuning DB2/PeopleSoft environment related to archiving procedures and end user reporting queries - DB2 9.5, AIX, PeopleSoft Financials 8.8, Optim 7.0

Confidential

Oracle Database Administrator - Implementation/Performance Tuning Specialist

Responsibilities:

  • Primary responsibility- performance tuning of the Oracle instance, SQL tuning and environmental optimization
  • Also performed backup and recovery scenarios, implemented and tested recovery procedures
  • Transferred knowledge to exiting DBA’s on Oracle performance tuning techniques, backup and recovery procedures, explanation of init.ora settings and Oracle fundamentals; ORACLE 10.x, AIX, PeopleSoft Financials, HR, Student Admin

Confidential

Lead PeopleSoft Oracle Database Administrator

Responsibilities:

  • PeopleSoft Financials and Database Upgrade; Manage database implementations and upgrades in Oracle/PeopleSoft environments serving as an Upgrade/ Performance Tuning Specialist Mercury LoadRunner script development
  • Planning and implementation of end to end load test (creating virtual users, scenario’s development and analysis);
  • Manage and perform tuning activities during implementation and post implementation
  • Upgraded 9.X to 10.2.04; Implemented Quest Shareplex to offload reporting to a separate db
  • Perform daily Oracle DBA tasks, including management of backups and day-to-day support issues; ORACLE 10.x/9.x, HPUX, PeopleSoft Financials - Implementation/Upgrade

Confidential

Lead PeopleSoft/Oracle Performance Tuning Specialist

Responsibilities:

  • Manage database implementations and upgrades in Oracle/PeopleSoft environments
  • Consult client on best practices for change control, environment configuration, physical and logical database layout, performance tuning procedures, and the implementation of existing Oracle technology to best fit the needs of the business and analyze customized programs for migration into the new environment
  • Troubleshooting environment for the migration of customized bolt on applications
  • Perform daily Oracle DBA tasks, including management of backups, recoveries and day-to-day support issues
  • Lead technical resource for all aspects of database-related activities and implementations
  • Developed scripts for new tables and objects in Oracle databases, including tables, triggers, views, synonyms and permissions
  • Implement Oracle distributed environment to serve as a reporting database for point-in-time reporting.
  • ORACLE 8.x/9.x, AIX, PeopleSoft CIS, Financials, HRMS - Upgrade

Hire Now