Oracle Applications/database Administrator Resume
4.00/5 (Submit Your Rating)
SUMMARY
- A seasoned Oracle Apps DBA with over 24 years experience maintaining Oracle Database versions 6/7/8i/9i/10g/11g/12c/19c and Oracle Apps versions 9/10.7/11.5.7/12.1/12.2.10 running on Unix/Linux (Solaris, HP - UX, AIX, RedHat) and Windows. Solaris System Administrator with 12 years experience supporting Solaris version 8/10/11.
- 10 Years experience as a team leader with excellent communication. Strong troubleshooting, technical and operations support skills. Superb client relations and customer support skills.
TECHNICAL SKILLS
- Database Administration
- Windows System Administration
- Solaris System Administration
- Database Configuration
- RMAN backup and recovery
- Data / Object Migration
- Performance Tuning
- Applications Development
- Security Management
- Shell Scripting
- Db & apps patching
- Change Control Implementation
- Project Management
- Disk Architecture
- Software Implementation
PROFESSIONAL EXPERIENCE
Confidential
Oracle Applications/Database Administrator
Responsibilities:
- Sr. DBA that provided 24/7/365 database, EBS application and systems support for MSC’s financial and HRMS systems. Provides on-call user, customer and developer support for all mission critical HRMS and Financial management systems on production, test, development and training including user workstation troubleshooting
- As lead administrator I performed 6 complete Oracle E-Business Suite installation and upgrades from version 8 - 12.2.10 releases on Solaris, Linux and AIX operating systems
- Lowered downtime by 90% for the entire datacenter by upgrading EBS to enable Online patching and modifying the CPU/PSU patching plan for 24 separate Oracle applications
- Performed installation, configuration, upgrades and managing the Fusion Middleware stack. This included installation and configuration of WebLogic server
- Responsible for all Oracle RDBMS installation and upgrades from Oracle database version 6 - 19c including the setup of the current multi-tennent / single-tennent CDB/PDB architecture
- Performed 3 entire datacenter migrations from Solaris 9-10-11 / IBM AIX and again to Oracle Linux
- Support remote databases for area commands running Unix/Linux (Solaris, HP-UX, AIX)
- Patching of Oracle applications, middleware and RDBMS using OPatch, adpatch, bsu and adop
- Provide support for Oracle databases and Oracle development tools running in a windows environment
- Implemented RMAN backup and recovery solutions to Disk and tape for both hot and cold backups
- Implemented backup and disaster recovery plan of all Oracle applications across the enterprise
- Application of Quarterly release of Oracle CPU’s to Oracle E Business suite, middleware and databases.
- Performed weekly refreshes and clones of database and EBS 11i/R12.2.9 environments using rman, rapid clone, cold backup and datapump refreshes of data.
- Experience in Oracle database performance tuning using sqladvisor, awr, addm, explain plan, sqltrace and statspack
- Experience with RAC Clusterware administration, Configuration and Patching
- Implemented Military Sealift Commands entire disaster recovery site in Pensacola Fl
- Involved with Datagaurd installation and maintenance of Oracle 10g RAC and standby database for High Availability and Disaster recovery
- Support all Oracle 9i-19c database systems that support the budget planning and preparation systems at MSC
- Experience managing very large Data Warehouse Databases
- Performed Solaris system maintenance including installation of monthly recommended Kernel patches to ensure security and stability of the OS.
- Performed Solaris operating system and database / application recovery from tape & disk backup
- Installed and upgraded Sun SPARC operating systems from version 8-9 and 9-10 including system administration on version 11
- Extensive working relationship with Oracle Support for break fixes and custom bug fixes
- Responsible for coordinating and executing change management tasks, code deployment and software migration tasks for
- Support of all development efforts of the development team and sole responsible party for code rollouts to production
Confidential
Oracle Database Administrator / Foxpro Developer
Responsibilities:
- Performed database administration and support for Clipper and Oracle 6 databases. Developed U.S. Treasury departments Telecommunications Service Request system to fully automate the Treasury Departments telecommunications request system.
- Served as lead developer for communications department of the U.S. Treasury and maintained Windows 3.5.1 network for a network of less than 30 users.
- Served as lead DBA for Clipper database and Oracle 6 databases for legacy TSR systems. Performed all routine maintenance for TSR systems servers, applications and databases.
