SUMMARY
Extensive experience in information systems providing database administration services, including production troubleshooting, systems programming, analysis, design, and the support of development efforts. Qualified to play an integral role in the field of information technology where talents and experience will contribute to achieving company goals.

SOFTWARE/OPERATING SYSTEMS

Databases: Oracle, SQL Server, Sybase, Informix, Watcom, IMS, Lansa, DMSII, Image.
Systems: AIX, Solaris, SunOS, HP-UX, LINUX, AT & T and Sequent Unix, Novel Unix SVR4.2, OS/400, MVS, OS/VS2, JES3, MCP, Gemcos, MPE, Windows Server 2003 and 2000, NT 4.0, XP, MS-DOS.
Programming Language: SQL, Unix shell scripting, PL/SQL, HTML, C, Visual Basic, Powerbuilder, COBOL, Lansa, DL/1, LINC, Fortran, JCL, Mark IV, ETIP, CICS, Quiz, InstallShield, ODESY.
Hardware: AT & T - 3B2; Sun - SPARC Servers; UNISYS - U6000/80, U6000/75, U6000/60, U6000/55, A17, A15, A12, A3, A1, B7900, B7800, CP9500, B25; IBM - RS/6000, AS/400, 3033, 4341, 370/158, PC; Hewlett Packard - HP9000, HP3000; Various - Intel microprocessor based systems.
Software: Oracle Enterprise Manager, Oracle Migration Workbench, OFA, SQL Navigator, Toad, Erwin, DBArtisan, System Architect, Visio, Microsoft Office Suite, vi, WordPerfect,CMS/SPF, ROSCOE, LIBRARIAN, CANDE, Editor.

EXPERIENCE

Confidential, Denver, Colorado April 2007 - August 2010
Database Administrator -

• Maintained, tuned, and troubleshot Oracle databases in a LINUX environment.
• Converted all RMAN backups from direct to disk to direct to tape.
• Performed Oracle 9.2.0.4 to 10.2.0.4 database upgrades of the core business databases, including database and business process environment adjustments and updates.
• Provided database schema design and standards recommendations to the development team.
• Upgraded Oracle 9.2.0.4 databases to 10.2.0.4 using both database upgrade assistant and manual upgrade procedures.
• Set up an Oracle Enterprise Manager 10.2.0.4 Grid Control infrastructure in a SuSE Linux 10 and Windows environment.
• A bug was filed with Oracle Technical support related to an Enterprise Manager job scheduling issue. Provided in-depth analysis, trouble-shooting, and debugging efforts in combination with Oracle Technical Support to arrive at a patch for the bug, which resolved the job scheduling issue.
• Assisted the software development team on numerous occasions with SQL performance, database object and SQL design, debugging, object implementation, and standards.
• Upgraded an RMAN repository from version 9.2.0.4 to 10.2.0.4.
• Used RMAN on a regular basis to produce hot and cold backups, which were restored onto alternate environments. Special cold restoration procedures were developed and used to go from an older Linux platform that supported Oracle 9i to a newer platform that only supported Oracle 10g.
• Recovered a production RMAN backup to an alternate location without a recovery catalog, and then used transportable tablespaces to move the selected data from the restored database back into production.

Confidential, Englewood, Colorado January 2007 - April 2007
Database Administration Contractor -

• Upgraded telephone book publishing database schemas from Keystone version 6.4.1 to 7.1.
• Provided maintenance and troubleshooting support for Dex Media directory publishing databases.
• Researched and applied Oracle time stamp Daylight Savings time zone patches to various databases at Dex Media, serving as the subject matter expert.

Confidential, Englewood, Colorado September 2006 - January 2007
Staff Database Administrator -

• Supported an Oracle Siebel 10TB database in an HP-UX production environment, including troubleshooting, and UNIX and RMAN scripting and maintenance.
• Participated in an Oracle Siebel 7TB database benchmark on IBM, HP, and Sun Unix platforms.
• Built Business Objects Repository and Westbury Reporting schemas in an Oracle 10.1.0.4 HP UNIX environment.
• Rebuilt Oracle Data Guard database after disk failure.
• Database refreshes, environment configurations, and troubleshooting.

Confidential, Englewood, Colorado October 1998 - July 2006
Senior Database Administrator -

• Migrated a help desk Oracle database from Enterprise to Standard Edition, saving $80K in licensing fees.
• Greatly minimized Oracle downtime during an OS upgrade failure by moving database disks to a different serverand then back to the original server, once fixed.
• Configured direct, non-recoverable SQL*Loader control files and Unix jobs to run within OEM for error-proof, high-volume, high-performance Oracle database loads.
• Installed Oracle 10.1.0.5 on a Solaris 10 server and Oracle 10.1.0.2 on AIX 5L servers. Also configured and created instance setup scripts.
• Set up Oracle RMAN/Legato tape backups of several Oracle database servers.
• Researched the problem of having duplicate Oracle DBID\'s (database ID\'s) with regard to implementing RMAN backups and registering databases in the recovery catalog. Determined that a utility, nid, must be run to make a DBID unique.
• Repaired Oracle tables using the dbms_repair package after block corruptions were reported.
• Performed several rollback to undo and dictionary to local extent management tablespace conversions.
• Troubleshot database errors, warnings, and failed jobs to greatly reduce potential database downtime, and ensure database recoverability.
• Used Quest Software SQL Lab Tuning Expert and other tools to obtain alternative SQL statements to poorly performing queries and worked with developers to improve them.
• Migrated numerous databases from Oracle 8i to 9i using dbua.
• Set up the operating environment and installed the Oracle 10g EM agent on numerous database servers, enhancing their manageability.
• Installed and supported several SQL Server 7 and 2000 databases, including customer care call tracking and call analytics data transformation services databases.

