SUMMARY:

• 25+ years of progressive experience as: Database administrator & consultant - Database designer, modeler & analyst - Lead Programmer Analyst - Programmer - Technical Support Analyst.
• 20+ years Oracle experience, Strong database/application performance analysis and tuning skills.
• In-depth knowledge and experience designing/supporting both OLTP & OLAP databases.

TECHNICAL SKILLS:

ERP Applications: SAP-R3, Retek, Oracle-R11, PeopleSoft, Adaytum, E*Hub/E*Gate

Custom Applications: WWW-apps, Data warehouse/mart, EDI, CPG, POS, Billing, Healthcare, Distribution, Manufacturing, Inventory, Financials (AP, AR GL, etc.)Databases: Oracle: 7.3.4 - 12.1.0.1, SQLServer: 6.5, Informix: 4.1 - 7.2.3

Languages: Oracle: SQL, PL/SQL, SQLPlus; KSH, HTML. Informix 4gl, Transact-SQL

Operating Systems/software: RH-LINUX, AIX, SOLARIS, HP-UX, Windows, AOS/VS, VMS, DOS

PROFESSIONAL EXPERIENCE:

Confidential

Sr./Lead Oracle DBA - Consultant

Responsibilities:

• Production support, 2nd tier (SME) on-call support for Major national pharmaceutical services company.
• Performed primarily system-DBA activities responsible for all aspects of migrating/maintaining/monitoring/upgrading/patching/resolving any issues/interfacing with Oracle support, plus assisting development with sql coding and data modeling.
• RH-5 server environments with Oracle 10g, 11g & 12c DEV, TST and PROD databases. 8 primary DBs all with 2-3 actively managed (utilizing DataGurad) standby databases each.
• All backed up with RMAN and expdp (as possible). DB & backup verification via RMAN.
• Wrote/deployed/maintained dozens of shell scripts to automate monitoring/reporting and backups plus other common functions as needed.
• Produced much documentation on database processes, procedures and scripts.
• Mentored/trained junior DBAs.
• 12 month contract extended 3 more months, continuing consulting full-time at Confidential . But now supporting the Confidential Corporate IT team (HITS). Engaged in traditional Sr. Oracle DBA activities in AIX/Linux OS and 9i, 10g and 11gR2 databases. These include: on-call, plus: Oracle install/upgrade/patching, database creation, configuration, tuning. DB issue investigation/resolution, Backup/restore (RMAN), export/import, application support, shell scripting, etc. Beyond on-call, work is primarily driven through Remedy incident and change-control tickets.
• 12 month contract, consulting full-time supporting Confidential ’s SAP environment as part of Fujitsu multinational global team supporting over 200 Oracle 10g databases (including on-call) . Projects included: RMAN implementation using br*tools with TSM and NetBackup - Oracle standby database creation, maintenance, and support - Oracle database cloning - shell script development, - process/procedure development and documentation - interface to high-levels of Oracle, Symantec (NetBackup client) and IBM client (TSM) support to work and resolve RMAN issues.
• Confidential , successful recover their 8i (8.1.7.4) Oracle database and corresponding (11.5.3) Oracle Applications, after a user error without backups. Developed/deployed/supported several monitoring and maintenance shell scripts.

Confidential

DBA/DA/Developer

Responsibilities:

• Provide complete database support for the development and deployment of the flagship product of this MMO computer gaming company: StarGate Worlds.
• Substantial PL/SQL development, interface to 11g DB for C++, PHP, Python and Java.
• Analyzed data requirements to provide enhanced logical and physical database design.
• Implemented and automated daily RMAN hot backups plus export.
• Designed/Developed data migration automation tool, utilizing SQL-Loader and shell scripts.
• Improved code and data migrations process by enhancing and simplifying procedure.

Confidential

DBA/DA

Responsibilities:

• On small team of 2 DBAs, extended RAC experience, consistently in that 10g environment.
• Complete support for development, QA and training databases. Production DB oversight.
• Migrated 9i RMAN using TSM to 10g RMAN using FDR-Upstream, - totally revised RMAN utilization and implementation to automate execution, monitoring and reporting.
• Implemented/supported CDC (streams feature) providing hot-update to QA database.
• Coached development staff in efficient SQL coding, conducted code review session.
• Analyzed and advised improvements in poor performing SQL and PL/SQL code
• Re-designed and implemented improved data migration procedure utilizing data-pump.

