PROFESSIONAL SUMMARY

• Over 30 years of information technology experience including expertise in Oracle database administration, application and systems software development, and Unix system administration.
• Extensive experience with enterprise-level software including Oracle Enterprise Resource Planning ERP, Oracle Financials, Oracle Manufacturing, Oracle Supply Chain Management, Oracle 10g, 9i and 8i RDBMS as well as all of the major Unix and Windows operating systems.
• Extensive experience in analyzing and tuning Oracle performance issues using tools such as the Oracle Wait Interface, dynamic performance views, Enterprise Manager Grid Control Diagnostic and Tuning Packs, TOAD, TKPROF, Explain Plan, statistics gathering, Statspack, AWR, ADDM, and Steve Adams and other performance scripts.
• An extremely high level of dedication with a reputation for time commitments that assure that projects are completed on time and with high quality. At one consulting company, held the record for hours billed with 430 hours in a single month.
• Self-starter with the ability to perform in high-pressure situations.
• Able to analyze complex technical problems and business needs, then recommend and implement technical solutions.
• Experienced working within a team environment and communicating effectively with other team members. Also able to mentor other team members and provide leadership.
• Able to manage multiple tasks with changing priorities.
• Excellent written and verbal communication skills and interpersonal skills.

TECHNICAL EXPERTISE

Database Administration:

• Oracle10g, Oracle9i, Oracle8i, Oracle8, Oracle7, Oracle6 RDBMS, Microsoft SQL Server 2008-2012
• Operating Systems:
• HP-UX 11i, IBM AIX, Sun SOLARIS, SunOS, Windows 7, XP, NT, 2000, 98, 95, DOS
• Languages:
• SQL, PL/SQL, Unix Korn / Bourne / C shell script, C, Oracle PRO C embedded SQL and PL/SQL , PASCAL, Assembler
• ERP Administration:
• Oracle Applications E-Business Suite Release 11i 11.5.1 - 11.5.10 Terminal Release , Oracle Applications Release 12, Oracle Financials Release 10.7 SmartClient and NCA, Oracle Financial Analyzer OFA , Oracle Express Server OES , ALCIE, E.piphany CRM, Lawson

Tools:

Oracle Enterprise Manager Grid Control, SQLTXPLAIN, SQL Trace, TOAD, TKPROF, Explain Plan, statistics gathering, Statspack, AWR, ADDM, Oracle My Oracle Support and MetaLink, SQL Plus, Import / Export, RMAN, SQL Loader, Oracle Migration Workbench, Oracle Rapid Install rapidwiz , Developer 2000 and 6i, Oracle 8i Advanced Replication, Microsoft SQL Server Enterprise Manager, EMC, Veritas NetBackup, Rational ClearCase, ERwin Data Modeler, PVCS Change Management, AutoSys Job Management, Citrix, Discoverer, IBM MQSeries Message Queuing, Transarc Encina

Hardware:

• HP 9000 PA-RISC, IBM RS/6000 and eServer pSeries, Sun SPARC, Intel
• Network Software:
• TeamViewer, TCP/IP, NET8, SQL NET, FTP, TELNET, XWindows, Hummingbird, NFS, UUCP
• Web Servers:
• Oracle JVM, Oracle iAS, HTTP Apache, WebDB, OAS 3.0 and 4.0

PROFESSIONAL EXPERIENCE

URNES CONSULTING SERVICES

Confidential

• As a Microsoft SQL Server DBA, was responsible for performing various DBA tasks using Microsoft SQL Server 2008-2012 in support of Microsoft Dynamics GP 2010-2013 ERP installations for a variety of clients. Extensive use of SQL Server Enterprise Manager and Management Studio for a variety of tasks including data fixes, backup of database tables, data loads from Excel into SQL Server tables, correlated updates, table joins, etc.
• Also extensive experience in PC support including performing upgrades and new installations of Microsoft Windows 7, writing complex batch scripts running in Windows 7, performance tuning of disk i/o problems, performing cpu and memory upgrades, fixing network issues, performing backup and recovery tasks using the latest Windows-based tools, networking together PC's running Windows 7, Windows Vista and Windows XP, and extensive user training and support.
• As a volunteer data analyst at a large church in Eden Prairie, was responsible for data migration from an older Microsoft Access system to a new church management software solution.

Confidential

Oracle Applications DBA, IT Group

