SUMMARY:

Demonstrate a positive, responsive approach where my 20+ years of leadership and technical skills will contribute towards achieving the company’s utmost goals. Exploit and enhance technologies while providing guidance and influence to the Information Technology staff.

TECHNICAL SKILLS:

Industries: Defense, Pharmaceutical, State/Local Government, Mass Transit

ERP Packages: PeopleSoft HCM, Financials, EPM

PeopleTools: Application Designer, DataMover, Process Scheduler

Oracle Database: 4/5/6/7/8i/9i/10g Install, Tune, Patch, Upgrade

Oracle Tools: SQL*Plus, SQL*Net, SQL Loader, EXP/IMP, EXPDP/IMPDP, Enterprise Manager

Oracle Technologies: Streams (Local & Downstream Real - Time)

GUI: TOAD, SQL*Navigator, Space Manager, Spotlight on Oracle, Spotlight on Oracle RAC

Migration/Utility Tools: Universal Installer, DB Configuration Assistant, DB Upgrade Assistant, Network Configuration Assistant, Microsoft ODBC Administrator, Statspack, AWR

Languages: SQL, PL/SQL, K Shell, Windows Batch

Operating Systems: UNIX, Linux, Windows 95/98/NT/2k/2k3, DOS

Backup Utilities: Tivoli TSM, Arcserve Hot and Cold with Point-In-Time-Recovery

PROFESSIONAL EXPERIENCE:

Confidential, Newtown, PA

Senior Oracle DBA

Responsibilities:

• Apply new installs/upgrades/security patches as required in 4-node RAC
• Monitor system performance and modify db parameters as required
• Generate performance statistics via AWR/ADDM
• Monitor table space I/O and modify data file layout for optimum performance
• Apply partitioning (Range, Hash, List & Composite) to tables/indexes a required
• Streams - downstream, local capture, & reporting
• Develop DBMS STATS management process to control the resources required for collecting object level statistics
• Develop Data Purge process for removing aged data from .5Tb Ops and 9Tb historical databases

Confidential, Washington, DC

Senior Oracle/PeopleSoft DBA

Responsibilities:

• Apply new installs/upgrades/security patches as required
• Oversee system performance and modify db parameters as required
• Generate performance statistics via Statspack
• Monitor table space I/O and modify data file layout for optimum performance
• Develop backup/recovery strategy via Cron job
• Develop/Maintain K-Shell scripts
• Provide PeopleCode/SQR/Crystal tuning support.
• Build/Migrate/test PeopleSoft customization projects
• Experienced with Statspack, Toad, Quest Central for Oracle, Spotlight, Space Manager, and SQL*Navigator
• Build new Instances as required
• Refresh/copy instances as required
• Manage in-house service issues to completion
• Manage vendor service requests to completion
• Manage user security via roles and profiles
• Provide database/schema level documentation

Confidential, Essington, PA

Senior Oracle/PeopleSoft DBA

Responsibilities:

• PeopleSoft Financials, HCM, & EPM
• Confidential
• Manage 5 production and 24 development instances
• All Instance configured in a 2-node clustered HA environment
• Planned/Managed Oracle 7 -> 8i, 8i -> 9i & 9i ->10g upgrades
• Generate all required capacity plans for new servers/technologies
• Managed team to develop implementation strategy and test scenario for upgrades.
• Apply new installs/upgrades/security patches as required
• Generate performance statistics via Statspack/AWR
• Oversee system performance and modify db parameters as required
• Monitor table space I/O and modify datafile layout for optimum performance as required
• Responsible for backup strategies using ArcServe & Tivoli Storage Manager
• Support PeopleSoft upgrades
• Provide PeopleCode/SQR/Crystal tuning support.
• Provide OS level and HP SAN tuning support
• Automated Storage Management (ASM)
• Provide database/schema level documentation
• Developed and documented the strategy for the enterprise wide Change Control Process
• Developed and documented the enterprise wide Business Continuity Plan template
• Experienced with Statspack, Quest Central for Oracle (QCO), Toad, Spotlight, Space Manager, and SQL*Navigator

Confidential, Parsippany, NJ

Senior Oracle PeopleSoft/DBA

Responsibilities:

• SYS Admin responsible for Installs, Updates, User Security
• Built post-upgrade development instances
• Provide Oracle 9i (9.2.0.3) DBA support during period of full-time employee absence
• Provide pre/post upgrade PeopleCode/SQR/Crystal tuning support.
• Provide tuning recommendations that reduced data conversion/budget checking times down from days to hours
• Modified tablespace layout for optimal PeopleSoft upgrade performance
• Provide plan with recommendation to reduced transactional times of numerous processes with capability to handle future projected demands

Confidential, Horsham, PA

Senior consultant

Responsibilities:

• Manage team of three in generation of all documentation detailing the certification of each product
• Serve as co-manager of the isolated Y2k test-bed where all certification activities are conducted
• Using Erwin data modeling software product, developed the data model that is used to track all Y2K certification activities for each product.
• Utilized capacity planning procedures for sizing all Y2k data entities at time of their creation
• Developed Y2K tracking application using Oracle 7 and Developer/2000.
• Serve as Project Manager’s backup on several occasions by performing Y2K audits of external vendors.
• Tasked to analyze and make recommendations for change to the current infrastructure management/reporting system that is used for client error reporting, system monitoring, change management, and daily/monthly reports to various levels of management.

Confidential, Plymouth Meeting, PA

Senior developer

Responsibilities:

• Project Manager, responsible for developing the application that validated the AIDS vaccine Crixivan
• Develop automated centralized laboratory ( Confidential ) program to receive laboratory data from various sources and screen for errors prior to batch loading into the main Clinical Trials application
• Solved complex programmatic open-issue items, some exceeding 18 months
• Utilized performance tuning skills to improve performance of specific jobs (Forms, SQL, Pro*C, etc) in one case reducing execution time from over 40 hours to less than 1 hour
• Served as Oracle 6 DBA on a VAX 4000 series test environment
• Served as Oracle 7 DBA, Installing and maintaining Oracle v7 in a Windows NT environment for the local workgroup
• Served as a member of the disaster recovery team
• Transferred as senior consultant to new technologies group responsible for converting Oracle 6/Forms 3 environments within the clinical group to Oracle 7/Forms 4.5
• Responsible for Y2K certification of business critical pre/post-sales clinical trial applications.