SUMMARY:

• I have 14+ years of experience in activities relating to Oracle Apps DBA & Oracle DBA. Involved in the areas of installation and support of oracle applications 11x/R12x on single and multi - node systems and databases 9i/10g/11g/12c.
• Databases and applications cloning/refresh, patches, upgrade of database/applications.
• Experience in administrating and managing oracle 11.5.10.2, R12.x applications, SOA 11g & WebLogic 11g/12c.
• I have strong troubleshooting/logical abilities to identify organizational needs meet corporate goals and undertake full responsibility for delivering solutions which meets customer’s expectations /requirements.
• Having considerable working experience of oracle database administration using oracle rdbms and tools, thorough understanding of system administration including concurrent managers, applications security and printing.
• Good Experience on Oracle Application 12.2 & WebLogic Administration
• Good Upgrade experience on R12.1.3 to 12.2.3, 12.2.3 to 12.2.4 and 12.2.4 to 12.2.5
• Good Experience on ADOP R12.2 online Patching
• Strong Trouble Shooting skill for R12.2 issue like fs clone, prepare online patching and application issues
• EBS Extension for Oracle Endeca 12.2 V5 Installation, integration with EBS 12.2.4 and support
• Good Experience on R12.2 Clonings, Multinode to single node, Single node to Multi node
• Installation of R12.2, 12.1.3, 12.0.4 &11i Applications, Oracle Databases 9i,10g,11g.&12c
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, AWR, ADDM, SQL TRACE and SQLT
• Cloning RAC to RAC and RAC to NON RAC using RMAN.
• Experience in Managing the Oracle Databases using ASM Administration
• Experience in different OS platforms like SUN SOLARIS 10, OEL 6.4 and IBM AIX 5, HP-UX
• DMZ Setup, Configuration and support for 11.5.10.2 and R12.1.3 environments for iSupplier and iExpenses modules.
• Expertise in configuring and managing the Concurrent Managers, Workflow Notification Mailers and monitoring their operations.
• WMS Module MWA/MSCA issues Support.
• Expérience in VCP (ASCP/Demantra) environnement administration and support in R12.2
• Experience in supporting ASCP and OLTP enviorments in R11.5.10.2
• ODI Linux Code Solutions Deployments Support and ODI/OBIEE 11g installation & Configuration Support.
• Oracle Discoverer integration with EBS 11i/R12 and support.
• Oracle Database upgrade 10g to 11g & Oracle Applications 11.
• Patching CPU/PSU/One-Off for databases and Oracle Applications
• Code moves like creating packages/package bodies/table creation etc.
• Handling Ticketing system and resolutions for End-user issues
• Checking the status of important services like concurrent manager, form server, web server, application listener, database listener is up
• Experience in Administration of 10g/11g DataGuard databases using Dataguard broker.
• Experience with AD utilities and SYSADMIN activities of Oracle Applications environments.
• Good working knowledge in Shell Scripting.
• Involved in performance tuning of Oracle EBS Applications & Database systems.
• Good experience in Backup / Recovery using User Managed / RMAN, export / import (Data Pump) and SQL Loader, etc.
• Expertise in resolving the view log/out files issue of concurrent requests, MOS support, Apache and Forms issues
• Monitor growth of Database with scripts and resizing the tables, Responsible for High Availability.
• Good working experience in Installation & Configuration Golden gate for replication and troubleshooting issues of Golden gate 11g/12c
• Monitoring Tablespace usage, Temp tablespace usage and undo tablespace usage.
• Knowledge in MongoDB and PostgreSQL database administration.
• Worked on scripts for creating new schemas, assigning roles and privileges.
• Implemented the shared appltop, application systems, Parallel Concurrent Processing (PCP) and configured load balance to mid-tiers
• Experience in the 11g Grid, OEM 12c,13c for the database tasks like adding the data file, resizing the data file, code compilation, User/Role creation and maintenance etc.
• Good working knowledge in Schema Management and indexes optimization.
• Extensive experience in supporting and managing multiple Production, Staging, Development and test instances and Oracle Applications environments of varied complexity
• Experienced with HP-PPM Tool for User/Environment & workflow configuration
• Daily health check like monitoring tablespace, mount points etc.
• Installation & Configuring domains for Fusion Middleware like WebLogic, SOA, BPM, BAM, ODI, OHS
• Installation and Support of Oracle SSO, OAM, OID, OIM.
• Good working experience in Installation, Configuration, Performance Tuning and Trouble Shooting of SOA Environment (Service Engines, Adapters, BAM…).
• Domain creation Knowledge
• Involved in the configuration of WebLogic 11g domain with domain templates, configured clusters, servers, connection pool, JMS queues using console.
• Supporting NDM Process as per business requirement.
• Configured Machine, Node Manager to control server lifecycles remotely
• Deployed Applications (WAR, SAR, RAR, JAR&EAR) in Domain and Clustered environment.
• JDBC Connection Pool configuration with Oracle.
• JMS Configurations - JMS Server, Connection Factory, Topic/Queue.
• Monitor and manage SOA Components by using the Oracle Enterprise Manager Fusion Middleware Control Console to perform administrative tasks.
• Managing and Monitoring the JVM Performance by adjusting WebLogic heap size and garbage collection parameters
• Good experience in configuring and managing security realm for users and groups.
• Responsible for 24x7 on server and environment availability and monitoring.
• Quickly adapting new technologies.

