Customer Service Oracle

Terry C., OCP

We only do consulting.

No permanent job

inquiries please.

Click here for

Consulting rates.

BIOGRAPHY

Terry C is an Oracle Certified

DBA with more than 25 years of full-time IT experience. Certified in

client-server and LAN technologies by DePaul University, Terry has

extensive experience troubleshooting and tuning database networks.

An acknowledge Oracle Windows expert, Terry has published in Oracle Internals

Magazine and has over a decade of Oracle experience working with

mission-critical Oracle systems. Terry specializes in Oracle tuning

and troubleshooting and is noted for his ability to quickly identify and

correct Oracle production problems.

SKILL SUMMARY

Hands-on

visionary able to leverage legacy investments while implementing process

re-engineering strategies incorporating cutting-edge technology into

long-term growth plans. Experience includes:

Database

Oracle

DB2

SQL Server

SQL

PL/SQL

Oracle DBA

A Certified Oracle Professional with experience in the

implementation of a large-scale Oracle ERP system. Proficient in

PL/SQL and Oracle utilities

Network

NT&2000

LAN/WAN

Novell

Voice/Data

Oracle Net8

Network Designer &

Administrator

Experienced with the design, implementation, and administration of

Microsoft networks (NT & 2000) in a LAN/WAN environment including

Citrix and Terminal Server

Web Developer

Developed and implemented production web sites using Microsoft

FrontPage

Unix

HP-UX

Solaris

Shell Scripts

Linux

UNIX

Administrator

HP/UX, Sun Solaris, and Linux ... shell scripts.

Mainframe

MVS/CICS

BAL

COBOL

CLIST

TSO/ISPF

JCL

Assembler

Programmer

Extensive experience with BAL, and EXCP level coding on MVS

mainframes

Cobol Programmer

- Competent Cobol programmer, familiar with JCL and MVS/CICS

utilities (IEBGENER, IDCAMS, IEFBR14)

ISPF

Developer

Customizes and extends TSO and ISPF functionality using CLISTs and

Dialog Manager

Desktop

Windows 9x

NT Workstation

2000 Pro

XP Pro

MS-Office Expert

- Word, Excel, PowerPoint, FrontPage, Outlook, Access, Visio,

Project, Publisher

PROFESSIONAL EXPERIENCE

Consulting experience:

Lebensart Inc - Phoenix AZ

Developed Oracle batch scripts to simulate korn

shell scripts to run in a Windows environment

Implemented Windows scheduler for Oracle script

automation

Installed and utilized an e-mail gateway for

automated alert notification in a Windows environment

Migrated Oracle system from Windows to Solaris

environment using Exp / Imp utilities

Performed Oracle object sizing for new environment

data and index tablespaces

Name withheld due to non-disclosure - Vancouver,

CA

Migrated from 8k to 16k block size

Debugged connectivity issues and stabilized

environment

Implemented new very large memory (VLM) techniques

for increasing SGA beyond 1.7GB limit in a 32-bit Intel environment

Removed MTS and achieved higher connection rates

with dedicated connections

Provided SQL tuning hints to developers

Centennial Medical Systems

Performed detailed repair of Oracle database

corruption

Trover Health Care Louisville, KY

Investigated and patched ORA-0600 errors

Worked with Oracle technical Support to repair data

dictionary corruption

Worked to resolve in-doubt transactions with Oracle

distributed queries

Installed STATSPACK and specialized monitoring

scripts

Customized and installed Oracle server and database

exception reporting scripts

Automated Oracle processes in Solaris using crontab

Szabo Inc Atlanta GA

Performed detailed capacity planning analysis with

predictive models

Assisted in the development of Oracle reporting

infrastructure

DesignWorks USA San Jose, CA

Troubleshooting of RAM PGA errors and stabilized

Oracle database.

Calvary Inc New York

Identified and repaired performance problem related

to Incomplete object statistics

Resolved ORA-0600 error using

dbms_stats.gather_schema_stats

Performed Oracle online redo log balancing

Performed archive log relocation for improved

performance

Installed STATSPACK and performed detailed internal

Oracle tuning

Applied critical Oracle patches to support 9203

upgrade

Implemented very large memory (VLM) techniques for

increasing SGA beyond 1.7GB limit in a 32-bit Intel environment

Full-Time experience:

Monona Wire

Corporation

1998 - 2002

Led

the selection and implementation of a new corporate ERP system (Oracle

Applications) for improved decision making, centralized control, and

reduced resource requirements

Directed the development of a custom shop floor control system (Visual

Basic & Java) integrated with the Oracle Apps. ERP system for improved

workflow efficiencies

Designed and developed the corporate web site and corporate intranet for

internal documentation

Implemented a mixed HP-UNIX, NT Server (BackOffice), LAN/WAN environment

with Internet link

Designed and implemented a communications infrastructure servicing 10

remote manufacturing sites, integrating both data and voice over a frame

relay network, eliminating internal long distance charges

Newark

Electronics Corporation

1989 - 1998

Supported a multi-platform (IBM mainframe, NT Server, AS/400 RISC)

infrastructure servicing 75 sales branches, 2 call centers and 2 major

distribution centers (1200 user interactive environment).

Established PC Support / Help Desk functions. Managed nation-wide training

for e-mail users.

Designed and managed the installation and support of a multi-server

Windows NT (SQL Server, Exchange, SNA Server, SMS, IIS) based Local Area

Network including a high-speed Internet connection, improving internal and

customer communications

Provided infrastructure and support for the replacement of legacy MVS

mainframe systems with an AS/400 based ERP system (SSA BPCS) for improved

business productivity and customer service

Directed the DBA staff in the management of relational databases on each

of the computing platforms (ADABAS, DB2/400, SQL Server), providing a

reliable foundation for core business systems

Stabilized and enhanced a large scale IBM (CMOS) legacy environment

consisting of MVS/ESA (OS/390), CICS, ADABAS, IMS, and Computer Associates

automation products

Standardized the network of computing equipment and software for

significant cost savings

Developed Disaster Recovery plans, procedures, and policies for the

Business Resumption Process

TCL Associates

1987 - 1989

Development / implementation of an interactive database membership system

for a major travel club (COBOL, CICS, DB/2)

Customization and implementation of automated accounting for an

independent gasoline distributor (Peach Tree)

Conversion to a multi-user, LAN based, financial system for a janitorial

service

Implementation of LAN technology for an independent insurance broker

(Novell)

METROMAIL

CORPORATION

1977 - 1987

Responsible for the

overall coordination and management of a large scale IBM Mainframe data

center. Directed a technical and professional staff of 60+ with

fiscal/budgetary responsibilities for over $3 million. Major areas of

responsibility included computer operations, voice and data

communications, physical and data security, contingency planning, facility

maintenance, capacity planning, change management, and technical

training. Accomplishments included:

Developed much of the core software required to support customer needs

(COBOL, BAL)

Introduced and supported database technology for improved data storage and

retrieval (ADABAS)

Directed construction of and relocation to a new data center resulting in

major cost savings

Directed the conversion from a batch to an interactive environment for

improved customer service (TSO/ISPF)

Implemented Personal Computer Technologies for improved customer response

levels

Directed all technical and training upgrades for operations and technical

staffs

EDUCATION & Certifications

Bachelor of Science,

Roosevelt

University

Technical Certifications

Information Technology,

Honeywell

Institute

Client/Server Technology,

DePaul

University

Local Area Networking,

DePaul

University

Oracle Certified Professional DBA,

Oracle Corporation

PROFESSIONAL

AFFILIATIONS

Network and Systems Professionals Association (NaSPA)

Contact this candidate