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. Robert 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. In addition, Robert has extensive experience in Information Governance solutions with specialties in IBM InfoSphere Optim and Guardium.

PROFESSIONAL EXPERIENCE:

Confidential

PeopleSoft Administration

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 in Washington state. Image 5 was downloaded and applied Image 7 via the PUM for client requirements All items from image 6 and 7 were applied . 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

Oracle/PeopleSoft Performance Tuning

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. Example of success: 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

Oracle/ PeopleSoft Performance Tuning

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

Oracle/Peoplesoft Performance Tuning

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

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

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

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

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

Confidential

Optim Consultant

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

Confidential

PeopleSoft System Architect and Optim Consultant

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

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

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 Lab Manager, Upgrade Lead

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 BTRG'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

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

• 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

Performance Tuning - 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

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

Performance Tuning specialist, tuning of all aspects of PeopleSoft implementation to include: AIX, Oracle, Websphere and Tuxedo 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

Confidential

Lead PeopleSoft Oracle Database Administrator

Performed daily checks of backups, extents and alerts for 6 Oracle databases Wrote various PLSQL scripts to perform direct updates to Oracle production databases Provided recommendations and solutions for production data issues Coordinated all development changes into new version of PeopleSoft Served as architect and designed new hardware configuration for PeopleSoft environment Setup complete PIA architecture for PeopleSoft tools 8.44 Upgraded Oracle from .4 Performed all technical upgrade tasks to go from 7.54 to 8.4 Upgraded modules to include the following: Human Resources, Benefits Admin, Payroll Interface, General Ledger, Asset Management, Projects, Expenses, Inventory and Purchasing. - ORACLE 8.x/9x, Windows NT/Server 2003, UNIX Solaris, PeopleSoft Financials Upgrade

Confidential

Lead PeopleSoft Oracle Database Administrator

• Created and managed schema objects, such as tables, views, clusters, indexes, procedures, triggers and maintaining referential integrity Identified areas of cost savings for hardware implementation.
• Maintain 10 Oracle 8i instances Wrote architecture specifications document outlining the purpose, scope, reference and overview logical, deployment, and implementation of the system Performed upgrades to Oracle 9i Implemented Quest Shareplex for high availability stand-by database Managed 2 DBA's on the project to verify assigned weekly goals/status updates were met appropriately Documented database requirements for the project Studied performance/stability factors and made recommendations as needed Implemented Oracle Enterprise Manager, Tuning Pack and Diagnostic Pack Implemented Oracles STATSPACK to analyze trend and growth statistics Implemented backup and recovery procedures using Korn Shell and Perl Applied all PeopleSoft patches to the production environment, including SQR, SQL and Data Mover scripts. Programmed various DTS packages to manipulate data between Oracle/SQL Server databases. Oracle 8.x/9.x, SQL Server 6.5/7.0, Sun Solaris, Red Hat Linux, Windows 2003, PeopleSoft Financials Upgrade

Confidential

Database Administrator

• Lead DBA on the Confidential implementation of VWR's online catalog Maintained and created Shell scripts for database monitoring, tuning and backups Performed extensive SQL Performance tuning.
• Performed upgrades to Oracle 8i Implemented Oracle Enterprise Manager, Tuning Pack and Diagnostic Pack Implemented Oracles STATSPACK to analyze trend and growth statistics Studied performance/stability factors and makes recommendations as needed Implemented backup and recovery procedures Oracle 8.x, 9.x, MySQL, Postgres SQL, Red Hat Linux, Sun Solaris

Confidential

Database Manager

Maintained 12 SQL 7.0 databases Upgraded SQL 6.5 Servers to 7.0 Recommended and implemented changes to architecture to improve performance of online banking services Recommended and implemented changes to Oracle/SQL Server RDBMS System to improve performance - Oracle 8.x, SQL Server 6.5/7.0, Windows NT/2000

Confidential

Lead PeopleSoft Database Administrator

PeopleSoft 7.54 Financials Implementation Lead DBA for implementation of PeopleSoft Financials version 7.54 Created and maintained 15 Oracle instances for the implementation. Performed SQL Performance tuning Created Shell scripts for backups Managed backup policies and procedures for all instances Implemented SQL server as the main database for the Siebel implementation Designed logical and physical designs for optimum performance Maintained security for development and production environments Guided Unix Administrators setting up technical infrastructure Reorganized tablespaces, tables, and indexes Created and maintained users and roles, and defined account and object security Assigned system level roles Implemented and tested database recovery policies and procedures Oracle 8.x, Sun Solaris, PeopleSoft - Implementation

Confidential

Database Administrator

• PeopleSoft Upgrade to 7.52 and PeopleTools upgrade to 7.55 Recommended changes to system architecture to improve system performance Created new database layouts to relieve contention between modules Applied fixes for AP, AM, PO, IN and GL modules Upgraded PS 7.53 tools > 7.54.10 > 7.55 Upgraded PS 7.51 apps > 7.52 Served as a MS SQL Server DBA.
• SQL Server 7.0/ NT 4.0, PeopleSoft Upgrade

Confidential

Lead PeopleSoft Database Administrator

Implementation of Ceridian HR/Payroll package/ MS SQL Server 6.5 Served as Senior DBA for the implementation of Ceridian HR/Payroll package/ MS SQL Server 6.5 Upgraded SQL Server 6.5 to 7.0 Tuned SQL statements, memory usage, and data storage Reorganized tablespaces, tables, and indexes

Confidential

Database Manager

Managed a SQL Server 6.5 database, used for storage of articles Administered Oracle databases on NT and VAX/VMS platforms

Confidential

Telecommunications Repair Technician

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