On a contract assignment as an Oracle Apps DBA, was responsible for production and development Oracle Applications Release 11i and 12 test, performance, and production database instances. These instances ran on HP-UX PA-RISC servers for Rosemount's Chanhassen manufacturing facility as well as Emerson Corporation's other Oracle Applications ERP environments. Expertise used in all facets of the Oracle Applications DBA role including Oracle Enterprise Manager Grid Control, cloning, patching, performance tuning, production support, technology stack Oracle Applications Database Tier, Web Tier Web Server, Forms Server, Concurrent Processing Server, Java Virtual Machine , TAR resolution, backup/recovery, and instance management. Administration of multiple 11.5.10 Applications instances, each greater than 500 gigabytes in size, occupying a total of over 100 terabytes of storage space. Also, extensive experience in analyzing and tuning Oracle performance issues using tools such as the Oracle Wait Interface, dynamic performance views, Enterprise Manager Grid Control Diagnostic and Tuning Packs, TOAD, TKPROF, Explain Plan, statistics gathering, Statspack, AWR, ADDM, and Steve Adams and other performance scripts.

Confidential

Senior Database Administrator, DBA Group

• Primary Oracle DBA responsible for administration of 20 Oracle 9i and 8i OLTP and data warehouse databases totaling over 1.5 terabytes on Sun SOLARIS and DEC Alpha platforms.
• Developed ETL scripts for migration of large tables for Lawson upgrades.
• Developed and maintained Unix shell and Perl scripts used in Oracle RMAN backup and recovery.

Confidential

Database Administrator/Analyst

• Mortgage IT DBA Group and Web Development Group
• On a two year contract assignment, was responsible for all database administration and data migration activities involved in migration from a Microsoft SQL Server based mortgage application to Oracle 9i databases running on IBM AIX servers.
• Developed complex migration strategy using the Oracle Migration Workbench for SQL Server utility.
• Designed and developed numerous DOS and Unix scripts and other utilities to work in conjunction with Oracle Migration Workbench.
• Acquired expertise in Microsoft SQL Server and SQL Server Enterprise Manager utility.
• On a subsequent project during the same contract assignment, was responsible for all database administration and data migration activities involved in the migration of data from multiple Telemagic customer relationship management databases FoxPro to an E.piphany CRM application based on Oracle 9i.
• Key member of team responsible for mapping of data from Telemagic and Ultimate E-form applications to E.piphany.
• Developed and maintained sophisticated migration strategy which included full database design as well as development of PLSQL stored procedures and SQL and Unix shell scripts.
• Utilized STATSPACK, Oracle Enterprise Manager and knowledge of Oracle Wait Events to provide performance monitoring, analysis, and tuning expertise in order to achieve optimal performance of Oracle database.
• Performed upgrades from Oracle 8i to 9i as well as new installs of Oracle 9i on IBM AIX and Windows 2000 and NT platforms.

Confidential

Database Administrator

• On a two month contract assignment, was responsible for database administration of numerous Oracle Applications and custom in-house application databases.
• Performed upgrades from Oracle 7 to Oracle 8i.
• Provided performance monitoring and tuning expertise.
• Developed and enhanced sophisticated SQL and Unix shell scripts for propagating fixes and enhancements between various development, integration, and production databases.
• Installed Oracle Applications patches using Adpatch utility. Also installed Oracle RDBMS patches.
• Provided production, integration, and development DBA support for entire team of DBA's who were out of the office at various times for various reasons. These team members were responsible for numerous multi-faceted application databases.

Confidential

Senior Database Administrator

