DAVID B. RUSSELL
875 STEVENS AVE APT 2306
Solana Beach, CA 92075
Phone: (858)481-3283
E-mail: david_russell@roadrunner.com
Objective
David Russell is a senior level data
architect, database designer and administrator with expertise in the entire
system life-cycle for military, government, private and commercial
organizations.
He is constantly looking for contract
or consulting positions to apply these skills on a regular schedule. He
is currently on site with a government customer; but is available for client
meetings and proposals, as required.
Professional Summary
Over ten years in both production
support and development/test/QA environments. The same ten years each in
UNIX and Windows (command line and GUI). Oracle through 10g on a dozen
platforms. Knowledgeable with many operating systems allowing me to
perform OS installations and initial systems administration. Experience
with the Oracle financial modules from an administration and patching
perspective, plus limited functional area expertise in accounting. Good
Communication Skills.
Systems analysis, design, integration,
operations, maintenance, and administration; Expertise in logical and physical
database analysis, E/RDs, modeling, automation, performance tuning, charting,
diagramming, training and documentation.
Technical Summary
Oracle7i-10g database, Oracle
Financials 10.7 and 11.3; Informix, Sybase, MS SQL Server, HP-UX, Sun Solaris,
Windows, Assembler, BASIC, C, COBOL, FORTRAN, Machine (binary), SQL, PL/SQL,
plus several other languages. Plus exposure to Microsoft Access, dBase,
FoxPro, Paradox and many PC based database products. Migrations between
many combinations, and various forms of data replication.
Operating Systems
HP-UX, Sun Solaris, Linux, AT&T
System V, VAX/VMS, Digital Equipment Corporation OSF/1, Data General AOS/VS,
Prime, IBM/VM and MVS (3090, 4381 & 9370), and of course, IBM/PC DOS,
Windows.
Computer Languages
Assembler
BASIC
C, C++
COBOL
FORTRAN
Machine
(binary)
SQL, PL/SQL
Modeling Tools
Oracle Case
KnowledgeWare
IEW/ADW
System
Architect
PowerBuilder
PowerSoft
(S-Designer)
ERWin
Visio
Chronological History
Database Consultants
Solana Beach, CA
10/01-Present
CONTRACT DATABASE ADMINISTRATION
·
Various
customers in San Diego and Carlsbad. Maintenance, backup, tuning,
configuration, and help with resolution of issues. Also trained team of
developers in Oracle/SQL issues and performance tuning. Wrote migration
scripts for customer product upgrade on east coast.
Novartis Research Foundation (GNF)
La Jolla, CA
03/02-05/03
Oracle
and SQL Server DBA
·
Manager
of database group. Responsible for twelve Oracle databases on Solaris and
Linux, and five SQL Server 2000 databases, and two related applications.
Migrated applications to new platforms and versions of Oracle. Built
Veritas cluster with Sun V880 using dynamic features of 9iR2 and Solaris.
Monitoring and Maintenance on a daily basis. Backup and Recovery with and
without Veritas Netbackup.
Lightspan.com
La Jolla, CA
05/01-10/01 PRINCIPAL
DBA
·
Manager
for the database group responsible for 15 SQL Servers. Six of these
servers are SQL 2000 clusters. Migrated from SQL Server 7 to SQL Server
2000 in this all Microsoft shop. Wrote and implemented database
standards, established routine backup jobs, automated and documented existing
procedures, jobs, and tasks. Taught Microsoft SQL Server 2000
Administration course at UCSD.
Edupoint.com Solana Beach, CA
07/00-04/01
ORACLE DBA MANAGER
·
Managed
team of three Oracle DBAs who supported several 8i instances on Solaris.
These databases where used by a custom Java application that ran on our
website. Other databases were used for internal purposes. One DBA
was largely responsible for data migration and integrity while the others
worked with performance, upgrade and maintenance issues. Designed Oracle
standby database configuration as long-term solution to provide limited
downtime. Defined hardware and software upgrade requirements.
Automated most aspects of day-to-day operations. Also supported several
SQL Server databases and scripted daily data delivery to Microsoft Encarta, a
business partner. This was a hands-on position with 25% management
responsibilities.
Equipp.com San
Diego, CA
11/99-06/00
ORACLE DBA
·
Managed
three Oracle 8i instances on Solaris that were used by Moai Live Exchange
auction software. Replicated Oracle8i database to Linux for management
reports. Managed three additional 8.0.5 instances running 11.0.3 Oracle
Financial software. Limited application support and minor patch
upgrades. Also managed Oracle database to support Accrue Insight (web
traffic monitoring software). Provided customized database installation
to support this three-tier software in a two-tier environment. Also
supported several SQL Server databases and scripted automatic weekly delivery
of data to our help desk.
Gateway
San Diego, CA
08/99-11/99
ORACLE DBA
·
Oracle
DBA. One of three supporting over twenty Oracle8i instances in four
development and test environments, and “go live” of E-Commerce
application for Telesales division of company into production where contractor
personnel will take over all support. Worked extensively with data
replication (updateable snapshots), interMedia (context server and indices),
OEM 2.0.5, Systems Management Server (remote administration), BMC Patrol, Quest
Software Instance Monitor, and other current technology tools, all on NT and
Sun Solaris platforms.
SAIC
San Diego, CA
01/99-08/99
ORACLE DBA
·
Oracle
DBA. Oracle Installations, 24/7 production & application support, and
year 2000 responsibilities. Responsible for migrating two live production
systems (Kenan/Arbor Billing & Ace*Comm Mediation) from San Diego Data
Center to customer location in Denver, CO. Installed and maintained
Informix based fraud (ATACS) application for this telecommunications customer.
Duke Energy
Charlotte, NC
09/98 to
11/98 Contract Oracle DBA
·
Oracle
Installations, 24/7 application support, and year 2000 responsibilities.
Wachovia Bank
Winston-Salem, NC
10/97 to
07/98 Contract Distributed DBA / Team
Lead
·
Year
2000 DBA responsible for all distributed (non-Mainframe DB/2, non-IMS),
databases (Oracle, Informix, Sybase, and IBM UDB) for major bank customer.
Responsible for locating and identifying products and test resources. Worked
with vendors to secure software products. Wrote test scripts, configured
environments, and managed a team of DBAs to complete the respective tests.
Sybase DBA managing migrations from versions 4.9.2, 10.x, and 11.x to Adaptive
Server Enterprise (ASE) 11.5. Also supported Virginia Bank Merger with
various DBA related tasks required on short notice. Received exposure to
Progress, CA-DB (Ingres), MS Access, dBase, FoxPro, and Paradox databases
although these will end up being tested by the individual business units that
use them.
Computer Science Corporation
Fairfax, VA
06/97 to
10/97
Contract Oracle DBA / Designer / Team Lead
·
Worked
on System/Subsystem Design Document, Database Design Document and Software
Design Folders for four site Oracle replication of a very large database.
Responsible for the Manage Data, External Database Interface, and External
Management System Interfaces essential components. Using Designer 2000 and
Software thru Pictures (StP) to document design. System being built on Sun platforms
under Solaris 2.5.1 and using CA-Unicenter, Accugraph, and Remedy off the shelf
application packages.
SAIC
San Diego, CA
09/96 to
4/97 Contract Oracle DBA
·
Oracle
installation of RDBMS, tools, SQL*Net, and replication, on six DEC Alpha
servers. Implemented N-way replication, and snapshots, for customer demo on 80
tables at multiple sites. Configuration and performance enhancements on DEC and
SGI platforms. Coded Oracle Call Interface (OCI) bound arrays using C and C++,
and wrote several reports using SQL*ReportWriter. Oracle installation on RISC
6000, with replication to NT platforms. Also designed and wrote PL/SQL
procedures and functions for a fourth project.
Boeing Information Services
Vienna, VA
12/91 to
08/96
DBA, Designer, Developer, Analyst, Technical Lead
Amplified below by position and / or
manager
04/96 to
08/96 Army Reserve / Marine Corp
Data Management Department
·
Worked
Data Administration issues centered on development of the metadata repository
using Rochade under MS NT and Sun Solaris OS.
02/96 to
04/96 Boeing / GRC
Proposal Effort
·
Successfully
managed, installed, configured and programmed all aspects of Oracle environment
with replication on multiple operating systems (Sun O/S, NT and HP UNIX 10).
Also staffed tasks for additional demonstrations in Ada and PowerBuilder, and
participated in presentation to government customer.
06/95 to
02/96 Army Reserve / Marine Corp
Data Management Department
·
Participated
in the Reserve Component Automation System (RCAS) program restructure effort.
The government realized in February that the direction for RCAS should be
toward an open architecture of a DOS nature using Common Off-the-shelf (COTS),
and Government Off-the-shelf (GOTS) products to accomplish this goal. The
program staff was down-sized from 1000 to fewer than 400 employees during this
time, assuring successful redirection of the contract.
01/94 to
06/95 Army Reserve / Marine Corp
Data Management Department
·
Technical
lead for the test data team of five full-time employees. Provided test data to
populate all instances of Informix database on the RCAS program. The Mission
Support Database consisted of over 1500 tables in an Informix RDBMS. Over 2000
data requests were filled in support of approximately 200 personnel.
10/93 to
01/94 Army Reserve / Marine Corp
Data Analysis & Value Mapping
·
Wrote
several programs in Informix R4GL to support this task. Also wrote utilities,
and defined techniques that were used by other programmers in their daily
development.
07/93 to
10/93 NASA Space Station
Freedom Program Office
·
Delivered
consolidated Work Breakdown Structure (WBS) in Forth Dimension (4D) Database on
Macintosh for Space Station Freedom Program (SSFP) which was being moved to
Houston.
12/91 to
07/93 NASA Space Station
Freedom Data Management
·
Responsible
for development of KnowledgeWare encyclopedia, and transition to physical
Oracle implementation. Provided data analyses, and database analyses support as
member of application team for Utilization and Operation task of NASA TMIS
project. Platforms included PC, VAX, and IBM 3090.
Grumman Data Systems
Herndon, VA
07/90 to
11/91
Systems Designer / Software Engineer / DBA
·
Worked
on Headquarters Systems Replacement Program (HSRP) Planning Programming
Budgeting System (PPBS). Member of database team using PC Oracle, IBM DB2, KnowledgeWare
IEW and ADW Case Tools, and the Brownstone Data Dictionary. The local expert
with the KnowledgeWare IEW CASE tools: the encyclopedia manager. Reverse
engineered encyclopedias into Oracle and DB2. Configured the standalone tool to
work on the LAN. Developed a LAN based encyclopedia distribution tool so that
multiple analysts may use encyclopedias conveniently. Developed procedures for
periodic consolidation of nineteen analyst’s individual encyclopedias
into one. Asked by KnowledgeWare to co-chair a Working Group (a modified
Special Interest Group, or SIG) at the April 1991 User's Conference in Atlanta.
Asked by KW to consult with their customers about encyclopedia management. One
of their customers being the DOD Computer Information Management CIM Group
which consists of those officials responsible for the Department of Defense
Enterprise Model, which will possibly be done in KW's IEW or ADW. Also provided
consultation to internal Grumman projects taking place at corporate New York
facilities.
Oracle Corporation
Bethesda, MD
05/90 to
07/90 Contract Programmer/Analyst
·
Worked
on a conversion project for the Post Office moving code from VAX character mode
to Version 6 Oracle and the IBM 3270 block environment. HOST calls, and user
exits in C were used.
American Technical Resources
Arlington, VA
04/90 to
05/90
Contract Programmer/Analyst
·
Part-time
effort on two projects using Oracle, COBOL and SQL*Forms. The COBOL project was
a reporting system for an insurance company. The SQL*Forms project was a
payroll system to handle direct deposit of paychecks.
Booz-Allen, Hamilton Gaithersburg,
MD
02/90 to
04/90
Contract Programmer / Analyst
·
Re-designed
and coded a critical section of the Real Property Management (RPM) system. IBM
9370 block mode Oracle was converted to character mode for installation on a
Banyon Vine with version six Oracle. This system incorporated many of the
design, and coding standards learned at Oracle Corp, plus many new ones
tailored to the customer needs. A paper was presented at the International
Oracle User Week conference on the techniques used to drive this project
development.
CDSI
Gaithersburg, MD
01/90 to
02/90 Contract Programmer/Analyst
·
Produced
a rapid prototype, integrated, distributed database system between Fort Lee
(Oracle/PC) and Fort Monroe (SQL DS/4381). Designed, coded, and demonstrated
product in four weeks.
Oracle Corporation
Bethesda, MD
06/89 to
12/89 Contract Programmer/Analyst
·
Worked
with Oracle employees to complete coding and delivery of a document handling
system for the U.S. Navy. Upon successful completion was shifted to work on a
second project, a cost estimating system, for the U.S. Air Force. Expertise
gained in V2.3 SQL*FORMS coding standards, and documentation. Extensive
experience gained with SQL*ReportWriter.
Anadac Information Systems
Rockville, MD
05/89 to
10/89
Contract Programmer/Analyst
·
Coded
extremely complex SQL*FORMS from specs provided by the Air Force. As an example
of the complexity, one application was from a 90 page spec which defined a set
of forms containing 41 screens. User exits were required using COBOL.
USAF Systems Command
Andrews AFB, MD
01/89 to
07/89
Contract Programmer/Analyst DBA, Team & Technical Lead
·
Designed
and coded major enhancements to a reporting system using VAX FORTRAN, embedded
and interactive SQL, and SQL*FORMS. Took responsibility for bug fixes to all
modules during system integration and quality test support.
Martin Marietta
Herndon, VA
08/88 to
11/88 Contract Programmer/Analyst
DBA, Team & Technical Lead
·
Contract
Programmer/Analyst, DBA, Technical Lead Developed an Oracle application with
the user, put together schedules, procedures and a team to complete the
project. This was the FTS 2000 proposal effort. The specific area of effort was
transition, which amounts to an inventory and scheduling system.
Comsat Corporation Gaithersburg,
MD
11/86 to
07/88
Contract Programmer/Analyst, DBA, Technical Lead
·
Performed
a wide range of duties for the Office of the Undersecretary of Defense. VAX
Oracle, Cubicomp, Raster, and related issues for a video teleconferencing room
in the Pentagon.
Vanguard Technologies
Falls Church, VA
09/86 to
11/86
Contract Programmer/Analyst, DBA
·
Developed
a database and screens for the Internal Security Division of the IRS using
Oracle on personal computers.
Systems & Applied Science Corp.
Vienna, VA
05/85 to
05/86
Programmer/Analyst, DBA
·
Wrote
DEC/VAX FMS and Ingres Forms. Also wrote various technical reports. Evaluated
DECnet, Ethernet, and IngresNet and made recommendations. Wrote FORTRAN code.
Developed and maintained various SEED databases and provided test bed comprised
of databases, application access codes, and system service calls. Developed
sequence of error exit handling routines for all application code. Used PDL and
data flow diagrams to program various tools to allow junior programmers to
define and generate the 300 screens required under contract.
CDSI
Gaithersburg, MD
06/84 to
05/85 Programmer/Analyst, DBA, Team Technical
Lead
Amplified below by position and / or
manager
03/85 to
05/85 Army Material Command
Headquarters Alexandria, VA
·
Taught
office automation for the Systems Directorate.
03/85 CDSI
Gaithersburg, MD
·
Worked
on a crash effort to resolve bugs in a NAVSEA statistical model written in
FORTRAN 77 on a Digital PDP11 running RSX11. Acquired an immediate
understanding of the application, with a 5member team took corrective
actions, and conducted a satisfactory product demonstration to customer with
Executive Vice President, and represented company at GSA negations. Avoided
default 95% payment.
06/84 to
03/85 CDSI
Alexandria, VA
·
Task
leader for four tasks at NARDAC (Codes 42 and 44). Major task was to provide an
Oracle prototype for Navy customer (OP 901M) at Pentagon, including data,
screens, backup, training, and technical notes. Supervised three individuals in
DBMS related tasks.
System Development Corporation Vienna,
VA
01/82 to
05/84
Programmer/Analyst, DBA
·
Duties
included developing Oracle prototypes for the National Emergency Airborne
Command Post (NEACP). Also developed a message handler system for AFSATCOM
messages. Participated as programmer analyst on a message emulator to provide a
prototype of AUTODIN and AFSATCOM message traffic. Developed a Submarine
Location Display in FORTRAN using Oracle's Host Language Interface (HLI, now
OCI, or Oracle Call Interface).
ComputerLand
Vienna, VA
03/81 to
12/81 Sales Consultant
·
Sold
personal computers to small business customers.
SAI/C (Comsys)
McLean, VA
05/80 to
03/81 Programmer/Analyst, DBA, Team
Technical Lead
·
Participated
in development of a management information system for the Army Reserve using
the Data General Infos database.
Planning Research Corporation
McLean, VA
10/79 to
05/80
Programmer/Analyst
·
Participated
in programming development of the Navy's Microfilm Personnel Record System
using FORTRAN V and Inter-process Communication to a proprietary database.
Alanthus Data Communication
Rockville, MD
11/78 to
10/79
Programmer/Analyst
·
Product
evaluation and tool development were prime objectives. Wrote string primitives
and device drivers for in-house word processing system.
Arlington Hospital
Arlington, VA
02/78 to
11/78 Programmer/Analyst
·
Wrote
application programs using COBOL, RPG and NEAT/3 for the hospital personnel
department.
Various Automotive
Arlington, VA
1965 to
1978
Auto Parts Manager
·
Developed
many inventory control systems: cardix, service bureau, and in-house systems.
One of these systems which was developed for three years was later sold to
Chrysler Motors Corporation. Days were spent working with this system, and
nights at the mainframe helping with development.
Education
1968
Electronic Computer Programming Institute
Arlington, VA
IBM 360
BAL/ALC, and COBOL Certificate
1978-1985
Northern Virginia Community College Annandale, VA
A.A.S. in Data
Processing
Attended Specialized
Courses, as follows:
·
SQL
Server 2000 Administration, 2001
·
Oracle8i
Administration, 2000
·
Oracle8i
Backup and Recovery, 2000
·
Oracle8i
Performance Tuning, 2000
·
Sybase
SQL Server DBA, and Sybase Advanced DBA, 1998
·
Migrating
to Sybase System 11 & ASE 11.5, 1998
·
Software
thru Pictures CASE (StP), 1997
·
System
Architect Repository Management, 1996
·
Information
Mapping, 1996
·
Software
Engineering Institute/Capability Maturity, 1995
·
World
Class Competitiveness, 1995
·
Informix
Online DBA, 1994
·
Verdix
Ada Training, 1993
·
KnowledgeWare
/ IE CASE Tools, 1992
·
Yourdon
Structured Analysis and Design, 1990
·
Oracle
(DBA, Forms, Reports, Design)
·
Ada
·
AOS/VS
·
Pascal
·
8086
assembly language
·
C
Security Clearance(s)
DOD Secret, Top Secret Clearances
since 1979 -
Plus SIOP compartment with Extended
Background Investigation.
Last Revised: August 2007