Resume 9

Senior E-Commerce VLDB DBA/Architect and Oracle Replication Specialist

Independent Consultant:

Architected development system into a highly available production configuration using Oracle advanced replication, standby database, Veritas HA Cluster and Oracle Dataguard products. Systems were designed, tested and implemented for minimum downtime in the event of a node, database or corruption failure. Designed production architecture from scratch to scale out multiple servers with load balancing as well as up within the primary machine with zero completed transaction loss on switchover. Worked with developers to implement JDBC cached connection pooling and improve SQL queries, bfile and XML access.

Primarily responsible for SQL and database level tuning and scalability projects for Corporate Express primary OLTP systems. Modified systems to enhance scalability due to migration from legacy systems. Increased workload 100 in two months with no loss of response time. In project to purge approximately 50GB of old data, improved performance by twenty-fold by tuning or re-writing the SQL and parallelizing the process. Performance white papers were written for this client on buffer busy waits, sequential read waits, db_block_size comparison, SQL tuning and file I/O load balancing.

Implementing 2TB+ OLTP system Sapphire to process loan information from over 1000 offices in a 7/24 operation at 99.99 uptime requirement. Implemented Oracle Parallel Server 8.1.6 - SUN PDB on two Sun E10000 machines for high availability requirements. Modified physical design of databases for the specific needs of OLTP and secondary structured reporting data mart approx 5.5TB . Designed and implemented EMC EDM Symmetrix SymmConnect and SymmPath backups for minimal impact on database operations. Using Veritas, created all raw volumes and filesystems for use by the OLTP and structured reporting systems. Other duties include production support of HR, payroll, Remedy, ITO and other production systems.

Manage over 35 production and development databases on 14 systems HP, SUN, IBM-AIX, NT . Databases support Peoplesoft HR, Oracle GL and GEMMS in 7/24 operation. Upgraded systems from 7.3 to 8.0 and 8i using Oracle s migration utility and import/export. Created processes to monitor and implement changes to all systems from one machine with shell scripts ksh via remote shell, SQL and other methods. Simplified systems to have a similar look and feel for ease of maintenance, i.e. naming conventions for datafiles, tablespaces and directories, scripts written once to modify any or all of the instances as well as logical and physical backup scripts using BMC SQL*Backtrack. Database project lead for advanced technology projects to include sales-force automation updateable snapshot replication , imaging and Oracle Express all on Oracle 8i. Created and executed plan to move several 100GB+ databases from New York to North Carolina to include tablespace consolidation and reorganization within a very limited timeframe..

Designed physical and logical structure and implemented client s health insurance commerce server. Previously implemented for one carrier on Windows NT and Oracle 7.3.3, the new system will include over 100 carriers and 400 users for 7x24 operation. Designed disk layout for EMC2 3430 array for optimal OLTP performance and to scale to projected growth of 228GB per year.

Designed and implemented changes to tune and enable operational consistency to nine databases of approximately 200GB each supporting the free email services of Country.Net Netaddress and Netscape Webmail and fee-based mail American Express, Country.Net s Postoffice.net . Also manage 8 other supporting databases for customer service, order processing, etc. Increased amount of data accounts stored on each mail database by 160 from 900,000 to 2.5 million with no change in response time sub 2 second . Reduced database downtime from an average of 30 hours/month to less than 2 hours including scheduled maintenance for 99.7 availability. Worked with Timebridge and Country.Net personnel to resolve memory and I/O tuning issues. Implemented new backup procedures for all databases using EMC2 Symmetrix and Timefinder software with EMC2 s EDM backup system and tape array subsystem replacing RMAN and EBU. Lead and trainer of junior DBA blending Oracle training with practical knowledge specific to the needs of Country.Net s OLTP systems.

Senior member of the Server Technologies kernel group.

• Senior analyst resolving database, advanced replication, backup - recovery, tuning, PL/SQL, and internals issues for worldwide clients.
• Replication specialist for the Rocky Mountain Support Center. Resolved in depth replication issues in multi-master, updateable and read-only snapshots. Instructor in Oracle replication internals and replication SME subject matter expert for Oracle 8i beta program.
• Systems administrator/DBA for six Server Technologies group systems Sun, HP - Windows NT . Manage over 50 databases for training, version testing, beta testing and customer test cases.
• Manage eight analysts, assist in resolution of technical issues, provide a technical escalation path, define training plans, scheduling and manage day-to-day operations customer satisfaction, call and issue metrics .
• Developed and presented training courses for analysts in advanced replication, distributed database operations, database installation, snapshots, multi-threaded server and SQL*Net.
• Developed and implemented web based personnel scheduling system and team TAR tracking system written in PL/SQL.
• Maintain script repository for Oracle Support Services. Scripts are evaluated, tested and placed for availability on an intranet web site.
• Developed and maintain the RMSC RDBMS intranet web site.

