Architect - IBM Cloud - Oracle Line of Business
IBM
Total des années d'expérience :26 years, 0 Mois
Automation and Building Database and ERP cloud like Oracle, Oracle EBusiness Suites. Peoplesoft and Primavera on IBM CMS and IBM SoftLayer cloud.
• Capacity planning of offering of Database, EBS, Peoplesoft, Primavera and Hyperion.
• Creation of Oracle VM template for DB, Peoplesoft and EBS and automation.
• Design self-service portal with OEM 12c and OVMM for OVM based template deployment and Database as Service.
• Working on architectural Themes/Epic and documents like HLD, SSD, stories and end to end architecture.
• Creating architectural data for solution and sales team for Oracle products.
• Supporting pre-sales for cloud hosting by mapping on-premises datacenter to IBM Cloud.
• Transition and transformation solution for prospect customers looking for cloud hosting solution for their enterprise applications like EBS, Peoplesoft, Database, Data warehouse, OBIEE, Hyperion, Primavera and for customer looking for new implementations.
• Works as Architect in Oracle Cloud Managed Services
• Support P1 issue with Hosted and non-hosted client in shift and out of shift.
• Datacenter migration on Oracle Cloud hosted on Oracle Exadata and Exalogic machines which include Oracle database, RAC, Oracle EBusiness Suites, SOA, OBIEE and Fusion Middleware components.
• Part of shared pool resource to help in implementation of Oracle Life Sciences Data Hub.
• Capacity planning for new hardware on VMs for existing hardware.
• Training DBA and team members.
• Upgrade RAC and Databases from Oracle 11gr1 to 11gR2 11.2.0.4
• Performance tuning instance and databases and Demantra engines.
• Performance tuning Fusion Middleware components hosted with SOA, BPM, OSB, WSM and ODI.
1. Sr. Oracle Application DBA (March 2013 - present)
Client VMware Inc./Accenture India- Bangalore
Involvement Oracle RAC virtualization for Oracle Apps 11i and SOA Dehydration store
Skill Used Oracle 11g RAC (11.2.0.3), SOA 10g, OSB 11g, WebLogic, Oracle 11i (11.5.10.2), vSphere 5.5,
O S/HW Oracle Linux 4, 5 and 6 (64 and 32-bit), EMC VNX,
Details
• Audit and recommendation for VMware EBS environment and recommendations and best practices.
• Tuning and purge Workflow, AutoInvoice, SFM Manager and database parameters etc. based on outcome of Load testing and issues on production.
• Root causes analysis for Conc. Manager Nodes crash during Load test since last year Aug. Linux Kernel tuning and recommendation and nfs_inode_cache and low memory area caching on 32-bit Linux.
• Design and Architect Oracle 11gR2 RAC for vSphere Virtualization/Cloud Infrastructure for IDM, SOA and E-Business Suites environment.
• HW/OS Failover, Load Test and Stage testing running for 11gRAC2 RAC on VM with VMware Virtualization solution.
• Provided L3 Support for Oracle Application and database and real application cluster issues.
• Architect Lobs migration from basic files to secure files and DBFS.
• Recommendation to implement best practice for Oracle application purge and archive not done since implementation and database advance compression to reduce size of database and better performance.
• Troubleshooting ERP development SDLC instances related to performance issue, IO benchmarking (Latency, throughput, IOPS) using Orion, dd, IO Calibration between instances running in Physical servers and running on VM/Cloud.
• Tuning 10G NIC to performance better on NFS and VM/Cloud.
Development and production support for EBS R12 (12.1.2/12.1.3), Identity Management, Oracle 11gR1 RAC, OBIEE, SOA and IPM
Oracle 11g RAC (11.1.0.7), Oracle 11gr2 (12.1.0.3), Oracle BIEE 10.1.3.4/11.1.1.5, WebLogic 10.3.x, Oracle 10g Application Server 10.1.3.4 (J2EE), Oracle EBusiness Suites R12(12.1.2/12.1.3), Informatica 8.6/9.0.1, DAC, Oracle 10gR2/11R1 OEM, Toad, Oracle Business Intelligence Application 7.9.6.x, Identity Management 10.1.4.3/11.1.1.3, Informatica Data Archive 5.3 for EBS,
Oracle Linux 4, 5 and 6 (64 and 32-bit), EMC DMX 3/Clarion, VNX1 and VNX2
• Analysis for H/W from Dell to Hitachi and Storage from EMC DMX/300 to VMX migration and disk performance testing.
• 6 TB production and 31 TB development online database migration from DMX to VNX for cost saving.
• Analysis for OS rpm with Oracle 11gr2 11.1.0.3 on Linux 6..3 and hardware requirement for facilitate Database Flash Cache implementation and back porting possible database features from Oracle Exadata 2.0
• Installation of Oracle 11gR2 11.1.0.3 RAC 3-node, Database migration from old hardware to new hardware using expdp and pointing to existing application tier nodes.
• OID upgrade from 11.1.1.4 to 11.1.1.6.
• Patch analysis for EBS 12.1.3 environment for all recommended, critical and rollup patches using patch wizard.
• Cloning OEM to different server and upgraded from OEM 11g R1 upgrade to OEM 12c and implementing ACP/AMP 4.x with OEM 12c.
• Oracle BIEE upgrade from 11.1.1.5 to 11.1.1.6.2 in HA environment.
• Oracle BIEE 10 to 11.1.1.5 Upgrade with BI apps and OBIEE clustering and enabling SSO.
• OS Upgrade from Linux 4.8 to Linux 5.7 application running EBS R12, OBIEE 11g, OID 11g, SSO 10g, Fusion Middleware 11g.
• Oracle Clusterware upgrade from 11.1.0.7 to 11.2.0.3 and Database upgrade from 11.1.0.7 to 11.2.0.3.
• EBS Upgrade from R12 12.1.2 to 12.1.3
• Day to day production and development support.
• Cloning EBS R12 instances, RAC to RAC and RAC to non-RAC.
• Upgrade and OID to OID 11gR1 with Weblogic Clustering /OID clustering.
• Converted existing OID/SSO environment to true HA with RAC, OID and SSO cluster/HA.
• Upgrade Oracle RAC Clusterware, ASM and DB upgrade to 11gR1 11.1.0.7
• Perform full and incremental ETL load in development and production and fixed issue while loading data.
• OEM 10gR2 to OEM 11gR1 upgrade and waiting for ACP/AMP 3.1 pack once ACP/AMP for OEM 11GR1 release.
• Identity Management implementation with People soft ERP in progress
• Support ADF development for Middleware.
• Evaluation of Database and application migration to Oracle HexaData and HexaLogic Machine are in progress.
• Applimation upgrade as part of post EBS R12 upgrade.
• Applimation to Data Archive 5.3 upgrade.
• EBusiness Suites R12 12.1.2 to 12.1.3 upgrade.
• Oracle 11gR1 to Oracle 11gR2 RAC (11.2.0.2) upgrade in progress.
• Active data guard implementation with EBS R12.1.3 with 3 nodes RAC primary node and single node standby reporting instance for discoverer 11g, OBIEE ETL and sqlplus, TOAD, queries to offload load from primary.
• Implemented jumbo frame for existing 11gr1 RAC instance and tuning kernel parameters.
• Implemented huge page with Oracle 11gR1 database.
3. Sr. Oracle DBA (June 2009 - April 2010)
Client Beckman Coulter., Fullerton, CA
Involvement
Platform migration for Ebiz from Hpux to Oracle Linux, Clusterware, ASM setup for Ebiz and Data warehouse, Setup Informatica and DAC and OBIEE Clustering. Support PCP and Shared Top Implementation for Ebiz
Skill Used
Oracle 10g RAC (10.2.0.4), Oracle 11g RAC (11.2.0.1), Oracle BIEE 10.1.3.3, Oracle 10g Application Server 10.1.3.3 (J2EE), Oracle EBusiness Suites 11i (11.5.10.2), Informatica 8.0, DAC, Oracle 10gR2 OEM, Toad, Oracle Business Intelligence Application 7.9
O S Oracle Linux 4 and 5 (64 and 32-bit), HP UX 11.11, EMC DMX Symmetric 300 series, HP 12000, 24000 XP Storage
Details
• Oracle 10gR2 and ASM and Clusterware setup for EBusiness Suites.
• Implemented Jumbo frame for RAC interconnect.
• Database platform migration from HP-UX to Linux using data pump.
• Platform migration of database from Hpux to Linux and converted to 6 nodes RAC DB, 12 node Apps Tier of which 2 node Conc. Manager and PCP with queue implemented and shared Appl top.
• Migrated third party software like Vertex, clear orbit and integrated with EBusiness Suites.
• Standardize customization in proper way and fixed shell scripts and custom program for RAC.
• User and developers support as when required.
• EBusiness Suites cloning from RAC to RAC and RAC to non-RAC instances with ASM using BCV snap and RMAN duplication depends of storage support.
• Informatica and DAC setup for Data warehouse ETL loading.
• OBIEE and 10g AS OC4J Clustering for BI reporting.
• BI Development support and tuning ETL script and Scaling database parameters.
• Used Multi Block size 8k default and 32k for DWH schema for data warehouse.
• Development support as and when required for BI development.
• Oracle 11gR2 Grid Installation, analyze pros and con of using GNS and SCAN IP for client connection with three nodes RAC for data warehouse for UAT.
• BI RPD code migration between development nQUDMLGen and nQUDLexc utilities.
• Closely worked with Oracle Support for Clusterware crashing issue with internal timeout.
• Used Jumbo frame for interconnect for better hand shacking across cluster nodes.
• Configure BI Web Catalog Caching for better user response.
• Helped ETL team to support long running jobs and troubleshoot the issue with old stats
• Tuning ETL Full and incremental load and suggested to use parallel DML for fast insert and updates.
• Oracle 11gR2 3node and 8- NODE RAC Installation and configuration for Data warehouse for UAT and production.
• Helped in datacenter migration from Fullerton to Phoenix.
4. Oracle Architect (January 2009 - June 2009)
Client Diebold Inc., North Canton, Ohio
Involvement
Oracle BIEE Clustering, BI Cloning procedure from Production, BI Security Implementation, OBIEE and LDAP (AD) Integration. Data Loading from OLTP to OLAP using Oracle Stream and Oracle 10g Data Guard Implementation to DR Site. Oracle 10g Clustering at Application. Setup Oracle 10gTransparent Gateway for Mainframe (DRDA), SQL Server, Lotus Domino Server. Oracle 10g OEM R4 Monitoring Integration from Oracle EBusiness Suites 11i and F5 BigIP, Capacity planning for E-business Suites R12 implementation instances for Brazil and setup SOA development environment.
Skill Used
Oracle BIEE 10.1.3.2, Oracle 10g RAC (10.2.0.3), F5 Big IP, Oracle 10g Application Server 10.1.3.1 (J2EE), Oracle Transparent Gateway for DRDA, SQL Server, Oracle EBusiness Suites 11i (11.5.10.2), Oracle Warehouse Builder and Oracle Data Integrator, SOA HA implementation and integration with mainframe
O S Oracle Linux 4 (64 and 32-bit), HP UX 11i, EMC Symmetric 300 series
Details
• Implementing BI Cloning procedure from Production to development.
• Oracle 10g Application Server Clustering on Application and HTTP load balancing with F5 BigIP.
• Oracle BI Clustering, Bi Cluster Controller setup, Presentation Layer Failover configuration and BI Scheduler Failover Configuration and Enabling Global Caching for presentation Layer.
• Oracle BI EE and LDAP (AD) Integration for Authentication and Database for Authorization Configuration.
• Configuring Data Loading from EBusiness Suites (OLTP) to Oracle Warehouse (OLAP) using Oracle Streams.
• Installation and Configuration of Oracle Transparent Gateway for SQL Server, DRDA (main frame) /DB2 and Oracle Heterogeneous Connectivity for Lotus Domino Server.
• Help Client to setup development Oracle 10g Data guard (Standby Database) at DRP site.
• Reviewing and recommending Oracle EBusiness Purge and Purging NULL values from Payroll module to reduce pay roll table data by 25%.
• Solved critical production issue with Oracle iProcumbent Punch-out with Oracle Exchange.
• Setup development Oracle Demantra 7.2 Instance with Oracle 11i separate planning instance.
• Installation of Oracle 10g SOA suites for development and clustered environment for production.
• Support E-business Suites 11.5.10.2 with Oracle 10g Database environment with multimode apps tier on Linux and DMZ with iSupplier as and when required.
• Installation SOA environment and provide support to developers.
• Written scripts using ant to code promotion from development to other environment.
• Provide production support as and when required.
• Involve in patching and cloning for Ebusiness Suites environment and solved critical post cloning issues.
5. Oracle SOA Administrator/ Apps DBA (September 2008 - December 2008)
Client Medtronic, Minneapolis, MN
Involvement
Design and implementation of High Availability Environment for Service Oriented Architecture (SOA) and Oracle Ebusiness Suites with multimode Apps Tier with DMZ with F5 Big IP and Apache as Reverse Proxy
Skill Used Oracle SOA Suite 10.1.3.1, Oracle Ebusiness Suites R12, F5 Big IP, Apache
O S Sun Solaris 10, Oracle Linux 4
Details
• Created BPEL domains and ESB systems for enterprise applications
• Applied various patches for fixing product issues.
• Migrated BPEL and ESB codes to test, staging and production environments using ant scripts
• Performance tuning of the SOA system at various layers (application, application server and database)
• Provide end user support and support to developers for day to day issues with SOA environment and Ebusiness Suites R12
• Clustering BPEL, ESB environment for Production
• Supporting developer for critical issues, creating SR with Oracle and working for resolution.
• Configuring various SOA adapters to integrated with Mainframe (CICS) and Seibel to integrate with Ebusiness Suites R12.
• Configuration and implementation of multi tier and multi node DMZ implementation with Apache as reverse proxy implemented URL firewall rules for iStore and iPayment gateway and iSupplier portal.
• Worked and supported integration of SOA and Ebusiness Suites with irep (Oracle Integration Repository)
• Occasionally involvement in patching and cloning o f Ebusiness Suites R12 environment.
6. Oracle Application Administrator with RAC (May 2008 - August 2008)
Client JDS Uniphase, Milpitas, CA Through Deloitte Consulting
Involvement
Support High priority Issue, Helping client in Upgrade Database/Oracle Apps/RAC, DMZ, Shared APPL_TOP, OATM and cross platform database migration from Sun (Big Endian) to Oracle Linux (little Endian) using TTS (Transportable tablespace), Oracle Fusion Application (BPEL, EBS, WSM, BAM), Oracle Identity Management, Oracle BAM, OBIEE, DAC and Informatica.
Skill Used
Oracle 9i (9.2.0.8) /Oracle RAC 10.2.0.3, EBusiness Suite 11.5.7 /11.5.10.2 (Financial/ Supply Chain, Order Management, APS, HRMS, CRM, iProcurement, iStore), PCP, DMZ, TOAD, OEM 10g Grid Control R3, SQL, PL/SQL, Oracle Workflow, Oracle Demantra, Oracle 10g Application Server, Oracle Middleware Fusion, BPEL, Data warehousing, ETL, F5 BigIP,
O S Oracle Linux 4 (64 and 32-bit), Sun Solaris 5.8, Net Apps Filer
Details
• Helping in post upgrade issue of Oracle Apps from 11.5.7 to 11.5.10.2
• Helping in configuring RAC, PCP, Shared APPL_TOP, DMZ and iStore through DMZ
• Helping client to reduce down in various consuming area like Maintenance Patch, Database Cross Platform Migration, OATM and identified steps which can be perform pre-outage.
• Identifying SQL or working taking more time during maintenance patch
• Identifying area where we can purge data to reduce patching time.
• Working on issue with Data warehouse RAC with other OLTP source instance and ETL tools scheduler.
• Solved performance issue with ATP and Planning engine (Analytical Work Bench) with APS suites after 11.5.7 to 15.5.10.2 upgrade.
• Helping client to setup Demantra with APS.
• Working on 24/7 support for project going live in mid of August.
• Cloning Instance from Current Production to get reference instance for Upgrade
• Cloning Instance from RAC (UAT and CRP) to non-RAC development instance.
• Project using NetApp Snap Mirror for Database and Rapid Clone for Apps Tier.
• Support user for testing issue/defect/error/ SR open with metalink.
• Oracle 10g OEM R3 installation and configuration for Database, EBusiness Suites, Middleware Fusion Components.
• Proactive Instance Tuning and Implementing Oracle EBusiness Security Best Practices.
• Tuning SQL using database trace, event, tkprof and AWR based to long running concurrent programs and user defect found during testing as an a performance issue.
• Helping client to setup Fusion Application and Identity Management and Oracle EBusiness Suites and Siebel and other legacy Application through SOA suites and Identity Management.
• OBIEE, DAC and Informatica installation for development for pipe line projects.
7. Sr. Oracle EBS/Application Server DBA (November 2007 - May 2008)
Client Zebra Technologies Inc, Chicago, IL
Involvement
0g RAC Architect, 10gAS Architect, Apps DBA for RAC migration. Performance tuning, AD & 10gAS OID LDAP integration architect and implementer.
Skill Used
Oracle RAC 10.2.0.3, EBusiness Suite /11.5.9/R12 (CRM, APS), Oracle Demantra, PCP, DMZ, TOAD, SQL, PL/SQL, Oracle Workflow, Oracle 10g Application Server, Oracle OBIEE, Oracle Business Application, Informatica, DAC, Oracle 10g AS
O S HPUX 11i, Oracle Linux, EMC Symmetric 3000 series
Details
• R12 reimplementation using Agile methodologies and Oracle Accelerator Server.
• Installation of Oracle 10g RAC with ASM on EMC Symmetric 3000 series SAN on Oracle Linux 64-bit. Setup interconnects, raw devices, ASM and VIP.
• Configuring Oracle EBusiness Suites R12 with RAC and single node to RAC migration, PCP implementation.
• Database Migration from HP-UX to Oracle Linux with using data pump.
• Setup Oracle Demantra Server for Demand Planning with R12
• Installation, configuration of Oracle BIEE and Oracle Business Application with DAC and Informatica and installed pre built ETL scripts, Interactive Dashboard, Answers for development environment.
• Installation and Support SOA environment, BPEL, ESB, Oracle WSM, Oracle BAM, Configured various adapters.
• Integrated SSO and Portal 10AS with ERP for SSO and OID based user base.
• Configured LDAP for LDAP cluster, Installed 10gCRS, ASM and RAC 2 node RAC blank database, MRCA metadata install using REPCA on RAC database, clustered LDAP services using HA.
• Configured password filter on domain controllers, configured ODISRV for user sync, setup bootstrapping and mapping file. Integrated several 9 and 10g database with LDAP server for SSO for EUS model. Integrated 11i with OID and build portal pages for SSO. Migrated all FND_USER to OID with new GUID's.
• Used AWR, ASH, OWI to setup tuning goals, started 6 multiple OC4j JVM threads, tuned apache, portal cache, web cache, OID threads and PLSQL cache to accept 1000 concurrent connections per portal server, tuned database and application tier JVM's, setup various concurrency threads. Tuned various R12 components, RAC GC components, interconnects, enqueues, latches and SQL's. Configured stress tests to test interconnect latencies, RAC component capacity.
8. Sr. Oracle E-Business and Security Architect (September 2007 - November 2007)
Client Brooks Automation, Boston, MA
Involvement
10g RAC Architect, 10gAS Architect, Performance tuning, Oracle Identity Management, integration architect and implementer.
Skill Used
Oracle RAC 10.2.0.3, EBusiness Suite /11.5.10.2 (CRM, APS), OAD, SQL, PL/SQL, Oracle Workflow, Oracle 10g Identity Management 10.1.4.0.1, Oracle Access Manager (OAM), Oracle Identity federation
O S HPUX 11i, Oracle Linux, EMC Symmetric 3000 series
Details
• Designed a Single sign-on solution by Integrating Oracle Identity Management (10.1.4), Microsoft Active Directory and Oracle e-Business Suite. The goal of the integration was to have a single source of user information and authentication. The solution enabled users to get authenticated to various partner applications by simply logging into the domain.
• Designed the solution for high-availability (Using multi-master replication) and scalability.
• Performed capacity planning based on the current load keeping in mind the anticipated growth over the next few years.
• Installed CRS, RAC software, ASM software, created ASM instances and created databases for OID metadata repositories in DEV, TEST and Production environments.
• Created the Metadata Repository using RepCA
• Installed, configured and maintained Identity Management 10.1.4.0.1
• Created OID schema, including custom attributes and objectClasses.
• Set up required Access Control Privileges (ACPs) through the use of dynamic and static groups.
• Configured the Directory Integration Platform Profile for importing user information from Active Directory including setting up custom attribute mapping.
• Configured external authentication plug-in to delegate authentication to AD.
• Configured Windows Native Authentication to provide seamless SSO integration.
• Configured Oracle e-Business Suite (11.5.10.2) to delegate authentication to SSO thus enabling users to access e-Biz without having to login.
• Setup one way provisioning between OID and e-Biz for automatic user creation in e-Biz.
9. Lead Oracle Application /Application server/Integration Architect (March 2006 - September 2007)
Client Diebold Incorporated /Deloitte, North Canton, OH
Involvement
Development and Production Support, Engineering of Shared APPL_TOP, OATM, Oracle Application and BigIP Monitoring using OEM Release2, Oracle Discoverer Failover clustering using BigIP F5 and Oracle10g RAC for BI and eBusiness Suites. SSL Implementations using BigIP as SSL Accelerator, Fixing complex issue OATM while implementing OATM like corruption in database etc. Oracle 10g RAC Installation for Portal/Data warehouse-BI usage and EBusiness Suites. Oracle 10g Discoverer upgrade for EBIZ and for Decision Support environment. Oracle iProcurement Support etc.
Skill Used
Oracle 9i /10g, Oracle 10g RAC, EBusiness Suite 11.5.8/11.5.10.2/ R12 (Financial/ Supply Chain, Order Management, APS, HRMS, CRM), TOAD, OEM 10g Grid Control R1/R2, SQL, PL/SQL, Oracle Workflow, Oracle 10g Application Server, Kintana, LoadRunner. Oracle 10g RAC, ASM, VMware, Oracle 10g Application Server, Oracle Middleware Fusion (BPEL, BPM, BAM, EBS) and Identity Management (SSO/OID), Oracle BIEE 10g (OBIEE), DAC, Informatica, , Mercury Quality Center and Kintana
O S HP UX 11i, Red Hat AS 2.1/3.0/4.0, EMS Clara Server, EMC Symmetric DMX 3000, SRDF.
Details
• Oracle 10g RAC with EBusiness Suites (11.5.10.2) with PCP and multiple apps tier with F5Big IP as SSL Accelerator.
• Database Migration from HPUX 11i to Oracle Linux 4 (Update 5) - 64 bit using data pump.
• Oracle 10g RAC Installation for Portal/Data warehouse-BI usage on Linux and EMC storage and ASM.
• Architecture and Installation of Oracle EBusiness Suites R12 for Brazil implementation of Oracle Linux and DELL Server and setup development instance.
• Oracle 10g Discoverer upgrade for EBusiness Suites and for Decision Support environment.
• Setup Oracle OBIEE environment, configured DAC and Informatica for development environment.
• Help in establishing connectivity to Oracle based Data warehouse to Mainframe, Oracle EBusiness Suites, BAAN, Lotus Domino Server and SQL servers.
• Setup development environment for Identity Management (SSO-OID) with repository on RAC and configure clustering for SSO, OID and BPEL component using VMware on Oracle Linux.
• Oracle Application Release 12 Vision Installation for Client to learn new features.
• Upgrade Oracle Application 11.5.8 to 11.5.10.2.
• Single point of contact for APS (planning) instance issue. Fixed issue with performance, long running Planning jobs and ATP (Available to promise) issue with planning. Worked to all functional issue and customization issue with planning instance after 10.2.0.3 upgrade at source instance.
• Helped client to setup Oracle Demantra on top of Planning Instance in development for better decision making on planning side.
• Conc. Manager Node Migration from HPUX11i to Oracle Linux and Oracle 10g Database upgrade.
• Engineering for putting to in iModule like iProcurement, iSupplier and iStore, Sales Online and Mobile Field Service in DMZ and help UNIX and Big IP team and SSL Implementation through F5 Big-IP. Also helped client to setup reverse proxy, multi layered DMZ, URL firewall rules, URL rewrite rules using Apache 2.0.54 as reverse proxy with SSL.
• Engineering for Form Load balancing using forms servlet and Jserv load balancing.
• Worked on day to day production and development.
• Cloning Ebiz Instance from production to developments and support instance using BCV snapshot, Rapid clone and RMAN duplication.
• Architect DMZ implementation for All modules to access to through Internet including SWWA, forms etc.
• Architecture SSL implementation using F5 BigIP v 9.1 work as SSL Accelerator and fixes complex issue after implementing SSL specially in Order Management- Booking and Configurator.
• Help client to go-live with iProcurement specially issue related to punch-out, XML PO, SSL related and iProcurement Bulk Loader.
• Development cum production support for an environment of one of the most complicated environment of Oracle Application, where more than 90 modules are implemented and database size 1.4TB
• Engineering for Shared_APPL_TOP: cloning environment from prod, implement http load balancing, patch analysis for Shared_APPL_TOP patches. Worked with NAS team to perform proof of concept.
• Implemented Oracle Application 11i and BigIP monitoring using Oracle Enterprise Manager 10g and OEM-OAM integration.
• TAR support and Patch Impact Analysis for before applying to any environment.
• Recommend to improve the cloning process.
• Engineering and impact analysis for Developer6i upgrade to Patchset 18.
• Support development issue by generating FRD and trace.
• Performance improvement recommendation using rebuild tables and purging workflow tables.
• Supports performance and testing team and fixing issue during testing.
• Worked on Kintana for code and object migration, fixing the cloning and patching issue.
• Solving complex issue after cloning and patching while some business functionality broken.
• Engineering for putting to in iModule like iProcurement, iSupplier and iStore) Sales Online and Mobile Field Service in DMZ and help UNIX and Big IP team and SSL Implementation through F5 Big-IP.
• Engineering for Form Load balancing using forms servlet.
• Same time working on production support as well as Help Desk Ticket using Kintana.
• Supporting Performance and Regression Testing.
• Doing project planning for upgrade to Oracle Application 11.5.10.2, Database 10g Release 2, and OATM and Discoverer 10g Load balancing through F5 BigIP.
• Doing Engineering for Mobile Field Service/Olite webtogo for SSL and Load balancing.
• On demand basis, fixing the issue in prod and supporting high priority TARs.
• Implement Workflow Purging process which is never done since implementation. Purge 400 GB from APPLSYS (FND, WF), BEN, OKS, and OKC schemas.
• Help in establishing connectivity to Oracle based Data warehouse to Mainframe, Oracle EBusiness Suites, BAAN and SQL servers etc.
• Reengineering existing DMZ for 11.5.8 to make this capable of Handling all iModule of 11.5.10.2 specially issue with launching configurator from Sales Online module which is caused by loop back connection which Apache make to BigIP loadbalancer and introduction of Apache 2.0 as reverse proxy.
• Oracle Discover upgrade
• Tuning /Performance issue of post 11.5.10.2 upgrade especially in area of Service Contract and Call Center module.
• Help client during Performance/Load Testing during 11.5.10.2 upgrade and monthly patching.
• 27x4 production and on call support for DBA supporting from India.
10. Sr. Oracle Application Database Administrator (Dec 2005 - Feb 2006)
Client Sino Swearingen Aircraft Corporation, San Antonio, TX
Involvement Oracle Database Upgrade from 8171 to 9207 and Oracle EBusiness Suites from 11.5.5 to 11.5.10.2
Skill Used
Oracle 8i/9i, EBusiness Suite 11.5.5/11.5.10.2 (Financial/ Manufacturing), TOAD, OEM 10g Grid Control R2, SQL, PL/SQL, Oracle Workflow, Oracle Discoverer 4i, Oracle Discoverer 10g
O S Sun Solaris 5.8/5.10, Red Hat Linux 3.0/4.0,
Details
• Upgraded Database Oracle 8.1.7.1 to 9.2.0.7 including interMedia, context, spatial and OLAP.
• Upgraded Techs tack to IAS 1022 and Developer 6i Patchset 16.
• Applied All -pre-req patch like AD.I.2, TUMPS and Techstack Validation,
• Cloning Oracle Application using self written scripting, and Rapid Clone.
• Implemented Autoconfig and Rapid Clone to new upgraded instance.
• Implement and build Database using duplicate RMAN method and cloning databases on fly.
• Applied Maintenance Patch and module specific patches to fix the forms and report issues and other functional issues. Splitting nodes from single to multi-node.
• Adding additional node for Web/forms and configuring Apache with Cisco Big IP load balancer
• Reconfigure and fixed issue with Workflow and Concurrent Manager.
• Split Single node to three node and application.
• Implemented Apache Load Balancing using Cisco Big IP (LBR)
• Work flow configuration and integration with MS Exchange Server for Workflow mailer.
• Performance tuning by rebuilding indexes and fnd_stats.
• Solve the forms and report issue using trace and TKprof.
• Implemented OEM 10g Grid control for Database and Apps-tier monitoring and OEM-OAM Integration.
• Automat backup through RMAN, Configuring and Testing Duplicate database though to avoid the Cloning with down of production for future.
• Implemented Cronjobs monitoring for database, concurrent manager jobs, apache, and forms.
• Helping developer to fix custom code and configuring Web-ADI and ADI 7.2.
• Did UNIX administration as when required.
• Workflow integration to Exchange Server for mailer notification.
• Cloning development, test and patch environment using EMC BCB and rapid-clone.
11. Sr. Oracle Application Database Administrator (March 2005 to December 2005)
Client Pension Benefit Guaranty Corporation, Washington DC
Involvement Oracle Database and EBusiness Suites Administration and Capacity Planning
Skill Used
Oracle 8i/9i/10g, EBusiness Suite 11.5.9/11.5.10 (Financial /CRM), Oracle 10g OEM Grid Control Release 1, TOAD, SQL, PL/SQL, PVCS, Load Runner/Win Loader, Shell Scripting.
O S Sun Solaris, Red Hat Linux 3.0/4.0,
Details
• Work on security implementation for Oracle 9i Database and 11i EBusiness Suite for financial application.
• Upgraded Oracle EBusiness Suite from 11.5.9 to 11.5.10.1 and used staging to reduce the downtime for production.
• Upgraded Database from 9.2.0.5 (32-bit) to 9.2.0.6 (64-bit) with Oracle EBusiness Suite.
• Engineering to Upgrade to Tech Stack for Oracle EBusiness Suite to apply Oracle Quarterly Critical Updates.
• Did Engineering to build Standby Database and Middle-tier for Oracle EBusiness Suite.
• Engineering to apply patches to Oracle EBusiness suite with Standby Database and EBusiness Suite.
• Fresh Oracle EBusiness Suite 11.5.10 Installation with 2 nodes and also build vision application for training.
• Working on 10g OEM grid control implementation for monitoring 9i Database, Oracle EBusiness Suite (DB and Application tier) and 10g AS.
• Work as a Team member for Middle-tier migration from Sun 5.8 with single node to RHE 3.0 (4 -node Apps tier) with Apache Loading Balancing with Cisco LBR.
• EBusiness Suite Cloning using Rapid Clone.
• Upgraded Apps -tier (Developer 6i and iAS-Client Binaries) and applied oracle critical patches for Oracle EBusiness Suites (11.5.9/11.5.10.1)
• Engineering for EBusiness Suites Patching under high availability (Standby Database and Standby EBusiness Suites Apps-tier) and work of Workflow and Oracle Email Server.
• Support for OID/SSO and AD integration and BPEL Database and Schema and work with BPEL Process Manager and Portal and EBusiness Suites Integration.
• Support Development team to implement Web ADI and Client based ADI 7.2
• Capacity planning for Oracle Databases and 10g Application Servers and EBusiness Suites for Common Development Environment for Consolidated Application Testing Environment for Developers.
• Building new instance and refreshing Oracle Application cloning using Rapid-clone.
• Work flow configuration and integration with MS Exchange Server for Work flow mailer.
• Data Modeling using Erwin for custom applications
• Custom code testing and migration from development to test environment
• Documenting cloning documentation using Rapid-clone for different scenario and giving training to the core DBA for apps cloning
• Reviewing Technical documentation.
• Using PVCS for code migration and code promotion from development to test environment
• Helping tester in testing new build instance using Mercury Test Director.
12. Oracle 10G RAC DBA (March 2005)
Client Denso Manufacturing, Maryville, TN
Involvement Oracle 10g Real Application Clustering Installation and Database Migration.
Skills Used Oracle 10g RAC 10.1.0.1.0, RMAN, ASM, OEM 10g Standalone Control
O S Sun Solaris 5.9, Sun v880, EMC SAN
Details
• Oracle 10g RAC Installation with HP DL 360 server EMC under Sun Solaris 5.9.
• Configuring and testing 10g RAC for High Availability (HA) and transparent fail-over (TFO)
• Configure database to use ASM (Automatic Storage Management), Automatic SGA Management, Oracle Managed File system.
• Resolve issue with I/O issue with written to SAN by updating the latest firmware and Storage controller.
• Applied latest 10g Patchset 10.1.0.3.0 and resolving the post patch installation with OEM which was Internal Error after longing to DB Console by recreating OEM repository.
• Install new Recovery catalog with Oracle 10g and Configure RMAN backup through 10g Oracle Enterprise Manager, setup the retention policy and backup schedule for the database.
• Migrate the database schema from the production to RAC using export-import utility.
• Configure automatic patch management with 10g OEM.
• Configure automatic alert and notification with OEM.
• Train the client DBA to handle 10g RAC and give brief training to the DBA to handle 10g Database and RAC through 10g OEM.
• Did Table and Index partitioning for some of the table having gigabytes of the data.
13. Oracle APPS DBA/DBA (Dec 2004 to February 2005)
Client Danka Office Automation, St. Petersburg, FL
Involvement
Oracle 9i RAC Installation, Upgrades of Apps Tier Components, Configuration of Parallel Concurrent Manager and Load Balancing Apache.
Skills Used Oracle 9i RAC, Oracle eBusiness Suites 11.5.9 (Financial, Order Management, iPayment), TOAD, OEM 9i, PCFS,
O S IBM AIX 5.2, Windows
Details
• Involved in Oracle 9i RAC installations on RS/6000 with FAST T900 Storage server with GPFS, testing load balancing, Database migration to RAC from single instance production instance with Oracle 11i.
• Configured Parallel Concurrent Processing among the RAC instances.
• Involved in 9i AS upgrade from Apache 1.3.12 with Oracle 11.5.9.
• Applied application patches, Opatches to Oracle database and 11i Application to make sync the RAC instance with production instance.
• Involved in disk reorg activity for production as well as test and development instance based on v$filestat view.
• Solving issue related to concurrent manager and space issue with file system and databases.
• Play key role the distributing the data files across the different mount point to distribute the I/O loads.
• Written scripts for monitoring data file issues and long running concurrent jobs.
• Work and support TAR arising issues with Oracle 9i AS upgrade and 9i RAC performance issues.
• Solved issue related to gsdctl and srvconfig hanging issue by applying Opatches.
• Configured RMAN to automate the backup of the RAC.
14. Oracle APPS DBA/ DBA (October 2004 to December 2004)
Client Data Intensity Inc., Waltham, MA
Involvement Oracle Database, eBusiness Suites Remote Development/ Production Support of more than 60 customers
Skills Used
Oracle 10G/9i/8i/8/7.3, EBusiness Suites (11.5.3-11.5.9/11.0.3) - Ebiz and APS, Oracle Discoverer), TOAD, Kintana, OEM 9i, Mercury Scope view, Shell Scripting,
O S RHE Linux 3.0, Sun 5.8, HP-UX, AIX, Windows
Details
• Providing remote DBA support to more than 50 customers and around 400 databases on Oracle, SQL Server, Oracle Application 11i and People soft.
• Installing, Upgrading, Patching and Managing Oracle Applications 11 and 11i Application using custom scripts and adpatch.
• Working on TAR, coordinating with Oracle and customer to solve the issues.
• Taking care of backup using RMAN, hot and cold backup under UNIX and NT/2000.
• Solving issues related to extent on table, indexes and Tablespace level.
• Cloning database and oracle application using self created scripts and Adclone and rapid clone.
• Solving issues with concurrent manager, Apache, Form servers by Appling security and maintenance patches for database as well as application.
• Doing research on patch for pre-requisite and special instructions.
• Solving problem related to people soft, web logic from time to time.
• Solving issues related space availability the different mount points.
• Responsible adding data file and resize Tablespace and problem related extents, free list, pc used and pct free.
• Writing scripts for backup (hot, RMAN), cronjob.
• Involved the database upgrade from oracle 11.0.3 to oracle 11.5.9.
• Tuning database based on Stats pack report and SQL tuning for long running jobs using TKprof.
• Involved in recovery of database and application from the backup taking through RMAN, cold and hot backup scripts.
• Installation, administration and work flow. Solving issued related to APPLSYSD Tablespace as the Tablespace growth in coordination of Oracle.
• Monitoring database through Mercury Interactive tools like Topaz and Scope view and at same time oracle application services like apache, forms, concurrent manager and database through custom shell scripts.
• Refreshing database from production to development and test environment.
• Involved in the installation of Oracle 11i on RAC for one of customer and migrating database from single instance to RAC instance.
• Involved in research and applying maintenance, family patches using self created shell scripts
• Monitoring database growth, capacity planning etc.
15. Oracle Application DBA (April 2004 to October 2004)
Client McGraw Hill Education, Columbus, OH
Involvement Oracle eBusiness Suite Implementation, Performance Tuning, Performance Monitoring,
Skills Used Oracle 9i, EBusiness Suites 11.5.9 (Order Management, Financial, Supply Chain, HRMS), APS
O S Sun 5.9, Windows
Details
• Worked as part of a Team of Oracle Application performance DBAs, supporting Development, TEST and Production environment.
• Performed Applications System Administration tasks like registering new custom application, forms, reports etc.
• Used Kintana for code migration, Ring Master for Patching, PVCS for version controlling and Mercury Test Director for Defect Management.
• Involved in Tuning Oracle Application performance issues, custom code, SQL tuning for long running concurrent jobs.
• Involved in Work Flow configuration, performance purging issues.
• Written scripts for pining and unpinning objects, recommended developers for rewritten the SQL having performance issues and used HINTS and explain plan to reduce to the cost for SQL.
• Configured Stats pack, monitoring database contention, generating Stats pack report for the duration of contention and analyzing Stats pack report and recommending and testing or the recommended change under test environment.
• Support APS instance for issue with database link between and source and planning instances. Fixed issue with ATP and Planning engine issue on 9.2.0.6 Database.
• Work of Performance related TAR, provide information asked by oracle and testing the oracle recommendation in our environment and recommending for Production.
• Coordinating with users, other DBAs and development staff and oracle support (metalink) for fixing the technical as well as functional issue related to custom application and standard application fixes and patches.
• Participate in Oracle Application Custom Design, development and migration of reports, interfaces (forms), conversion, and extension (RICE) using oracle developer 6i/9i and version controlling using PVCS version control.
• Defining new concurrent manager, Tuning Concurrent Managers, Defining Work Shifts, etc.
16. Oracle Database Administrator (September 1999 to September 2003)
Client Almajdouie Group, Dammam, Kingdom of Saudi Arabia
Involvement Oracle 9i/8i/8, Oracle Financial, HRMS, Order Management, OEM 9i,
Skills Used
Oracle 9i/8i/8 Database, Oracle Failsafe, Oracle Financial, HRMS, Order Management, TOAD, OEM 8i, Developer 2000/6i, SQL, PL/SQL, Java,
O S Sun 5.7, Windows 2000/NT, Novell 4.2,
Details
• Installation, Upgrade, patching and managing Oracle Applications and 11.0.3 /11.5.3
• Tuning Concurrent Managers, Defining Work Shifts, etc.
• Installation, Upgrade and Configuration of Oracle (8.0.6/8.1.7.4)
• Upgrade Oracle Application from 11.0.3 to 11.5.3
• Extensive Performance Tuning, Memory (SGA) Tuning, Tuning Concurrent Managers, etc
• Applying patches both Server side and Client side.
• Used Designer 2000 and Power Designer for database design
• Cloning databases and application using Adclone.
• Setting up new environments (Development, Testing, Conference Room Pilot, Production etc)
• Upgrading to Oracle Server 7.3.4 and then to 8.0.6.
• Removing row chaining for better performance.
• Data Modeling, Database Design and Creation
• Deciding the naming conventions of datafiles, redo log files, tablespaces, and segments.
• Writing scripts for backup and recovery, Import and export procedure.
• Unix Shell scripting in csh, ksh for automating startup/shutdown of databases.
• Setting up advanced replication.
• Installed and configured Oracle Web Server 3.0
• Taking Hot and Cold Backups, Exports etc.
• Setting and Installing Oracle Enterprise Manager and Enterprise Backup Utility.
• Creating the database, tables, tablespaces, data objects, setting privileges, indexes, user logins, passwords (security)
• Database Sizing, Tablespace Management and Rollback Tablespace Management, Transaction Management, Security Administration.
• Installation, Administration, Performance Tuning, Backup and recovery planning of Oracle 8.1.5 Database on Cluster Server (WinNT, MSCS, IBM Netfinity 5600 & Oracle Fail Safe) . Degrade the Database back to Single high configuration because of the performance problem.
• Monitoring Database status through Enterprise Manager and self-created, vendor supplies scripts and TOAD (A tool created by Quest Software Inc.)
• Monitoring the status of the system hardware and status of the Tables paces for block corruption and space.
• Provided administrative supports for eMIS/2000 a mid-range ERP developed by ESI technology, USA with Oracle running on Windows NT/2000. The application is integrated database having 11 modules (Finance (AR, AP, GL, FA, BFM, CSH), Distribution (ISM, POM, SOM), Transportation (TRP, CJC), Automobile (AUT, ISM), Manufacturing (BOM, SFC, MRP, MPS, ROU), Point of sales and payroll and personnel) . We have 4 Database located at DAMMAM head office, DAMMAM Transport, Riyadh and Jeddah. The Databases controlled through a single console of the Enterprise manager at Dammam. We keep the database in 4 locations because of the Network infrastructure problem. Now we have a plan to use replication of the all the Database to HO when the Network infrastructure is ready. Also, the most important database having 10 business at Dammam is configuration a Standby Database through Data Guard to another location around 15 km from the Head office to avoid data loss and downtime.
• Configuring Enterprise Manager to taking backup of the Database through RMAN during night. Also, I am taking daily dump of the database through schedule and testing one a weekly after restoring on the other server.
• Identified, resolved, or provided recommendations to other different kinds of the performance problems ranging from Database performance problems to I/O hardware performance problems.
• The tools used mainly are UTLBstat/ UTLestat, TKPROF, Explain Plan, and some my own scripts. The tool called TOAD from Quest Software for SQL statement tuning was also used.
17. Oracle DBA/ Developer (July 1996- Aug 1999)
Client ITI Ltd., Mankapur, INDIA
Involvement
Oracle Database Administration, Form and Report generation, Written, SQL, PL/SQL Programming, Written Shell Script for Database management
Development Tools Oracle 7.3/8, Form 4.5/Report 2.5, SQL, PL/SQL, SQL loader, export-import
O S Main frame, Windows NT, SCO UNIX
Details
• Work as team member of DBA and Developer. Migrating data from mainframe, to Oracle through SQL Loader.
• Maintain and support Material Management Database.
• Taking daily backup and planning recovery strategy through export-import utilities.
• Developed schema for Material Management in Oracle Designer/2000 and developed forms and reports using D2k.
• Planned for the network and communicate with networking vendor.
• Solving network problem.
• Configuration data-access through ODBC and Net Easy configuration and supporting client-server database of around 100 users.
• Customization of Oracle Reports using Report 2.5.
• Installed Database on SCO Unix and create the database under Oracle 7.3
• Create application on MS Access 2 to manage IT inventory Items.
• Windows 9.x and NT installation and configuration client to access database through SQL Net Easy configuration.
• Installation of Sever having RAID controllers and configuring RAID controller and installation of OS and Database.
Conference/ Training: • Oracle 9i Database Administration from Oracle Corporation,
• Oracle RAC from I2I Innovation Pvt. Ltd.
• Oracle eBusiness Suites Administration from I2I Innovation Pvt. Ltd.
B. S. Engineering (Electronics)