KENNETH D. DAVIS
KENNETH D. DAVIS
3223 W. Fontanero St., Colorado Springs, CO 80904
Voice: h. 719-477-6809 c. 719-332-8216
E-Mail: kenneth.davis@ekklesia.com
SUMMARY:
IT background: Data Warehouse System Architect, Senior DBA, Data Architect, Software Analysis, Development, Training and Support.
Programmatic: Twenty years RDBMS (Oracle 7,8i,9i, 10g), Xbase; Ten years ETL, Data Migration; Twelve years PL/SQL; Nine years Unix shell; Eight years Data Architect
Developmental: Oracle DBA 7,8,8i,9i,10g, PL/SQL, ErWin Modeling, Ab Initio, MS SQL, K Shell, API, HTML, OOP/OOD, Foxpro, Access
Testing: OO, Xbase, Client/Server, Multi-tier, C, C++
Communication: Emulators, TCP/IP, Ethernet/LAN.
OS/Platform: Expert (Unix HP/Sun; W2K, XP); Intermediate (Linux, AIX)
Management: Demonstrated ability to administer projects.
Accounting: Developed / maintenance of accounting environments.
Supervisory: Eighteen years administering five to seventy-five team members.
Financial: Business/financial planning and procurement consultant.
Miscellaneous: Expert witness (4/2000), Texas PUC for Reciprocal Data Hearings. Analysis/validation for PUC hearings in CA, TX, CO, OH. Patent development and automated manufacturing processes.
PROFESSIONAL EXPERIENCE:
Scripps Networks, LLC, Data Warehouse Systems Architect / Senior Oracle DBA / Data Architect, November 2006 - September 2008
* Client had failed to produce an operational Data Warehouse system for 18 months.
* Designed hardware system configuration for Data Warehouse, ETL processing and Data Mart sub-systems.
* Prepared and presented system design to senior staff for project approval.
* Project managed build out of new hardware and software system configuration(s).
* Trained ETL staff in proper techniques to reduce daily processing times by 800%.
* Data Architected (Erwin) Data Warehouse atomic store and built required Oracle instances.
* Wrote PL/SQL to extract data from source systems.
* In first 3 months first complete working component of system had been designed, built, tested and released to production with reduced daily ETL processing from 26 hours down to 15 minutes.
* Presented architectural plan for approval to build complete warehouse over next 18 months.
* Designed and then trained personnel in Korn shell to automate external data extract system, Informatica automated processing and error sub-systems.
* Repeated process for next seven ETL/Data Mart sub-systems over the next 14 months.
* Managed and trained Oracle dba staff is operation of multiple terabyte warehouse operations and maintenance.
* Designed migration of part of the atomic warehouse to Sarbanes/Oxley compliant secured environment.
* Designed architecture for build-out of new Business Intelligent Data Mart for > 1,000 users.
BAE Systems, Senior Oracle DBA, May 2005 - August 2006
* Oracle DBA to multiple Dod instances.
* Prepare Erwin data model(s) and deploy model(s) to Oracle instances.
* Provide technical support to developers and user communities.
* Large scale parallel processing using Oracle in a clustered environment.
* Instance analysis and performance tuning.
* SAN configuration to clustered MS 2003 servers.
* Usage of Quest tools.
* Multi-master replication of data to backup instances.
* Built ETL processes for data mart/warehouse.
Level 3, Ab Initio Developer / Data Architect, April 2004 -April, 2005
* Prepare Erwin data model(s) and deploy model(s) to Ab Initio processes on Unix (Sun).
* Ab Initio development for telephony billing records. Process raw data and merge data stream with Oracle data to prepare data marts.
* Ab Initio development for telephony hardware capacity planning. Process raw hardware component usage records; scrub, aggregate and rollup data to data mart for management review and planning.
* Large scale parallel processing using Ab Initio and Oracle Pl/Sql.
* Korn shell development for wrapper control of Ab Initio processes.
ITT Industries - DOSCOMM, Senior Oracle DBA, March 2003 – September, 2003
* Oracle DBA for Department of State (Distributed Information Network)
* Oracle 9i system configuration for clustered O.S. (W2K)
* Oracle 9i Advanced Replication configuration for multi-mastered asynchronous replication.
* Oracle 9i Instance tuning and performance analysis.
ITT Industries, Senior Oracle DBA / Data Architect , March 2002 – March 2003
* · Oracle DBA for design, documentation, coding and implementation of DoD communication satellite control system.
* Data Architect using ErWin design tools for Oracle database.
* · Produced and presented PowerPoint presentation(s) on Oracle database design and security features to ITT, Boeing, Raytheon, Northrop Grumman and U.S. Government Representatives.
* Designed and administered testing of Army ARSPACE NT workstation performance allocation and requirements tests for compliancy.
* · Configured EMC multi-terabyte RAID as a network storage host subsystem (NAS).
AT&T Broadband, Senior Oracle DBA / Developer, July 2000 - September 2001
* Oracle DBA for 9 production instances, (2 data-warehouses > 1 terabyte, 1 data mart 1/2 terabyte, 3 data-warehouses > 150 gig and 3 auto-processing instances using Oracle 7.3.4, 8.0.5, 8.1.6, 8.1.7).
* Responsible for critical system operation during peak periods, data structures covered customer record files for entire Eastern United States and five Western States. Loss of system would stop marketing feeds critical to corporate income.
* Organized extensive usage of database links, partitioned data/index structures and materialized views.
* 7/24 support for databases and production operations teams.
* Direct support for 500+ users through nationwide third party support desk system(s).
* Directly supported operation/development of interfaces for background processes from billing systems, tandem switch feeds and Abinitio and Informatica (inclusive of data scrubbers, i.e. Trillium).
* Performed SQL tuning for development code migration to production systems.
* Assisted in SQL tuning for user based ad hoc queries.
* Taught developers to tune PL/SQL and use trace and explain plan outputs.
* Oracle instance tuning resulted in 200%+ performance improvements.
* Integrated monitoring tools (Quest Spotlight, Sql xpert, TOAD).
* Korn shell scripting for Sun UE10000 and HP9000 systems.
* Tested Holos reporting applications with Seagate Info Reports.
* Worked on team to install/upgrade Quest Vista 4.5 to capture reports from Oracle Financials.
* Debugged and wrote error trap routines in Unix Korn Shell for automated Holos applications.
* Worked with managers to trouble shoot system failures in Oracle and Korn shell applications.
PROFESSIONAL ASSOCIATIONS:
National Rifle Association; Life Member 1975
The Voice of the Martyrs; 1972-2008
Colorado Springs Chorale Society; 1995-1997
EDUCATION:
B.A.; Theology & History; Harding University, Searcy, AR
Graduate Studies in Theology & Psychology; ENMU
Secondary Education Certification; ASU, Tempe, AZ
Certificate in Safety; ASU, Tempe, AZ
Rational Solution Suite
MS Developers Network
Visual Foxpro Developers Conference, Phoenix, AZ
MEI Visual Foxpro Training Seminar, Denver, CO
Delphi Development Training Seminar, Phoenix, AZ
References furnished upon request.