Resume
Kent Crotty,
OCP.
BIOGRAPHY
 |
|
Kent Crotty is Oracle Certified DBA and a graduate
of the University of Maryland. He is an IT professional with over 15
years in a variety of roles ranging from Programmer/Analyst
(developer) to Systems and Database Administrator. Kent is
instrumental in developing complex Oracle systems architectures and
specializes on web-based Oracle applications.
Kent is a well-rounded Oracle DBA with a broad range of experience
and skills and is author of "Easy
Oracle HTML-DB".
|
Work Experience Summary:
-
Experience with
Oracle RDBMS and its associated tools for 12 years.
-
Extensive
experience in relational database administration, design, development
and implementation using Oracle Designer, PL/SQL and other Oracle tools
and utilities.
-
Use of Oracle
techniques such as Standby Databases, Real Application Clusters and RMAN
-
Experience in a
variety of hardware platforms including; IBM, Unisys, AT&T, Intel and
PCs with a concentration on UNIX systems.
Technical Skills Expertise:
-
Oracle
Databases, 10g, 9i, 8i and 7.x
-
Oracle Developer
2000
-
Oracle Designer
2000
-
Oracle
Enterprise Manager
-
Recovery Manager
(RMAN)
-
Standby
Databases
-
PL/SQL, Perl, C
-
SQL Server 2000,
7.0
-
MySQL
-
Unix/AIX/SUSE
Linux
-
Unix Scripting (Korn,
C or Bourne shells)
-
Windows
NT/2000/XP/2003
-
PeopleSoft 7.x
-
DB Artisan/SQL
Navigator/TOAD
-
Crystal Reports
-
SQL Server
Education:
-
1986 B.S. in
Computer Science from the University of Maryland, College Park, MD
-
Completed
various Oracle educational courses including; New Features for Oracle
8i, Database Administration for Oracle 7, Database Administration Oracle
6, Database Tuning, Oracle Forms 4.5 Design and Programming, Oracle
SQL*Forms 3.0, Oracle SQL*ReportWriter 1.0, PL/SQL 1.0 PL/SQL 2.0
Programming, Developer 2000 Tools, Designer 2000 and Introduction to
Client/Server Computing.
Work Experience:
Burleson Consulting
(February 2005 to present)
State of North
Carolina, Database Administratror
(December 2004 to January 2005)
One member of a team of Database Administrators responsible for
installation, maintenance support, upgrades, monitoring and tuning of 15
Oracle and Microsoft SQL Server databases. Environments included Oracle
9.2.0.X running on Sun Solaris Unix and Microsoft SQL Server running on
Windows 2000/2003.
Skills Utilized:
Responsible for administration and maintenance of Oracle and SQL Server
databases.
Hardware Experience:
Sun Servers, IBM Compatibles.
Software Experience: Sun Solaris UNIX, Windows 2000/2003
United States Postal
Service, Database Administrator
(March 2004 to December 2004)
One of a team of
database administrators responsible for application support, maintenance,
upgrades, monitoring and tuning of over 1100 databases spread throughout the
country. Oracle Enterprise Manager is used for administration of the
databases. The Intelligent Agents are used for alerting and monitoring of
the databases. The Oracle environments include 8.0.5, 8.1.X and 9.2.0.X on
Sun Solaris and Windows 2000/2003 servers. Utilized advanced techniques
such as StatsPacks, Standby Databases/Data Guard and Real Application
Clusters.
Skills Utilized:
Responsible for administration and maintenance of Oracle databases.
Hardware Experience:
Sun Servers, IBM Compatibles.
Software Experience:
Sun Solaris UNIX, Windows NT/2000
Central Carolina
Bank, Database Administrator
(December 2001 – March 2004)
Part of a team of
database administrators responsible for 24 Oracle and SQL Server
databases. Duties include application support, regular maintenance,
monitoring, tuning, object creation and upgrades. Oracle database
environments include versions 8.0.5, 8.1.7(8i) and 9i on HP Unix, SUSE
Linux, Sun Solaris and Windows NT systems. Microsoft SQL Server versions
included 7.0 and 2000. Used Oracle Designer (6i) to document and design
database systems. Wrote scripts to perform a schema upgrade.
Skills Utilized:
Responsible for administration and maintenance of Oracle and SQL Server
databases.
Hardware Experience:
Sun and HP servers, IBM Compatibles
Software Experience:
HP UNIX,
Windows NT/2000
Chugach Electric
Association, Oracle Database Administrator
(January 1999 – October 2001)
Database Administrator responsible for administration of several Oracle
databases including PeopleSoft Financial, PeopleSoft HR and Indus Passport
implementations. Other databases included a data warehouse and company
built databases. The environment is Oracle 8i running on IBM Risc 6000s
with AIX. Administration included design, maintenance, monitoring,
tuning, configuring, object (databases, tables, triggers, indexes,
procedures and functions) creation and backing up of databases. Led effort
to upgrade the databases from Oracle 7.3.4 to 8i. Other duties were
installing database and client software including patches, writing UNIX
scripts to perform certain tasks and assisting developers with problems and
SQL optimization. Utilized Oracle Enterprise Manager and DB Artisan for
database monitoring and management. Developed management reports using
Crystal Reports.
Administrated
several SQL Server 7.0 databases that support various office applications
such as the Intranet, Project Office and Net Pay systems. Performed
maintenance, performance tuning and backups on these databases.
Skills Utilized:
Responsible for administration and maintenance of Oracle and SQL Server
databases.
Hardware Experience:
IBM Risc 6000, Compaq and Sun Servers, IBM Compatibles
Software Experience:
UNIX, AIX, Windows NT/2000, Oracle Enterprise Manager, DB Artisan, Crystal
Reports.
Computer Sciences
Corporation, Database Management Specialist
(October 1994 to November 1998)
Programmer/Analyst
responsibilities included a complexity of applications in the development
and maintenance of the USAREUR Community Automation System (UCAS).
UCAS is a centralized automated information
system and database designed to enhance standard administrative and support
functions and processes throughout U.S. Army Europe (USAREUR).
Responsibilities included converting
forms and reports to the latest Oracle products (Oracle 7.3.4). Created
packages, libraries and database trigger scripts in support of the Oracle
Forms conversion. Co-developed organization and tracking of the redesign
and testing of the conversion. Assisted in software installation and
development environment creation by creating databases and modifying scripts
that access them. Assisted in the conversion and upgrade of the
Configuration Management Scripts and forms to support the changes in the new
Oracle products. Performed application maintenance programming on existing
Oracle modules and Unix script files. Analyzed problems and completed
coding changes. Performed Project Leader duties after the previous leader
resigned, supervising 5 programmer/analysts.
Skills Utilized:
Responsible for administration, design, implementation, maintenance and
testing of Oracle forms and reports. Project Leader duties included
application work, planning, control, supervising the development team, and
interfacing with the government representatives.
Hardware Experience:
AT&T 3B2, IBM Risc 6000, IBM Compatibles
Software Experience:
UNIX, AIX, Oracle Forms 3.0, Oracle Forms 4.5, Oracle Database
Techdyn Systems, Senior Systems Analyst
September 1991 -
July 1994
Senior Systems
Analyst responsible for the database administration, requirements analysis,
application design, database design, coding, implementation and testing of
modules for the USAREUR Personnel Database System (UPDB). Modules included
the Casualty Tracking, Foreign Service Tour Extensions and various programs
for database population as well as the menu system.
Skills
Utilized:
Database Administration and tuning. Application development performed using
Oracle 6.0, SQL*FORMS 3.0, SQL*REPORTWRITER, SQL*LOADER, SQL*PLUS and
SQL*MENUS. The hardware platform was an AT&T 3B2 Risc with UNIX System V.
LBMS Case Tool was utilized for database design.
Hardware Experience:
AT&T 3B2 , IBM Compatibles
Software Experience:
UNIX, Oracle Database
Integrated
Microsystems Corporation, Senior Programmer/Analyst
February 1990 - August 1991
Senior
Programmer/Analyst responsible for the requirements analysis, database
design, application design, coding, implementation and testing of modules
for the Forensic Toxicology Drug Testing Laboratory (FTDTL) Information
Management System (IMS). FTDTL was developed using Oracle 6 with SQL*Forms
on a Unisys 5000 minicomputer.
Skills Utilized:
The application development was performed using Oracle 5.0, SQL*FORMS 2.3,
SQL*REPORT, PL/SQL, SQL*LOADER, SQL*PLUS and SQL*MENUS. The hardware
platform was a Unisys 5000 with UNIX System V. LBMS Case Tool was utilized
for database design.
Hardware Experience:
Unisys 5000, IBM Compatibles
Software Experience:
UNIX, Oracle Database
The Orkand
Corporation, Programmer/Analyst
February 1987 - January 1990
Programmer/Analyst
responsible for requirements analysis, database design, application design,
coding and implementation of modules for the Headquarters Housing Management
System (HQHOMES). The system was developed in Informix 4GL/SQL on a Intel
310/311 minicomputer. Also performed the same duties during the development
of the Armed Forces Information System (AFIS) during the 1988 Presidential
Inauguration. This system was developed using Informix 4GL/SQL on a Unisys
5000/80 minicomputer.
Skills Utilized:
Application development was performed using Informix 4GL/SQL. The hardware
platform was an Unisys 5000 and Intel 310/311 with UNIX System V and Xenix.
Hardware Experience:
Unisys 5000, Intel 310/311, IBM Compatibles
Software Experience:
UNIX, Xenix, Informix 4GL/SQL
|
|