TECHNICAL SKILLS:

Operating Systems: LinuxOEL 6x, SUN Solaris5x,10x,HP-UX11ix, AIX5x/7x Windows NT & 2000, Windows 95/98

Languages: SQL, PL/SQL

Databases: Oracle 8i/9i/10g/11g/12c

ERP: Oracle Applications 11i/R12x

Tools: & Utilities: OEM 10g/11g/12c/13c, Export/Import, Recovery Manager (RMAN), Toad, HP-PPM/Kintana, PVCS,SVN,STAT QC, Service-Now. SQL Developer, BMC Remedy, JIRA

PROFESSIONAL EXPERIENCE:

Confidential, Grafton, WI

Sr. Oracle Applications DBA

Responsibilities:

• Completed detailed analysis for existing 164 databases upgrade from 9i/10g/11g/12c to 12.2.x as part of the discovery Phase and presented to CIO.
• Completed detailed analysis for 114 existing Third Party applications which are integrated with EBS 12.1.3 Production database.
• Worked with Oracle for database version 12.2.0.1 matrix, for different products OBIA, Hyperion, VCP, EBS, Oracle Configurator, Oracle Comp Work Bench, etc.
• Identified the databases and list out them as part of the discovery phase which are eligible for retirement/Move the existing schemas to other databases/ not eligible for upgrade as per the project team recommendations
• Prepared the detailed worksheet as part of the discovery which consists of application/database/server/3rd party applications details for all existing Regal applications.
• Weekly Status reports submission and gave presentation to Oracle Practice Directors in Regal level. Based on review and feedback modified them accordingly.
• Plan and prepared the technical document for Oracle database upgrades from 9i/10g/11g/12c to 12.2.x.
• Co-ordination with multiple functional teams and project teams across all Confidential locations as part of the database upgrade discovery phase.

Environment: R12.1.3 Database 11.2.0.4 IBM AIX 7.2

Confidential, Alpharetta, GA

DBA Lead

Responsibilities:

