SUMMARY

• 23+ years of professional experience in the IT industry, including nearly 20 years as an Oracle/DB2/SQL Server DBA.
• Has extensive experience in PeopleSoft ERP implementations and customizations, including supporting development of customized applications.
• Expert in conducting Performance Tuning including Performance Testing of PeopleSoft applications and system architecture.
• Extremely proficient in performance tuning in large OLTP and data warehouse environments.
• Has specific experience utilizing Load Runner for conducting Performance Testing; 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.
• Has been the Technical Lead on many successful ERP implementations.
• 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, has extensive experience in Information Governance solutions with specialties in IBM Info Sphere Optim and Guardium.

TECHNICAL SKILLSDatabases 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, People Code, Oracle Forms, Microsoft .NET

People Tools V8.x, SQR, App Engine, Process Scheduler, Integration Broker App Messaging: IBM Info Sphere Optim (Data Growth, TDM, Privacy, Retirement), Info Sphere GuardiumPROFESSIONAL SUMMARY

Lead PeopleSoft/Oracle DBA, Washington, DC

• Performance tuning specialist. Identify and correct all related performance tuning issues by working with functional SME’s.
• Develop test scripts with Load Runner to identify bottlenecks in the full PeopleSoft infrastructure stack. Correct all performance related issues in Web/App Servers.
• Tune SQL with in the Oracle database.
• Correct Application Engine programs to ensure they meet performance SLA’s.
• Configure Application/Web Servers for optimal performance and reliability.
• Use and configure OEM for application/database monitoring using the PeopleSoft Plugin.

Lead PeopleSoft/Oracle DBA, Knoxville, TN

• Hold knowledge transfer session to instruct junior DBA’s or Oracle best practices pertaining to tuning, backup/recover techniques, architecture design, change control processes.
• 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;
• PeopleSoft HCM 9.0
• PeopleSoft Upgrade Manager (PUM)
• Expert in People Tools 8.54 preferred in PeopleSoft HCM.
• 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;
• Requirements Analysis and generation of detailed design specifications.
• Lead technical resource for all aspects of database-related activities and implementations.
• Oracle 12c,11g, PS 9.2,Weblogic, OEM, Toad, TKPROF, AWR ASH, pscbo stats

Lead Oracle/PeopleSoft DBA, NJ

• Support upgrade to PeopleSoft Financials 9.2 and People Tools 8.53, evaluating overall system performance(WebLogic and Appserver configuration), load testing,(Load Runner scripts creation and analysis)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.
• PeopleSoft Upgrade Manager (PUM)
• 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,Weblogic, OEM, Toad, TKPROF, AWR ASH, pscbo stats

Lead PeopleSoft DBA/Admin, Optim Consultant all places

• Knoxville Utilities Board - Oracle/PeopleSoft DBA(Performance Tuning)
• New York University - Oracle/PeopleSoft DBA(Performance Tuning)
• U.S. House of Representatives - Oracle/PeopleSoft DBA(Performance Tuning, Load Runner)
• Knoxville Utilities Board - Oracle/PeopleSoft HCM DBA(Performance Tuning, Knowledge Transfer)
• Stanford University Acceleration Lab - Oracle/PeopleSoft HCM DBA(Architecture redesign)
• AT&T Wireless - Oracle/Optim DBA(Optim Performance Tuning)
• Rovi Corp - Optim Architect
• Battelle Memorial Institute - PeopleSoft Systems Architect/Optim Consultant
• Delhaize - PeopleSoft System Architect/Optim Consultant
• Confidential – Oracle/PeopleSoft DBA(Performance Tuning)
• Keane – PeopleSoft Upgrade Specialist
• Battelle Memorial Institute – 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
• PeopleSoft 9.2 Upgrade Experience with execution and Management of Upgrade Data Conversion Scripts.
• PeopleSoft Upgrade Manager (PUM)
• 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, and Optim 7.0

Lead Oracle Database, OH

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

Lead PeopleSoft Oracle Database Administrator, NJ

• PeopleSoft Financials and Database Upgrade;
• Manage database implementations and upgrades in Oracle/PeopleSoft environments serving as an Upgrade/ Performance Tuning Specialist Mercury Load Runner 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

Lead PeopleSoft/Oracle Performance Tuning Specialist, TN

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

Lead PeopleSoft Oracle Database Administrator, NJ

• 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

Lead PeopleSoft Oracle Database Administrator, NY

• Created and managed schema objects, such as tables, views, clusters, indexes, procedures, and 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

Database Administrator

Served as administrator for 8 Oracle 8i databases.

• Lead DBA on the European 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

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

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

Database Administrator

• PeopleSoft Upgrade to 7.52 and People Tools 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

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;

Database Manager

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

Telecommunications Repair Technician