Gerald K. Leithoff
1886 Hunters Ridge Ln.
Greenwood, IN 46143
[Send email to request phone number] 88-1374 (Home)
[Send email to request phone number] 06-5125 (Cell)
[Send email using form at bottom]
Objective: A challenging position as a Database Administrator/Developer.
Summary of Qualifications
* Oracle Database Administration
* Database Installation and patches
* MS SQL Server 2000/2005
* Oracle Enterprise Manager, Toad
* Oracle Linux Clustering
* Monitoring Production issues
* Oracle RAC
* Oracle Cluster Registry Services
* Oracle ASM cluster file system
* Backup and Recovery
* UNIX (AIX and Solaris)/Linux/NT
* C/C++/Java/XML Software Development
* Project leadership experience
* Windows/NT development
* UNIX Shell scripting/Cron
* Database development
* Tools: Enterprise Manager, TOAD, Sitescope, Cygwin, Exceed, MS Outlook
* Over 18 years of experience in the IT industry
Professional Experience:
October 2007 to Present
Accent Technology
Indianapolis, Indiana
Sr. Oracle and SQL Server DBA Administrator:
I am currently a Sr. Oracle Database Developer/Administrator for versions 9i,
and 10g on Linux Severs. As lead development DBA I drive high levels of
performance in the design, development and implementation of enhancements to the
databases related to the corporate web sites. I work with java programmers,
system architectural designers and SQL/PLSQL developers to implement and maintain
business solutions of the integrated corporate data systems.
I provide leadership through experience for complex technology environments. I
provide extensive development experience and detailed design skills, planning
development methods, defining life cycles and working with all aspects as a
designing Development DBA.
I provide ongoing technical guidance in terms of how the application supports
the business as well as review the design and code produced by developers to
ensure quality, efficiency and adherence to coding standards and ensure strong
PL/SQL Programming Skills.
June 2002 to August 2007
Delphi Corp., (Consultant through G-Tech)
Kokomo, Indiana
Sr. Oracle and SQL Server DBA Administrator:
I am a Sr. Oracle Database Administrator for versions 8i, 9i, and 10g
(clustered) as well as a SQL Server Database Administrator for versions MSSQL
2000 and MSSQL 2005 for both stand alone and clustered server environments.
Installed Oracle 8i, 9i, 10g Server on Sun Solaris, Linux, and Windows 2000
platforms and followed with Oracle Tuning. Applied Oracle upgrades and security
patches to Oracle 8i, 9i, 10g Servers on Sun Solaris, Linux, and Windows 2000
platforms.
Configured Oracle RAC database and Cluster Registry Service environments.
Implemented Oracles ASM file management system for Oracle clusters on Linux
RHEL3. Migrated Oracle 8i databases to 9i and 10g. Performed Oracle backup,
recovery and cloning. Wrote Shell scripts for backups, updating statistics,
monitoring and general maintenance. Documented processes during projects for
future reference and repeatability.
Installed and maintained SQL Server Database instances on Windows 2000/2003
Servers, both Standard and Enterprise clustered environments. Applied SQL Server
upgrades and security patches to SQL Server 2000 and SQL Server 2005 on Windows
2000 server and Windows 2003 server platforms. Implemented SQL Server
Transactional Replication. Created and maintained SQL Server DTS Packages.
Created and maintained SQL Server Database Maintenance Plans. Created and
supported replication subscription and publishing databases. Operating System
scripting for batch jobs.
Provided 24 * 7 support for over 150 Oracle and SQL Server production
databases.
December 1996 to March 2002
Bank One Mortgage
Indianapolis, Indiana
Sr. Oracle Database Administrator/Developer:
Sr. Oracle Database Administrator/Developer:
I was Sr. Oracle DBA and team leader for administration and development work on
all mortgage division databases with the main production database being 120 GB of
data and over 2000 simultaneous connections. Project lead on full life cycle
relational database application design and implementation. Installed and created
new databases for testing, training, development and production along with data
warehousing projects on Oracle versions 7.x 8.x. Performed installation and
upgrades on UNIX and NT platforms as well as set up replication databases. DBA
duties included adding/modifying all database objects, troubleshooting database
outages, fine-tuning system resources, problem analysis, end user support,
maintaining Oracle Application Server (Web Server). Migrated Oracle
Application Server from Oracle Spyglass Technology to Apache engine (OAS version
4.06). Installed and maintained the Oracle Names Server for global connection
service. Applications used: Exceed 6.2, Developer 2000 Reports Builder 3.12,
Oracle Enterprise Manager, Oracle Application Server 4.0, Sqlplus, Crystal
Reports 5.0/6.0, NT and Unix (AIX and Solaris).
I have always been willing to work the hours necessary to deliver the project,
which included overtime, working weekends and being on call. I come with a
dedication that is essential in producing quality for the company on a timely
schedule.
Team leader for administration and development work on all mortgage division
databases with the main production database being 120 GB of data and over 2000
simultaneous connections.
February 1995 to December 1996
Bank One Mortgage
Indianapolis, Indiana
Programmer/Analyst: Used Visual C/C++ to debug and update the Service Mortgage
System. Maintained and Modified multiple applications using Visual C++, Java,
Oracle Pro C, Sqlplus, and Crystal Reports 5.0 engine.
February 1983 to February 1995
IFR Systems Inc.
Wichita, KS
Software Engineer Project leader for software engineering team developing
software for calibration of a multimode cellular phone system. The project
software was developed under MS Windows using MS Visual C++, Microsoft Foundation
Classes (MFC), MS ODBC Oracle database interface, Crystal Reports/print engine.
This Project had half the personnel resources of most projects and was still
delivered in less time than the other projects undertaken in the department. I
give this credit to productive tools and a highly focused team. Also, I designed
digital/analog hardware and wrote the embedded software drivers to control the
interface. Evaluated and recommended new software and computer systems for the
company. Developed an analysis system Quinn Curtis Real Time Graphics, Accys
database engine and was a core team leader for this project as well as others.
Education
Wichita State University
Wichita, KS
Electrical Engineering, Bachelor of Science, 1992
Emphasis on Computer Science, OS Kernels and mathematics
Butler State College
Eldorado, KS
Electrical Engineering Technology, AES, 1983
IUPUI
Indianapolis, IN
Unix Shell Scripting
PROFESSIONAL TRAINING
Oracle University
Oracle Database Administration I
Oracle Database Administration II
Backup and Recovery
Oracle Tuning techniques
Oracle PLSQL programming
Oracle Tuning for SQL statements
Oracle Database Tuning techniques`
Oracle 8 and Oracle 8i: New Features for Administrators/Developers
Oracle Application Server 4.0.8
|