• Production Support and Maintenance of Corporate Financial Oracle E-Business Suite Applications R12.2.5 and Oracle 11G RAC Database (11.2.0.4).
• Applying the Ebusiness Suite application patches using ADOP Online Patching utility in Test and Production environments.
• Code Migration Support using KINTANA (HP-PPM).
• DIGI Cert and Symantec SSL s installation & renewals has been done using ORAPKI, OPENSSL and OWM tool for Production/Dev/Test environments.
• Plan and scheduled the Concurrent requests Purging and archiving in R12.2.5 EBS application as per requirement.
• Supporting NDM: Connect Direct Process as per business requirement.
• Ensure that all database changes in the production environment are approved by Confidential & Confidential before deployment and all change requests are routing through BMC Remedy CHANGE MANAGMENT tool in Production environment.
• Experience in deregister/reregister EBS with OID for Single Sign On setup
• Carried out requirement study and analysis for supporting 74 production applications based on 7/24 hours availability model.
• Delivering ADBA services with hands on enriched experience for all level DBA activities.
• Work with ODBAs to keep DBMS on current levels per Confidential & Confidential Technology Strategy & Standards (“TSS”) and coordinate upgrades with impacted applications and support organizations. Decision to upgrade DBMS will be taken by Confidential & Confidential ’s development team and scoped by the scoping team.
• Coordination with (T2/T3) Production Support teams and offshore ADBA teams. Meeting client’s SLAs based on 7/24 hours support model. Plan resource and estimates efforts requirement for new onboarding applications.
• Production Disaster Recovery database Monitoring and support.
• Identify requirements based on discussion with multiple teams and plan the project deliverables accordingly with meeting ATT standards.
• Onboard and retire applications based on the requirement and decision made by Confidential & Confidential .
• Supporting and Monitoring the Prod/Dev/Test databases using OEM 12c and 13c Administration
• Experience in Schema Management and indexes in oracle 11g environment.
• EBS Security Policy: ADBA following RDBMS-level policies in place to support R12.2.5 EBS applications. User-management support and register them in SOX tables to support the Auditing process in Confidential & Confidential .
• Good working knowledge in shell scripting.
• Data Router (DMaaP-Component) is installed and configured for R12.2.5 EBS Production application for file transfers.
• Enabling & disabling rules using ORACLE DATABASE VAULT (DBV) for databases
• Experience in Oracle Business Intelligence and supporting ETL and DW environments.
• Managing the offshore ADBA team: Scheduled team meetings between offshore and onsite for open and close issues discussion and plan proactive measures to meet the SLAs.
• Perform database activities required for the health of the application and release processes (i.e., backup, restore, recovery, import, export, copy, move and performance tuning activities).
• Analyze database activity, perform application database performance and tuning activities in the pre-production and production databases.
• Perform activities of data maintenance, table maintenance, database re-organizations, cache tuning, data archival, data importing/exporting between environments and other efforts typically undertaken to improve the efficiency and reliability of applications and the databases.
• Weblogic Upgrade experience from 12.2.1.1 to 12.2.1.2 and 12.2.1.3
• OHS Upgrade experience from 11g to 12c
• Red Hat JBoss EAP-7 Administration experience in deployments, User Adminstration, start and stop of the hosts.
• Coordinate with Oracle On-Demand for infrastructure and environment related issues, product support team for an oracle product issues
• Adding the printers into printer Queues and registering them in oracle applications and troubleshooting.
• User administration using Confidential & Confidential Standards.
• Administering concurrent managers’ status, logs, defining concurrent managers based on requirement and troubleshoot the issues.
• Workflow Managers monitoring, log checks and provide updates to user community.
• Working experience on conflicts between the target and source database in GOLDEN GATE11g
• Supporting MS SQL Server 2008 and 2012 administration.
• Daily health check like monitoring tablespace, mount points etc and accordingly work with ODBA team.
• Starting, stopping managed servers, admin servers as per the monitoring status.
• Involved in application (.rar/war files) deployments using weblogic server for FAST applications.
• Monitoring and Adminstering of different tools ZOOKEEPER, SOLAR JOBS, NAGIOS for FAST applications alerts.
• Monitoring all the Domain resources, servers, clusters, JMS, Connection Pools
• Plan DBA schedules and activities, prioritize the work to ensure work is progressed and aligned with Project delivery dates
• Identify an escalation plan for each critical situation
• Handling tickets raised by users using BMC Remedy tool, iSupport Application.

Environment: R12.2.5 Database 11.2.0.4 RedHat Linux 6.8

Confidential, Waukesha, WI

DBA Lead

Responsibilities:

