Production Database Administrator Resume Oakbrook Terrace, Illinois - Hire IT People

SUMMARY:

Extensive experience in Database and Application Performance Tuning as a database administrator.

TECHNICAL SKILLS:

Databases: Oracle 12c, 11g, 10g; Mongo

Oracle Real Application Cluster (RAC): 11gR2

Oracle Middleware: Weblogic, Oracle Application Server (with OC4J), Apache

Oracle Enterprise Manager: 13.2 (10.2.0.4, 10.2.0.5, 11.1, 12.1.0.2, 12.1.0.3)

OS: RHEL 7 (5,6), SOLARIS 10 (9), WINDOWS 10 (XP,7)

Tools: SQL Developer, TOAD 11, Putty, MobaXTerm

PROFESSIONAL EXPERIENCE:

Production Database Administrator

Confidential, Oakbrook Terrace, Illinois

Responsibilities:

Regularly investigated application performance problems and tuned various application jobs and database sessions -
Extensive experience installing, upgrading, and patching OEM Grid Control and Cloud Control (10g, 11g, 12c,13c), creating metric extensions, setting security rules, creating incident rules, maintaining plugins.
Developed and implemented custom metrics, tuning the performance of SQL scripts, capacity planning, creating custom dashboards, and designing and implementing custom metrics -Used SQL Plan Management and SQL Profiles to stabilize explain plans in legacy SQL migration..
Integrated OEM with third-party tools (Remedy, BPPM, Evanios) -
Implemented database security controls and auditing -
Automated database patching using patch plans in OEM -Extensive experience in creating, upgrading, migrating, patching, backing up, and recovering Oracle databases (10g, 11g, 12c), including implementing dataguard databases.
Implemented and administrated 11g RAC implementation. -Installed database and middleware portions of Banner 9.
Experience with security (PCI data masking) and auditing, Weblogic administration and debugging, change and problem management (ITIL Certified).

Production Database Administrator

Confidential, Downers Grove, Illinois

Responsibilities:

Developed, built, upgraded, and maintained almost 100 Oracle standalone and RAC databases.
Designed, implemented, and tested database objects -Introduced, championed, planned, implemented and maintained Oracle Enterprise Manager, including planning and implementing a High Availability configuration on 11gR2 Oracle RAC
Worked effectively with Level 2 and Level 3 support personnel resolving production problems.
Developed and modified UNIX scripts

Database Analyst

Confidential, Joliet, Illinois

Responsibilities:

Maintained and customized BANNER ERP in support of administrators and developers
Developed large PL/SQL program to transform and load data from Admissions data store
Specified and implemented SQL LOADER control files to migrate data from SQL SERVER
Implemented and maintained UNIX scripts

Database Analyst

Confidential, Warrenville, Illinois

Reponsibilities: