We provide IT Staff Augmentation Services!

Senior Oracle Database Administer Resume

3.00/5 (Submit Your Rating)

SUMMARY:

  • An accomplished information systems professional with over 25 years of experience in the configuration, implementation, management and support of data base administrative systems. This includes over eighteen years of experience serving as an Architect / Oracle Database Administrator and more than five years serving as a
  • Technical Project Leader. More than 15 years working with the Oracle e - Business Suite including installations and upgrades. Additional experience includes Architect responsibilities on large projects the development/support of Enterprise Data Warehouse systems that exceeded 50 terabytes in size. Performance tuning, Oracle PL/SQL development, CLOUD, interface programming and UNIX scripting are also areas of experience.

TECHNICAL SKILLS:

ORACLE TECHNOLOGY: TECHNICAL ARCHITECT, DATABASE ADMINISTRATION, DATA MODELING, DATABASE PROGRAMMING, ORACLE E-BUSINESS SUITE, VERSIONS 12, 11 DATA WAREHOUSE DESIGN, PL/SQL, DATAGUARD, RMAN, ASM,TOAD, INFORMATICA, GRID (OEM), IMPDP, EXPDP, ERWIN, GUARDIUM, SCHEMA DESIGN. UNIX SCURE SHELL SCRIPTING, ACFS, RAC, WEBLOGIC, SSO, VI, PL/SQL, SQL, PYTHON, RAPID INSTALL, COBOL, EXADATA, ADCTRL, ADPATCH, LOGMINER, CLOUD, ADOP, ETL, PHYSICAL STANDBY, REMEDY, RAC, APACHE HADOOP, PERL, INFORMATION SECURITY

DATABASE TECHNOLOGY: ORACLE 12C, 11G, 10 (15 years +, Last used 2018), SQL Server 11.0

OPERATING SYSTEMS: AIX, SOLARIS, LINUX, WINDOWS 2008, WINDOWS 2012

WORK EXPERIENCE:

Senior Oracle Database Administer

Confidential

