SUMMARY:

• Having 9 + 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 Professional OCP(11g) and Red Hat Certified Engineer RHCE s
• 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, multi node)
• 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
• Experience in troubleshooting related to OS on database or application servers in production
• Installation, secure configuration, and troubleshooting of networkservices 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.

TECHNICAL SKILLS:

Oracle Apps Modules: SCM,OAM

Database(No-SQL): Mongo DB

Languages: C, Linux shell scripts, SQL

BI Reports: Discoverer

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 Database 11g and 12c Environments.
• Worked on 11g RAC Environments.
• Worked on Database Performance issues
• Worked on patch application when required
• Worked on AWR Reports for pinpointing the Database issue
• Expertise on Linux and Solaris operating system
• Worked on 11gGolden Gate
• Resolved the issues on incidents raised
• Handled customer call with user for any troubleshooting issues related to ORA-Errors
• Upgraded Database version from 11.2.0.3 to 12.1.0.2 on Dev Environment
• Upgraded Application Version from 12.1.3 to 12.2.4
• Monitored and check the concurrent program status, as per the requirement from End user
• Resolved Concurrent Manager Troubleshooting
• Managed passwords of oracle products and schemas using FNDCPASS
• Assigned responsibilities to the users as per client requirement
• Movement or replacement of files as per the developer's requirement
• Performed cloning as per the requirement
• Resolving tablespace issues when alert triggered
• Using Adutilityadadmin for maintenance of Oracle Applications
• Having Good communication to work with team
• Worked on Application performance issues

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

Confidential, Somerset, NJ

Oracle Apps DBA

Responsibilities:

• Applied patches on dev, pre-prod and test instance
• Worked on releases as per the requirement
• Compiled RDF Files as per the user's issues
• Closed the incidents through Remedy Tool
• Configured the TNS connections and troubleshooting network issues
• Modified the PO,PR status in database after interaction with end user
• Checked the PO,PRstatus in sysadmin and forwarding to next Approver as per End user requirement
• Cloning of production databases for test and development purpose performed
• 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
• Worked closely on SCM issues in Sys admin
• 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.1.3, Oracle DB Version 11.2.0.1, UNIX

Confidential, San Francisco, CA

Oracle Apps DBA

Responsibilities:

• Worked on R12 Applications and 11g Database 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
• 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