Confidential, Englewood, Colorado June 1998 - October 1998
Database Administrator

• Performed database set-up, support, troubleshooting, maintenance and shell scripting in a Sybase-Sun Solaris/HP-UX/Digital UNIX environment.

Confidential, Denver, Colorado May 1998 - June 1998
Database Administrator

• Performed data analysis and assisted with database configuration of a State of Colorado Child Welfare and Youth Correction application in an Oracle 7.3/HP-UX environment.

Confidential, Denver, Colorado June 1994 - May 1998
Senior Database Administrator/Database Administrator

• Provided Oracle version 7.1 and 7.3 database administration support in IBM RS6000 AIX and Windows NT 3.51 environments, including data placement and space usage analysis, database and instance creation, database upgrades, SQL*NET server and client set-up, and database backup and recovery procedures for asset management applications.
• Carried out Sybase System 11 and System 10 database administration responsibilities, including stored procedure writing, stored procedure and table design advice, Digital Open VMS and IBM AS/400 to Sybase data transfer mechanism set-up, server configuration, troubleshooting, storage management and Sybase System 10 to System 11 upgrades for Imaging, Messaging, and Personnel Time Management applications.
• Served as the Solaris systems administrator, performing such tasks as Solaris 2.3 to 2.5 upgrades, file system reconfigurations, internal firewall software installation, task scheduling, and hardware installation and configuration.
• Performed Sybase and Microsoft SQL Server database administration tasks, including database software installations and configurations, Sybase to Microsoft SQL Server database conversions, data transfer and database maintenance scripting, stored procedure maintenance, troubleshooting, and disaster recovery plan development and execution for Securities Trading, Imaging and Personnel Time Management applications.

Confidential, Denver, Colorado November 1993 - June 1994
Programmer Analyst

• Performed analysis, design, SQL*PLUS report writing, Oracle Forms Version 2.3 and 3.0-PL/SQL user interface development and maintenance, application performance tuning using indexes, and database table design in an Oracle Version 6.0/AT & T 3B2 UNIX environment for Police, Sheriff, and Fire Departments personnel and operations applications.

Confidential, Washington, D.C. April 1992 - September 1993
Lead Developer/Functional Analyst/Programmer

• Database and systems administration in Informx/Solaris/AT & T UNIX environments including database building, loading, and scripting for Army Personnel Applications.
• Revised, enhanced, tested, and demonstrated Army Personnel software written in C, Informix SQL, UNIX, and ETIP.
• Performed analysis of Army Budgeting and Forecasting application requirements.
• Database SQL usage standardization, query optimization, database schema normalization and generation tool implementation, and C/embedded Informix SQL/ETIP/UNIX programming.

Confidential, Denver, Colorado and Tucson, Arizona April 1983 - November 1991
Project Leader/Programmer Analyst

• Installed UNIX system software and performed Accounts Payable and Milling Operations Accounting application conversions from a mainframe Unisys environment to a UNIX/Oracle Version 6 environment.
• Performed Mining Accounting application data conversions from a Unisys mainframe environment to a UNIX/ORACLE 6 platform running the MINCOM mining accounting application package.
• Provided analysis, development, installation, maintenance, and user support of the Corporate Accounts Payable application, including Materials Management and Equipment Maintenance interfaces, check reconciliation, 1099 reporting, and cash management in a Unisys Mainframe/LINC/DMSII/COBOL environment.

Confidential, Cleveland, Ohio 1981 - 1983
Junior Programmer

• Designed, wrote, and maintained programs for Traffic, Purchasing, Materials Management, and Windfall Profit Tax Accounting applications in IBM IMS, DL/I, COBOL, and JCL environment.

Confidential, Twinsburg, Ohio 1980 - 1981

• Converted time-sharing Equipment Maintenance Costing System to in-house HP-3000 platform.

ADDITIONAL TRAINING

Oracle Rocky Mountain Oracle User Group Training Days 2010, 2009, and 2008
Oracle Version 9i New Database Features for Administrators and Real Application Clusters
Oracle Version 8 Oracle Distributed Database and Advanced Replication Classes
Oracle Version 7 Advanced and Basic Database Administration
Rational Rose Rational Software Corporation Object-Oriented Analysis and Design
Sybase System 11 Advanced and Basic System Administration, Performance Tuning, Advanced Stored Procedures
Microsoft SQL Server 7.0 Overview, SQL Server 6.5 Sysem Administration, Windows NT 4.0 Core Technologies, Supporting Windows 95.
Lan/Wan Data Communications and Networking Seminar.
Powerbuilder 4.0 PowerBuilder Mastering DataWindows, PowerBuilder Performance, Tuning and Techniques, and PowerBuilder Basics Classes
C++ Object Oriented Programming Course in C++ at Metropolitan State College of Denver.
C++ object oriented programming course at Northern Virginia Community College.

EDUCATION
Bachelor of Business Administration

AFFILIATIONS
Beta Gamma Sigma National Honorary Society in Business.