Confidential

DBA/Developer

Responsibilities:

• May of 2004 rolled off the Dial account and Joined EDS’s Advanced Operations Team.
• Hosted and supported the WWW infrastructure for dozens of clients throughout the world.
• Performed all aspects of System DBA activities for dozens of clients worldwide.
• Upgrades/patching, backup/recovery, export/import, space management, database configuration management and database problem investigation and resolution, application code pushes and database structure updates.
• Utilize EMC SAN with VCS for HA. Standby databases for DR.
• Our client’s High Availability web sites demanded no unscheduled downtime.
• Provided full database automated monitoring (with page-out to on-call DBA) of system performance, space utilization, alert-log errors, DB availability, backups, standby DB status, cluster status, etc.
• Supported 8i and 9i database environments on Sun hardware
• Migrated DBs from 8i, through progressive versions of 9i, and on to 10g.
• Implemented automated Statspack execution and database statistics gathering.
• Provided SQL and PL/SQL review with investigation of performance issues.
• Created/supported internal HTML-based client environment tracking service.
• Senior member of on-call-rotation support team.
• Bolstered and enhanced customer satisfaction and confidence as primary technical liaison to most customers because of effective interpersonal skills, written and verbal - plus flawless execution of assigned tasks and responses to system issues.
• Utilized Remedy incident ticketing/tracking software to drive client request and project work..

Confidential

Database Administrator/Data Analyst

Responsibilities:

• Provide complete database support for over 140 Oracle production, test and development databases for one of Americas best known CPG companies.
• Responsible for day-to-day administration of 8, 8i & 9i databases
• Monitoring, tuning, trouble shooting, space/user management, reorgs/refreshes, DDL changes, code migration, database cloning, DB Install-creation-upgrades-patching, responding to/resolving DB issues including interfacing with Oracle support.
• Provide program design consultation, SQL performance analysis and SQL coaching.
• Implemented automated Statspack execution and database statistics gathering.
• Dedicated DBA to the data warehousing team and their custom applications.
• Implemented and supported 8i & 9i DSS features like: partitioning, parallelism, IOT tables and bit-map indexing.
• Primary DBA for the EDI team’s heavy OLTP, 24/7 custom application.
• This demanding application required consistent sub-second response time.
• Primary DBA on Vendor applications Adaytum and E*Hub XML messaging software.
• Developed many DBA tools using UNIX shell scripts.
• Employed EMC’s BCV for backups of data warehouse and EDI databases for fast backups.

Confidential

Database Administrator/DA/Developer

Responsibilities:

• On large DBA team providing complete DBA support for a huge RETEK implementation.
• Supported dozens of databases on multiple servers running Oracle 8i.
• DB Install, creation, configuration, administration, upgrades, patching.
• 3rd-party application installation, upgrades and support;
• Program design/code reviews, SQL and PL/SQL coaching; application tuning;
• Utilized autotrace, explain plan and SQL trace with tkprof.
• Implemented Oracle distributed processing, replication and partitioning features.
• PL/SQL development and extensive Unix shell script development.
• Designed/developed PL/SQL application to automate code & data migration.
• Oracle Designer administration (v6)

Confidential

Lead DBA/Developer

Responsibilities:

• Hired to lead migration from SQLServer 6.5 on NT to Oracle 8i on UNIX
• Coached and directed junior DBA, Provided training to DBA and development staff.
• Provided extensive documentation of process and procedures.
• Became competent with SQLServer, its administration & tools.
• Became familiar with SS6.5 system tables and Transact-SQL coding.
• Provided support in the SQLServer environment, including 24x7 on-call rotation.
• Used the Oracle Migration WorkBench (OMWB) to migrate the MSS DB to Oracle 8I.
• Translated and rewrote over 100 Transact-SQL stored procedures into PL/SQL.

Confidential

System/DB Administrator

Responsibilities:

• Provided technical support to Oracle Applications and Technology Sales Consultants in the western and central regions.
• Provided and maintained portable R11 demo environments on Sun Ultra5’s (which included install/upgrade/configuration of Solaris OS, Oracle applications software and Oracle core technology products (8 & 8i databases and tools).
• Developed web sites (HTML based) for internal oracle groups.
• Provide technical assistance to sales team while on-site during customer demos.
• Worked closely with development & Support groups to resolve/escalate demo issues.
• Configured server and application for Internet demos at prospect’s site.