• On a five year contract assignment as an Oracle Applications DBA, was responsible for production and development ERP environments running on HP 9000 servers for Honeywell's Corporate, Technology Center, Latin America, and Asia Pacific
• divisions. These environments comprised over 30 database instances ranging up to 200 Gb in size and supporting over 500 users. Oracle Financials modules included AP, GL, PO, PA, FA, FND, AD, INV, AR, OE, ALR, Workflow, and Self-Service Web Applications.
• Performed Honeywell's first production upgrade from Oracle Financials Release 10.7 to 11i in November 2000. One of the first 11i upgrades to a production ERP system in the world.
• Developed a sophisticated database and application cloning procedure to clone production and development 11i environments to multiple HP-UX machines. This was used in place of Oracle's cloning procedure, which was found to be inadequate.
• Responsible for server configuration, backup and recovery standards and methodology, disaster recovery planning, Unix shell scripting, instance management, security configuration, logical and physical database design, replication implementation, OracleiAS configuration, SQL NET and NET8 configuration, database tuning, tuning of SQL, PL/SQL and concurrent manager processes, optimization, space management, sizing and performance management of all production and development environments.
• Applied all patches, mini-packs, and maintenance packs for Oracle Applications and Oracle RDBMS software.
• Provided 24 X 7 on-call support of production and development environments.
• Provided technical mentoring and leadership to less senior database administrators.
• Performed all Oracle Apps DBA activities for the installation and upgrade of Oracle Applications from Release 10.7 SmartClient to 11i, 10.6 to 10.7 SmartClient and NCA, and 10.4 to 10.6.
• Performed all activities for the installation and upgrade of Oracle RDBMS from Oracle 7 to Oracle 8 and 8i.
• Extensive use of Oracle MetaLink and other technical web sites for working with Oracle to solve problems, open and track TAR's, download applications and RDBMS patches, and obtain documentation, scripts and other procedures.
• Utilized strong Unix knowledge and extensive Unix shell scripting experience to develop scripts for monitoring database availability and performance and write wrapper scripts to enhance existing Oracle utilities, and automate routine DBA tasks.
• Developed system specifications and requirements.
• Interfaced closely with both IT staff Unix system administrators and developers and end users.
• Developed and implemented sophisticated interfaces to/from Oracle ERP systems using Oracle 8i Advanced Replication and distributed technology. Data was interfaced between numerous Release 11i and 10.7 ERP instances as well as between 11i and PeopleSoft HR and Oracle Financial Analyzer OFA instances.

Confidential

Senior Database Administrator

• On a 3 year contract assignment as a senior database administrator, was responsible for database administration and application development on what was, at the time, the world's largest operational open systems database totaling over 600 Gb in size. The production and development databases ran on Sun SPARC servers and supported over 1500 developers and end users.
• Designed, coded, and implemented numerous distributed database applications written in C and Oracle PRO C and running on SOLARIS. These were used in the transformation of flat file data from an IBM mainframe database to distributed Oracle databases using Oracle's two-phase commit mechanism. Over 100 Gb of data was transformed daily to the Oracle production databases through daily delta updates.
• Due to a system limitation on the maximum number of disk drives which could be connected to a Sun SPARC server at that time, the company was in danger of running out of disk space on the production server. Lack of availability of this system would have cost the company over 1 million a day. Designed, coded, and implemented a PRO C application which split the data from one Oracle database on one Sun server to two databases on two servers. This application moved over 500 Gb of data and completed just days before the single server was estimated to run out of space. This was all done with complete transparency to the users with zero downtime.
• Developed a three-tier workload testing application in PRO C using Transarc's Encina TP monitor software. This was used to test the viability of using a TP monitor to manage transactions which included commits to both the Sun/Oracle instance and an IBM DB2 mainframe database.
• Developed an application to test the viability of using IBM's MQSeries message queuing software for achieving transactions between the IBM DB2 mainframe database and the Sun/Oracle instances.
• Provided technical assistance to application developers through code reviews which enforced rigid standards for writing, tuning, and optimizing SQL and PL/SQL programs. Also assisted in developing stored procedures, triggers, forms and reports.

Confidential

Senior Consultant

• As a senior consultant, was responsible for database administration, Unix system administration, and application development for a variety of clients whose ERP systems ran on Oracle and Unix.
• On a two year consulting assignment, was responsible for all database administration, Unix system administration, and custom forms and reports programming during a conversion of a large 60-user business system from an NCR/Unix tower running RM/COBOL to a Sun/Oracle system running the ALCIE suite of ERP products. Duties included installation of all software and hardware, diagnosing and resolving all software and hardware problems, server configuration, database backup and recovery, disaster recovery, Unix shell scripting, SQL FORMS, SQL Reportwriter, and IQ SQR report programming, instance management, security configuration, logical and physical database design, SQL NET configuration, database tuning, SQL tuning, optimization, space management, sizing and performance management of all production and development environments, and setup and maintenance of network services including NFS, TCP/IP, and UUCP.
• Performed demonstrations and provided training to technical staff and end users in a variety of areas including Oracle database administration, Unix system administration, SQR report writing, and SQL programming.

Confidential

Systems programmer/analyst

• Systems programmer/analyst responsible for the development and support of data communications and operating system software on Nortel Networks line of integrated voice and data products offering office automation and telecommunications solutions.
• Responsible for porting, maintaining, and enhancing the C and 68000 Assembler source code for data communications 3270, SNA, and BATCH/RJE and printing software running under Unix. Acquired extensive knowledge of device drivers and inter-process communication in Unix.
• Primary software support programmer for Nortel's DVS operating system software written in PASCAL. Responsible for X.25 networking, teleconferencing, telephony and operating system software.
• Primary Unix system administrator for a large software development group.