Thomas E. Canty, 888-918-6309

 I now work exclusively through my company ServerCare, Inc.
 Please email me by clicking here. Thanks!


Thomas E. Canty
ServerCare, Inc. 888-918-6309
16885 Via del Campo Ct., Suite 211
San Diego, CA 92127

Systems Knowledge:
Database Systems:
	Oracle (v5, 6, 7.0-7.3, 8.0, 8i, 9i, 10g)*
	Data Modeling*

Operating Systems:
	OpenVMS (VAX and Alpha AXP)
	UNIX (HP/UX, IBM/AIX, Sun, Linux, and SCO)*
	DOS/Windows 9x/NT/2000/XP*
	Novell

Tools:
	SQL*Plus/Server Manager/OEM*
	Pro*C
	Oracle CASE Tools and Designer/2000*
	Oracle Financials
	KEY and ERwin/ERX Case Tools*

Languages:
	SQL and PL/SQL*
	C 
	DCL 
	Pascal
				* = extensive knowledge

Most Recent Work (prior to forming ServerCare):
3/96 to 5/99: Glenayre Electronics, Atlanta, GA.
Manager of Database and Systems Group: Email for more details.

Full Time Contracts:
9/95 to 3/96: Anderson Consulting/State of Massachusetts (Department of Transitional Assistance), Boston, MA
Database Architect and Oracle7 DBA: The State of Massachusetts accepted Anderson Consulting's bid to 
develop a new Welfare system to replace the outdated and cumbersome legacy mainframe system. Key to 
this development effort was the choice of a distributed database architecture using Oracle RDBMS, 
HP/UX open systems, and Anderson's Foundation three-tiered client-server development environment. 
Mr. Canty's primary responsibility was to migrate a logical database design of 1000 entities from the 
Sterling KEY CASE tool (formerly ADW) to Oracle's Designer/2000 and produce a physical database 
design. Was one of two analysts that walked through the 70+ "data families" to identify logical modeling 
errors, super/subtype compression opportunities, and physical implementation needs. Secondarily, Mr. 
Canty acted as Oracle Database Administrator for the HP/UX development environment until the State of 
Massachusetts personnel were able to assume the responsibility. Accomplishments included migrating 
database from Oracle version 7.1 to 7.2, the development of standards for client software installation, and 
the proposal of many logical and physical database standards.

11/94 to 9/95: EDS/Blue Cross-Blue Shield (BCBSMA), Boston, MA (3 month contract extended twice to 8 months)
Database Administrator and Oracle7 Consultant: Oracle Database Administrator for HP/UX and SCO 
environments with a total of 50Gb over 9 databases. Accomplishments include: Planned for, installed, and 
implemented Oracle Financials General Ledger on 4 databases; acted as Oracle7 "guru" for development 
and operations teams; trained 3 permanent employees to be Oracle Database Administrators; migrated 
from SQL*Net version 1 for SPX to SQL*Net version 2 for TCP/IP for two Powerbuilder applications; 
Migrated 3 databases from Novell and SCO environments running Oracle version 7.0 to HP/UX running 
Oracle version 7.1; created various reports for Oracle Financials General Ledger; tuned databases and 
applications as needed, and in one instance cut processing time of an application in half; developed plans 
and standards for backups, monitoring, tuning, client software installation, and team interactions; created 
physical model of an application for which one had never been made using ERwin/ERX CASE tool

10/93 to 9/94: Syntex, Palo Alto, CA (4 month contract, extended twice to 11 months)
Database Administrator and Oracle7 Specialist: Oracle Database Administrator for client-server 
VAX/VMS 7640 cluster with a total of 500Gb over 12 databases, three of which are operated with the 
Oracle Parallel Server. Accomplishments include: recommended key tuning advice on client-server 
applications; acted as Oracle7 "guru" for multiple development teams; responsible for 24x7 operation of 
production databases; assisted Sun and HP Unix DBA's; installed, tested, and benchmarked Oracle7 for 
DEC Alpha AXP machine; did extensive research on SQL*Net (DecNet and TCP/IP) and tuned 
applications appropriately; did extensive research and produced recommendations for the use of Oracle 
distributed database technology to improve performance of a Client/Server application whose clients were 
in both the United States and Great Britain; developed guidelines for the use of database Pipes and Alerts.

