DAVID BRUCE RUSSELL
249 S. Coast Highway 101 – PMB 312
Solana Beach, CA 92075
Phone: (858) 432-3282
E-mail: david.russell@roadrunner.com
Professional
Summary
David Russell is a senior level data
architect, database designer, and administrator with over 30 years of
experience working with data and databases including both analysis and design.
Demonstrated
expertise in both production support and development/test/QA environments in
both UNIX and Windows environments. Oracle through 11g
on a dozen platforms. Excellent Written and Oral
Communication Skills.
Technical Summary
Systems analysis, design, integration,
operations, maintenance, and administration; Expertise in logical and physical
database analysis, Entity Relationship Diagrams, modeling, automation,
performance tuning, charting, diagramming, training, and documentation.
Oracle7i-11g
database,
Oracle Financials 10.7 and 11.3; Informix, Sybase, SQL Server, HP-UX, Sun
Solaris, Windows, Assembler, BASIC, C, COBOL, FORTRAN, Machine (binary), SQL,
PL/SQL, plus several other languages.
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
Anything Oracle, Anything Data, Anything Database, Any Database
·
Oracle Windows (32/64) and Linux installations. OEM 2 and Oracle Grid Manager
Installations.Deployed Oracle Recovery Manager (RMAN) configurations including scripts for backup/recovery
and restoration. Migration from 8i and 9i to 10g (software, structures, code
and data).
Team lead in SQL Server 2005 and one of the first to use the new Integration
Services for ETL. Published on SQL Server Central four times on SQL Server
experience.
Numerous customers in San Diego and Carlsbad area. Work included maintenance,
backup, tuning, configuration, and assistance with issue resolution.
Trained team of developers in Oracle/SQL issues and performance tuning.
Lead Oracle and SQL Server DBA 3E Company, Inc. (3E)
Carlsbad, CA 03/08-07/10 Lead
Oracle and SQL Server DBA ·
Senior DBA tasked with responsibility for 12 production Oracle databases,
plus many development and quality control environments. Tasks included backups,
restores and database stomps with production data, sometimes transferred
internationally (large volume, slow rate) requiring many hours of attention.
Implemented RMAN, inventoried product licenses, patched and upgraded software,
migrated data and database to 64-bit platforms, maintained and improved home-grown
replication, created disaster recovery site, Oracle software installations and
documentation, as required, plus hundreds of minor tasks.
With customers as far east as Copenhagen, and customers between there and California,
was on-call or on-duty 6 AM until midnight (7/365) for over two years. 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: March 2011