Resume

Kent Crotty, OCP.

 

 

 

We only do consulting. 

No permanent job inquiries please.

 

Click here for Consulting rates.

 

 

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