• Upgrade expérience of Oracle Applications from 12.1.3 to 12.2.3, 12.2.3 to 12.2.4 and 12.2.4 to 12.2.5
• Cloning of 12.2.3, 12.2.4 oracle applications
• Oracle Applications R12.2.4 Clone and Support on EXADATA environment.
• R12.2.x installations and ADOP Online Patching Activities
• Installation of R12.1.3, Oracle Database 11g.
• Installation of R12.2 Multi& Single node
• Installation and support of Oracle Database 12c(12.1.0.2)
• Cloning of 12.2.3, Multinode to single node and single node to multi node.
• Experience in deregister/reregister EBS with OID for Single Sign On setup
• Cloning RAC to RAC and RAC to NON RAC using RMAN.
• GRC-PCG Installation and Configuration.
• PLM to MOMI Intégration with R12.2.4 EBS Application.
• Clearorbit, Sabrix Configuration with R12.2.4 EBS Application.
• HP-PPM Code migration Support.
• EBS Extension for Oracle Endeca 12.2 V5 Installation, intégration with EBS 12.2.4 and support
• WMS Module MWA/MSCA issues Support.
• Experience in Dresser-VCP (ASCP/Demantra) environment administration and support in R12.2
• Experience in supporting Dresser-ASCP and OLTP enviorments in R11.5.10.2
• Monitor and support of the Concurrent Scheduled jobs (Dresser Supply chain data collections, etc) run in ASCP environment under MRP admin user.
• Patch application on ASCP and OLTP instances
• VCP/OBIEE/DEMANTRA Environnements installation and cloning
• Experience in Oracle Business Intelligence and supporting ETL and DW.
• Integrated SOA Gateway implémentation and integrated with R12.2.4 EBS Application
• Installation and configuration of GOLDEN GATE for replication on 11g/12c
• Resolved the issues in conflicts between the target and source database in golden gate
• Patching CPU for databases and Oracle Applications
• Troubleshoot Oracle Applications and Oracle database issues
• Daily health check like monitoring tablespace, mount points etc.
• Involved in SYSADMIN activities
• Involved in Install and configure Oracle SOA Suite 11g components in Oracle Weblogic Server domains.
• Monitor and manage SOA Components by using the Oracle Enterprise Manager Fusion Middleware Control Console to perform administrative tasks.
• Deploying, configuring, monitoring SOA composite applications,
• Managing and monitoring Service engines, and updating the state of SOA composite applications.
• Troubleshoot SOA composite applications by performing corrective actions such as fault recovery.
• Starting, stopping managed servers, admin servers as per the monitoring status.
• Monitoring all the Domain resources, servers, clusters, JMS, Connection Pools
• Plan DBA schedules and activities, prioritize the work to ensure work is progressed and aligned with project delivery dates
• Coordination and communicate with Offshore DBA team
• Identify an escalation plan for each critical situation
• Handling tickets raised by users through Service-now tool.

Environment: R12.2.4 Database 11.2.0.4 OEL 6.4

Confidential, Atlanta, GA

Apps DBA

Responsibilities:

• Support and maintain Oracle Applications R12.1.3 instances.
• R12.2.x installations, Online Patching Activities and support
• Create and Manage Application Users, assigning Responsibilities.
• Troubleshoot the Applications issues and performance problems.
• Managing Oracle Applications using AD Utilities.
• Performed DB upgradation from 11.2.0.2 to 11.2.0.3
• Administration of WebLogic servers
• BPEL&OSB Composites deployments.
• ODI Linux code solutions deployments
• OBIEE Installation and Support.
• DMZ Setup and configuration for R12.1.3 I supplier Module.
• Review proposed changes and test them in a test and QA environment
• Creating Weblogic Server resources such as Connection Pool, datasources and JNDIs
• Creating SOA wallets and Configure the Weblogic Server for SSL communication
• Deploying SOA code between test QA and production environments
• Applied the various patch sets, application patches and rdbms patches.
• Analyzing and applying the security patches
• Plan DBA schedules and activities, prioritize the work to ensure work is progressed and aligned with project delivery dates
• Coordinate with Oracle On Demand for infrastructure and environment related issues, product support team for an oracle product issues
• Database and application health check
• Coordination and communicate with Onsite/Offshore DBA team
• Identify an escalation plan for each critical situation
• Working with release management team to progress RP(release packages)
• Handling tickets raised by users through Service-now tool.
• Supported functional team for setup of iSupplier Registration, Key Processes: PO Acknowledgement,PO RFC's by Supplier, PO Advance Shipment Notics,PO Invoice info and iSupplier key setups: Assign responsibilities to internal users, Applying Securing attributes to custom responsibilities.

Environment: R12.1.3,12.2.3 Database 11.2.0.3 OEL 5.5

Confidential, Milpitas, CA

Apps DBA

Responsibilities:

