Summary of Qualifications
Over 20 years experience in data processing. Positions have included Oracle
Database Administrator (15 years), Database Designer (17 years), Application
Developer (17 years), Systems Analyst (15 years), Project Leader (10 years) and Systems Manager (1 year).
Highly skilled at designing reliable, maintainable and lowest cost systems.
Consistently solve difficult design problems. Consistently design simpler solutions.
Project Process
Skill.
Technical Skills
Database Experience:
Oracle 8, Oracle 7, Microsoft SQL Server, Microsoft Access, dBASE II, ISAM.
Language Experience:
HTML, PL/SQL, SQL, AWK, FORTRAN, BASIC, PL/1, COBOL, dBASE II, RALLY ADL, C, DEC
Datatrieve, Metasymbol.
Hardware/Systems Experience:
HP9000, HP-UX, SUN SOLARIS, IBM, DEC VAX/VMS, XDS930, IBM PC, Windows
NT 3.5, NT 4.0, Windows 98, Windows 3.11, MS-DOS.
Education
BS, Mathematics, Central Washington University
MBA Studies, University of Portland and University of Seattle
AA, Judson Conservative Baptist College
Professional Training
Oracle Advanced Symmetric Replication.
(4/98)
New Features of Oracle8 for Database Administrators (1/98)
Forms and Reports Development in DEC RALLY.
Relational Database Theory.
Project Team Management.
Management Development.
Java 1.2
Professional Experience
Employment 1973 -- 1994
Freelance Consulting 1994 -- present
Sr. Oracle DBA, consultant
XO Communications (formerly Nextlink)
Oct 2000 to Dec 2000
Accomplishments at XO Communications
- Administered several 8.1.6 Oracle Databases running on Sun Solaris boxes.
- Created Tables, Views, Indexes, Constrainsts, User Accounts, User Security,
scripts.
- Assisted Software Developers with issues related to database performance
and access.
- Advised management regarding system design issues.
- Tools used: SQL, Oracle DBA Studio, FTP, Telnet, Microsoft Access.
Web Site Developer and Promotor
Design Your Web Page.com, Inc Jul 2000 to Sep 2000
Accomplishments at Design Your Web Page.com.
- Created HTML pages and META TAGs for ROBOTS, KEYWORDS, DESCRIPTION, CONTENT,
SUBJECT, RATING, EXPIRES, SHORTCUT ICON, BASE REF, EDITOR, REVISIT-AFTER.
- Submitted Web Pages to 80+ Search Engines using web site promotion software.
- Tools used: Java 1.2.2 SDK, Dreamweaver 3.0, FTP, Telnet, MS IE 5.5, Add
Web 3 (web site promotion tool), Icon Forge 4.6, unix.
Sr. Oracle DBA, consultant
David van Beek -- KPMG LLP Development
Center, (formerly known as KPMG Peat-Marwick) Sep
1999 to Jun 2000
Accomplishments at KPMG LLP.
- Supported twelve Oracle 7.3.4 databases on both Sun Solaris and Windows
NT 4.0.
- Diagnosed and proposed correction for a database-wide distruption of service
in the production database. A CI Lock was occuring and performance would slow
to a crawl in Oracle 7.3.4 on Sun Solaris.
- Created and maintained a stable environment for the Oracle Production Database.
- Installed Oracle 7.3.4 on serveral Windows NT 4.0 boxes.
- Installed Oracle 8.0.5 on several Sun Solaris 5.6 boxes.
- Installed Oracle Patch 8.0.5.2 on several Sun Solaris 5.6 and NT 4.0 boxes.
- Tuned application SQL.
- Tuned Tables and Indexes.
- Created and implemented plan for migrating twelve Oracle 7.3.4 databases
to Oracle 8.0.5.2.
- Wrote detailed step-by-step instructions for migrating Oracle 7.3.4 databases.
- Migrated several Oracle 7.3.4 databases to Oracle 8.0.5.2 databases on
Sun Solaris and Windows NT 4.0.
- Created application to monitor database backup logs and email status nightly.
- Created application to monitor production Oracle Database and email errors,
checking every five minutes.
- Installed Desktop Database Performance monitoring for the production database.
- Installed automated database space analysis and reporting software.
- Diagnosed and corrected problem with Oracle startup and shutdown scripts
on Sun Solaris to properly deal with 7.3.4 and 8.0.5 versions on the same
Unix Box.
- Set up SQL statement monitoring and analysis for one Oracle Database, including
integration of results with IIS Web Server logs and Net Dynamics Application
logs.
- Wrote programs to do summary reports of data access for management.
- Wrote scripts to compare all objects between any two Oracle databases.
- Wrote scripts to extract object definition statements from any Oracle Database.
- Refreshed data as needed in Test Databases.
- Diagnosed Network Issues and failures to connect to Oracle Databases.
- Wrote unix scripts to clean up log, trace and other miscellaneous files.
- Scheduled unix scripts using cron.
- Worked with computer operations people and developers.
- Created weekly status reports for management.
- Tools used: SQL Navigator (from Quest Software), Instance Monitor (from
Quest Software), AWK, SQL, Oracle Enterprise Manager, Space Manager (from
Quest Software), FTP, Telnet, Reflection, Wincron, Blat (freeware email for
NT), Oracle Installer.
Company-wide Oracle DBA/guru, Sr. Systems Analyst, consultant
David van Beek -- RHI Consulting
Jan 1999 to Jul 1999
Served as the company-wide DBA/guru and directly affected many aspects
of the company's product.
As Senior Systems Analyst , I analyzed new system design documents, participated
in design meetings, proposed solutions to meet the requirements of the client
and designed and documented technical requirements.
As an Oracle7 and Oracle8 Database Administrator I was responsible for
creating Oracle Tables, constraints, indexes, storage areas, access permissions,
triggers and procedures, creating user accounts and granting access to Oracle
tables. In addition, I assisted developers with diagnosing performance problems
with their SQL queries.
Specific accomplishments:
- Simplified the maintenance of metadata for the HotData Data Items. Reduced
the data structure from 30 tables to 3 tables. Eliminated the need for a
custom-written application to maintain the data.
- Eliminated the need for a separate metadata system for Oracle-based data.
- Eliminated the need to validate the correctness of a SQL query before
submitting it to the Oracle Database.This eliminated the need to maintain
custom-written code. Implemented Oracle "resource limits" to suspend
malformed SQL queries.
- Designed the implementation of flexible Oracle Views to map HotData Data
Items to the physical Oracle Tables.
- Designed a flexible indexing system to present data from multiple Tables
as a single virtual Table.
- Designed an algorithm for easily matching data from different sources.
- Identified and analyzed poor performing SQL queries and recommended changes
for improvement.
- Coached a college student intern regarding database, system and software
topics.
- Created ad hoc reports using MS Access, SQL and PL/SQL.
Sr. Systems Analyst, Oracle Database Administrator, Data modeler, consultant
David van Beek -- Montare-Comforce
& Ascension Consulting, Corp. Dec 1997 to Jan 1999
As Senior Systems Analyst , I analyzed new system design documents, participated
in design meetings, proposed solutions to meet the requirements of the client
and designed and documented technical requirements. The project was to interface
a database in a northern city to a database in Dallas. I designed the interfaces,
processes and PL/SQL Procedures to implement this interface.
As an Oracle7 and Oracle8 Database Administrator I was responsible for
creating Oracle Tables, constraints, indexes, storage areas, access permissions,
triggers and procedures, creating user accounts and granting access to Oracle
tables. I was also responsible for backup and recovery of one Oracle8 database
and three Oracle7 databases. In addition, I assisted users with diagnosing performance
problems with their SQL queries. Oracle7 rdms software was running on a HP-9000
HP-UX platform and Intel NT 4.0 platform. The Oracle8 rdms software was running
on an Intel NT 4.0 platform. In addition, I assisted developers with diagnosing
performance problems with their SQL queries.
As Data modeler , I used ERwin to analyze existing data structures and
to design new data structures.
Oracle Database Administrator, consultant
David van Beek -- Merridian
Technology Group Jan 1997 to Nov 1997
As an Oracle7 Database Administrator I was responsible for creating Oracle
Tables, constraints, indexes, storage areas, access permissions, triggers and
procedures, creating user accounts and granting access to Oracle tables. I was
also responsible for backup and recovery of 6 Oracle7 databases. In addition,
I assisted developers with diagnosing performance problems with their SQL queries.
Senior Analyst, Data modeler, Oracle DBA, consultant
David van Beek -- BDM International
Oct 1996 - Jan 1997
As a Senior Systems Analyst I was responsible for analyzing documentation
and participating in user meetings.
As data modeler , I was responsible for creating entity relationship
diagrams using LBMS Systems Engineer.
As Oracle DBA I was responsible for creating Oracle 7 Tables, constraints,
indexes, storage areas, access permissions, triggers and procedures.
Senior Business Analyst, consultant
David van Beek -- Solutions
IQ Jul 1996 - Aug 1996
As a Senior Business Analyst I was responsible for analyzing Ingres Database
Tables, Ingres Scripts, Ingres Application by form code and C programs with embedded
SQL. My main responsibilities included analyzing the present system, making recommendations
for optimization & improvement, and implementing those needed changes. Additionally,
I wrote a C program with embedded SQL that summarized data in the Ingres Database
and generated multiple tab-delimited text files for distribution via email.
Oracle Rally, Oracle RDB and EPA Regulations, consultant
David van Beek -- Weyerhaeuser
Corporation Longview Feb 1996 -- Jun 1996
I updated their Community-Right-To-Know software to comply with the new EPA Regulations.
This included the production of the recommended reports.
Other tasks were assessing the impact of newly listed chemicals and to train their
staff on how to use the software. Also, I estimated the cost of converting the
RDB Database to Oracle7 and upgrading Oracle Rally to version 6.1.
Oracle Database Administrator, consultant
David van Beek -- CINTECH Corp
Feb 1994 -- Feb 1996
As Database Administrator for Oracle Rdb databases my tasks were monitoring
the performance of databases, restructuring data-areas, updating access privileges
to the data, creating tables and indexes, creating scripts for database maintenance,
diagnosing and correcting problems related to Databases and answering questions.
Also, I analyzed the application performance and made recommendations for process
changes to the applications for performance improvement. One recommendation resulted
in a reduction of time to run the application by a factor of 50 .
Project Leader / Database and Application Developer
David van Beek -- Weyerhaeuser Corporation Research & Development Division
1983 -- 1994
As project leader / database and application developer, Systems Analyst and
internal consultant , I designed and implemented relational databases for
on-line information tracking.
The applications were developed in MS Access, DEC Datatrieve, Oracle Rally, DataEase
SQL, Transact-SQL (Microsoft/Sybase) and dBASE II.
As database developer and systems analyst my tasks were mostly focused
on systems analysis, systems design, database design, module design and programming.
As project leader , my tasks and responsibilities were to direct software
projects from specifications development to implementation.
This included the systems analysis, specifications development, systems design,
database design, module design, programming, training and implementation.
Project Leader / Database and Application Developer / System manager
David van Beek -- Tektronix 1976 -- 1983
As Database Developer I designed and implemented applications
in BASIC+2, FORTRAN-11 and DEC Datatrieve. The platform was DEC PDP-11 RSX-11.
As project leader , my tasks and responsibilities were to:
Direct numerous software projects from specifications to implementation.
This included the systems analysis, specifications, systems design, Database
design, module design, programming, training and implementation.
Evaluated and managed team members' performance.
As system manager , I managed and supervised a PDP-11/70 in-house timesharing
system.
As application developer , I wrote COBOL and PL/1 programs in an IBM
360 VM environment with the TSO option.
David van Beek, Oracle DBA / Systems Analyst / Architect
/ Data Modeler / Application Developer / freelance