20 years experience in MIS with UNIX, NT , Oracle suite of products, mainframe
M.A., History, Syracuse University, Maxwell School of Citizenship and Public Affairs, Degree in progress, 27 of 30 credits completed, expected degree date May, 2007. 3.8 GPA.
B.S., Information Systems Management, University of Maryland University College, May, 1993; 3.8 GPA
B.A., Journalism/History, University of Kentucky, May, 1983
Personal Computer; Hewlett Packard (HP 9000 enterprise level), SUN (V-class, E-class), IBM (RS/6000, SP Frame, 3800, 3900)
SQL, oracle PL/SQL, UNIX Shell Script, COBOL
Current: oracle7, oracle8, oracle 8i, oracle 9i, 10g, Previous: Sybase, DB/2
oracle Application Server (3.0, 4.0, 9iAS/10g ? oracle Portal, SSO, SSL, Discover, OID), oracle Developer Server 6.0
oracle Enterprise Manager (OEM) 2.1/2.2/9i/10g, oracle Recovery Manager (RMAN), oracle 9iAS/10gAS, Quest Toad, Veritas Netbackup Datacenter, oracle Designer/2000, Designer 6i, oracle Reports (2.5, 3.0, 6.0), oracle Forms (4.5, 5.0. 6.0), oracle Financials (GL, AP, FA, Projects 10.7, 11.0), Erwin, Peoplesoft HRMS/Payroll/Fixed Assets 7.5/8.12
Unix (HP/UX 9-11; AIX 4.x, 5, OS/390; Solaris 2.5-2.10); Windows NT Server 4.0/2000, Windows 95/98/XP; Data Warehousing, OLTP
Consulting oracle DBA (October, 2006 - present)
Assigned to Retriever Payment Systems, Houston, TX for a 6-8 week project. Create oracle 10g RAC instances for a data warehousing project to include a star-schema based data repository, ETL repository - oracle Warehouse Builder (OWB) 10g and oracle Discoverer 10.1. Teamed with management, technical staff and end-users to integrate credit card clearinghouse data from disparate systems and create new data models for the warehouse using ERWIN.
U.S Department of Veteran?s Affairs (January, 2006 ? October, 2006)
Install, upgrade and migrate database and oracle application server software. Monitor and create backups using RMAN/Veritas tools. Perform lead functions on certain projects. Investigate/troubleshoot/resolve database and if necessary, application/database related problems. Manage oracle Enterprise Manager 10g grid environment. Hardware software environments include HP Superdome and Sun hardware, oracle database releases 8i, 9i and 10g, Veritas Netbackup and Veritas Clustering software (active/passive failover), oracle Application Server versions 9 and 10.
Consulting oracle DBA (April, 1997 ? January, 2006)
Assigned to DestinyUSA, a large scale construction project slated to build over 5,000,000 square feet of retail and office space. Tasked with implementing an enterprise-wide backup and recovery solution using oracle 9i RMAN and Legato, designing a high-availability system using an oracle Real Application Clusters (RAC) clustered environment in 9i (migrating to 10g) and eventually maintaining an enterprise-level SAP system based on Microsoft SQL Server. Additionally, providing support to an oracle 9i Advanced Replication Server environment using a master-to-master, asynchronous update configuration.
oracle DBA for Nine-Mile Nuclear Station, Oswego, New York. Supported oracle 8i and 9i databases and applications such as employee education, personnel and radiation levels. Installed and maintained oracle Application Server Release 9iAS, and recovered a mission-critical database using oracle Data Guard/standby database technology. Installed oracle Release 10g to evaluate the new capabilities provided by oracle Enterprise Manager.
Implemented an oracle 9iAS Application Server project for PIC USA of Franklin, Kentucky a multinational company specializing in animal science, genetics and food production. Installed 9iAS (9.04 or 10g) on a Dell-based Red Hat Linux platform, configuring Portal, Wireless, Unified Messaging, Single Signon, SSL, oracle Internet Directory (OID) and other options for PIC. Developed a backup solution for the application server, repositories and oracle 9i R2 databases.
Consultant to Sun Microsystems for implementation of oracle 8i/9i high availability (HA) solutions at a client site in Des Moines, Iowa. In project Phase I provided space allocation and layout for EMC storage array, installation, configuration and database conversion support from IBM SP frame (server cluster) to a Sun V880 cluster. Implemented backup strategy using Veritas Netbackup Datacenter and oracle 9i RMAN. Documented detailed specifications of database physical structures for SUN system engineers.
Supported a manufacturing concern (HON Industries) running a heterogeneous vendor environment including Peoplesoft HRMS version 8, Manugistics, oracle 8i, oracle 9i, TOAD, Microsoft SQL Server 7/2000, Cognos, Windows NT/2000 Server, HP9000 N-class (HP-UX). Refreshed Peoplesoft production and development databases, maintained application and process servers, performed oracle and operating system installs and configured disk arrays and provided day-to-day user support for a 500 GB data warehouse. Implemented an enterprise wide backup and recovery solution for oracle and SQL Server with Veritas Netbackup Datacenter. Documented backup and recovery procedures for the client.
Provided production support to BellSouth commercial billing and reporting data warehouse (2 terabyte). Tuned SQL and PL/SQL queries, (parallel query), monitor and maintain Informatica loads, modify production run Unix shell scripts and provide general day-to-day DBA support at customer direction. System environment utilizes oracle 8I (8.1.7), SUN E10K 40 processor enterprise class servers, EMC multiple-terabyte storage arrays, oracle 9iAS Application Server, oracle Financials AR 11I module and oracle Discover 3i.
Data architect (modeler) designing web-based relational database for the University of Michigan Health Care system. Complex system that will provide physicians and hospital staff the ability to track and monitor patient health and medication levels through pharmaceutical and lexical-based system interfaces. Front end application is a CORBA-compliant JAVA system that will be mapped to the relational database "back-end" through Toplink. Environment is oracle 8.1.7 (8i), IBM AIX 4.3.3 - 8 node clustered SP server, Websphere and Visual Age.
DBA for team migrating Peoplesoft Financials 7.5 and HRMS 6 application to Peoplesoft 8.12 at the US Department of Energy Rocky Flats nuclear site in the Denver area. Migration of oracle 7.3.4 to 8.1.6 (oracle 8i). Monitored and corrected problems with Peoplesoft Web Servers, Tuxedo, and Process Scheduler, migrated SQR packages and panels through Peopletools from test to Production, administered panel security. Managed oracle databases using the oracle Enterprise Manager.
Provided on-site production and development support to Toyota Motor Manufacturing, Kentucky for an oracle 8/8i, Peoplesoft 7.5 (HR/Financials/Manufacturing) systems. Performed database refreshes, monitored production activity, assisted with Quest Tools/Iwatch and RMAN/Veritas backup tool implementation.
Project consultant to ABN Amro Bank on-site in Amsterdam, The Netherlands. Advised the bank on the use of oracle 7/8I, oracle Enterprise Manager, Unix performance monitoring tools, capacity planning and high availability issues for a worldwide system consisting of 20,000 users, 15 enterprise level HP servers and 100 NT servers. Provided written evaluation of proposed strategic database and system monitoring tools from four different vendors.
Provided analysis and solutions for performance enhancements to an oracle7, Peoplesoft HR/Payroll 7.5 and NT 4.0 installation at Carter and Burgess, Ft. Worth, TX, a civil engineering firm. Installed, tuned and maintained oracle8 database and oracle Application Server (Web Server) for Carter and Burgess. Designed and developed marketing application using oracle Forms 6.0, Designer/2000 and Reports 3.0, SQL, PL/SQL.
Project Lead, oracle Database Administrator (DBA) and database designer for in-house system designed to track migration of engineering software throughout Boeing Commercial Aircraft Group. Created tables, developed procedures and scripts for backup and recovery, tuned the database and applications to improve performance and maintained user accounts. Installed and configured oracle 8 on IBM AIX platform and oracle 184.108.40.206 on a Windows NT 4.0 Server platform. Developed end-user documentation for directions on the delivered system.
oracle Corporation, Colorado Springs, CO. (March, 1996 - April, 1997) Sr. Technical Analyst Unix/oracle Database Administration. Provided technical support to customers for oracle installs on Unix servers, operating system failures and system tuning/kernel configuration. Interacted with customers to determine the source of problems and the solution to situations involving the oracle7 Server, SQL*NET, Developer/Designer 2000, SQL*PLUS, PL/SQL, PRO*C, PRO*COBOL, OCI, Unix/Windows workstations and TCP/IP connections on the 90+ platforms supported by oracle. Tested customer application software primarily on DEC Unix, Sun Solaris, HP/UX and IBM AIX platforms. Documented procedures for other oracle analysts on specific solutions for customer problems.
Consultant to Wyman-Gordon Aerospace, Houston, TX. (February, 1996 - March, 1996). Under temporary short-term contract to convert an IBM mainframe-based Cyborg payroll application to an HP9000 Unix platform at the Houston plant of Wyman-Gordon Aerospace. Converted the company's IBM MVS JCL-based batch payroll system to Unix Bourne Shell scripts running on an HP platform.
MCI Telecommunications, Colorado Springs, CO. (November, 1992 - December, 1995) Project Manager for the Consumer Markets Customer Marketing Database (CMD). The CMD system is comprised of a 500 GB data warehouse accessed via Visual Basic and other GUI front-ends and operational data maintained under Sybase SQL Server System 10. Coordinated project teams across various user and development groups nationwide. Developed and communicated project requirements to the user and development communities. Documented existing system functionality by developing a process model in the Execelator II CASE Tool. Managed projects throughout each life cycle phase by defining and monitoring project schedules, highlighting critical junctures in the development life cycle using Microsoft Project Manager. Provided programming support where applicable using MVS/TSO, ISPF, COBOL II, VSAM, DB/2, Syncsort, Sybase Transact SQL,
VAX VMS , "C", FTP and NDM.
Programmer/Analyst , November, 1988 ? November, 1992
Software Technical Writer, 1985 ? November, 1988