Senior Oracle Applications Dba, Oci Assistant Architect Resume
2.00/5 (Submit Your Rating)
SUMMARY
- Information Technology professional with a combined 25+ years of experience, including 15+ as an E - Business Suite DBA/Architect. My experience also includes 5 years contracting for International manufacturing company, 5 years of IT Shared Services, 4 years in the Healthcare, and 8 years in the Airlines industry. My goals are to leverage and expand my expertise in OCI, Systems, Database and Oracle Applications Administration, down to the OS Level, with an emphasis in the area of Databases while utilizing my development experience, all to enhance company productivity.
TECHNICAL SKILLS
- Oracle 12c/11g/10g
- Oracle 9i/8i
- Sybase
- Oracle Apps EBS 11i
- R12.1.3 - R12.2.9
- OCI bsu, adop, opatch, adpatch
- Linux RHEL 7/6/5/4/3
- SUN Solaris 10/9/8
- Various Windows
- PostgreSQL
- Oracle 9iAS,10g, 11g, 12c
- MySQL
- Oracle Discoverer 9i,10g
- MS SQL Server
- OBIEE, ASM, Data Guard
- Informatica PowerCenter
- OID/SSO/OAM and Portal
- SAP ECC 6.6, 6.7
PROFESSIONAL EXPERIENCE
Confidential
Senior Oracle Applications DBA, OCI Assistant Architect
Responsibilities:
- Migrated Publicly traded Oracle EBS 12.2.6 customer from on-Prem to OCI
- Upgraded EBS from R12.1.3 to R12.2.9 for local Government facility
- Obtained OCI Assistant Architect certificate
- Provide Production Support for multiple Oracle EBS environments from 11.5.10.2 to R12.2.9
- Co-designed, programmed, implemented Auto-cloning with both OCI Block Volume and RMAN
- Implemented Spain Language in EBS for a Global client
- Implemented SOA in EBS for Global client
- Executed manual Tablespace resizing to reduce APPS tablespace from 3.5TB to 500GB
- Migrated EBS 12.1.2 environment from on-prem to OCI compute instances.
- Execute a variety of cloning methods: Block Volume backup, RMAN... for multiple customers
- Liaison between Oracle Applications team, customers, and customer representatives
- Executed OATM process for customers of both R12.2 and R12.1.3
- Executed adpatch, adop patching and analysis including DB upgrades, one-off patches, family & maintenance packs CPU, PSU both manually and via. Patch Wizard
- Created Oracle Applications monitoring suite for Database and EBS environments using Opsview
- Extensive utilization of Metalink for research and SR creation to resolution
- Created tasks and schedules for routine health and maintenance checks
- Worked with Netapp and Nimble filers on behalf of the client for better utilization of the tools.
- Participated in quarterly SOX audits from all publicly traded clients
Confidential
Senior Oracle Applications DBA
Responsibilities:
- Rapidwiz installation of Oracle E-Business Suite R12.2.0 utilizing AWS
- Upgrade Oracle E-Business Suite R12.2 RUP8
- Utilized opatch, bsu (Weblogic), and adop for R12.2.8 upgrade
- Installation and Configuration of Oracle Automatic Storage Management (ASM)
- Installation and Configuration Oracle 12c (12.1.0) for Active Data Guard (two server)
- Installation Oracle Enterprise Manager Cloud Control 12c
- Researched and Created Oracle databases utilizing AWS Amazon RDS
- Database Administrator for EBS environments 10g, Oracle RDBMS
- Architected and executed a variety of cloning methods: RMAN, standby, Hot & Cold
- Implemented Oracle Applications documentation standards
- Extensive utilization of Metalink for research and SR creation to resolution
- Architected Fault Tolerance environment migrating from unsupported VERITAS Clustering
- Implemented tasks and schedules for routine health and maintenance checks
- Implemented custom monitoring for Oracle Applications EBS environments
- Responsible for 1st and 2nd level interviewing Oracle Applications DBAs
- Upgraded in 11.5.10.2 to R12 with an emphasis on EBS customizations
- Presented Oracle Maintenance Wizard for R12 upgrade
- Assisted in stabilizing Oracle Portal/OID/GRID/OAM for company wide employee Portal
- Re-architected and Re-implemented SSO for Oracle EBS for external and internal usage
- Responsible for all database object and code migration
- Provide Production Support for Oracle EBS environments 11.5.10.2 and R12/ Solaris 10
- Architected and implemented Dell Boomi Atoms and Molecules on Windows and Linux servers
- Member of Project Spring for SAP SuccessFactors and Dell Boomi implementation
- Currently implementing Accenture’s Clone and Test for SuccessFactors Cloud environments
- Installation and maintenance of BackOffice Associates (BOA) for Project Spring
- Light DBA work for BOA project utilizing MS SQL Server
- Designed DB, OS, and Application Tier monitoring of Oracle ERP and Dell boomi
- SAP ERP ECC6 EH7 implementation with Oracle 11g for development team
- SAP Solution Manger implementation for development team
- SAP ERP ECC6 EH7 IDES with Oracle 11g implementation for team (training)
Confidential
Senior Oracle Applications DBA/Tech Lead/Architect
Responsibilities:
- Provide Production Support for multiple Oracle EBS environments 11.5.10.2 and R12
- Execute a variety of cloning methods: RMAN, standby, Hot & Cold for multiple customers
- Liaison between Oracle Applications team, customers and customer representatives
- Designed methodology to analyze and implement - DB upgrades, one-off patches, family & maintenance packs
- Responsible for architecting and sizing environments for single and multi node Apps/DB Tiers for existing and future customers
- Lead Architect for sizing environments in 11i, R12, with 9i, 10g, 11g Oracle RDBMS
- Architected and implemented DMZ with SSL external web node utilizing common ‘ad’ tools
- Responsible for designing and implementing EBS transitions from client datacenters to outsourcing datacenters
- Crafted and implemented migration plans for cross platform hardware/OS upgrades for Oracle Apps environments
- Created Oracle Applications monitoring suite for 9i, 10g, 11g, 11i, R12 environments for cross platform/OS implementations
- Created documentation standards for internal and customer utilization
- Extensive utilization of Metalink for research and SR creation to resolution
- Attended multiple sales calls both on-site and off-site locations
- Architected and implemented multiple Disaster Recovery sites utilizing Oracle Dataguard
- Architected and implemented multiple Fault Tolerance environments utilizing SAN technology
- Responsible for 1st and 2nd level interviewing of five Oracle Applications DBAs
- Created tasks and schedules for routine health and maintenance checks
- Implemented team training directives for both individual and team growth
- Responsible for Interfacing all monitoring to HP OVO, Nagios, and customer Support Center
- Created monthly Quality of Service, db performance, and space growth reports
- Tune Oracle Applications environment from a Database and Application Tier perspective
Confidential
Senior Oracle Applications DBA/Manager
Responsibilities:
- Coordination/management of an Oracle team of seven contractors and employees.
- Installation of OBIEE suite: iAS, Oracle Analytics Dashboard, 10G db, Informatica PowerCenter ETL tools, DAC, on Windows and Linux platforms.
- Installation of SOA middleware: Oracle iAS, Oracle 10G RDBMS, on Linux platform.
- Maintained, upgraded, configured, and recommended the required Linux environments for all Oracle environments.
- Solely responsible for migration from 8i to 9i on 11.5.8 Oracle Applications environments.
- Work with Informatica to extract data from Oracle Financials to Data warehouse database.
- Solely responsible for migration of 11.5.8 to 11.5.10.2 Oracle Applications environments.
- Responsible for staying Sarbanes-Oxley compliant for all Oracle based environments.
- Administration utilizing Oracle 10g Enterprise Manager and Grid Control.
- Design and implemented an ODS to reduce production CPU utilization on OLTP.
- Responsible Oracle Applications HRMS, Financials, and Web based Discoverer reporting maintaining 99.9% availability.
- Patch management for all environments EBS 11.5.10.2, on 9i databases from Development to Production.
- Responsible for cloning utilizing Rapid Clone and Auto Configuration from Production to all environments.
- Responsible for all 8i, 9i 10g Oracle database installations, upgrades, and patching.
- Responsible for troubleshooting enterprise applications utilizing web research and Metalink TARS.
- PL/SQL, SQL programming, and Linux shell scripting for custom application development.
- Utilized and well versed in SQL Loader, IMP/EXP, Logminer, RDA, Statspack.
- Responsible for migrations during development cycles and customer upgrades from Development to Production.
- Responsible for migration of all RDBMS custom environments to 10g.
- Administration of multiple MS SQL Server databases.
- Responsible for all RDBMS backup and recovery processes at Confidential .
- Currently learning to utilize Oracle’s AIM Methodologies for all software implementations.
- Currently learning Informatica PowerCenter ETL tools as well as DAC and other OBIEE software.
- Responsible for interviewing and hiring all Oracle Application team members.
- Implementation and administration of multiple MySQL databases.
- Negotiated Oracle contracts and licensing agreements and reduced contract costs
Confidential
Oracle, MS SQL Server, PostgreSQL, MySQL DBA
Responsibilities:
- Responsible for development and test environments for Oracle 8, 9i, MS SQL Server, and Postgres databases.
- Setup uPortal environments on Linux and Solaris environments utilizing Apache and Tomcat servers.
- Investigated differences in MySQL in comparison to Oracle 8, 9i, MS SQL Server, and Postgres RDBMSs.
- First to migrate the companies Portal to MySQL.
- Performance tested uPortal application against Oracle 9i environments using OpenSTA, Statspack, and GNUplot.
- Maintained SQL delta scripts for uPortal application in Oracle 8, 9i, MS SQL Server, and Postgres environments.
- Responsible for migrations during development cycles and customer upgrades.
Confidential
Solaris SA/ Oracle DBA
Responsibilities:
- Responsible for production and development Oracle 9i databases 24X7 365 days a year for a high profile Homeland security project.
- Implementation and maintenance of Oracle 9i backup and recovery using Archivelog mode and Unix shell scripting.
- Responsible for production and development Sunfire280Rs with Solaris 8 operating system environments 24X7 365 days a year.
- Maintenance of Sunfire 280R and StorEdge A1000 disk Array Raid for Homeland security project.
- Implementation and maintenance of Veritas Netbackup Business Server 4.5 utilizing Sun StorEdge L9 tape backup.
- Performance and tuning using Statspack and RDA for Oracle 9i on production and development environments to further Metalink support.
- Organized Solaris 8 init.d shutdown/boot programs, shutdown unnecessary daemons and ports to reduce hacking.
- Setup MTS (Multi-Threaded Server) for all Oracle Environment using Java web applications Homeland security project.
- Installation and maintenance of SQL Server 2000 and Microsoft Project Server Homeland security project.
- Implementation and maintenance of Apache+SSL (Secure Socket Layer) web server 1.3.27 for Homeland security project.
- Installed Patch Clusters for Solaris 8 for added security benefits and upgrading environment.
- Created multiple Korn shell scripts with sendmail to monitor 24X7 365 both Oracle and Solaris 8 prod and dev environments.
- Implemented and scheduled all production batch jobs for maintenance using Solaris 8 job scheduler “cron”.
- Performance and tuning on commonly run SQL scripts within all Oracle 9i environments.
Confidential
Oracle DBA
Responsibilities:
- Conversion to Oracle RDBMS from Powerbuilder application that currently utilizes MS Access and SQL Server.
- Responsible for Oracle DBA duties, including implementation, conversion, and data troubleshooting.
- Troubleshooting connectivity and source code challenges from Powerbuilder to Oracle 8i.
- Setup critical backup and recovery methods using Archivelog mode as well as non-critical data gathering times.
Confidential
Oracle Financial Analyzer
Responsibilities:
- Contracted by this Fortune 500 global manufacturer of agricultural and construction equipment to lead a global project at its Wisconsin Information Systems headquarters.
- Project Manager of the OFA (Oracle Financial Analyzer 6.3) team comprising three consultants and four employees.
- Designed and implemented Access database and reporting application for project team management.
- Oracle Express DBA responsibilities: design, implementation, maintenance of backup and recovery, performance and tuning, data troubleshooting 24/7 - 365 days a year.
- Created multiple Korn shell scripts to monitor and maintain Unix and Oracle Express server environments.
- Responsible for maintenance and stability of OFA, OAS (Oracle Application Server)/web and OES (Oracle Express Server).
- Created Unix based extract scripts to interfaces between Oracle Express and multiple RDBMS.
- Responsible for streamlining data extracts from PC based software to mainframe datasets utilizing RDBMS.
- Created Sybase databases, tables, and stored procedures for data extracts from various general ledgers for input to OFA system.
- Co-designed database tables structures with web application team to use with OFA internal structures.
- Designed and developed RDBMS structural table extracts using Unix Korn shell scripts for Oracle Express input.
- Implementation of OFA, OAS and OES (Oracle Express Server) on Sun E6500 Unix environments.
- DBA responsibilities included OFA maintenance of structures (e.g., dimensions, attributes, hierarchies, models, etc.) throughout OFA system.
- Created data and structures import programs using the Oracle Express Export/ Import software utilities.
- Analysis of data and reconciliation of reports extracted from the OFA system using Oracle Express multidimensional language.
- Created and implemented nightly EIF backup and recovery methods for multiple production and test Oracle Express systems.
- Produced shell scripts for extract of ldif files from LDAP and Microsoft Exchange servers for business users ad hoc requests.
- Khalix Financial Planning and Analysis OLAP project
- Team technical lead for worldwide implementation and maintenance of the Khalix Financial Planning and Analysis OLAP project.
- Created Sybase tables and stored procs for holding data extractions from various GL platforms, product/unit data repositories, and HR systems.
- Designed Unix shell scripts for the data extraction system from multiple computer platforms for the Financial Planning system.
- Established the Sybase environment for the financial application server, including creation of all databases, table layouts, and stored procedure data conversion systems using Sybase release 11.
- Implemented the latest software releases and upgrades, including dropping/creating databases tables and indexes during beta testing and production upgrades.
- Produced shell scripts using sed and nawk to convert RDBMS exports to LDAPs ldif format.and ldif format back to import format for RDBMSs.
- Responsible for backup and recovery of production environments located in Sybase databases, as well as setup of multiple development/test environments for each new beta release and existing production release.
- Established the Unix environment for the Khalix application server
- Created multiple Korn shell scripts to monitor and maintain Unix and application software in Sybase environments.
- Modified Perl scripts to load LDAP system with extracts from RDBMS converted to ldif format utilizing ldapsearch and ldapmodify.
- Created 12000 E-mail accounts from extracts of ldif files by obtaining from LDAP & Exchange Bridgehead Servers with shell scripting.