Resume
Kent Crotty, OCP.
 |
We only do consulting. No permanent job inquiries please.
|
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