Christopher D. Glenn Database Administrator / Architect.
Professional Profile
Over twenty years of progressive experience in software development and
systems architecture for both IT organizations and software companies.
Over twelve years experience as database administrator (DBA) and database
architect (data modeling)
Proficient in database design, implementation and tuning on multiple RDBMS (MS
SQL, Sybase, Oracle).
Experienced in developing, deploying and supporting large scale enterprise
databases for Financial Services, Banking and Insurance/Healthcare industries.
Experienced in developing, deploying and supporting database driven web sites
and products.
Excellent planning and organization skills, with strong sense of ownership
that drives project to a successful completion. Acknowledged by management for
ability to skillfully demonstrate and deliver business solutions to new and
existing customers.
Ability to manage and coordinate multiple projects simultaneously.
Technical Skills & Summary of Achievements
MS SQL Server versions 6.5 2005; Oracle 8i/9i; Sybase 11.x; MySQL 4.0
relational
database management systems. Sybase Replication Server 11.5. Design of both
logical and physical schemas.
T-SQL and PL/SQL. Proficient in all aspects of database design; stored
procedures, views, triggers, index optimization, normalized table relations etc.
C, PHP 4.x, JavaScript, HTML, XHTML, DHTML, VB 6.0,
Experienced with Performance Tuning MS SQL and Sybase RDBMS (query
enhancements, index optimization and segment placement).
Database architect and administrator for both the development and production
operations.
Designed database as acting DBA for IEEE award winning re-engineering project
for Secure Horizons of PacifiCare.
Director of Software Engineering of Dig-Media. Architect of databases and
integration of all applications and processes.
Proficient in UNIX scripting. Sun Solaris, HP UNIX and Linux environment.
Proficient in MS operating system scripting (VBscript, Jscript, batch file)
Microsoft 98/NT/2000/XP.
Enhanced database infrastructure and designed software development procedures
for Pacific Investment Management Company (PICMO). This Included software
development policies and backup / recovery processes. Multiple technologies and
techniques were incorporated. (example: Sybase Replication Server, off site
disaster recovery instances, UNIX scripting, MS OS scripting etc.)
Designed database and server side CGI for DRM (Digital Rights Management)
system that allowed media (music/video/pictures/document files) owners to control
access to their content. Encryption based utilizing Blowfish 2.0 algorithms and
HTTP protocol. Borland C++ and MFC.
DBA in client / server environments utilizing heterogeneous client applications
(example: PowerBuilder, Access, VB).
Designed and implemented both internet and intranet environments utilizing
heterogeneous web servers and client browsers (IIE, Apache, Red Hat web servers
and IE, Netscape browsers)
Internet base systems design and development PHP/C/HTML/DHTML/JavaScript.
Experience
Science Applications International Corporation (SAIC), La Jolla California
Senior DBA and Developer
10/04 to Present
Consultant to permanent. SAICs DBA group consists of several specialized
service groups. I am a member of three of these groups
Database Engineering: Evaluate and recommend technologies and processes as
relates to database implementations. New products in consideration of purchase
are evaluated on their database implementation. The service group evaluates
whether the implementation meets best practice and SAIC standards. The group also
explores new technologies and best practice procedures. A variety of RDBMS are
included (MS SQL, Oracle, MySQL and legacy main frame systems).
Database Capacity and Planning: This group performs analysis of database
servers approaching critical resource shortages (example: disk space, CPU
utilization, database space) and makes a recommendation of action to the database
owners. The recommendation includes a solution to their immediate issue as well
as long term solutions. The group is also responsible for monitoring of
enterprise applications.
Database Development: Development and enhancements of database objects,
utilities and applications (both web and client based). Projects range from
performance enhancement to a stored procedure to the development of a suite of
web based tools used by the Help Desk.
My original project was to modify, test and implement a trigger based auditing
system on an Oracle 9i database installation. The system monitors selected
PeopleSoft tables and provides information on data that is changed, when it was
changed and who (user or process) performed the change. Delivery of the project
included full documentation and a process that verified both integration to the
PeopleSoft application and that the audit data was being captured. The system was
successfully bundled and deployed with a major PeopleSoft hardware and software
upgrade. I am also a team member directed to gather requirements for a web based
Account Management System. My
responsibility is to analyze current methods and assist in defining a set of
requirements for the new system. This includes defining the current integration
points of the applications. (i.e. what type of user account data is passed from
one system to another and how this is currently done). In addition I have
performed DBA duties in troubleshooting batch processes, stored procedures and
end user processes.
Palomar Pomerado Health System DBA and Developer
02/03 to 02/04 and 04/04 to 10/04
My main responsibility was to provide DBA duties for Oracle 8i & 9i databases.
This included monitoring logs, backups and database resources. I monitored
database performance and performed maintenance procedures (i.e. analyze
statistics, table space management, user access management and troubleshooting
etc.). I was also responsible for the database during hardware upgrade and
re-location tasks. This included rollback and recovery planning, database and
application verification post upgrade / re-location. I also designed and
developed support processes (automated backup systems, DB re-organization
processes, integration of mainframe to enterprise applications, data loading
etc.). I developed an intranet based DBA Support Tool using VB Script and PL/SQL
scripts on IIS Web Server to simplify maintenance tasks, log management and
database resource monitoring. I developed PL/SQL scripts to maintain data
(archiving, size management, integration to sub systems). I also developed a
system that interfaced data feeds from both mainframe and UNIX environments to
an Oracle based decision support system. Error detection / management, and
re-start logic ensured no data loss and guaranteed chronological loading of data
to the Oracle system. Although Oracle is the prevalent RDBMS, I was also
responsible for maintenance, integration and monitoring of a SQL Anywhere (Sybase
product) server and consultant to MS SQL Server issues.
Brandes Investment Partners DB Analysis and Tuning
02/03 to 04/03
Performance Tuning of existing T/SQL objects (views, indexes, and stored
procedures). Existing software had performance issues once tested on
production-sized databases. My duties were to identify and correct the errant
database objects. Most performance gains were obtained through identifying and
re-writing SQL code. Some index optimization was implemented as well as view re
structuring. Typical run time decreases were from two minutes plus to under one
second.
CODEBENDER Inc, Del Mar California - Director of Software Engineering
9/01 To 2/03
CodeBender produces and supports a web product called Coordinate. My
responsibilities at CodeBender were to design and develop the database, client
and server side logic. I hired and managed consultants to assist in the coding
and graphic design. Other duties included demonstrating the product to potential
clients and investors. Database modeling was done using ERwin 3.5.2. Coordinate
is a database driven web site with high amounts of user interaction. The user can
upload files, download files, view reports and communicate with other users.
Communication is either via a note system or by email written and maintained by
Coordinate but also sent to the recipients email address. In addition the product
has an administration section where user permissions and roles are set and
maintained by an administrator. I designed and coded all aspects of the system.
The system platform consists of Linux as the server OS, Apache Web Server, and
PHP as the server side processing language and MySQL as the RDBMS. A main design
concern was portability to other database and operating system platforms, this
was achieved and the product can be ported to Oracle or MS SQL based platforms on
either UNIX based or Microsoft operating systems.
DIG MEDIA, Inc., Carlsbad, California - Director of Software Engineering
4/00 to 9/01
Dig Media produces web sites for the entertainment industry. Oracle 8i on NT
interfaced to the web based application on Red Hat Linux running an Apache
Server. I was responsible for designing and directing development of a wide range
of applications and processes. Processes ranged from integrating data from
outside vendors using PL/SQL and Oracle XML to Digital Rights Management
products. Dig Media specialized in designing sites that provide the content owner
secure management of their content while providing the end-user easy access to
their purchased content. The sites are end user oriented designed for intuitive
and easy use. Several interacting sites provide both the administration of
content by the content owners and the consumption of content
by the end user. I acted as a key member in designing all sites and was on a
team of 20 developers who coded, tested and delivered the sites. Dig Media also
produced a stereo web appliance that streamed audio. This allows the end user
access to their audio content from either their PC browser or through the stereo
web appliance. All products were delivered successfully on time, on budget and
launched at the Winter 2001 CES show in Las Vegas. During this time, Dig Media
was the only group worldwide to deploy a high traffic web site for Virgin Records
and the Platinum band Daft Punk using InterTrust s DRM technology. Technologies
used were Linux as the OS, Apache Web Server, and PHP as the server side
processing and Oracle as the RDBMS.
PIMCO, Newport Beach, California Sr. DBA
1/98 to 3/00
Senior DBA responsible for daily tactical processes as well as analysis of
system for performance gains. Tasks included installing SQL Monitor and History
servers, collecting and analyzing performance data, reconfiguring Sybase data
devices, migration of the data to the new databases. The DBA group was also
responsible for source code management. Thus my responsibilities included
directing tasks of those developers assigned to assist in source code management.
I was also responsible for the directing all tasks of the DBA staff. Other
responsibilities included installing and directing the maintenance of the backup
server. The on site redundant server used Sybase
Replication server to keep the redundant server current to the main server. Also
assisted developers in SQL scripting and devised alternate methods for both daily
transaction and nightly batching processing. Invited to join various
groups in designing backup and disaster recovery policies and procedures. Also
participated in in-house software release process, which occurred every six
weeks.
CAPITOL GROUP, Brea, California Consultant/DBA
7/96 to 11/97
Senior DBA of the Sybase database group. The fifty plus Sybase servers supported
over one hundred and fifty individual databases used by the company. I provided
both support and performance tuning of the databases and
software processes that interfaced to them. In addition I managed a small team
providing the company with a system to produce monthly account summaries. The
system consisted of a Sybase 11.0.2 database, HP UNIX shell scripts and a
PowerBuilder front end. UNIX and SQL scripts ran as nightly batch processes
building the account summaries in database tables. The data was written to flat
files that were evaluated by the end user and eventually sent electronically to
outside concerns. Performed all business analysis, database modeling, database
creation and SQL and UNIX script coding.
Consulting Various Locations Consultant/DBA
12/95 to 6/96
Performed DBA duties and database performance tuning. On a re-occurring basis
for the following companies. Capitol Group, Rainbow Technologies, Optimum
Software. Details of development work available upon request.
MERISEL, El Segundo, California Consultant/DBA
8/95 to 11/95
Enhanced and corrected bugs in the warehouse management system, which existed in
9 sites, and was a Sybase on UNIX combination with Unify s Excel and Symbol RF
barcode system. Developed C processes to watch file movements between the
warehouse installations and the mainframe providing early warning to the system
operators of possible problems. Also acted as second to the primary DBA.
PACIFICARE HEALTH SYSTEMS, Cypress, California DBA
6/94 to 8/95
DBA of a team that designed the transaction database (all tables, stored
procedures, triggers, etc.) And decision support database for a complete
re-engineering of the sales and marketing department s information system.
Headed two teams that converted data from a VAX RDB environment to MS SQL server
on NT. Responsible for security, performance and integrity of all databases.
Designed and implemented a data replication system utilizing stored procedures,
SQL scripts, triggers and the BCP utility. It was run by the NT scheduler keeping
the decision support database in synch with the transaction database. Also
designed the development cycle and necessary databases for the developers,
organized database creation scripts into an archiving and retrieval system to
support the software development cycle. PVCS was used as a source archiving tool.
PLAZA SAVINGS AND LOAN, Santa Ana, California DBA
1/93 to 6/94
Designed both database architecture and applications of a loan origination
system using Microsoft SQL Server and PowerBuilder. Created the schedule of user
availability and maintenance and was the point-of-contact for night
operations. While tuning and maintaining the system, I evaluated Sybase System
10 on HP-UNIX as a new platform. Project lead for migration of data from
Microsoft SQL Server on OS/2. Responsible for organizing tasks and managing
efforts of a team of developers.
Awards
Certificate of Excellence from PacifiCare for completing re-engineering project
on time
Award of Appreciation from PacifiCare for outstanding effort in problem solving.
Team Award at PacifiCare from IEEE for the year s best re-engineering project.
Patent pending for specialized software / hardware user interface.
Education
University of California, Irvine. School of Computer Sciences (Completed
undergraduate courses)
SQL Server 7.0 program
Sybase Replication Server program
Sybase 10.0 Performance and Tuning program
Qualifications
Proven ability to select, hire, retain and motivate staff to accomplish goals
Experienced in all phases of software development life cycle
Ability to handle multiple projects simultaneously
Demonstrated ability to plan and meet goals
Ability to quickly develop new skills and adapt to changing environments
|
