SUMMARY

• Having 9.2 years of experience in Confidential as Oracle Apps DBA (11i, R12 & R12.2) / Oracle DBA (9i, 10g, & 11g)/EBS setup and system administration which includes Installation, upgrade, network maintenance, UNIX Servers, Cloning, patching, user support, Trouble shooting, Performance tuning, Space management and Providing 24x7 support of Production, Development & UAT environments on Various Platforms.
• Experienced in Planning, Installation, Physical Database Design, Cloning, Refreshing Databases on Oracle Applications.
• Experienced in Performance tuning of Applications & database using Oracle OEM, AWR, stats pack, SQL scripts.
• Experience in Configuring, Monitoring, Patching, Cloning, maintenance on oracle Applications RAC
• Expertise in Oracle applications e - Business Suite i.e., from 11.5.10.2 to 12.1.3, 12.1.3 to 12.2.4
• Performed Applications installations and upgrades of 11i and R12 (single node, multimode)
• Experience in resolving table space issues for PROD
• Experience in Troubleshooting Oracle DB in production environments on high volume DB
• Experience with Oracle DBA Activities and daily maintenance tasks
• Experience in troubleshooting related to OS on database or application servers in production
• Have good experience on applying patches using adpatch, adop and BSU utilities.
• WebLogic installation, configuration, upgradation and administration (10.3.3,11g and 12c)
• Discoverer installation, configuration and administration
• Excellent communication, problem-solving and Client Management skills
• Expertise in Coordinating with Other teams in getting the required work done
• Experience in requirement gathering and working closely with Business Users
• Holding Master Degree in Computer Applications.

TECHNICAL SKILLS

Applications Versions: 11i,R12,R12.2,Demantra,VCP,SOA,UPK and Hyperion

Database: Oracle 9i/10g/11g

DB Tools: OEM,TOAD,SQL Developer

Languages: C, Linux shell scripts, Perl, SQL/PLSQL

BI Reports: Discoverer

Operating System: UNIX, Windows-XP/2000/NT/98/7/8

Network Protocols: TCP/IP, UDP, HTTP, DNS, DHCP

Others: Win SCP, FTP,PUTTY

PROFESSIONAL EXPERIENCE

Confidential - St Louis, MO

Oracle Applications DBA support

Responsibilities:

• Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of application and database issues
• Design Project Plan, Interfaces, and Instance Strategy documents for Oracle EBS, GRC and SOA environments.
• Installation of Oracle EBS R12.2.4 instance on single node and multi nodes.
• Installation of Vertex OSeries Tax Link and integrate with Oracle EBS 12.2.4
• Install GRC(AACG) and configure multiple data sources and integrate with Oracle EBS 12.2.4
• Troubleshoot and fix GRC access synchronization, user provisioning issues.
• Install SOA 11.1.1.7 on RHEL 6 and integrate with Oracle EBS.
• Setup Database links with heterogeneous databases like SQLServer.
• Troubleshoot and remediate adworker failures during online patching.
• Extensively used adadmin, adctrl, adpatch, adsplice, ADOP,opatch,bsu etc.
• Cloning Development, QA, SIT etc. instances using different type’s backups and active database duplication.
• Tuning Oacore parameters, JVM heap sizes and adding managed servers to support higher workloads.
• Maintaining passwords through CyberArk.
• Configure work mailer with SSL, office 365, import certificates and troubleshooting mailer is-sues.
• Configured ADOP sync driver and resolved sync, custom code issues between RUN and PATCH file systems.
• Installation of GL Wand financial reporting tool and integrate with EBS 12.2.4
• Installation of Noetix views, a pre-build BI coverage for Oracle E-Business Suite environment.

Environment: EBS R12.2, WebLogic Administration, GRC, SOA, UPK, Manage Engine, CyberArk and SharePoint.

Confidential - Dallas, Texas

Oracle Applications DBA (R12.2)

Responsibilities:

• Involved in discussions with Confidential stake holders for gathering the requirements.
• Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues
• Upgraded database from 11.2.0.2 to 11.2.0.4
• Upgrade EBS from 11i to 12.2.4
• Discoverer installation and configuration
• Applying Minimum Baseline, AD TUMS and GDF patches
• Registering schemas using edition based redefinition
• Weblogic installation and configuration
• Apply ADOP readiness report patch and running Readiness report.
• Installing and configuring ILINK, Excel for Apps.
• Disable and Enable auditing.
• Noetix Generator installation, configuration and upgraded noetix views.
• Applying WebLogic security patches using BSU(Bea Smart Update)
• Verifying OS patches, settings and validating mount points
• Running ETCC report to verify DB patches
• Running GSS with GATHER AUTO
• Troubleshooting Upgrade issues
• Extensively worked on cloning of single and multi-node database and applications.
• Provided database support for applications like FMW, AGILE, Vertex and DEMANTRA.
• Had experience in 11g and 12c OEM (Oracle Enterprise Manager) for monitoring applications and databases and to schedule reports.
• Taking care of the performance issues both at the database level and applications level.
• Used Rman for backup and recovery of databases and for cloning.
• Creating custom tops (ILINK, XXLAPPS...) using ad splicer.
• Manages concurrent programs and reports.
• Configure and monitor workflow mailer.
• OAF and Form customizations and migrations.
• Performing Tuning of applications Concurrent Manager.

