Ellen Bachmann Email & Phone Number

Dayton, Ohio Area

Key Responsibilities: • Oracle core and Oracle EBS 12.1.3/12.2 database support including system maintenance, patching, cloning, upgrades/installations, and database administration • Devise and execute 12.2 Oracle application database upgrade plan • Install, configure and upgrade Oracle RDBMS software and related products. • Perform database tuning and performance monitoring. • Develop and implement the technical procedures and standards for preserving the integrity and… Show more Key Responsibilities: • Oracle core and Oracle EBS 12.1.3/12.2 database support including system maintenance, patching, cloning, upgrades/installations, and database administration • Devise and execute 12.2 Oracle application database upgrade plan • Install, configure and upgrade Oracle RDBMS software and related products. • Perform database tuning and performance monitoring. • Develop and implement the technical procedures and standards for preserving the integrity and security of Oracle databases • Establish, coordinate, and maintain databases and database environments for testing, production, training, and user demonstration • Monitor and optimize the performance of Oracle and EBS Application databases as a unit • Allocate system storage and plan future storage requirements for all database systems • Establish disaster recovery architecture for supported databases and conducts disaster recovery tests • Administer complex database architectures Oracle 10g/11g/12c • Participate in Sarbanes-Oxley compliance audits as they pertain to database controls • Develop an accurate capacity plan based on resources available on the system • Develop innovative ideas and solutions for project teams facing database issues • Participate in 24x7 on-call production support rotation Show less

Administered a multi-application database servicing an internal quoting and configuration system, opportunity management system and e-commerce system. Coordinated the successful simultaneous database development efforts for these applications.• Installed, patched and maintained Oracle Software for development and production databases.• Performed data modeling and Oracle database design for new and modified requirements.• Managed data security utilizing obfuscation… Show more Administered a multi-application database servicing an internal quoting and configuration system, opportunity management system and e-commerce system. Coordinated the successful simultaneous database development efforts for these applications.• Installed, patched and maintained Oracle Software for development and production databases.• Performed data modeling and Oracle database design for new and modified requirements.• Managed data security utilizing obfuscation procedures in compliance with Sarbanes Oxley requirements.• Tuned Oracle instance components including SQL and PL/SQL. • Approved production schema and design changes.• Controlled migrations of Oracle schema objects.• Designed and implemented backup & recovery system.• Predicted future Oracle trends for hardware usage and user load.• Provided Ad-hoc reports in support of business analytics.• Developed interface capabilities using SQL, PL/SQL and UNIX shell scripts to Oracle ERP Order Management, Invoicing, Accounts Receivable, and Inventory Systems.• Involved in the design, development, and implementation conversion of multiple country centric application databases to a global model reducing support and development efforts and costs. Show less

• Installed, patched and maintained multiple development, test and production Oracle Databases supporting Oracle Inventory, Order Management, Accounts Receivable, Accounts Payable and Purchase Order.• Resolved daily customer support issues per day relating to the Oracle Inventory data input system,• Reduced execution time by 70% and trouble reports by 98% by successfully redesigning the data input to the Oracle Inventory system.