SUMMARY

• Having 12+ years of experience as Oracle Apps DBA (11i, R12 & R12.2) / Oracle DBA (9i, 10g, & 11g)/Linux and network admin 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, statspack, SQL scripts.
• Having Oracle Certification Professional OCP(11g) and Red Hat Certified Engineer RHCE Certifications
• 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/5
• Performed Applications installations, and upgrades of 11i and R12 (single node, multinode)
• Experience in resolving table space issues for PROD
• Experience in Troubleshooting Oracle DB in production environments on high volume DB
• Experience with Oracle RAC, DBA Activities and daily maintenance tasks
• Expertise on PLSQL and Oracle database 10g,11g,12c
• Experience in troubleshooting related to OS on database or application servers in production
• Installation, secure configuration, and troubleshooting of network services like NFS, SSH, SAMBA
• Installation, secure configuration, troubleshooting of internet services like POP3, IMAP etc.
• Creation and deletion of users as per the requirement and policies
• Creation and addition of hosts to network
• Remote administration using Terminal Services
• Through network devices supported infrastructure for smooth flow of network and work.
• 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 Bachelor Degree in Electrical Engineering from Bangalore University from 2004(August)

TECHNICAL SKILLS

Applications Versions: 11i,R12,R12.2.5

Database: Oracle 9i/10g/11g/12c

DB Tools: OEM,TOAD,SQL Developer

Oracle AppsModules: SCM,OAM

Database(No-SQL): Mongo DB

Languages: C, Linux shell scripts, SQL

BI Reports: Discoverer

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

Network Devices: Routers, Switches, Hub

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

Others: Win SCP, FTP,PUTTY

Big Data(Hadoop): HDFS,HIVE,HBASE,PIG

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Sr. Oracle Apps DBA

Responsibilities:

• Worked on ERP login issues for individual user and multi users.
• Worked on Apps System Admin
• Upgraded from 11.2.0.4 to 12.1.0.2 on Dev Environment
• Worked on Oracle RAC like Node Evictions
• Performed performance monitoring through OEM and AWR
• Worked on Demantra Workbook issues for end Users
• Scheduled RG Program to Demantra Performance issues
• Applying Application patches through adop
• Worked on RMAN and Oracle ASM
• Troubleshooting Concurrent requests related to Finance business user Issues
• Expertise on Linux and AIX operating system
• Resolved the issues on incidents raised
• Unlocked the account of users as per the requirement
• Handled customer call with user for any troubleshooting issues related to ORA-Errors
• Assigned responsibilities to the users as per client requirement
• Having Good communication to work with team
• Worked on Production support (24/7) Environment.
• Worked on Business user issues for any Oracle Workflow Failure Notification

Environment: Oracle Applications 12.2.5, Oracle DB Version 11.2.0.4, UNIX

Confidential, Somerset, NJ

Oracle Apps DBA

Responsibilities:

• Applied patches on dev, pre-prod and test instance
• Having knowledge of shell scripting for modification as per the requirement
• Monitored RMAN Backups
• Hands on Experience in SQL Procedure/Triggers/Packages coding
• Worked on releases as per the requirement
• Compiled RDF Files as per the user's issues
• Used PLSQL code for applications to function
• Checking the PLSQL Code for any issues related to Financial Invoice Errors in PROD
• Recompiled Apps schema, forms
• Migration of Code objects from Development or test to PROD using FNDLOAD compiled Invalid objects in Database for performance issues
• Closed the incidents through Remedy Tool
• Modified the PO,PR status in database after interaction with end user
• Checked the PO, PR status in sys admin and forwarding to next Approver as per End user requirement
• Worked on Oracle RAC like Node Evictions
• Regenerated the workflow notification as per the user requirement when failed in ERP
• Supported Application modules like FIN,HR,SCM for any issues in Sys admin
• Performed Web logic Troubleshooting for login issues
• Provided the Reports from Database as per the User's requirement
• Raised CRQ in Remedy for any application changes
• Working with other operations teams on infrastructure issues such as server performance, network issues
• Monitor and check the concurrent program status, as per the requirement from End user

