SUMMARY

• I have 11+ 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.
• 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.5.10 to R12
• 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 Data guard broker.
• Experience with AD utilities and SYSADMIN activities of Oracle Applications environments.
• 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.
• 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 for the database tasks like adding the data file, resizing the data file, code compilation, User/Role creation and maintenance etc
• 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.
• SSO implementation, Discoverer with SSO
• Installation & Configuring domains for Fusion Middleware like WebLogic, SOA, BPM, BAM, ODI, OHS
• Installation and Support of Oracle 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.
• 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: Linux-OEL-6x, SUN Solaris5x,10x,HP-UX11ix, AIX5x Windows NT & 2000, Windows 95/98

Languages: SQL, PL/SQL

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

ERP: Oracle Applications 11i/R12

Tools: & Utilities: 10g Enterprise Manager, Export/Import, Recovery Manager (RMAN), Toad, HP-PPM/Kintana, PVCS, QC, Service-Now. SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, Alpharetta, GA

DBA Lead

Environment: R12.2.5 Database 11.2.0.4 RedHat Linux 6.8

Responsibilities:

• Ensure that all database changes in the production environment are approved by Confidential &T before deployment and all change requests are routing through BMC Remedy CHANGE MANAGMENT tool in Production environment.
• 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 &T Technology Strategy & Standards (“TSS”) and coordinate upgrades with impacted applications and support organizations. Decision to upgrade DBMS will be taken by Confidential &T’s development team and scoped by the scoping team.
• Coordination with T2, T3 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.
• 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 &T.
• 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.
• Production Oracle Ebusiness Suite Applications R12.1.3, R12.2.5 and Oracle Database 11.2.0.4 Support and Maintenance.
• Applying the Ebusiness Suite application patches using ADOP Online Patching utility in Test and Production environments.
• HP-PPM Code Migration Support.
• SSL Certificates renewals has been done using ORAPKI and OWM tool for CAPS-Weblogic12c Production/Dev/Test environments.
• 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 &T 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.
• Resolved the issues in conflicts between the target and source database in Golden gate
• 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.

Confidential, Waukesha, WI

DBA Lead

Environment: R12.2.4 Database 11.2.0.4 OEL 6.4

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 enivornment.
• 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 Database12c (12.1.0.2)
• Cloning of 12.2.3, Multinode to single node and single node to multi node.
• Cloning RAC to RAC and RAC to NON RAC using RMAN.
• GRC-PCG Installation and Configuration.
• PLM to MOMI Intégration with R12 EBS Application.
• Clearorbit, Sabrix Configuration with R12 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.
• 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.

Confidential, Atlanta, GA

Apps DBA

Environment: R12.1.3,12.2.3 Database 11.2.0.3 OEL 5.5

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 funatcional team for setup of iSupplier Regiisrtation, 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.

Confidential, Milpitas, CA

Apps DBA

Environment: R11.5.10.2 Database 11.2.0.2 OEL 5x

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 JDSU 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).

Confidential, Wauwatosa, WI

Apps DBA

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

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.

Confidential

Apps DBA

Environment: R12.1.3 Database 10.2.0.3 Solaris 5x

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.

Confidential

Apps DBA

Environment: R11.5.10.2 Database 10.2.0.4 OEL 5x

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.

Confidential, Atlanta

Apps DBA

Environment: R11.5.10.2 Database 9i IBM-AIX 5x

Responsibilities:

• Cloning Oracle Applications.
• Managing Concurrent Managers and Concurrent Programs.
• Create and Manage Application Users, assigning Responsibilities.
• Troubleshoot the Applications issues and performance problems.
• Managing Oracle Application using AD Utilities.
• Maintenance included relining applications objects and regenerating forms and reports using all.
• Troubleshooting invalid and unusable objects and run gather schema statistics periodically.
• Work experience on oracle’s TAR system
• Configured cold backs through the crontab on daily basis.
• Activities like Export/Imports, database monitoring, file system check etc.
• Provided support to user community, development and testing teams
• Onsite - Offshore co-ordination
• Database refresh on regular basis as per the requirement.
• Cloning of Production environment into Test environment.
• Patch Application both application and database patches.
• Analyzing and application of the CPU patches.
• Backup and recovery of database running in Archive Log Mode.
• User creation and privilege maintenance.
• Activities like Export/Imports, Database monitoring, File system check, troubleshooting, etc.

Confidential, NY

Apps DBA

Environment: R11.5.10.2 Database 9i, Linux AS 3.0

Responsibilities:

• Support and maintain Oracle Applications 11.5.10.2 instances.
• Cloning Oracle Applications.
• Managing Concurrent Managers and Concurrent Programs.
• Create and Manage Application Users, assigning Responsibilities.
• Troubleshooting the Applications issues and performance problems.
• Managing Oracle Application using AD Utilities.
• Maintenance included relining applications objects and regenerating forms and reports using all.
• Worked with Oracle-Support for bug fixes and patch applications.
• Onsite - Offshore co-ordination
• Administering concurrent manager, defining concurrent managers and work shifts
• General trouble shooting like removing yellow bar, Jinitiator Problems, Digital Certificate problem. Server Administration, system backups and Space Management
• Automation of daily backup process through shell scripts, checking backup status to ensure backup validity.
• Interaction and coordination with external vendors and resolve all technical issues

Confidential

Apps DBA

Environment: R11.5.9 Database 9i HP-UX 11i Ver2

Responsibilities:

• Patch Applications for resolving performance and bug issues.
• Refresh Development instance periodically from the PROD
• Cloning Oracle applications from PROD to TEST.
• Create and Manage Application Users, assigning Responsibilities and user profiles.
• Maintenance included relinking applications objects and regenerating forms and reports using all.
• Recommend development team on load balancing Concurrent managers
• Manage and Monitor Concurrent Jobs and Application Users.
• Used Statspack to monitor and tune database performance.
• Unix shell scripting for automating startup/shutdown of application and database servers.
• Support the onsite team during their off-hours on TEST instance.
• Troubleshoot the Applications issues and performance problems.
• Assisted programmers and developers with Oracle issues.