SUMMARY:

• 3 + years of professional experience in Information Technology as Oracle Applications DBA and Database Administrator ( 2years)
• Corporate compliancy - Oracle8, 8i, 9i, 10g... Oracle Certified Professional DBA. Trained by Oracle University for R12 E-Business Suites.
• Experience of Implementations, Upgrades and Production Supports of Oracle E-Business Suites (R12, 11i and 10.7) in Single node, Multi Node with RAC on various Platforms such as Red Hat Linux and Sun Solaris, windows with vast verity of clients all over the Middle East.
• Integration of Discoverer4i/10g, Logical Apps (Active Governance), BPEL processes, SOA Suite, OBIEE, Oracle 10g AS, Single Sign-On with E-Business Suite R12 and 11i.
• Sound business skills - includes consulting, planning, plan execution, delivery management, process/SLA compliance, written and oral communication, resolution partnering, best practices, documentation, customer relationship, time management, flexibility, team skills and result orientations.
• Soup-to-nut Oracle Server (7x, 8ix, 9ix, 10g, 11g) with RAC, ASM, OCFS2, Data Guard, Disaster Recovery, RMAN, Oracle Enterprise manager and Grid control.
• Proficient in wide verities of tools and technology - including Unix/Linux,Windows system administration, Perl shell scripting, SQL, PL/SQL, Rapid Install, AutoConfig, AD utilities, Oracle Diagnostic tools, Oracle Application Manager, Oracle Change Management, TOAD, and RMAN.
• Zeal to learn and adopt innovative and evolving technology and support methods.

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Upgrade E-Business Database from 9i to 11g.
• Upgrade E-Business Suite from 11i to R12 (Rollup-4)
• Upgrade SOA suite from 10.1.2.1 to 10.1.2.4, 10.1.2.4 to 11g SOA
• Integrate Discoverer10g with E-Business suite using 10g AS.
• Day to day Production support for EBS 11.5.10/R12 with Discoverer10g/OBIEE, Logical Apps 7.2.1, SOA Suite in 24/11 operation.
• EBS R12 Implementation using accelerators program of Oracle
• DMZ server setup in HA environment with 11i/R12
• Implement and support of Logical Apps 7.2.1
• Vertex upgrade from 3.1 to 3.2 and 3.2 to 3.3
• Integrate Office2007 with Desktop ADI, also implement WEB ADI.
• Co-ordinate with off-shore for 24/7 operation support from.
• Performed application sizing and capacity planning for SOA, OBIEE, ODI, OID/SSO - Portal and Oracle Applications R12
• Involved in Oracle e-Business R12 Installation, maintenance troubleshooting and support
• Configured PCP parallel concurrent processing and Shared Application Tier and Load balancer for Oracle E-Business R12
• Involved in all Single Node/Multi Node cloning of Oracle E-business Suite.
• Involved in integration of Oracle SSO/OID with Oracle E-Business Suite R12 along with Oracle Portal application.
• Implemented SSL offloading and SSL for Oracle e-Business R12
• Setup and Configured Oracle Identity Management Infrastructure (OID/SSO) 10.1.4.0.3 and Oracle Portal in High availability mode.
• Implemented SSL offloading and SSL for OID/SSO and Portal.
• Installed and configured OBIEE in High availability mode including analytics, xmlpserver and scheduler.
• Implemented SSL offloading and SSL for OBIEE.
• Involved in SOA installation and SSL configuration.
• Coordinating with Oracle Support on TAR & other key issues.
• Installation of 11.5.10 EBS in RAC with IBM AIX with ASM with Financial, iprocurement.
• Installation of R12 with RedHat Linux with RAC in NetApps Shared Storage.
• Day to day Production support for EBS 11.5.10 in RAC environment
• Setup and Test Disaster Recovery, Data Guard, RMAN for Oracle Databases
• Upgrade RAC Database from 9i to 10g for e-business and other Oracle Databases
• Setup RMAN Backup using Flash recovery area for all 10g Databases
• Refreshes/Cloning Diff e-Business Suites Instances as per schedules
• Setup up Oracle Enterprise Manager 10g as Monitoring tools for all Databases
• Managing and train junior oracle DBA staff in ODE.
• Upgrade 11.5.9 to 11.5.10 in their Multi-Node RAC, ASM
• Installation. 11.5.10 patching and cloning for DEV/Test environment
• Support Consultants and User for patching and Oracle RAC Databases issues.
• Performance Tuning for EBS after upgrade to EBS 11.5.10
• Apply CPU patches to there number of Oracle homes
• Refreshes Diff Apps Instances as per schedules

Confidential

Oracle DBA

Responsibilities:

