Experienced independent consultant specializing in database development using Oracle on Unix. Broad experience in database administration, Unix system administration, application development and operating systems. A team player and leader with excellent written and verbal communication skills and outstanding interpersonal skills.
Technical Expertise: Web-based data solutions, Unix system administration, database system architecture and design, data warehousing, internet communications, user interface and ergonomics, multilingual application development, feasibility analysis (prototyping), application and query performance tuning.
Languages: PL/SQL, Korn/Bash Shell Scripting, SQL, Perl, HTML, Java (JDBC), JavaScript, XML, PHP, Visual Basic, Lasso.
Database Management Systems: Oracle, MySQL, Access, Btrieve, FoxPro, dBase.
OS Expertise: Unix (Sun Solaris, HP-UX, Mac/Darwin), Linux (Red Hat, Slackware, Yellow Dog Linux, LinuxPPC), Windows NT Server, Macintosh.
Oracle Development / Oracle DBA: 8+ years, frequent project lead. (See 2, 3, 4, 7, 9 below.)
Unix System Administration: equivalent 5 years, tasks related to database and web site development and administration. (See 1, 2, 3, 4, 5, 7, 10 below.)
Data Architecture: 10+ years, including all phases of design process from gathering of business requirements to user interface design and logical and physical database design. (See 1, 2, 3, 4, 5, 6, 7, 8, 9, 11 below.)
Microsoft Access: 9 years. (See 4, 7, 8, 9, 10 below.)
MySQL: 3 years. (See 1, 2, 5 below.)
Total DBMS Experience: 12+ years.
Worked as an independent or subcontracting consultant with various companies from 1993 to present. Significant projects (in reverse chronological order):
1. Apr. 2002 to present, ongoing: Dynamic Web Content Programmer, DBA
Designed data structures and wrote server code for dynamic web site for custom painted furniture company. Performed Unix software installation and configuration on Mac OS X (BSD-Unix) Server. Wrote PHP, Perl and JavaScript code using MySQL to drive content, then wrote Perl and Unix shell scripts to automate loading of order data from NT Server Btrieve database so that clients can check current order status online. [Client: Patina, Inc., Atlanta, GA.]
2. Sep. 2002 to present, ongoing: Oracle Database Programmer, DBA
Designed data structures and loading strategy for data warehousing component of automated passenger counting system used on buses in major transit systems throughout North America. Installed and configured Oracle 9i on Mac OS X Server. Wrote Oracle 9iR2 SQL and ANSI-SQL scripts to load data; tested loading on Oracle 9i, MySQL and MS SQL-Server. [Client: Urban Transportation Associates, Cincinnati, OH.]
3. Sep. 2001 to Apr. 2002: Oracle Data Warehouse Architect, DBA
Gathered business requirements, designed and developed Oracle data warehouse to analyze huge amounts of transit data for metrics and government reporting. Wrote Java, Perl, HP-Unix shell, and PL/SQL programs to gather data from various Unix, Mainframe and PC systems. Performed all DBA tasks. Worked closely with developers to design OLAP analysis system and web-based reports. [Client: Metropolitan Atlanta Rapid Transit Authority, Atlanta, GA.]
4. Mar. 2000 to Jun. 2001: Oracle Data Warehouse Architect, Developer, DBA
Designed, implemented and maintained very large Oracle 8i data warehouse providing order visibility information for order tracking and metrics. Designed parallel data-gathering techniques on Solaris using cron with Perl and Korn shell scripts, wrote PL/SQL programs to gather data from DB/2 system via ftp/Korn shell scripts, tuned queries, performed all DBA tasks and supported end-user reporting tool using Microsoft Access. [Client: Lucent Technologies, Atlanta, GA.]
5. Jan. 2000 to present, ongoing: Web Database Architect, Developer, DBA
Designed logical and physical architecture and then implemented web-based decision making process for survey research company. Wrote PHP and Perl code using MySQL in a Linux environment. Configured web site, gd graphics libraries and database access tools. [Client: MetaLogic Research. Note: Jay Davis is part owner of this company.]
6. Oct. 1999 to Jan. 2000: Web Database Architect, Developer, DBA, System Administrator
Designed and implemented database back-end for an e-commerce web site using Lasso and Filemaker Pro in a Mac OS environment. Note: Site has been modified recently; however, basic programming code appears functional. [Client: Earthshaking Music.]
7. Jan. 1997 to Oct. 1999: Oracle Data Warehouse Architect, Developer Lead, DBA
Wrote business requirements, designed and then directed a team of four programmers to implement an Oracle 7 data warehouse and application front-end for use in management of large telephone network construction projects. Wrote PL/SQL programs and Korn Shell scripts (Solaris) and Microsoft Access (VB 5) code to automate gathering of data from DB/2 via ftp scripts. Performed various DBA tasks.
Analyzed existing Oracle 7 application and front-end, designed and created enhancements and tuned Oracle stored procedures to dramatically improve performance using VB 6.
Designed and implemented system procedures to transfer files across a WAN using NT Servers, Perl 5 and Windows NT command files. [Client: Lucent Technologies, Whippany, NJ.]
8. Aug. 1994 to Dec. 1996: Data Warehouse Architect, Developer and Development Manager
Created data warehouse and directed programming team in creation of front-end for system used to track installation costs for large construction projects. Wrote front-end using Visual Basic 4, Access 2 and Btrieve. [Client: AT&T Outside Plant Systems, Duluth, GA.]
9. Feb. 1994 to Aug. 1994: Oracle Database Architect, Developer, DBA
Created Oracle application used to define corporate business terms and processes using Access 2 and Oracle 7. Performed DBA tasks.
Designed and created database tool to track relationships among various corporate entities using Access 2. [Client: The Coca-Cola Company International, Atlanta, GA.]
10. Jan. 1993 to Feb. 1994: Database Developer
Created portions of multilingual point-of-sale (POS) system using VB, Access and HP Unix.
Maintained existing systems in FoxBase+/UNIX and FoxPro/Windows. [Client: WalMart Vision Centers, Atlanta, GA.]
11. Feb. 1990 to Jan. 1993: Manager of Information Systems [Full-Time Position]
Designed, created and maintained membership tracking and product sales DBMS using FoxBase+/Macintosh. [Employer: Center for Media Literacy, Los Angeles, CA.]
Bachelor of Arts in Communications, with honors. Minor in Physics. Auburn University, 1984.
Master of Divinity, with honors. Emory University, 1988.