Sr Oracle Application Dba Resume
SUMMARY:
- Over 7+ years of experience in Oracle Fusion Middleware including Oracle SOA suite (10g, 11g,12c), web services, Oracle BPEL process Manager, BPM, Service Bus (OSB). Expertise in administration of BEA WebLogic 8.1/9.2 /10/11 g/12c on Sun - Solaris, Red Hat Linux, Oracle Linux, Windows.
- Worked on Proxy & Business services.
- Designing proxy services using structures like pipelines and route nodes.
- Good understanding of Agile and Devops methodologies.
- Experience in the design and implementation of automated Continuous Integration, Continuous Delivery and Continuous Deployment.
- Experience in Web Application server Administration providing support for production, staging, testing and development environments.
- Configuration and development of JCA adapters like DB, FTP, JMS and File Adapters using JDeveloper and WebLogic server console.
- Solid experience in administration of Weblogic server 8.1/9.2/10.0.2 &10.3.x/12c on Sun-Solaris, Red Hat Linux 4.x/5.xEL, Oracle Linux, and Windows NT 2003/2008 environments.
- Expertise with BPEL process Orchestration for integrating ERP applications, Databases, legacy applications, Flat Files and Portals.
- Strong technical background in Java, J2EE and application server technologies with an expertise in developing product roadmaps, detailed product requirements and competitive analysis.
- Strong knowledge in clustering, JDBC connections and JMS connection factories.
- Configured Web Server plug-ins for applications servers (Weblogic).
- Installed, Upgraded and configured Iplanet 6.0 to 6.1 and Apache web server 1.3.x to 2.0.
- Recommended Clustering, load-balancing and fail-over solutions.
- Configured Node manager for administering the servers.
- Extensive experience of secure ftp, Proxy technologies, TCP/IP, DNS, NFS, Ethernet, NIS, HTML, SSL Certificates and network troubleshooting.
- Experience working with iPlanet Sunone 6.1.x, Apache webserver 1.x/2.x and IIS 6.0/7.x, OHS.
- Experience working with databases like DB2, Point base, Oracle and SQL Server.
- Conceptual knowledge of configuring site minder and load balancer.
- Configured and administered Monitoring tools Site scope and wily Introscope 7.x/8.x/9.x, Oracle Enterprise Manager (OEM) 12c.
- Developed scripts using shell scripting, Perl and WLST for automation of process.
- Extensive experience with the Oracle Database with the necessary insight to ensure that any Oracle implementation will make the best use of the database functionality
- Upgraded Oracle Application 11.0.3 to 11.5.10.2 and 11.5.10.2 to R12.2.4
- Upgraded DB version 10.2.0.2 to 10.2.0.4, 11.2.0.1 to 11.2.0.3, 11.2.0.3 to 11.2.0.4,12.1.0.2
- Implemented R12.1.3 Oracle Application, Implemented Oracle Revenue Management and Billing application
- Provided Production support for Oracle Application of various different versions, provided Production support for RMB application, OBIEE application, Applimation, Journix application, Demantra Application, Discoverer to name a few
- Provided Core DBA support for various Oracle Database versions
- Planned, designed and implemented Real Application Cluster for High Availability
- 12 years of corporate experience in Supply Chain Management, 2+ years of
- Oracle Transportation Management (OTM) experience
- OTM support projects in total for clients in Retail, food and Manufacturing industries in USA, Asia Pacific and Middle Eastern markets.
- SOA implementation and maintenanceGood skills in Preparing project charter, User requirement analysis, Project
- Implementation, Design to configure OTM, Application ConfigurationWorked on the breadth of the OTM application from Order ManagementShipment Management, Fleet Management, Event Management and Settlement.
- Had proven track record of success in supporting clients and providing insight that can only be obtained from broad range of experience with the Oracle database and integrated packages in JAVA, Web Server, EJB, XML, and Web Logic
SKILL:
Database: Oracle 7.3.4/ 8.0.4/ 8.0.5/8.0.6/ 8.1.5/ 8.1.6/8.1.7/ 9.0.1.4 / 9.2.0.1/9.2.0.6 10.2.0.2. 10.2.0.4 , 11.1.0.6, 11.2.0.1, 11.2.0.2, 11.2.03.0.8 , 11.2.0.4,12.1.0.2
Tools: SQL Navigator, Precise, Spotlight, Oracle Enterprise Manager, TOAD, AD Tools, Erwin, All Fusion Harvest Change Manager, Designer, Forms Developer, Reports, Discoverer, IT governance, Kintana, Export, Import,datapump, RMAN, Data guard, grid control, OBIEE, RAC 10g and 11g,Ctrix,12c IBM Rational
SELECTED PROJECT EXPERIENCE:
Confidential
Sr Oracle Application DBA
Responsibilities:
- Production support
- Oracle Application R12.1.3, upgrade, cloning, SR suggested patching, Quarterly Security patching to DB, Weblogic, Application, Apache, tomcat
- ASCP R12.1.3,Cloning Patching,
- Webcenter Suite, installed WebCenter Portal 11.1.1.8,
- Integrated webcenter suite with Oracle Application,
- EMCC 13c installation and configuration,
- OTM 6.3,Cloning
- PPM installation, PPM clone, PPM relocated Database to EXADATA Machine,
- PPM Integration and troubleshoot, Using PPM for code Migration
- FTI,
- Mile Maker,
- Hyperion Essbase, workspace, Planning, Smartview
- APCC Oracle Advanced Planning Command Center BI application configured for ASCP
- UPK - User Productivity Kit,
- OBIEE 11.1.7,
- Fusion Middleware support for all related oracle applications,
- SOA Suite 11.1.7,Cloning, maintenance and user support,
- Installed & Configured Cluster in weblogic 10.3.6/10.3.6 , 12.1.1 environments for CFM.
- Configured JMS, JDBC, DB Adapter, FTP Adapter, File Adapter, JMS Adapter recourses on weblogic admin for various Applications usage.
- Configuration JDBC, JMS resources for CFM, InAuth, RSA, RCM application servers.
- Create in-place upgrade scripts for CFM and RCM application.
- Responsible for Clustering & Load balancing of weblogic along with Apache web server for scalability and high availability.
- Build parallel environment for OFM 12c in Dev for PoC.
- ODI 11g integrating with OEM using ODI Console,
- Oracle Retail 14.0,
- Exadata 2.4,
- Exadata appliance patching, Grid and RAC Database upgrade hosted on EXADATA,
- EXADATA ASR handling,
- Linux patching,
- Linux maintenance,
- Linux User management,
- 11.2.0.4 RAC database, 12.1.0,2 12c upgrade,
- Development support
- User support,
- Upgrade project underway for R12.1.3 to R12.2.5 upgraded SOA, SOLIX, EBUSINESS, OBIEE and OTM Pre prod and production databases upgrade from 11.2.0.4 to 12.1.0.2 12 c on exadata engineering system
Confidential
Sr Oracle Application DBA/RMB DBA Team Lead
Responsibilities:
- Implementing Oracle R12.2.2,
- Performance tuning after go live,
- 11.2.0.4 RAC database,
- Tibco interface with R12.2.2,
- Oracle webcenter suite for content management, WebCenter Portal 11.1.1.8
- Data Guard,
- OEM 12c,
- Development support
- Fusion Middleware support for RMB and other oracle Middle tiers,
- User support, Oracle Application R12.2.2, upgrade, cloning, SR suggested patching, Quarterly Security patching to DB, Weblogic, Application, Apache, tomcat
- Architect and design Oracle RMB instance,
- Oracle Revenue Management and Billing 2.4 sp2 (ORMB used to be CC&B) Support
- RMB Deployment, RMB cm.jar, SPLApp.war, framework code and patches deployment
- RMB Blue print deployment
- Clone RMB environment, troubleshoot weblogic issues
Confidential
DBA Team Lead
Responsibilities:
- Oracle application 11i to R12.2.4 upgrade,
- Linux patching for R12.2 upgrade readiness,
- Older version Oracle Application 11i, cloning, SR suggested patching, Quarterly Security patching to DB, Weblogic interfaces, Application, Apache, tomcat
- Oracle Federal Financial
- Built and configure OFM 11.1.1.7 environment.
- Responsible for Clustering & Load balancing of weblogic (SOA, OSB) along with OHS for scalability and high availability.
- Installed & Configured Cluster in weblogic 10.3.6/10.3.6 , 12.1.1 environments for CFM.
- Configured JMS, JDBC, DB Adapter, FTP Adapter, File Adapter, JMS Adapter recourses on weblogic admin for various Applications usage.
- Configuration JDBC, JMS resources for CFM, InAuth, RSA, RCM application servers.
- Create in-place upgrade scripts for CFM and RCM application.
- Responsible for Clustering & Load balancing of weblogic along with Apache web server for scalability and high availability.
- Build parallel environment for OFM 12c in Dev for PoC.
- OAM implementation and integration to R12.2.4
- Informatica archive ILM 6.2 to 6.4 upgrade
- Informatica applimation 11.5.10.2 to R12 upgrade
- Production support for 11i and R12 application, Discoverer, OAM, informatica
- Analyzed and Applied Quarterly Security patches to RAC DB, 11i Application, OAM, Discoverer, Informatica
- Provided End user support for various login issues for 400 users using IBM Rational Ticket System
- Clone Dev, Test and UAT environments as needed basis
- IBM Rational Suite
- C-6 Clearance
Confidential
Sr. Apps DBA, core DBA and RMB, Webcenter, ODI and Fusion infrastructure DBA Lead
Responsibilities:
- Product Development and user support R12.1.3 Application,
- 11.2.0.1 Database upgrade to 11.2.0.3
- Upgrade EBS db from 11.2.0.3 to 11.2.0.3.8
- GRC Support,
- GoldenGate Installation and Configuration,
- Architect and design Oracle RMB instance,
- Oracle Revenue Management and Billing v2.1 (RMB, used to be CC&B) Support
- RMB cm.jar, SPLApp.war, framework code and patches deployment
- RMB Blue print deployment
- ODI integration, ODI Console
- JVM tuning, threadpool server clustering (Weblogic)
- Clone RMB environment, troubleshoot weblogic issues
- Oracle Webcenter Suite, Web Content Management with IPM, UCM
- PPM installation, PPM clone,
- Fusion Middleware maintenance and User support,
- Using PPM for code Migration
- Patching and user support
- Updated init.ora for XML DB repository with Dispatcher parameter
- OBIEE implementation 11gR2 database installation, 11.1.1.6.0 BIEE MT installation
- 32bit RCU (Repository Creation Utility) installation and support
- Oracle Application R12.1.3, cloning, SR suggested patching, Quarterly Security patching to DB, Weblogic, Application, Apache, tomcat
- Heavy Fusion Apps environment
Confidential, Columbia, MD
Lead BA
Responsibilities:
- Production maintenance of 11.0.3 and R12 12.1.1. e-Business instances
- Major modules support Oracle ERP 12i (GL, AP, FA, PO, PA, INV, OM I-Expense) cloned 11.0.3 and R12 e-Business instances as needed using RMAN and hot backup,
- HP patching,
- HP user management,
- Linux Patching, configuration for new installation
- Linux user management,
- Golden Gate, Data Guard, OEM
- Oracle Webcenter Suite 11g (11.1.1.8), Java update for Webcenter jdk1.6.0 29
- Oracle Fusion Middleware support for all middle tier apps, Built and configure parallel new OFM 11.1.1.6 environment and configured same resources as 11.1.1.3.
- Installed & Configured Cluster in weblogic 10.3.6.
- Configuration and deployment of OSB web services, Worked on Proxy and business services.
- Configuration and deployment of SOA composites.
- Built and configure parallel new OFM 11.1.1.7 environment and configured same resources as 11.1.1.3.
- Created weblogic domain for ODI integration.
- Created/updated BAM resources.
- Old oracle apps with 11.0.3 (8i) database maintenance,
- Production Support and patch management of 11.0.3 and 12.1.1 oracle e-Business
- Production Support for 10.2.0.4 Clarify Database and application (CRM)
- Production Support of 9i Journix Database,
- Configured XML DB database using xdbconfig.xml file
- Created daily oracle production apps database clone script to support BI database extraction from Oracle Application database
Confidential, Charlotte, NC
Sr.Application DBA/Project Lead
Responsibilities:
- Lead the upgrade project, ERP database from 11.2.0.1 to 11.2.0.2 for 3.5 T size of database and production support for R12 ASCP, OTM, Demantra and e-Business 11.5.10.2 with (GL, AP, FA, PO, PA, INV, OM modules)
- 11g RAC database with ASM, evaluated with oracle team for SAN to EXADATA migration but company decided not to go with EXADATA due to cost and dual storage maintenance
Confidential, Boston, MA
Application DBA/Core DBA
Responsibilities:
- Technical lead DBA, monitoring offshore DBA team to support 24x7 environment
- Responsible for leading team and provide weekly task with execution plan if needed, cloned and refreshed instances as needed using RMAN
- Implemented DR site for EBS database and Application for Production and QA system
- Recently completed DR testing for all production systems, Data guard, 11g R2 RAC, ASM
- Implemented RFS transportation for companywide production databases
- Responsible for patching analysis and scheduling matching company downtime
- Responsible for change order moving from test, QA, Prod respectively
- Responsible for technical project management for web method and Demantra upgrade
- Involved in R12 ongoing upgrade project with major modules (GL, AP, FA, PO, PA, INV, OM, HR, PAY)
- Responsible for OTM production support
- Responsible for ASCP production Support
- Responsible for Webcenter 11g suite support
- OBIEE Team interaction and providing support regarding OBIEE and EBS ETL schedule and troubleshoot
- Managed project for Upgrade web methods database to 11g and application
- Managed Project for Upgrade Demantra database to 11g and application.
- Managed Project adding informatica for GL module in e-Business for data archiving to control the db growth which is 100G/yr
Confidential, Louisville, KY
Project Lead/Sr. Oracle Apps DBA
Responsibilities:
- Reason for Leaving: DBA services outsourced to overseas data centre after contract completed
- Team lead for E-Business application upgrade and production support project
- Production support for most manufacturing and Fin. Modules like (GL, AP, FA, PO, PA, INV, HRMS, PAY, OM), user support for development, patching, cloning
- Configured Weblogic 10.0.2 & 10.3.x and migrated from WLS 8.1Sp6 and 9.2.
- Created WLST scripts to automate some of the Admin utilities.
- Worked on SOA, OSB, BPEL domains/Applications.
- Implementing and tuning the throttling using OSB Throttling or Work managers.
- Responsible for clustering & load balancing of weblogic along with Apache web server and Sunone 6.1.x for scalability and high availability.
- Configured JMS, JDBC, DB Adapter, FTP Adapter, File Adapter, JMS Adapter recourses on weblogic admin for various Applications usage.
- Conceptual knowledge of configuring site minder 4.x/5.x and load balancer.
- Configured JMS, JDBC recourses on weblogic admin for Application usage.
- Used Web logic Smart update tool to apply patches.
- Installed & Configured Cluster in Weblogic 10.0.2, 10.3.x environments.
- Configuration of JDBC and JMS resources.
- Upgrade, added DMZ node for i-Expense, and ASCP, upgraded Discoverer to latest Version
- 10.2.0.2 database upgraded to 10.2.0.4 for pre-requirement for OS migration and 11i to R12 upgrade
- Extensively used RMAN for cloning, refreshing and standby db creation
- Ervin for data modelling