Responsibilities:

  • Remote Fifteen week assignment to upgrade Oracle Databases from 11G to 12C
  • Linux and Windows 2012 hardware
  • Patching, database tuning and application tuning.
  • Senior Database Admin Wells Fargo (March 2016 - End Date: September 2017)
  • Managed LARS database applications (11 50T databases). Upgrade from 11G to 12C, Refreshes, tuning, patches and development liaison.
  • Migration to Exadata,and the use of Informatica to load data.
  • Deploy application code to middleware and provide tuning advice
  • ERWIN. TOAD, GRID(OEM) and Apache Hadoop
  • REMEDY, GUARDIUM to monitor compliance control, access and data protection.
  • GRID RMAN ASM ACFS SSO RAC WEBLOGIC DATAGUARD TOAD, SSO
  • Senior Database Developer for Bank of America ( )
  • Liaison with development on PL/SQL tuning and troubleshooting.
  • Oracle 11.5.10 and SQL Server 11.0, Linux and Windows 2008
  • Development of triggers, packages and views.
  • TOAD, GRID, PL/SQL
  • Senior Database Administrator for Wells Fargo ( )
  • Support SIM CORP and CARD database applications.
  • Installation, upgrade, patching, cloning, tuning and support of Oracle e-Business Suite versions 11.5.10
  • Systems utilizing ASM, ACFS and RAC. RMAN refreshes
  • Red Hat and Solaris Servers. Custom Schema Design.
  • Database and application migration from Red Hat to Solaris
  • Design, creation and loading of multi-terabyte partitioned data storage for the EQMR Enterprise Data Warehouse medical system. Global/local partitioned indexes,
  • Database upgrades from Oracle 10g to Oracle 11gR2 on RAC storage.
  • PL/SQL query writing and tuning techniques for large scale partitioned data.
  • Architect and Technical Lead for US Army MEPCOM project, N. Chicago, IL ( )
  • Migration of 65 Oracle Databases and the custom MEPS application to one consolidated MEPS database
  • Design and implementation of database storage and schema modifications
  • Installation and configuration of WebLogic, J2EE for Custom Apps /SOA
  • Modify PL/SQL procedures and triggers to support merged data
  • Database upgrades from Oracle 9i to Oracle 11gR2, platform migration from AIX to Red Hat. EXPDP, IMPDP ASM RAC
  • Senior Oracle DBA Duke Energy in Charlotte NC ( )
  • Duke Energy / Progress Merger Project
  • Installation, upgrade, patching, tuning and support of 9 Oracle Asset Suite instances,
  • Schema design and implementation for assets DataMart (5 terabytes)
  • Database Upgrade from 11gR1 to 11gR2 on RAC Storage
  • Senior Oracle Applications Database Administrator for the Department of Defense
  • Installation, upgrade, patching, tuning and support of 19 Oracle Application Systems in RAC environments on Red Hat Linux Servers Application versions 11. .1
  • Database upgrades from 10G to 11gR1 and 11gR1 to 11gR2
  • Development Support liaison for the Application DBA team
  • Installation and configuration of WebLogic, ANT, J2EE and SOA
  • Lead Technical Support for interface importation of legacy systems from multiple sites, coordinating with end users and management.
  • Gathered user requirements for custom development, supported development efforts.
  • Additional Products installed and Supported:
  • SOA, OBIEE, OID, OEM, WMS TOAD, ERWIN, IMPDP, EXPDP, PL/SQL
  • Architect / Senior Oracle Applications Database Administrator forAir Force Expeditionary Combat Support System (ECSS) in Dayton OH ( )
  • Installation, upgrade, patching, tuning and support of 26 Oracle Application Systems in RAC environments on Sun Solaris Servers.
  • Application versions include 12.0.6 and 12.1
  • Development Support liaison for the Application DBA team.
  • Custom schema design and creation
  • Additional Products installed and Supported:
  • WebLogic, SOA, WMS, OBIEE, OTM, ODI, OID, PLM
  • Collaboration Suite, J2EE and DEMANTRA
  • Supported the importation of legacy systems from multiple sites
  • Developed PL/SQL interfaces for the load of WMS and item data
  • System Architect / Technical Project Leader for FEMA Disaster Operations Center Re-Development project in Winchester, VA ( )
  • Managed team of 6 development Database Administrators, 5 Java developers, 2 BOBJ report writers and 4 requirements writers
  • Managed the development of the following projects:
  • National Coordination Team Tracking Application
  • Task Order Administration and Quality Control Systems
  • Inspection Management Review
  • Relocation Assistance Application
  • Database upgrade of all applications from 9i to 10G
  • Implemented project management / agile application development methodology
  • Designed schema and database storage for FEMA applications.
  • Oracle DBA for Copyright Clearance Center Danvers MA ( )
  • Upgrade Applications database from 9i to 10G
  • Installation of Oracle diagnostics and WEB ADI, CPU patches
  • Oracle DBA Rosetta Stone in Harrisonburg, VA ( )
  • Oracle Applications 11.5.10i reimplementation / upgrade project
  • Installation of multiple instances of 11i on LINUX
  • Upgrade Applications 11.0.3 to 11.5.10 and applications database from 9i to 10G
  • Capacity Planning, Developed interfaces for the load of legacy data.
  • Cloning, patching, monitoring and tuning multiple instances
  • Oracle DBA support Continuum Health Care, NY( )
  • Database and application patching, cloning
  • Installation and configuration of EBS adapter and OAI schema creation
  • Performance tuning of Database, middle tier and custom application code
  • Application problem resolution and research
  • DBA support of project for Crossmatch (Remote) ( )
  • Oracle 11.5.10 Oracle On Demand
  • Database and application patching and cloning
  • Application problem resolution and research
  • Applications DBA for CCS Medical in Boston MA. ( )
  • Installation of Oracle Financials on Windows server, database and application patching, Resolution of environment issues
  • Oracle DBA for Confidential in Mobile AL ( )

Confidential

Senior Oracle Consultant