Environment: Oracle Applications 12.2.0, Oracle DB Version 11.2.0.2, UNIX

Confidential, San Francisco, CA

Oracle Apps DBA

Responsibilities:

• Worked on R12 Applications Environments
• Performed code migrations from QA to PROD
• Viewed and Tested Technical Design Document, Installation Documents (MD70, MD120) for successful code migration to PROD
• Creating Custom Concurrent Managers and Assigning Work shifts to it.
• Downloaded LDT files in dev and successfully uploaded to QA
• Moving the recent version code to shared client network folder
• Finding long running requests and sessions terminate them if needed
• Troubleshooting shellscripts when required
• Modified/Maintained shell scripts to monitor as needed and maintain the Oracle Applications database.
• Performed Oracle application and database tuning.
• Troubleshooting Critical problems when Dev is down
• Resolved applications frontend login issues
• Creation of application users as per client requirement

Environment: Oracle Applications 12.1.1, Oracle DB Version 11.2.0.1, UNIX

Confidential, Denver, CO

Oracle Apps DBA

Responsibilities:

• Discussed the critical issues in Blocking sessions with client
• Monitored and resolved Blocking sessions in Database
• Performed De mantra bounce requests on scheduled basis
• Resolved CA Tickets
• Worked on sys admin Activities
• Worked on Multiple production databases
• Usage of OEM for performance monitoring the environments
• Analyzed and resolved Concurrent Manager Trouble shooting
• Executed RFC’S as per the process
• Monitored the pending concurrent requests are in acceptable limits for performance issues

Environment: Oracle Applications 12.0.4, Oracle DB Version 10.2.0.3, UNIX

Confidential

Oracle Apps DBA

Responsibilities:

• Participated in Application 11.5.10 CU2 to R12 Upgrade
• Monitoring and supporting day to day activities of the development databases and work on urgent issues
• Found long running requests and sessions terminated them if needed
• Maintenance of Oracle Applications on test databases
• Bouncing of Apache services
• Applying Customized patches

Environment: Oracle Applications 11.5.10.2, Oracle DB Version 10.2.0.2, UNIX

Confidential

Oracle Apps DBA

Responsibilities:

• Responsible to ensure that the environments are stable and at acceptable performance
• Backup and cleaned up various log files for mount point issues
• Troubleshot the problems with web server, concurrent managers for the prod issues
• Managed, monitored workflow and bounced when required.
• Applied Application Patches
• Performed cloning as per the requirement
• Monitored the scheduled RMAN Backups, resolved when failed.
• Managed service level agreements with vendors

Environment: Oracle Applications 11.5.10, Oracle DB Version 10.2.0.4, UNIX

Confidential, Huntersville, NC

Oracle Apps DBA

Responsibilities:

• Applied Application patches & done Pre Patch Analysis
• Monitored concurrent request sets that run every weekend.
• Daily checked the Discoverer workbooks.
• Daily monitored Production and Test instances
• As per User Request Applied Bom drops
• Weekly once scheduled prod Bounce.
• Performed multi node Patching
• Applied RDBMS and Application Patches

Environment: Oracle Applications 12.0.4, Oracle DB Version 10.2.0.3, UNIX

Oracle DBA/Linux Admin

Responsibilities:

• Monitored Database Archive log Mount points
• Monitored all databases are up
• Performed database upgrade from 9.2.0.5 to 9.2.0.8
• Monitored Database backups, resolved when failed
• Created users and unlocked the users as per the requirement.
• Supported Networking devices like Routers, Hubs, Switches for the environment
• Maintained and supported user’s privileges
• Used networking commands for pinpointing the Operating and network issues

Environment: Oracle DB Version 9.2.0.5, UNIX