Steve Gahagan

Olathe, Kansas ***** • 949-***-**** • ad0shw@r.postjobfree.com

Education

Bachelor of Computer and Information Sciences, 05/1988

Washburn University - Topeka, KS

Professional Summary

With over 30 years of experience in Corporate America's IT sector, I've evolved from the COBOL and Assembler era to becoming proficient in data warehouse solutions. During my 11-year tenure at Koch Industries, I played a pivotal role in consolidating over thirty LLCs into a unified Oracle E-Business solution. With over a decade of experience as an Oracle EBS DBA, I've witnessed its transformation from a fat client (10.7 NCA) to its current cloud-based Oracle Fusion solution.

Presently, at ACI, I manage a hybrid environment consisting of on-premises 12.2 Oracle EBS middleware applications and Oracle Cloud Fusion. In addition to my E-Business expertise, I collaborate with developers on in-house customized solutions. My role in implementing an on-premises Oracle file transfer solution (SOA) exposed me to diverse network protocols, firewalls, DMZ, and other technologies. At ACI, we rely on JIRA as our ticketing system, emphasizing the importance of staying current with technology trends in this ever-evolving IT landscape. I embrace change to remain at the forefront of the field.

Skills

•Security Protocols

•Database Mirroring( Dataguard)

•Oracle EPM

•Data Audits

•Code Debugging

•Weblogic

•Linux, Unix, Solaris

•Java

•Oracle 10G

•Capacity Planning

•Toad, OEM, DBArtisan

•Oracle/LINUX command line

•Database objects - DDL

•Windows NT

•Oracle Data Guard

•Standby Database (Dataguard)

•ETL(Extract, Transform, Load)

•Data Warehouse maintenance

•Code and object migrations from DEV and UAT environments to Production

•Business Continuity

•Maximo Asset application

•Asset administration (hardware and software)

•Administer Cloud and on-prem application.

•PL/SQL

•Technical Support and Troubleshooting (performance issues)

•PL/SQL

•RDMS (Relational Database Management System) Oracle 9, 10G, 12c and 19c conversions

•Recovery Procedures

•Backup Recovery

•Disaster Recovery

•Quality Assurance (QA)

•Effective communication between business and technical personnel

Work History

ACI Worldwide (EMEA) Ltd – Omaha, NE

Sr. Oracle EBusiness DBA, 03/2014 to Current

•Establish and manage user profiles and access permissions for each database segment to safeguard critical data.

•Initiate database administration, providing support, proactive issue resolution, and server maintenance.

•Originate and execute database designs and data models to meet project requirements.

•Collaborate with business stakeholders to define optimal database specifications based on structural needs.

•Leverage RDBMS tools and utilities, including DBArtisan and Oracle OEM, for system performance monitoring and fine-tuning.

•Develop and maintain databases tailored to accommodate customer data effectively.

•Implement and monitor user access levels across multiple databases to ensure data security.

•Proficiently installed and administered Oracle SOA and Oracle reconciliation (EPM) with WebLogic serving as the administrative application.

Tallgrass Technologies-Lenexa, KS

Sr. Oracle Applications DBA, 10/2013-01/2015

Installation, maintenance, monitoring, and patching of ORACLE, JAVA, and WebLogic software.

Provided support to application developers/analysts for tuning, design, and debugging of Oracle applications and Database.

Created, scheduled, and monitored database and Linux file system backups.

Utilized technical support websites for resolving application and database problems.

Researched, downloaded, and applied Oracle maintenance and security patches.

Managed Change Control processes, including migrating packages, procedures, and reports between SDLC environments.

Maintained production Change Control documentation for Auditing and SOX compliance.

Provided end-user support for Oracle EBS R11i and R12.2 during daily business hours (production).

Established and maintained productive relationships with Network, Linux, and Storage Admins through effective communication.

Setting up alerts and warnings for the database, OS, and storage devices using OEM and operating system monitors.

Experience installing OEM 12c on Oracle Enterprise Edition 11.2.0.4.

TNMEC CO INC, Kansas City/Denter

Sr. Oracle EBS DBA, 12/2012-10/2013

Supported and maintained Oracle EBS R11 and R12, as well as Oracle RDBMS 10g and 11g

Installed 'Active DataGuard' to address query and failover issues.

Represented the DBA group in infrastructure and Disaster Recovery meetings.

Installed third-party 'add-on' products to Oracle EBS R12.

Provided DBA support to Application Developers using PLSQL and Oracle Developer.

Created and documented a workable 'cloning process' for Oracle EBS.

Koch Industries, Wichita, KS

Sr. Oracle Applications Database Administrator, 01/1999-05/2011

Provided Oracle DBA support for in-house and third-party mutual fund applications.

Administered the Accenture ERP software suite using Oracle 10g on Windows, as well as application software running on Sun Solaris.

Conducted software implementations and data migrations for Data Warehousing and OLTP systems.

Created and maintained Oracle databases in Windows, Linux, and Unix environments.

Served as a Subject Matter Expert (SME) on Oracle Database structure/design and UNIX administration.

Assessed, implemented, and tested Disaster Recovery strategies, including Oracle Dataguard.

Implemented Backup and Recovery procedures using RMAN and OS utilities.

Conducted performance tuning for Accenture ERP software in an Oracle Windows environment.

Utilized EMC Replication Manager and Veritas Volume Manager for database and application cloning.

LinkedIn Profile URL

https://www.linkedin.com/in/steve-gahagan-4b336a

Professional References

Paul Stark- Leader of Development and Operations ACI Worldwide

(ad0shw@r.postjobfree.com)

(ad0shw@r.postjobfree.com)

Sandeep Velhankar – Director of DBAs and System Admins ACI Worldwide

(ad0shw@r.postjobfree.com)

(ad0shw@r.postjobfree.com)

Contact this candidate