• Primary Oracle Apps DBA support to Production/UAT/CRP Oracle Applications eBiz environments.
• Coordinate with Oracle On Demand for technical requirements and support requests among team members -
• Monitor and Support Production Instance and issue logs.
• Performance Tuning after DataLoad of New Company in EBS.
• Complete end-to-end Oracle Apps DBA support eBiz suite 11.5.x Production/Stage/Test
• Support OCS and On Demand Team for Light Speed Project Support.
• Provide and maintain refreshed Production-environments UAT/CRP Instances.
• Monitoring and Support for Existing and New TAR (SR)
• Upgrade 11.5.7 Instance to 11.5.10 on Windows 2003 (APS Instance)
• Build and troubleshoot eBiz suite environments to mimic customer scenarios to help identify and isolate the issues.
• Primary 24X7 Oracle Apps DBA support to QA/Dev/Release Oracle Applications eBiz environments.
• Implement 11.5.9 on AIX server for Financials and HRMS
• Communicate and Coordinate needs of development teams, QA teams and Release teams and translate into technical requirements.
• Complete end-to-end Oracle Apps DBA support to all Panasonic Asia region Applications eBiz suite 11.5.x development, QA, upgrade and release teams for HRMS, Financial, Distribution products.
• Provide and maintain fresh-environments (complete eBiz suite installation) for development of new versions to various development and training teams on AIX,Linux Windows 2003 Servers
• Provide and maintain developed-environments (complete eBiz suite installation plus new versions as it develops) to QA teams for certification of new code and enhancements.
• Upgrade test new code from previous versions and technology to latest versions.
• Build and troubleshoot eBiz suite environments to mimic customer scenarios to help identify and isolate the issues.
• Participate in bigger picture Oracle Applications eBiz Suite Architecture reviews.
• Coordinating support requests among team members - manage and delegate the workload.
• Delegating advance technical requests and solutions and mentoring & motivating team to take up such tasks - such as crusial upgrades, installations, techstack upgrades, troubleshooting, new technology uptakes etc.
• Gained the end-to-end technical knowledge of Oracle Applications eBiz Suite 11i for major modules for new releases - 11.5.9/11.5.10 and Oracle iAS and DB 10gAs and 10g.
• Install, upgrade and maintain Oracle Databases and eBiz Suite instances (11.0.x. 11ix - including 11.5.10) - currently managing 12-1.3 complete eBiz Suite environments on Solaris, HP and Linux platforms.
• Install, upgrade and maintain 9iAS(9.0.1x and 9.0.2x) and 10gAS (9.0.4x) Oracle Application Server suites.
• Primary 24 X 7 on call support to Intenal Dev/QA/Release Oracle Applications eBiz environments.
• Backup, cloning, recovery and performance tuning of production Oracle Applications environments.
• Tech stack upgrades - RDBMS(8i to 9i -> 10g, RAC, JDK, Jinit, Forms patchset, Reports patchset, OA Framework, Workflow, FND, AD and JTF.
• Review and test Oracle Applications eBiz Suite Architecture for suitability, compatibility, scalability and other factors for the new versions of eBiz Suite being developed.
• Concurrent Managers - configuration, setup, optimisation, performance tuning, monitoring and troubleshooting.
• Oracle Work Flow - configuration, setup and troubleshooting.
• Maintain Autoconfig to ease cloning pre and post 11.5.8 environments.
• Rapid Cloning - 11.5.8 to 11.5.10 + upwards env
• Manual cloning - identify all configuration files used by a particular release and using them manually clone the environment for particular scenarios. Manual configuration - one apache for one development team provided for coexisting and concurrent development, multiple apaches per environments.
• Administer, install, patch and troubleshoot eBiz Suite databases and Tech stack - install test and QA install of One-offs, Family Packs, Maintenance packs, tech stacks patches.
• Work with development and QA teams to debug code and tech stack issues.
• Interact with eBiz Suite Central Operations teams to get Software and Hardware support.
• Develop, maintain and document administration tools and strategies.
• Installation and administration of Oracle (8i/805/7.x) database and Tools on UNIX (Solaris/HP/AIX/SCO) and Windows NT Server.
• Maintaining all products script in ERD form using Erwin Tool.
• Re-engineering of existing product for enhancement from Database point of view.
• Write Pseudo code, database trigger, stored procedure and packages to implement business logic and command procedure for product.
• Maintain database for Devolvement and Quality Department with the Versions and Releases integrity.
• Diagnosing and troubleshooting of Database related problems.
• Reveal the new features of oracle to development and management team.
• Replicate Customer DB environment and solve performance related Problems.
• Assign task, provide training and explain the business requirements to collogue.
• Implement backup strategy for different project as per requirements.
• Write Shell Script to create DB object for Products, Automate backup and testing scripts.
• Implement small projects for in-house requirement like personal and Bug management system.
• Generate Data for Unit test, Load testing Using script, Dynamic SQL and TestByte Tool
• Prepare auditing policy & Implement Security domain for Database Users.
• Perform Backup checking using recovery options on separate Setup of Databases.
• Plan & generate requirement for RDBMS Servers, space requirements, and Backup storage.
• Study and Recommend Database related Software for better project execution.