6/93 to 10/93: Cisco Systems, Santa Clara, CA (1.5 month contract, extended twice to 4.5 months)
Lead Database Administrator: Oracle Database Administrator for two HP/UX 9000 machines running 
Oracle v6. In charge of support of all applications using Oracle over 8 database instances. Installed 
Oracle7 server. Lead team of two other DBA's to optimize and tune databases, as well as redistribute 
datafiles. Implemented more effective backup procedures of databases. Spearheaded the separation of 
databases into production and development environments. Assisted in logical modeling effort of an 
application containing 150 entities.

4/92 to 6/93: Zeneca Ag Products (formerly ICI Americas), Richmond, CA (6 month contract, extended to 13 months)
Database Administrator: Oracle Database Administrator on a VAX/VMS cluster. Managed 10 
applications using Oracle, the tasks for which included tuning, fixes, modifications, and creation of new 
systems. Upgraded two separate environments to Oracle7. Involved in three separate process and data 
modeling efforts using ERwin/ERX CASE tool, which included the transition from logical to physical 
design. Recommended the use of Oracle Parallel Server and Distributed Database technology for an 
application being built for use in the United Stated and Great Britain. Duties also included support of SAS 
and SAS connection to Oracle.

Permanent Employment History:
3/91 to 4/92: Pacific Bell Information Services Group, San Ramon, CA (6 month contract; became permanent)
Database Systems Development Manager and Database Administrator: Project Manager in charge of 
modification, maintenance, and analysis of the California Call Management reporting and billing system. 
Duties included leading team of three employees and two contractors, modifying and creating software in 
C and DCL for new applications and fixes, training users, managing change requests and 
implementations, and managing the RDB databases. Was concurrently an Oracle DBA for OLTP system 
on a Sun4 platform running SunOS Unix. As part of this role, received training in the use or Oracle's 
CASE tools.

3/89 to 3/91: Synergen Associates, Walnut Creek, CA
Programmer/Analyst and Project Leader: Used Oracle, Ingres, Fortran (with the precompiler FLEX), and 
FMS forms package on a VAX/VMS system to customize and maintain commercial Maintenance and 
Materials Information System for various clients. Clients included Weyerhaeuser, New England Power, 
Bowater Pulp and Paper, and Exxon U.S.A. Support included intensive client interaction, including on-
site consulting. Designer and project leader for the new Capital Projects subsystem, and project manager 
of the Weyerhaeuser project. Authored bulk of the users guides for both projects. Other notable 
achievements included 10 weeks of on-site consulting for New England Power Company, team leader for 
the conversion of baseline product from Oracle to Ingres, and designer of many new components and 
utilities for the systems. Gained expertise in full-system life cycle, including specification compilation, 
data and process modeling, system analysis, development, prototyping, tuning, and production 
implementation.

Part Time and Short Term Contracts:
1/95 to present: Boston University, Boston, MA
Oracle Instructor: Instructor for Oracle related modules of the Client/Server Certification Program at 
Boston University's Corporate Education Campuses. Taught classes of up to 16 students in laboratory-
intensive modules. At this point Mr. Canty has taught on five separate occasions.

4/95: Colonial Gas, Lowell, MA (1 day contract)
Oracle7 Consultant: Brought in to tune an Oracle system on a Sun platform. Monitored installation, offered
key tuning advice, and suggested backup and maintenance plans for the future.

10/94 to 11/94: Navistar Trucking, Fort Wayne, IN (5 week contract)
Oracle7 Migration Consultant: Migrated two databases from VAX/VMS 5.0 and Oracle v6 to Alpha 
AXP/OpenVMS 6.1 and Oracle 7.1. Migrated all forms, reports, and Pro*C applications supporting over 
400 interactive users, and trained team on new features and tools of Oracle7.

9/94: Datatools, Menlo Park, CA (direct contract)
Datatools contracted with Mr. Canty to provide a consulting resource in their migration effort from Sybase 
to Oracle. Datatools currently markets a backup and recovery tool for Sybase (SQL BackTrack), and Mr. 
Canty assisted in their effort to adapt the tool to Oracle. As a result of this consultation, Datatools has 
come up with a number of concept modules for general Oracle database administration. Consultation 
consisted largely of information about Oracle database internals, physical file structure, and alternate 
database recovery methods.

