16 years dba / data architect / application design
Contract / Contract to hire, technical lead position requiring extensive knowledge of oracle database systems, strong analysis and design skills, excellent communication skills (clients, developers, customers, etc), with proven record of getting jobs done right even under tight time and/or budget constraints. Willing to travel, work long hours.
Over nineteen years of database architecture/administration experience, sixteen years oracle. Additional, extensive expertise in physical/logical modeling, data warehousing, project management, performance tuning, application architecture/coding, legacy system integration/migration, data replication and transformation (ETL), documentation and training/mentoring. Have worked on both internal and commercial software development efforts in commercial/Internet, industrial and government environments.
SOFTWARE / TOOLS / OPERATING SYSTEMS
oracle 9i,8i,8,7,6, oracle Enterprise Manager, ERWin, Designer/2000, PL/SQL, Stored Packages/Procedures/Table Triggers/View Triggers, Developer/2000 (Ver. 6, 2.1, 1.4,etc.), export/import, SQL*Loader, database links/oracle Gateway products, C, Pro*C, Pro*Fortan, Unix (AIX, Sun/Solaris, Sun/SCO, HP, Compaq/DEC), Win 2000/NT/Me, Business Objects Designer/Reporter
April 2003 ? Present, Johnson & Johnson ? Jacksonville, FL (Contract)
Brought in on short notice (emergency medical) to continue ?one man? Forms 6.0 application / 9i database design/development/production support for clinical studies group. Was able to get back on schedule in less than one week with only three hours of turnover and no documentation. Prepared proposal for re-design of application and database, project currently awaits funding.
October 2002 ? Present, Unifi Corp. ? Greensboro, NC (Contract)
Design new, convert existing custom interfaces for oracle 11i using oracle established coding standards. Includes oracle Forms/Reports and Pro*C (oracle 9i). Both web and client-server deployments. Conducted advanced PL/SQL training. Continue to work remotely on a part time basis.
November 2002 ? April 2003, Verisign Corp. ? Savannah, GA (Contract)
Design oracle database for new telephone activation service. Consulted on other ongoing database design efforts. Extensive use of advanced PL/SQL, oracle 9i features. Conducted training on database design, PL/SQL, advanced tuning and 9i features.
February 2000 ? April 2002, iSolutions Corp. ? Jacksonville, FL (Contract)
Project: Develop two Internet portals (J2EE/Weblogic) for medical supply company client allowing medical facilities to place orders via online catalog, with real time order tracking (currently producing over a million dollars in revenue per month). Also provide client with database expertise on existing OLTP and OLAP systems (tuning, backup/recovery, partitioning, etc.) as well as mentor their DBA staff. Position: Senior/Lead DBA, Data Architect
Duties: Designed/deployed two oracle 9i/8i databases to support two different portal based on-line ordering systems with extensive interfaces to two existing JD Edwards ordering systems (one JDE oracle, other DB2), interface used materialized views (snapshots)/database links/distributed transactions/oracle DB2 Gateway product. Made heavy use of the ERWin design tool to produce logical and physical models with install and upgrade scripts. Designed and coded several major stored package/procedures/trigger systems consisting of a pricing engine, order submitter, full order tracking, co-branding support and a universal error handler. Heavily assisted in requirements gathering, client interaction, user interface design and project management. Designed/implemented data mart, extensive ETL routines and table-partitioning system for data warehouse. Tuned/rewrote existing queries in multiple existing systems. Designed/developed entire portal catalog maintenance system (Developer/2000) including image/BLOB database storage, role based security system and staging areas. Catalog staging areas consisted of 'working', 'review' and 'production' with high speed migration from one area to another (packages/triggers). Supported database synchronization?s between laptops and main database. Mentored client's DBA and Development staff on daily basis. Extensive Unix scripting. Repeatedly asked for by name from several clients departments to assist in troubleshooting system wide problems not related to the current project. Platforms: Win2000/ME, NT, Sun Solaris, HP-UX, Linux.
August 1999 ? February 2000, Raytheon Aerospace ? Pensacola, FL (Contract)
Project: Migrate older Sun/SCO Unix systems to new Sun/Solaris platforms (Navy aircraft maintenance systems). Upgrade oracle database, Developer tools and custom code, special emphasis on Y2K compliance. Migrate second system to Win NT platform. Position: Lead DBA / conversion technical lead
Duties: Sole DBA with duties including installing oracle 8i (8 instances), optimizing (memory and tablespace usage), installing and using oracle Enterprise Manager, develop backup and recovery procedures, install Developer 1.6, 2.1, 6.0, train existing staff. Installs were on Sun/Solaris and Win NT. Also became project lead on the actual tools and custom code upgrade/conversions as well as lead on actual deployment team. Performed extensive optimization on existing inventory system.
August 1998 ? June 1999, Raytheon Engineering/Kraft Foods ? Birmingham, AL (Contract)
Project: Deploy updated software and new HP Unix servers to 10 Kraft food plant laboratories (contract awarded to Raytheon). Position: Lead DBA / Group Leader
Duties: Performance tuning of database, developed procedures for migration of data for junior DBA?s, installed concurrent instances for the database on most servers, assist project manager with scheduling, resource allocation, etc., came up to speed on Business Objects as quickly as possible ? designed the main ?Universe? (database interface) to assure proper data retrieval for ?drag and drop? report users. Assisted developers in design of Business Object reports. Prepared specification for, designed and wrote client/server Developer/2000 application to replace major portion of vendor?s software (deployed to 10 laboratories). Taught advanced PL/SQL and Developer/2000. Heavy emphasis on DBA skills/experience, Unix, PL/SQL, Developer/2000
March 1995 ? June 1998, US Telecom ? Hilton Head, SC (Contract and Permanent)
Project: Commercially available client/server telephony software package. Including billing, service orders, customer care, inventory management, etc. oracle based (RDBMS-ver. 7.3, Developer 2000-ver. 1.4W, Pro*C), using UNIX and NT servers with NT/95 clients. Position: Project Manager / Database & Application Architect
Duties: Started as contract developer doing specification preparation, design and coding of major add-on module. Upon completion of the contract accepted offer to become permanent project manager / system architect. Designed entire telephony billing system (Pro*C). Approved all new designs, database changes and maintenance efforts. Implemented software change/configuration control systems. Other roles included Lead DBA, technical subject matter expert for customer presentations, technical authority on tool implementations. Led migration team converting entire package from Forms 3.0 to 5.0. As part of this migration, developed coding and design standards for new environment. Extensive multi-language ETL work for east European clients.
July 1988 ? March 1995, Westinghouse/Dept. of Energy ? Aiken, SC (Permanent)
Project: Design and build oracle based Laboratory Information Management System (LIMS) for nuclear laboratory at government weapons plant for Department of Energy (DOE). Large, multiyear project handled almost entirely by myself. Position: Senior Software Engineer
Duties: Application architect/developer, Data architect/administrator, VMS system administrator. Used oracle Forms 3.0 to develop the interfaces used to configure the system, forms proved lacking for use as the front end for actual users so Pro*Fortran was used to create a high speed windowing system. Designed and wrote low level systems to interact with laboratory instruments, operating system and network to perform everything from real time data gathering to data exchanges with process control systems. Created an API for other software packages to 'feed' data directly into the system. System consisted of multiple, networked databases. System had extensive, configurable security system that controlled access to software functionality as well as data. System is currently in use in two labs and was leading contender for the lab that would be associated with the new tritium reactor prior to it?s cancellation. Prepared full user and system admin documentation according to DOE requirements. Prepared DOE acceptable document change control system. Conducted all user training. (oracle (6.x,7.x), Developer/2000, VMS)
July 1981 ? August 1988, American Cyanamid ? New Orleans, LA (Permanent)
Project: Laboratory Information Mgmt System (LIMS), prepare specifications, evaluate available products, procure, implement, add functionality and train users.
Duties: Project started out as an effort to procure an existing LIMS package. It was determined that considerable functionality would be needed beyond the existing system. Designed and wrote functionality that operated on top of vendor package. Over 85% of the vendors code was replaced. Set up second database and brought a second laboratory in Mobile, AL online remotely from New Orleans using existing staff and hardware. Developed instrument interfaces to gather real time analytical data. Implemented system to handle labs through out the plant with controlled data and functionality access. System was finally retired after 15 years due to operating system Y2K issues. Concurrent with LIMS project headed up effort that converted drafting department from paper to CAD. Became system manager for Integraph CAD system that used VMS as data server to Unix workstations. Three years as analytical chemist.
Education: Bachelor in Chemistry, minor in Computer Science (almost double major)