ORACLE APPS DBA
Ministry of Interior
Total years of experience :13 years, 9 Months
I have been taking part in HRMS project after getting shifted to oracle Database.Has been a lead for the project and single handedly taking care of oracle applications part.
• R12 upgrade experience from 11.5.10.2 to R12.1.1 on Aix
• Configure SSL Enabled on Production.
• Platform migration from Sun server to Aix server. Converted to ASM and RAC on 11.5.10.2 with 10.2.0.3.Adding node, configured F5 Load Balancer in Application
• JRE Upgrade from Jinitiator 1.3 to JRE 1.6.12 on 11.5.10, 2, JRE 1.6.12 on R12.1.1 from 1.6.07.
• Shared Appl_top and fixed Load balancing issue in the configuration issue on 11.5.10.2
• Installation of R12.1.1 and upgrade experience R12.1.1 and database upgrade from 10.2.0.3 to 11.0.6 on Sun server on Development server on January 2011
• Standalone discoverers install and Integrate with Oracle applications 11.5.1.2 and R12.1.
• Write a shell script to compile custom forms, reports in R12 upgrade
• Go Live for Oracle HR Implementation for 18k Employees for Ministry of Interior and participated in the Performance issue in March 2009
• Cloning of Oracle Application 11.5.10.2 using RMAN
• Configured RMAN backup and moving into Tape.
• Maintaining RAC instance, cluster ware upgrade, RAC database upgrade from 10.2.05 to 11.0.6
• configured backup using file system backup and RMAN Backup writing to disks and tapes
• Load Balancing of RAC database and failover Implementation.
• Monitoring performance and monitoring locks for RAC database.
• Write the shell script to move salary from Oracle sun server to security server.
• Configured Noarchivelogmode into Archive log mode for the cluster file system and configured RMAN backup for RAC database.
• Restored the Production Database because of Hardware failure.
• Participated for Hardware Memory Upgrade, Disk Upgrade, Sun Cluster configuration and Hardware issue.
• Physical Standby.
Oracle India Private Ltd. as Senior Technical Analyst August 2006 to August 2008
Duration Jan 2006 to August 2006
Role &
Responsibilities
Oracle Applications DBA
• Application Cloning and Database Refresh. Of different operating systems.
• Configuring MWA
• Maintaining RAC instance
• Monitoring locks on RAC instance
• Applying patches
• ASCP Cleaning
• Maintaining Applications Users security.
• Monitoring Tar's to resolve the known issues in coordination with Oracle Support.
• File System Alerts.
• Alert move across the instance
Technology 5 nodes: db tier: IBM and web tier: LINUX with RAC database version 9.2.05, Oracle Applications 11.5.9
Work Location India
• Rapid Cloning of 11.5.9 and Database Refresh.
• Configuring MWA
• Discoverer Upgrade.
• Database Upgrade
• Application Upgrade from 11.5.9 to 11.5.10
• Oracle 8i, Oracle 9i Data guard
• Portal Setup
• Patch Application on Database & Application Tier using Manually and using Kintana Tool
• Performance Tuning at the Database Level
• Monitoring TAR’s to resolve the known issues in coordination with Oracle Support
• Database Planning & Installation of Oracle Applications 11i Release 11.5.7
• Creating Application Users & Assigning appropriate Responsibilities.
• Configuration of Discover 4i
• Patch Application on Database & Application Tier
• Performance Tuning at the Database Level
• Monitoring TAR’s to resolve the known issues in coordination with Oracle Support
Duration June 2000- August 2001
Role & Responsibilities System Executive Developer and Creation of Database & Creation Of users. Developed in ASP for Admin Pages.DBA
Technology Oracle, Visual Basic, JavaScript, and Asp, IIS
Work Location India
Client Supreme Plastics Ltd
Plasticsjunction.com
Project Description
Plasticsjunction.com is conceived as a digital marketplace for plastics. The site will serve as a comprehensive B2B digital marketplace that caters to every face of plastics commerce- right from purchase of resin, auxiliary material, equipment and accessories to disposal of excess materials and used machinery. Various features Expert Junction, Discussion Forum, Trade Junction, Event Calendar, Job Listing, News etc have been incorporated into the site.
Duration Jan 1998 to June 2000
Role & Responsibilities System Executive Design and Coding, DBA
Technology Oracle, VB, ASP, IIS
Work Location India
• Master of Computer Application (MCA), Madras University
• Bachelor of Engineering in Mechanical (Mech), Bharathidasan University