Environment: Discover Server, Weblogic Administration, Demantra, Noetix, Kintana, QC and JIRA

Confidential - Schaumburg, IL

Oracle Applications DBA

Responsibilities:

• Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues
• Added/removed nodes to/from a RAC cluster.
• Had good experience in troubleshooting ASM disk related issues, RAC VIP and local listener issues.
• Extensively worked on cloning of single and multi-node database and applications.
• Worked on ASM and Non-ASM databases/ troubleshoot ASM issues
• Adding and dropping of ASM disks online.
• Provided database support for applications like FMW, AGILE, OBIEE, GRCC, Vertex, IAM/OAM, EPM, DEMANTRA and ODI.
• Involved in Implementation of Database Vault and Audit Vault.
• Had experience in 11g and 12c OEM (Oracle Enterprise Manager) for monitoring applications and databases and to schedule reports.
• Participated in High availability Testing and Disaster recovery drills.
• Used Rman for backup and recovery of databases and for cloning.
• Extensively worked on Import/export of schemas, tables and complete databases.
• Works with users’ developers and DBAs to coordinate the implementation and integration of new Oracle e-Business applications.
• Coordinating and supporting the Business users during CAT (Customer Acceptance Testing).
• Oracle Applications Manager(OAM)
• Maintain a Log Activity Report
• Provide support for code movement using kintana and manual to production/development/Stage - Implementation.
• Performing Sanity check of applications.

Environment: Kintana, BMC Remedy, QC and Service Now

Confidential

Oracle Application System Administrator

Responsibilities:

• Manages concurrent programs and reports.
• Configure and monitor workflow mailer.
• Works with users’ developers and DBAs to coordinate the implementation and integration of new Oracle e-Business applications.
• Creation of Responsibilities.
• Performing Tuning of applications Concurrent Manager.
• Creation of users and assigning the Roles and responsibilities
• Creation of custom responsibilities as requested/discussed with client.
• Creation of New Profile Options as requested by Clinet
• Creation of Menu's, Forms and functions as requested by client.
• Validation and testing before releasing to Developers/Users.
• Value sets and DFF creations
• Registering to data group and assigning the profiles.
• OAF Migrations
• Form Personalization
• Oracle Applications patches analysis
• Oracle Applications Manager(OAM)
• Maintain a Log Activity Report
• Provide support for code movement using kintana and manual to production/development/Stage - Implementation.
• Performing Sanity check of applications.

Confidential

Oracle Apps DBA

Responsibilities:

• Ensure service availability by proactively monitoring log entries, disk usage, memory usage, CPU utilization.
• Checking the growth of the database.
• Handling SRT calls for Critical tickets and providing RCA to management.
• Performing Backup’s and Restoration on Database and applications.
• Space Management Issues
• Managing Database alerts as for Table space, Listeners, CPU Utilization, Blocking sessions, etc
• Managing ASM Disk group.
• Adding ASM Disk group.
• Applying Patches in Development/Testing/Production instances.
• Creation of users and assigning Roles.
• Working with users on issues (concurrent Managers, tablespace, accessing applications).
• Completion of incidents (tickets) in SLA with priority.
• Manages concurrent programs and reports.
• Configure and monitor workflow mailer.
• Works with users’ developers and DBAs to coordinate the implementation and integration of new Oracle e-Business applications.
• Performing Sanity check of applications.
• Maintain a Log Activity Report.
• Performing Sanity check of applications.
• Provided 24x7 on-call technical supports.

Confidential

Module Leader

Responsibilities:

• Development, Enhancement and maintenance of the above System and provided end to end support.
• Many business critical production bugs have been identified and fixed single handedly.
• Worked in SS System replication into two instances and it went live successfully.
• I have also involved in Data Base Re-org Activity to improve the Performance of our Batch Scripts which runs on a weekly basis.
• Solving the tickets raised by the users through MONET (client application)
• Analyzing the Design document thoroughly for feasibility study
• Understanding the User Requirements and coming up with a proposed solution for the tickets raised by the customer in MONET.
• Working of data from transactional system to Oracle Database by using Confidential Specific Tool.
• Production maintenance, respond to queries for the project and report to Motorola and Confidential Management onsite
• Document the changes in standard procedures & methodologies and upload the latest in COMPASS.
• Programming Shell scripts for space/processes/listener/oracle alerts monitoring
• Using Confidential ’ Web IPMS tool for tracking the status of work requests and overall project monitoring in accordance with Confidential ’ iQMS