Consultant engaged in multiple DBA and development assignments including:

• Bureau of Reclamation, Department of the Interior - Addison, Colorado
  Oracle 7.3.x HP/UX 10.20 -- Designed, tested and implemented time - attendance/inventory data warehouse. System consisted of 19 distributed sites processing data to a central data warehouse. System implemented with Oracle7 7.3 with updateable snapshots and multi-master replication. Also developed distributed systems disaster recovery plan with Unix and SQL scripts and provided database and application tuning expertise. Worked with PSDI personnel to adapt Oracle database to specific needs of their Maximo product. Wrote PL/SQL code and triggers to process data between Maximo and other Bureau of Reclamation applications.
• Unisys/State of Wisconsin - Fremont, Wisconsin
  Oracle 7.2.3 Sequent Dynix -- Medicaid Data Warehouse Conversion. Created PL/SQL procedures to load/process data from legacy flat-file application into relational tables. Advised Unisys and Oracle staff on large scale systems 500+ GB and DBA concerns on HP T-500 system.
• Bell Atlantic Video Services - Bellton, Virginia
  Oracle 7.0-7.2 Sun Solaris 2.4 -- Design, installation and documentation of multi-database table level replication using snapshots. Database to support real-time order and video stream processing to home set-top boxes for direct video. Installation, database setup and tuning on Sun Solaris. Upgraded SQL*Net from 1.2 to 2.1 and modified applications for the new version. Task lead for migration of data from three sources two Oracle databases and a Filemaker Pro flat file database to two new Oracle databases.

Designed and developed Sybase database and applications using stored procedures and C++ to retrieve and process over 250,000 rows six times daily approximately 4000 real-time measurements for Hughes HS601 and HS603 communications satellites. Rewrote Sybase header files to C++ standards and tested system with 130 million rows of data.

Lead engineer and Oracle DBA. Designed, coded, installed and maintained database systems for Air Force Space Command customers. Logical and physical design for prototype and productions systems running parallel server. Other engineering included: design and code of human-machine interface using X-Windows and Motif, programming in Ada/Pro*Ada, C and C++ and documentation to DOD-STD-2167A standards.

Software: Oracle8i through 8.1.7 , Oracle8, Oracle7, Oracle V6 - V5.1, PL/SQL, Net8 - SQL*Net, DataGuard, EMC2 Symmetrix, Timefinder and EDM, BMC SQL-Backtrack, Pro*C, Pro*Ada, SQL*Module, Oracle Forms 4.5, Oracle Reports 2.5, C, C++, Ada, X-windows/Motif, Sybase, Veritas, Unix shell scripting korn - C shells , Perl

Hardware: Sun Solaris - SunOS , EMC2 EDM, EMC Clariion, HP HP/UX 9.X, 10.X - 11 , PC Windows NT , IBM AIX , Digital DEC Unix, VAX - OpenVMS , Sequent Dynix and SGI IRIX 5.x - 6.x

Oracle7 and Oracle8 - 8i Database Administration
Advanced Replication - Snapshots
Backup - Recovery
Database and Application Tuning
VLDB Design and Implementation
Distributed Database Design and Implementation

Oracle Certified Professional 7.3, 8.0, 8i
Database Administrator 2/98, 1/00, 6/00
Certifications: Oracle Masters - Database Administrator - 1995
Masters Candidate - Computer Systems Engineering
Colorado Technical University - estimated completion - 2001
B.S. Computer Science - Northwestern Oklahoma State University - 1989

Oracle Classes: Database Internals, Replication Internals, Database Administration, Backup - Recovery, Tuning, Advanced Symmetric Replication, Oracle Webserver Administration, Developing Web Applications with PL/SQL, Distributed Database Administration, Introduction to Data Warehousing, Implementing an Oracle Data Warehouse, Oracle8 New Features for Administrators, Oracle8 New Features for Developers, Managing Teamwork

Level 1 Award - RDBMS Group Outstanding Analyst Oracle Support Services - December 1997