Responsibilities:

  • Technical Lead for the Customization of the Order Entry Module of Oracle Financials for Carl Freeman, Inc.
  • Supervised team of developers. Developed Customization estimates.
  • on-site technical resources.
  • Applications DBA Life Data Labs Database, Cherokee, AL.
  • Installation of Oracle Financials and Manufacturing Special Edition 11.5.10
  • Database and application patching on Linux x86 Servers.
  • This was the initial SE install for Oracle Corporation.
  • Development of startup/shutdown and backup UNIX scripts.
  • Installation of Oracle Financials and Manufacturing 11.5.5 for Garmin.
  • Database and application patching. on-site technical resources.
  • Development of startup/shutdown and backup UNIX scripts.
  • on-site technical resources.
  • Development of PL/SQL interface load modules for customers and quality.
  • Upgrade of Oracle 8i database to 9iAS on Windows 2000 for Confidential and Sewer Systems in support of a Lawson Financials Upgrade.
  • Development of a customer tracking and consolidation system for Comcast.
  • Schema design and ETL scripts
  • Business analysis for discounts and customer plans.
  • Installation of Oracle Financial Analyzer 6.4.0, Oracle Express Server 6.3.4 and Oracle 91AS 9.0.3.0.0 on HP-UX for SYGEN (PIC)
  • Configuration of the GLLINK tool for download and upload of data between Oracle Financials 11i 11.57 and OFA.
  • Capacity planning of hardware resources.
  • Applied patches and debugged installation issues.
  • Produced and tested backup scripts.
  • Trained client technical staff and user community.
  • Assisted programming staff in the development of PL/SQL data load scripts.
  • Installation of Oracle Financial Analyzer 6.3.1 and Oracle Express Server 6.3.2.1 on a Windows server for MedSource Tech.
  • Configuration of the GLLINK for transmission of data between Oracle Financials 11i and OFA.
  • Coordinated patches and upgrades 11i (11.5.4) Financials application, OFA and OES.

Confidential

Senior Associate - Consultant

Responsibilities:

  • Upgrade of Oracle Financials from 11.0.3 to 11.5.3 on HP 9000 for Paychex.
  • Developed a project and time schedule coordinating downtime, testing, manpower and hardware requirements.
  • Supervised a team of three database administrators.
  • Trained new Application DBA in Financials upgrade methodology.
  • Researched past database growth for capacity planning.
  • Development of the Purchasing Data Analyzer Warehouse for Tyco Kendal Division
  • Developed, tested and tuned PL/SQL modules utilized to load and process both supplier and TYCO “spend” data into the system.
  • Created the Oracle database and installed the Oracle Sales Analyzer
  • Installation of Oracle Financials and Manufacturing Version 11i.5.2 including iStore on Windows NT and RS 6000 for NOVA Machine Products.
  • Installed of Oracle Financials Version 11.5.2 on Windows NT and RS 6000
  • Created UNIX scripts for database backup and recovery.
  • Trained Oracle Applications Database Administrators.
  • Provided technical support for custom WEB development.
  • Programmed Financial data interface modules for migrating legacy data.
  • Technical Leader for disaster recovery for Master Builders.
  • Restore the database from backup and apply archive logs
  • Utilized LOGMINER in order to recover data due to missing archive logs.
  • Internal Development
  • Developed an Employee Resource application utilizing Oracle tools
  • Trained internal employees in both generic and application database administration as well as PL/SQL.
  • Upgraded Internal (demonstration) Financials System from version 10.7 to 11.5.2.
  • Created MS Access database for storage of inventory (laptops, printers, etc.)
  • Upgrade Financials from version 10.7 to version 11.03 for Flight Options.
  • Trained lead client DBA in problem resolution and upgrade methodology.
  • Applied patches and researched problem resolutions.
  • Upgraded Oracle Financials and Manufacturing version 10.7 to version 11.0.3 on Windows NT and RS 6000 for Rose Acre Farms.
  • Capacity planning and patching. Developed custom cloning technique.
  • Provided PL/SQL custom development including an “Egg Price Update” module.

We'd love your feedback!