12/93 to 1/94: Jacobs Engineering, Pasadena, CA (direct contract)
Oracle Database Recovery Consultant: Brought in to repair a crashed Oracle v6 database on a Novell 
network. Client failed to back up one system datafile and was unable to recover when a disk was lost. Mr. 
Canty was contracted to attempt to recover data within other datafiles. Mr. Canty wrote a C program to 
read physical file blocks and translate them into an ASCII file readable by SQL*Loader. Recovered 
approximately 95% of lost data within one month. Resulted in savings of approximately 5 man-months of 
effort to manually re-enter data at a total billed cost of under $5,000.

6/93 and 7/93: Advanced Micro Devices, Santa Clara, CA (3 days total)
Oracle7 Consultant: Brought in to guide AMD with migration from Oracle v6 to Oracle7. Planned 
migration and implementation of new features with their DBA. Installed new software and migrated 
multiple development and production databases on SUN platforms.

2/91 to 10/92: Loral Space Systems (formerly Ford Aerospace), Palo Alto, CA (part-time contract)
Database Programmer/Analyst: Using Oracle, FMS, Fortran, DCL and C, created application to list part 
structures for the Space Station Freedom in a parent/child format. Implemented advanced capabilities of 
Oracle. Hundreds of thousands of dollars were saved as a direct result of the application. Also rewrote and 
automated database loading program, achieving a 75% time savings.

6/86 to 9/86 and 6/85 to 9/85: NASA Ames Research Center, Mountain View, CA (3 month contract each time)
Software Engineer/Analyst: In charge of converting old software using DI3000 and Versaplot graphics 
packages to use DISSPLA. Using Fortran, VAX/VMS DCL, and DISSPLA, created new software to 
support the expanding needs of the contract. Resolved problems between graphics packages and 
peripheral devices, and performed data reduction and analysis.

Other Contracts:
11/81 to 9/83: Lockheed Missiles and Space, Palo Alto, CA: Programmer/Analyst

OTHER INFORMATION
Interpersonal Skills:
Successful manager, project manager, system designer, database administrator, and database architect.
Author of user documentation at Synergen, CDC, and Cisco. Excellent client interaction aptitude proven by 
successful on-site consulting for various clients while with Synergen, and a number of consulting 
positions with CDC. Exceptional written and oral skills.

Education:
B.S. in Computer Science and Math, degree received 1988, University of California, Davis
Oracle Education Services classes:
	Data Modeling and Database Design
	Advanced Oracle for Developers (SQL*Forms 3.0)
	Tuning Oracle Version 6 Applications
	Introduction to SQL*ReportWriter
	Oracle Version 6.0 Database Architecture
	Oracle Version 6.0 Database Administration
	Oracle Version 7.0 New Features and Options
	Oracle Version 7.0 Workshop
	Custom 2 week CASE Tools course at Pacific Bell

This education would result in 5 Oracle Masters if I were to take the introductory course.

Professional Associations:
Chapter member of Digital Equipment Users Society (DECUS), and seminar attendee
Member of International Oracle Users Group (IOUG), Northern California Oracle Users Group (NoCOUG), and New England Oracle Users Group (NEOUG)
Member of Oracle Developers Alliance (ODA, now part of the Business Alliance Program)
Member (through ServerCare) of Oracle Partner Program

Additional Information:
Speaker at Oracle OpenWorld, San Francisco, 10/00
	Topic: Do I Really Need a DBA?
Alternate speaker for IOUG-A Live!, Anahiem, 5/00
	Topic: Do I Really Need a DBA?
Attendee at IOUG-A Live!, Orlando, 5/98
Attendee at Oracle Open World, San Francisco, 11/96
Paper published in NoCOUG newsletter, 2/94.
	Title: Tuning Tips for Fledgling Oracle7 Shops
Abstracts accepted for Oracle Users Week, Orlando, 9/93. Not presented because of financial limitations.
	Topics: Customizing the Oracle7 SQL*DBA Menus and Cost Based Optimization and Comparison to Rule Based
Speaker and frequent attendee at Northern California Oracle Users Group (NoCOUG) meetings, 1993-1994.
	Topics: DBA Campground, Procedures & Triggers & Bears, Oh My!, and Recovering the Unrecoverable
Attendee at Conference of Oracle Developers Alliance, San Francisco, 4/93 and 3/94
Attendee at International Oracle Users Week, San Francisco, 9/92

Copyright(c) 1995-2003 Thomas Canty and The Software Contractors' Guild, Post Office Box 257, Nottingham, NH USA 03290-0257