Oracle Software

Johnathan T Mutersbaugh

*** ********* ***** *****, **********, Mo 63385

Home: 636-***-**** - Cell: 636-***-****

email: *******-***@*******.***

Career Overview

I am a skilled Information Technology professional with 30 years of experience in computer operations, applications

development and database administration.

For the last 6 1/2 years I was with Laclede Gas Company as an Oracle database administrator. I was responsible for

installing and upgrading Oracle database software. I was also responsible for installing and upgrading the GIS

application software used by the engineering department (GIS - ESRI vendor), as well as maintaining the Service

hub application that was used by the service and installation department. (Viryanet - vendor)

Prior to this I was with GMAC insurance company for over 21 years, with 2 years of experience in computer operations, 9 years

in applications development, and 10 years in database administration.

I was with Co-operating School Districts from 1984 – 1985 working in computer operations.

I am seeking a database administrator position with an organization where my professional experience can be utilized

fully and effectively. I would like to set up an interview where we can discuss the many ways in which our association may be of

mutual benefit.

Qualifications - Professional Summary – Technichal Skills

Laclede Gas Company 720 Olive St. St. Louis, Mo 63101 314-***-****

Oracle Database Administration – March 2007 – May 2013

• Responsible for installing and upgrading/maintaining oracle database software

• Performed oracle database upgrades from oracle 9i to oracle 10gr2 and from oracle 10gr2 (32 bit) to

oracle 11gr2 (64 bit) – with ASM

• Worked on database migrations from oracle 10gr2 32 bit to oracle 11gr2 64 bit architecture using data

pump / export at database level

• Performance monitoring and tuning with (OEM) oracle enterprise manager versions 10 & 11 – also

via the oracle 10g client database monitoring tool

• Familiar with Linux (REDHAT) version 5 (32 bit) and version 6 (64 bit) operating systems

• Assisted Linux administrators with system validation as required with Oracle software upgrades

• Installed, maintained/upgraded the GIS (arcgisdektop) software used by the engineering department

and assisted with testing and validation of the software installation

• Performed and assisted windows administrator with versions 8.x, 9.x, 10.x of the arcgis desktop

software

• Installed and maintained/upgraded the Service Hub application software used by the service and

installation department – used for scheduling service calls

• Installed, maintained/upgraded the Service Hub application software on Linux servers – this was for

versions 9.x through 10.X and applied all patched released by the vendor

• Performed and assisted with testing these applications in test/devl environments

• Assisted with disaster recovery testing and validation

• Scheduled scripts for execution with CRONTAB

• Implemented and tested RMAN backup strategies

• Responsible for 24 X 7 availability of these application and associated databases

• Responsible for database backup and recovery scripts (RMAN)

• Performed RMAN duplicates and cloning of databases which were re-created as test/devl Databases

• Responsible for maintaining relationships with clients and vendors

• Resolving technical issues – By opening SR of with oracle support

• Assisted Help Desk Technicians with assigning problems to correct teams and following through with

problem resolution – Altiris Help Desk Ticketing System

• Assisted Engineering department with execution of sql scripts (DML) for large updates to various

schemas used within the GIS application prior to production implementation – example GDT.Streets

• Assisted Engineering department with data loads to various schemas used within the GIS application

prior to production implementation – example GDT.Streets

NGIC/GMAC Insurance Company 13736 Riverport Drive #700 Maryland Heights, Mo 63043 314-***-****

Adabas Database Administration – July 1996 – October 2006

• Maintain availability of all Adabas databases for the GMAC infrastructure

• Apply table changes to ADABAS databases as related to “releases” and changes to application made

by the development staff

• Developed and maintained and software control system that was used by applications development to

link cobol programs to adabas and enhance department productivity

• Created and maintained additional testing environments as requested and needed by applications

development

• Created and maintained a “data copy” utility that was used to copy date from production to test for

problem replication and testing

• Provide on-call support for 24 X 7 operations

• Responsible for database backup and recovery

• Responsible for maintaining relationships with clients and vendors

Computer Programmer/Analyst – July 1988 – July 1996

• Responsible for the implementation of all “rating” changes as related to application releases scheduled

by management (this was for an automobile insurance program)

• Assist actuarial department with testing and validation of rates as related to implementations or

changes in the auto insurance application

• Created and automated a process to create and test jcl using JOBSCAN – this was used to test all of

the batch jobs when an application release was being testing in a quality control environment

• Created and maintained a “rate” calculator that was used by the actuarial department – this enabled the

actuarial department to test rates without having to do all of the associated data entry with an

automobile quote

Computer Operations – July 1985 – July 1988

• IPL system on weekends as requested

• Monitor and maintain computer devices and monitor scheduled jobs for completion

• Work with applications development and technical staff to resolve issues

•

Cooperating School District 1460 Craig Rd St Louis, Mo 63146 314-***-****

Computer Operations – July 1983 – June 1985

• IPL system on weekends as requested

• Monitor and maintain computer devices and monitor scheduled jobs for completion

• Print specialized forms related to school schedules, report cards

ACCOMPLISHMENTS

Recognized by Laclede Gas Company for work done to set-up and test disaster recovery systems for the GIS

and Service Hub applications

Recognized by GMAC Insurance Company for work done on the “data copy utility” – this was a SarBanes

Oxley requirement related to “NPI” (non private information) data and required over 10,000 lines of code to

be changed along with testing and coordination to ensure that the copy was still working correctly

EDUCATION and TRAINING

Control Data Institute – June 1981 – May 1982 – St. Louis, Mo

Completed 850 hour course in computer Technology

St. Louis Community College Florissant Valley – September 1980 – August 1985

Completed approximately 75 – 80 credits in computer technology courses

Additional courses have also been completed through work related training with Oracle database technology.

Contact this candidate