SUMMARY:

Professional DBA with wide ranging computer system support expertise, including extensive experience in managing mission - critical Oracle databases and associated systems. Comprehensive involvement in support procedures and processes, managing and monitoring large and distributed databases, and related applications.Known for achieving excellent database reliability, proactive database monitoring, and responding to issues 24/7, working individually and as part of a team. Ensure peak application response through installation, configuration, maintenance, and troubleshooting issues with Oracle database software and related products. Work with world-wide development teams and building processes and tools to assist with production and development.

EXPERTISE INCLUDES:

Oracle Database Administration | Documentation, Standards, & Process Improvement Oracle Database Security |Backup & Restore | Application & Database Production Support Performance | Tuning | Capacity Planning | Banner ERP Database Administration

TECHNICAL SKILLS:

Operating Systems: Oracle (Sun) Solaris, UNIX, Linux, Windows

Software: Oracle RDBMS Versions 8, 8i, 9i, 10g, 11g, 12c, Oracle Application Server (OAS) 10g. SQL, UNIX Shells (Korn, BASH)

Utilities: SQL*Plus, SQL Loader, Export, Import, Data Pump Import and Export, Oracle Enterprise Manager (OEM), DBCA, OPatch, StatsPack, AWR, ASH, Toad, SQLDeveloper, SecureCRT, SecureFX, PuTTy, VNC, Microsoft Word, Microsoft Excel, Outlook, PowerPoint

Applications supported: Ellucian (SunGard Higher Education - SGHE) Banner ERP, Luminis (Banner portal) Databases, SGHE/ellucian Operational Data Store (ODS) and Enterprise Data Warehouse (EDW), Cognos, R25, Siebel CRM, Stibo, Dynamo Web Databases (Databases in US and UK), ImageNow, Appworx, AdAstra, and ProSam. Databases ranged in size from 4 GB to over 1 TB, remote and local

PROFESSIONAL EXPERIENCE:

Confidential, Downers Grove, IL

Oracle Database Administrator (DBA)

Responsibilities:

• Maintained critical business functions’ availability through installation, maintenance, troubleshooting, and patching of Oracle RDBMS databases on Solaris and Linux.
• Ensured optimal performance and availability by proactively monitoring and troubleshooting database and server performance with Oracle Enterprise Manager (OEMGC, OEMCC), AWR and ASH reports, and custom written SQL and UNIX scripts.
• Banner, ODS, and Degreeworks database administration, ensuring ERP system's optimal operation.
• Safeguarded company's business data by supporting (writing and fixing scripts for) RMAN and cold database backups.
• Cloning Oracle RDBMS databases from RMAN and cold backups.
• Standardized and enhanced staff productivity by writing procedures and standards for troubleshooting, on-boarding new DBAs, and SQL standards for developers.
• Minimized downtime, installation errors, and ensured standards of conformity by performing DBA consultation and tasks for software installation, upgrades, and production support for applications including Banner, DegreeWorks, ImageNow, Appworx, ProSam, and AdAstra integration into Oracle RDBMS databases.
• Enhanced productivity by eliminating bottlenecks and identifying resource shortfalls, automating alerts via email to minimize human intervention.
• Identified additional planning needs for architectural design, sizing, budgeting, and working with project managers and requestors to resolve any issues.
• Reduced daily DBA proactive monitoring from 5 to 1.5 hours through strategically written and scheduled SQL and BASH scripts.
• Tuned SQL performance with SQL Tuning advisor.
• Created and documented flexible but standard procedure for installing ellucian Banner (SGHE) baseline and custom software, providing authoritative installation methodology for conformity and elimination of errors.
• Wrote BASH script to cycle Oracle databases, OEM agent, and TNS Listener on server reboot and teach OS administrators to install it, reducing database downtime and need for DBA involvement for server maintenance. Script written to work on Solaris and Linux.
• Fix logical standby database data errors and restart apply processing as necessary.
• Oracle Streams
• Troubleshot via dba apply error table contents.
• Wrote, and scheduled via crontab, BASH and SQL scripts to monitor apply delay times.
• Stopped and started BEIS and ODS streams.
• Restaged ODS tables to fix missing data.
• Created OEM metric extension to email Oracle Streams progress graphs, simplifying performance monitoring for problem resolution.
• Wrote BASH and SQL scripts to display Oracle database lock contention, including sessions waiting and sessions blocking, reducing support calls by allowing operations staff to determine if high priority Oracle sessions were being impacted.
• Wrote script to send email alert if specific PL/SQL packages changed within last 24 hours, which would require OC4J recycle, reducing production downtime.
• Restarted OAS INB and SSB on Solaris via opmnctl.
• Maintained Windows WebLogic SSB's "welcome page" to notify of maintenance window.
• Maintained oraenv and banenv as needed.
• Write procedures and train DBAs in Banner support.
• Compiled Forms in DeVry environment.
• Installed Banner patches.
• Banner Jobsub and CAPP restart and troubleshooting.
• Banner patching procedure.
• Banner Workflow troubleshooting.
• Wrote procedure and trained DBAs and operations staff to run system verification workflow for monitoring Banner Workflow progress and hangs.
• Restarted Workflow engine and OC4J to fix hang in processing workflows.
• Generated and installing ear file.
• Wftool.
• Maintained event tables.
• Increased OC4J timeout.
• Wrote scripts to interrogate workflow.eng workflow as a troubleshooting aid.
• Troubleshot and resolved Luminis single signon outage caused by SSO service starting on incorrect RAC node.
• Wrote procedures and trained DBAs to fix shataeq constraint violations.

Confidential, Chicago, IL

Senior Oracle DBA (Specialist)

Responsibilities:

• Enabled efficient and continuous business functionality by establishing procedures and processes for installation, configuration, and maintenance of Oracle software, databases, Banner ERP, and related products.
• Ensured appropriate software levels for supporting business processes by installing and maintaining Oracle RDBMS and Oracle Application Server (OAS) software using Oracle Universal Installer (OUI), Database Configuration Assistant (DBCA), manual scripts, Critical Patch Updates (CPU), Patch Set Update (PSU), and Opatch.
• Automated database backup and archive log cleanup, safeguarding institution’s data, through RMAN configuration, support, and scheduling.
• Maintained availability and excellent response time through Oracle database performance management and monitoring.
• Provided Oracle security maintenance, granting necessary execution privileges to roles, individual users, and database objects by creating and maintaining user ids, roles, profiles, etc.
• Supported business requirements, ensuring appropriate software maintenance is installed, including installation of ellucian (formerly SCT and SGHE) Banner module upgrades and patches, involving UNIX and SQL scripts, and compiling COBOL, C, and Oracle Forms.
• Resolved errors responsible for hangs or bottlenecks by troubleshooting Banner job submission, pipes, sleep / wake application issues, remediating as necessary.
• Reduced errors and enhanced software maintenance productivity by developing methodology to track and report installed Banner patches.