Resume for Dennis Heltzel by zhouwenjuan


									                                                                                                    DENNIS HELTZEL
101 Wedgewood Drive                                                                                          610-469-2545
Pottstown, PA 19466                                                                           

Database Administrator with over nine years experience providing IT support within a diverse array of industries
that include biopharma, financial and office products. Excels at managing production systems with high uptime
requirements. Innovative problem solver able to use many different software tools to achieve results.
Communicates effectively on both technical and business issues.


ADOLOR COPORATION, Exton, PA                                                                                   2001 – 2006
Startup biopharma company specializing in Pain Management.

Senior Oracle DBA
Managed Oracle databases and Solaris systems for Clinical and Research/Development departments
 Reduced incorrect or incomplete data by developing PL/SQL procedures to validate data as it was entered.
 Protected critical data by developing backup and recovery plan for Oracle systems. Successfully executed
   Adolor's Business Continuity plan at a remote recovery site to test its completeness.
 Validated installation process of consultants as they installed a new version of the Oracle application used for
   clinical and drug safety data. Documented changes to these systems to maintain their validated state.
 Provided Solaris Administration services that allowed Adolor to avoid hiring a separate System Administrator.
 Increased employee productivity by implementing email filter that reduced unwanted email by more than 90%.
 Increased reliability of DNS and Web services by moving these services from an ISP to Adolor's data center.
 Created intranet portal used by all Adolor employees. The portal allowed each group to self-publish important
   information to the rest of the company and is the top site accessed by employees.
 Improved internet security by implementing a web proxy to filter traffic and monitor employee internet access.
REUTERS AMERICA, Norristown, PA                                                                                 1999-2001
Development and hosting of financial service websites, including stock quotes, news, and sales transactions.

Oracle DBA Team Leader                                                         (2000-2001)
Lead team of 4 DBA's responsible for all databases at 2 locations.
 Trained less experienced DBA's and supervised their activities in a 7/24 production environment.
 Lead project to move the largest and most complex database to a hot failover configuration using Oracle's
   Advanced Replication technology. This redundant system was used to help protect the company from steep
   contractual penalties levied for any downtime.
 Improved quality of applications and reduced development time by creating efficient PL/SQL packages for use
   by the software developers.
 Improved system stability by creating an approval process for all PL/SQL code on production systems.
 Modeled databases for new software products. Introduced a formal database modeling process to the company.
Oracle DBA                                                                     (1999-2000)
Automated backup and monitoring of databases.
IKON OFFICE SOLUTIONS, Malvern, PA                                                                             1988 – 1999
World’s largest distribution channel for copier and printer technologies.

Oracle DBA                                                                     (1997-1999)
Lead DBA for Data Warehousing project using Oracle RAC (formerly Oracle Parallel Server).
 Migrated database from initial 2-node cluster to 6-node cluster with no downtime.
 Implemented Oracle's Recovery Manager for backup and recovery. Coordinated testing of the database backup
   plan with remote data center.
 Configured 3-tier Enterprise Manager for use by other Database Administrators.
 Managed 16 IBM SP nodes running multiple instances of Oracle on AIX.
Page 2                                                                                    DENNIS HELTZEL

PC and Network Manager                                                     (1995-1997)
Managed PC and network operations for IKON’s Southern District (formerly Acme Business Products).
 Lead team of three support engineers covering 5 states.
 Managed the consolidation of networks at 3 facilities into one location.
Data Processing Manager                                                    (1990-1995)
Managed all computer operations for IKON St. Louis (formerly Mirex).
Software Support Representative                                            (1988-1990)
Supported custom accounting package for IKON Mid-Missouri (formerly CalType Office Solutions).

                                      PROFESSIONAL PORTFOLIO

Oracle University
Database Administration                        Oracle Web Application Server Administration
Oracle 7 Performance Tuning Workshop           Oracle9iAS Portal: Build Corporate Portals
Oracle 8 Performance Tuning Workshop           Oracle9iAS Portal: Build Portlets with PL/SQL
Backup and Recovery Workshop                   Oracle Internals:
SQL and PL/SQL using Procedure Builder          - Dumps, Crashes and Corruptions
Develop PL/SQL Program Units                    - Data Management and Storage
Data Warehouse Fundamentals                     - Advanced Backup, Restore, and Recovery Techniques
Oracle Express Database Design and Control      - Everything You Always Wanted to Know about the Optimizer
Oracle Applications Administration

Technical Training
Sun Microsystems - Solaris 8 Operating Environment - System Administration I
Learning Tree Intl - SQL Server 2000 Database Administration
Learning Tree Intl - Cisco Routers: A Comprehensive Hands-On Introduction
Symantec - SGS Firewall Administration

IT Software Summary
Oracle RDBMS (versions 7.3.4 to 10.0)          SQL Server
Oracle Enterprise Manager (OEM)                MySQL
Oracle SQLnet                                  PostgreSQL
Oracle PL/SQL                                  UNIX (Linux, Solaris, AIX, SCO, HP-UX)
Oracle Parallel Server (OPS)                   Windows
Oracle Recovery Manager (RMAN)                 Bash and Korn shelll (KSH) scripting
Oracle Application Server (9iAS)               Perl / PHP / Python
Oracle Portal                                  sendmail
Oracle Express                                 apache webserver
Oracle Financial Applications (11i)            squid proxy server
Oracle Designer                                bind (named)
Oracle Advanced Replication                    openssh
Oracle Clinical                                Zope/Plone
Oracle Thesaurus Management System             CanIt Spam Filter
Oracle Adverse Event Reporting System          Source code control (CVS and Subversion)
                                               VMware (OS virtualization)


                                 University of Maryland, College Park, MD
                                MBA, Management Information System, 1987
                                       BS, summa cum laude, 1985

To top