• Plan DBA schedules and activities, prioritize the work to ensure work is progressed and aligned with project delivery dates
• Coordinate with Oracle On Demand for infrastructure and environment related issues, product support team for an oracle product issues
• Maintaining the health of Oracle applications system daily, weekly, monthly database and application health check
• Coordination and communicate with Onsite DBA team
• Own the plan for each DBA task. The plan will include preparation time, launch, schedules, checklists, contact names, etc
• Identify an escalation plan for each critical situation
• Ensure OOD is defining and implementing work in line with Confidential business requirement and tracking the resolutions provided by OOD
• Working with release management team to progress RFC and CRT’s
• Supporting third-party applications like clear orbit, Tradebeam, Markview and Supplier express.
• Managing Oracle application services like Form Server, Report Server, and Concurrent Manager to ensure availability.
• Applying application patches in Test, dev and production instances.
• Troubleshooting of ongoing Oracle applications issues.
• Adding the printers into printer Queues and registering them in oracle applications and troubleshooting.
• Handling tickets raised by global users through GSC (Global Service Center).

Environment: R11.5.10.2 Database 11.2.0.2 OEL 5x

Confidential, Wauwatosa, WI

Apps DBA

Responsibilities:

• Support and maintain Oracle Applications 11.5.10.2 and R12.1.3 instances.
• L2 and L3 DBA support.
• Cloning of Oracle Applications, database refreshes and backups are automated with Confidential own customized shell scripts; those are scheduled and executed through APPWorx tool.
• Create and Manage Application Users, assigning Responsibilities.
• Troubleshoot the Applications issues and performance problems.
• Managing Oracle Applications using AD Utilities.
• Maintenance included relinking applications objects and regenerating forms and reports using all.
• Applied the various patch sets, application patches and rdbms patches.
• Daily Health check of Production environments and Space Management.
• Database Maintaince for Testing and Developments.
• Administering concurrent manager, defining concurrent managers and work shifts
• Troubleshooting issues raised by the support team through Incident Management GetRDone tool.

Environment: R11.5.10.2 & R12.1.3 Databases: 9.2.0.6, 10.2.0.3 & 11.2.0.2 Solaris5x, Linux5x & Windows

Confidential

Apps DBA

Responsibilities:

• Support and maintain Oracle Applications R12.1.3 instances.
• Upgraded Oracle applications from 11.5.10.2 to R12.1.3
• Cloning Oracle Applications.
• Create and Manage Application Users, assigning Responsibilities.
• Troubleshoot the Applications issues and performance problems.
• Managing Oracle Applications using AD Utilities.
• Maintenance included reliking applications objects and regenerating forms and reports using all.
• Applied the various patch sets, application patches and rdbms patches.
• Analyzing and applying the security patches.
• Daily Health check of Production environments and Space Management.
• Administering concurrent manager, defining concurrent managers and work shifts
• Troubleshooting issues raised by the support team of OM
• Created and Handover the R12 Rapid Cloning Procedure document for OM HRMS Support.

Environment: R12.1.3 Database 10.2.0.3 Solaris 5x

Confidential

Apps DBA

Responsibilities:

• Supporting Tools like Kintana, PVCS, UniTask, Quality Center, and OCM.
• Parallel Concurrent Processing (PCP) Implementation.
• Database Upgrades (9i-10g),10.2.0.4 to 11.1.0.7
• Creation of users and assigning them to the related responsibilities
• Defining form, functions and menus
• Configuring the Concurrent managers.
• RMAN Setup for Backup and Recovery.
• Cloning Applications (single node to multimode vice-versa) and Database.
• JDK Upgradations has done in Oracle Applications 11.5.10.2.
• Installation of Jinitiator on Windows Client Machines
• The infrastructure database/Metadata repository was converted into 10g RAC.
• DMZ Setup and configuration for 11.5.10.2 I supplier Module.
• Integrating Oracle Application Server 10g with Oracle Applications 11i.
• Integrating Discoverer with Oracle Applications 11i.
• Load Balancer configurations.
• Cloning from RAC environments to RAC environments using RMAN.
• Cloning from NON-RAC environments to RAC environments using RMAN.
• Applying patches - Application, Database, and CPU/PSU.
• Supporting and maintaining ASM instances.
• Supporting and maintaining Oracle Cluster Resource Manager.
• Managing database through Oracle Enterprise Manager.
• Implementing catalog backup from RMAN using Oracle Enterprise Manager.
• Troubleshooting issue raised by the support team of Confidential .
• UNITASK setup for printing, UNITASK was integrated with Oracle Applications 11i.
• Handling tickets raised by users through Siebel Ticketing System.
• Worked on Customizing an AutoConfig Environments
• D090 Documentation of all the tasks performed.

Environment: R11.5.10.2 Database 10.2.0.4 OEL 5x