Kathy McDaniel

Zenarms, including encryption, GoldenGate, DataGuard, across national data centers ensuring optimal performance low latency ExadataExadata

• Create, review, and maintain engineering plans, processes, and implementationExadatagies
• Assisted with DBA team with migrations, backups, recovery, pDataGuarde tuning, data modeling and governance using OEM, AWR, ADDM, and V$ objects
• Available 24x7 for Solutions support during major projects

• Technical SME for OFSAA 8.0.6 upgrade project to implementation providing 24x7 support
• Provided extensive support of Zena Enterprise Job scheduling, deployments Rundeckdeck, coordinated backup, cloning, and recovery
• Automated tasks, stored procedures, and functional jobs using shell scripting PL/SQL, & SQL*Plus for both user schema and metadata objects
• Development
• Installed, patched, and performance tuned Oracle environment using AWR, ADDM, and TOAD
• Managed users security and privileges
• Configured, developed, patch/upgraded, and customized OFSAAI, OFSFTP, and OFSPM
• Data Mapped staging and reporting between Enterprise Data Warehouse to OFSAA and T2T development
• Administratively supported Oracle software running on Linux/Unix and AIX including shell scripting,

• Managed Oracle databases including backup, recovery, cloning, performance tuning, instance management, and instance migration
• Work with business/data analysts to define data requirements and design data models
• Installed, configured and administered Oracle 11g, 12c databases on RHEL RAC clusters
• Data migrations using export/import utility, TOAD, and SQL-loader
• Included in architecting corporate project of innovative ERP system implementation
• Installed, upgraded, and patched Oracle E-Business 12.1.3,12.2.x suite instances on RHEL v6
• Resolved code not yet developed by HP within the Object Migration software for EBS 12.2.4 by collaborating with vendor's development team
• Installed and administered Oracle UPK (User Performance Kit) on Windows cluster and MSSQL Server

• Senior/Lead Oracle DBA 01/2012-07/2012
• Assessed team member's skillsets and assigned tasks accordingly for optimal efficiency Created monthly reports for senior management summarizing operational performance metrics
• Worked with Risk Assessment to review, report and ensure PCI, SOX, and ITIL policies were followed and appropriately and documented in GRC repository (CA GRC Manager)
• Represented team in internal and external audit meetings
• Participated as a team leader in resolving the 2013 security breach
• Lead and advised discussions to solve complex technical problems
• Collaborated with IT leadership to strategize, improve processes, efficiencies, and enhance performance
• Performed all database administrative tasks including installation, configuration, administration, security, backup & recovery, data loads, performance tuning, data modeling, business intelligence and 24x7 support

• BOE Administrator /Senior Database Administrator 06/2007-08/2008
• HR IS Systems Specialist/CF Applications Support 02/2006- 06/2007
• Oracle Database Administrator 09/2003-02/2006
• Managed team of analysts, developers, universe, and report designers
• Key technical advisor to Corporate Security & Compliance specialists for IT Governance
• Managed vendor software lifecycle and licensing
• Conduct data analysis and quality assurance to ensure data integrity and consistency.
• Performed all database administrative tasks including installation, configuration, administration, security, code migrations, backup & recovery, data loads, performance tuning and 24x7 support

• Administered Oracle, MS SQL databases and Oracle Financials
• System software administrator of middleware used by Oracle software
• Provided backup DBA support for MS SQL databases
• Performed all database administrative tasks including installation, configuration, administration, security, data loads, and 24x7 support

• PeopleSoft Y2K testing infrastructure including servers, software, backups, recovery, security, and scheduling
• Supported PeopleSoft Procurement and HR Implementation in the OSU Accounting Resource Management Systems (A.R.M.S.)
• Built and tested batch processing using Autosys Job Scheduler
• Performed all database administrative tasks including installation, configuration, administration, security, backup & recovery, data loads, performance tuning and 24x7 support
• Installed, supported all OS administrations on Y2K clusters

• Oracle Database Administrator 12/1996- 03/1998
• System Administrator 10/1995-12/1996
• Operations Technical Analyst 10/1994-10/1995
• Data Center Operator 04/1992-10/1994
• Installed, configured and administered Oracle 7.x, 8.x databases on HP Unix platforms.