Work Experience

Sysmex America Inc., Lincolnshire, IL

Systems Engineer (March, 2015 - April, 2009)

Work Description:

Production, Test, and Development environment support of 320 instances across North America:

-Administered Oracle Database Enterprise and Standard Edition versions 8i, 10g, 11g, & 12c

-Administered Oracle 10g Real Application Clusters (RAC) and Automatic Storage Management (ASM)

-Administered Red Hat Enterprise Linux AS versions 4.7 – 6.5

-Maintained HP DL380 G4 – G8 hardware and onboard disk storage

-Tuned database, server, application, network and client performance using ADDM, AWR, ASH, statspack & tkprof Oracle utilities, Linux utilities and Nagios

-Developed and implemented database schema DDL & DML changes across all SDLC environments

-Supported proprietary middleware (Compuware Uniface 8.4.0.6 – 9.6) configurations

-Developed SQL, PL/SQL and Bash Shell scripts for monitoring, everyday use & batch processing

Accomplishments:

-Architected, implemented, and supported Oracle 10g Data Guard Physical Standbys

-Architected, implemented, and certified our middleware product Oracle database security with the US Department of Defense Information Assurance Certification and Accreditation Process (DIACAP)

-Architected and implemented an Oracle License Refit and Database Storage Improvement for 74 production environments in the field

Snap-on, Inc., Kenosha, WI

Senior Database Administrator (March, 2009 - November, 2005)

Work Description:

Production, Test & Development environment support of:

-Administered 215 Oracle 7, 8i, 9i and 10g Enterprise Edition instances across HPUX & Solaris 10

-Maintained and monitored database, application, network and client performance using OEM, ADDM, AWR, ASH, statspack, tkprof and utlbstat/utlestat Oracle utilities

-Tuned and proactively monitored database and SQL performance

-Implemented database schema DDL and DML changes across test & production SDLC environments

-Administered Microsoft SQL Server 2000 and 2005 databases

-Supported Company proprietary and third party applications & client configurations (Infor/SSA/Baan, IBM WebSphere, Nokia Intellisync, BMC Control-M, Cognos)

-Investigated, troubleshot and resolved database issues with Oracle Support

-Developed SQL & Korn Shell scripts for monitoring, everyday use and batch processing

Accomplishments:

-Architected, implemented and support multiple Oracle 10g Data Guard Physical and Logical Standbys

-Architected and implemented and support Oracle 10g Enterprise Manager Grid Control server and agents across 30 hosts

-Architected and implemented database naming standard and Oracle File System standard suitable for highly available file systems deploying Veritas Cluster file systems

-Designed and conducted "Oracle 101" training class for the benefit of Tier One Operations staff

-Collaborated with internal and external developers to implement new indexes for improved application performance

-Consolidated database schemas to fewer servers and upgraded applications

Work Experience (cont.)

SBC / Ameritech, Milwaukee, WI - Park Place

Database Administrator (November, 2005 - April, 1997)

Work Description:

Production, Test & Development environment support of:

-Maintained and monitored database and application performance using Statspack, tkprof and/or utlbstat/utlestat Oracle utilities

-Administered Oracle 7, 8i & 9i Enterprise Edition Databases across HPUX & Solaris operating systems

-Supported proprietary and third party application support (CA Autosys, Oracle MetaSolv, Amdocs Lightspeed)

-Programming SQL & Korn Shell for everyday use and batch processing

Accomplishments:

-Designed and implemented test plan for Oracle 9i Real Application Clusters and roll out for production implementation

-Developed and conducted "Oracle Real Application Clusters" informational presentation for the benefit of IT leadership

-Designed and conducted "UNIX 101" training class for the benefit of Tier One and Two Application Support staff

-Tuned database & SQL code performance

-Mentored Tier One and Two Application Support staff

Ameritech, Milwaukee, WI - Park Place

System Monitor (April, 1997 - April, 1996)

Work Description:

Production, Test & Development environment support of:

-Monitored Sun server operating system for exception conditions

-Monitored Oracle database for exception conditions

-Monitored proprietary and third party application for exception conditions

Accomplishments:

-Designed and conducted UNIX training for Tier One and Two Application Support staff

-Troubleshot exception conditions to report to Tier Two and Three Application Support staff

Certifications

Oracle Certified Professional

Oracle 8i Database Administrator (Present-2002)

Federal Communications Commission

Amateur Radio Operators License - No Code Technician (Present-1998)

Interests

Photography

Mountain/Trail biking

Professional References

Adam Brody

Director, Sysmex America, Lincolnshire, IL

acp8ip@r.postjobfree.com

224-***-****

Jean-Luc Lejoly

Solution Architect, Sysmex America, Lincolnshire, IL

acp8ip@r.postjobfree.com

224-***-****

Natalya Devaux

Project Manager, Sysmex America, Lincolnshire, IL

acp8ip@r.postjobfree.com

773-***-****

Ray Forgianni

President, Kenosha Common Markets LLC, Kenosha, WI

acp8ip@r.postjobfree.com

262-***-****

Contact this candidate