SUMMARY:

• Over 10 years of IT experience working as Oracle DBA, Oracle Applications DBA, SOA Administrator and OBIEE Administration in large scale Support, Implementation and Upgrade Projects.
• Upgradation of Oracle E - Business Suite to R12.2.3 from R12.1.3, R12.2.5 from R12.2.3 and R12.2.6 from R12.2.5
• Installation and configuration of 11i and R12.1.X and R12.2.X
• Implementation, configuration of Load balancer, DMZ, SSL and SSO setup
• Installation of Oracle WebLogic server, SOA, OBIEE
• Worked as a Production Support DBA providing 24*7 support for EBS applications accessed by users across the globe, provided On-call and day-to-day support.
• Experienced in working as a team as well working individually on various projects according to the requirements.
• Developed scripts for the various simple to complex DBA tasks (day to day DBA tasks, cloning, reporting statistics, re-indexing, checking integrity, backup and recovery)
• Installing, Maintenance of Oracle E-Business suite 11i and upgrading of Oracle database Oracle E-Business Suite R12 - Installation & Maintenance
• Documenting, applying patches that included mini-patch sets, standalone patches, Family packs
• Cloning application using Rapid Clone from dual node to dual node, dual node to single node
• Administration of Oracle Database versions 9i/10g/11g/12c involving database installations, cloning, upgradation, Data Guard and backup configuration using RMAN/Hot backups, applying patches (PSU/CPU, bug fixes) & User administration.
• Expertise in administration of Real Application Cluster (RAC) / Automatic Storage Management (ASM).
• Expertise in Space Management, SQL query tuning, Application tuning
• Experience in creating database Objects like Tables, Stored Procedures, Views and functions.
• Expertise in administration of Golden Gate

WORK EXPERIENCE:

Tech Lead - Oracle Apps DBA

Confidential, Louisville, Kentucky

Application: Oracle Applications 11i, R12.1.3 and R12.2.3

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

O/S: Linux/RHEL AS 6.1

Responsibilities:

• Upgradation of R12.1.3 to R12.2.3, R12.2.3 to R12.2.5 and R12.2.5 to R12.2.6
• Expertise in OBIEE, which includes Implementations, Upgrade, Cloning, Patching and Integration with EBS
• OBIEE Upgrade from 11.1.1.7 to 11.1.1.9
• OBIEE Migration from 11.1.1.9 to 12.1.1.0
• Upgrading database 11g to 12c
• Installing and Managing OBIEE 11g
• Implementation, configuration of Load balancer, DMZ and SSL setup
• Implementation of Java Web Start (JWS)
• Applying Patches (R12.2.3, R12.1.3) with different teams involved in the process
• Maintaining the uptime of all Production instance 24x7
• Providing issue resolution to customers within SLA
• Carrying Cloning of single as well as multiple node architecture.
• Experience in Fusion Middleware like Weblogic/SOA/OBIEE
• Worked on Rehost project (EBS, OBIEE, Weblogic Server, Demantra application)
• Communicating out scheduled activity within tight timelines
• Performed the table reorg, based on the user request.
• Working Experience in Demantra/Agile/OTM
• Quarterly review of PSU/CPU patches and applying as requested.
• Solving day-to-day user Problems
• Considering future growth, reorganization of database and space management of database as per need
• Monitoring and Troubleshooting of Apache, Forms, Conc. Manager, and Servers.
• Experience in setup of cronjobs using crontab for Production Environment to receive alerts related to TS issues, OS level space issues, locking issues, log alerts, etc.
• Expertise in administration of Real Application Cluster (RAC) / Automatic Storage Management (ASM).
• Expertise in Space Management, SQL query tuning, Application tuning
• Expertise in administration of Golden Gate

Oracle Apps DBA

Confidential

Environment: Oracle Applications 11i,R12.1.X

O.S: Sun Solaris 10,Linux/RHEL AS 6.1,AIX

Responsibilities:

• Performed the Applications Upgrade from 11.5.10.2 to R12.1.3
• Worked new host projects on Tricore (Datacenter) servers
• Configured DR setup for new build instances.
• Administration of Oracle Database versions 10g/11g/12c involving database installations, cloning, backup configuration using RMAN/Hot backups, applying patches (PSU/CPU, bug fixes) & User administration
• Working on New R12 implementation environments
• Providing issue resolution to customers within SLA
• Carrying out scheduled activity within tight timelines
• Worked on 11g RAC and handled it with the help of srvctl, ocr, ocrcheck, ASM etc.
• Cloning of single as well as multiple node architecture.
• Monitoring Concurrent Manager, its operations & Troubleshooting problems, resolved the log/out files issues of concurrent requests.
• Daily monitoring the database alert log files & trace files for any error messages, periodic checking table spaces, Undo TS & index status.
• Cloning of SOA of instance
• Integration of Discoverer 10g with eBusiness Suite

Oracle APPS DBA

Confidential

Applications: Oracle Applications 11i, R12

Database: Oracle database 9i/10g/11g

O.S: Sun Solaris 10

Responsibilities:

• Upgrading Database 10g to 11g (10.2.0.5 to 11.2.0.4) in Production.
• Maintaining the uptime of all Production instance 24x7
• Performed the table reorg, based on the user request.
• Check Invalid objects in the database
• Check space on all Tablespace and Tempspaces
• Checks there are no DBMS JOBS with the status of failed or broken.
• Check Oracle Alert process for the errors and warnings
• Check any long-running operations on Database
• Review the AWR report for all database
• Performance Tuning and Maintenance for all database
• Check Concurrent Manager are running and any alert log in Concurrent Manager log file
• Check Workflow Managers are running and any alert log in Workflow log file
• Purge Concurrent Request and/or Manager Data program status.
• Check the status of the scheduled jobs
• Check any long running concurrent requests
• Doing all R12 SYSADMIN activities like user ID and responsibility creation, assignments
• Concurrent Manager Tuning
• R12 Application cloning

Oracle APPS DBA

Confidential

Environment: Oracle Applications 11i,R12

O.S: Sun Solaris 10

Responsibilities:

• Actively Participated in DATA CENTER MIGRATION for Development, Staging & Production Instances
• Performed the Applications Upgrade from 11.5.10.2 to R12
• Working on more organized Ticket based environment for issue resolution
• Providing issue resolution to customers within SLA
• Carrying out scheduled activity within tight timelines
• Applying Patches (PSU, CPU, INDIA Localization and RDBMS)
• Cloning the instances from Production to development (Using SRDF Replication and RMAN)
• Maintaining the uptime of all instance 24x7
• Participating weekend plan meeting and process meetings.
• Implementing load balancer, DMZ and SSL
• Installation and configuration of 11i and R12
• Working on New R12 implementation environments
• Upgrading database 9i to 10g & 10g to 11g
• Implementing Distributed application tier to shared application tier file system
• Implementing NLS support for Oracle Applications
• Convert character set from US7ASCCII to UTF8
• Configured Dedicated JVMs and Troubleshooting JVM related issues.
• Discussing and Implementing backup & restore policies
• Performed physical backups and recovery and restoration of database.
• Responsible for scheduling and monitoring backups.
• Performed tablespace reorg.
• Upgrade forms version 19 and JRE upgrade.
• Tracking invalid objects, compiling & validating the invalid objects.
• Filing SR’s, coordinating with Oracle corp. for support.
• Managing Oracle Applications using Utilities like AD Utilities like adctrl, adpatch, adadmin.
• Performed tracing for various user sessions and for various concurrent Programs.
• SYSADMIN Activities like Concurrent Manager Management, User Creation, etc.
• Added the off-cycle product by using AD Splice
• Reduced the patch timing by using merging patches and options.
• Monitoring memory and CPU utilization
• Fixed ora-600 errors by applying opatches.
• System Administration for Oracle Apps which includes creation and maintenance of Users, Responsibilities, Profiles, Concurrent Program etc.
• Created the custom tops to meet the development requirement
• Increased the concurrent manager processes as per development and Functional team requirement depends on the server load
• Monitoring Concurrent Manager, its operations & Troubleshooting problems, resolved the log/out files issues of concurrent requests.
• Daily monitoring the database alert log files & trace files for any error messages, periodic checking table spaces, Undo TS & index status.