SUMMARY:

• Oracle DBA/Apps DBA with 7+yrs of experience in administration of Oracle E - Business Suite (EBS) and Oracle Golden Gate 12c.
• 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 working individually on various projects according to the requirement
• Developed scripts for the various simple to complex DBA tasks (day to day DBA tasks, cloning
• Installed and configured Oracle E-Business Suite 12.2.0 for monitoring and alerting
• Installed and configured Oracle Fusion Application 11.1.7 in premises for monitoring and alerting
• Installation, Upgration, Configuration and Troubleshooting GoldenGate 12c Software.
• Upgraded Oracle EBS 12.0.6 to 12.1.3 to 12.2.0
• Upgraded Oracle EBS 12.2.0 to 12.2.5
• Applying the Online Patch using Adop session.
• Upgraded Oracle databases from 10g to 11g and 11g to 12c
• Expertise in Maintenance, Patching, Cloning, troubleshooting of Oracle Applications (11i and R12) e-Business Suite.
• Expertise in AD Utilities like adpatch, adadmin, adctrl, adrelink, adsplice, admerge, adclone, adconfig.
• Expertise in Maintenance, Patching, Clustering, troubleshooting of WebLogic Server.
• Installed, created and maintained Production, Stage and Dev database Versions 11g, 12c.
• Migrating Oracle ERP 12.1.3 from Linux 4.5(32 bit) to Linux 5.3(64 bit) OS.
• Implemented, maintenance of WebLogic, SOA, IDM in Fusion Application
• Hands on experience on 10g, 11g and 12c Database Refresh using RMAN and custom scripts
• Extensively used Oracle Datapump, export, import ‘
• Documenting, Applying patches that included mini-patch sets, standalone patches, Family packs
• Resolved various issues related to Concurrent Managers and long running concurrent requests
• Working knowledge UNIX/LINUX OS and Python/shell scripts.

TECHNICAL SKILLS:

Databases: Oracle Database 12c, 11g, 10g, 9i, 8, Cassandra Database 2.1.2, Microsoft SQL Server 2005 and 2008

Applications: Oracle E-Business Suite Release- R12 (12.1.3, 12.2.4) 11.5.9

Enterprise Management: Oracle Enterprise Manager Cloud Control 10g

Operating Systems: Redhat Linux, Solaris 10, Solaris 9, Solaris 8, IBM AIX 5L, Windows 2003 AS, 2000 Professional, NT, Windows Server 2008, Windows 7, Windows XP

DBA Tools & Utilities: Datapump, Logminer, SQL Loader, SQL Tuning advisor, Tracing & TKPROF, AWR/ASH/ADDM/STATSPACK, AD utilities, APEX, Golden gate, streams Shell Scripting

WORK EXPERIENCE:

Confidential, Long Beach, CA

Oracle DBA/APPS DBA

Responsibilities:

• Installation, Upgration, Configuration and Troubleshooting GoldenGate 12c Software.
• Configuration GoldenGate Downstream Mining and Integrated Component for Active-Passive and Active-Active replication.
• Configuration GoldenGate High Availability using Oracle DBFS and Active Data Guard.
• Installed and Configured GoldenGate JAgent to work with OEM GoldenGate Plugin.
• Performed Schema Level and Table Level date refreshes from Production to Development environment using Data pump, Expdp / Impdp.
• Monitoring the Various database activities such as Backup, Error Log, Space, Object, performance, User and session Monitoring to ensure proper Capacity and Availability.
• Involved in User Management and Database Security by granting appropriate Roles, and Profiles.
• Monitoring the availability of system, Listener, database, alter log file, trace File.
• Installing R12.2.0 in 5.7 Red hat Linux 64(bit).
• Applying the Online Patch using Adop session.
• Applied the patches in Fusion Middleware home
• Good knowledge in applying the patch in 12.2.4 in Production using Adop
• Performed cloning from PROD to UAT/Test server.
• Issue resolved in invalid objects tables.
• Monitoring of concurrent managers and concurrent requests from fronted and backend.
• Resolved the view log/out files issues of concurrent requests
• Applying patches to resolve different functional, technical and other application related issues.
• Monitoring Concurrent Manager activities
• Administrating the oracle database and applications with the AD utilities
• Monitoring and Troubleshooting of Apache, Forms, Conc. Manager and Database related issues
• Compiling invalid objects (manually and also using adadmin)
• Performance Tuning and Maintenance for all database
• Worked on RMAN repository upgrade and regular maintenance of catalog database by implementing changes suggested by Oracle.
• Doing all R12 SYSADMIN activities like user ID and responsibility creation, assignments

Oracle DBA/Apps DBA

Responsibilities:

• Performed an Upgrade of Oracle Application from R12 (12.0.6 to 12.1.3) in production
• Performed an Upgrade of DATABASE (10.2.0.4.0 to 11.2.0.3) in production
• Monitoring Concurrent Manager & its operations like starting/stopping
• Maintaining the Users issue in production
• Oracle EBS Cloning- Used Rapid clone utility to clone production EBS to non-production, was also involved in post cloning activities
• Performing the Rman Backup in production weekly once
• Worked as application DBA to resolve performance issues, user issues and network related issues.
• Maintaining the ORACLE database Health checkup
• Maintaining the Tablespace, alert log files, concurrent log files
• Performing solved the Users issue in production.
• Monitoring and fixing issues related to backups
• Provided Maintenance and troubleshooting support for EBS- Resolved Concurrent Manager and concurrent requests related issues. Worked on Concurrent manager startup issues and various performances and long running issues reported by users. Also worked on issues related to application performance issue, login issues etc.
• Resizing the data files, adding new data files to the tablespace as per the necessity.
• Troubleshooting expertise for all tiers (Apache, Forms, Concurrent, Admin, J-initiator and database)Interacting with users/developers and resolving their regular Service requests
• Troubleshooting Problem in performance tuning and concurrent manager requests,
• Worked on Backup and Recovery-Configured backups using RMAN and custom scripts. Recovered using hot/cold/full and incremental backups
• Daily Maintenance of the Applications and Database
• Implemented fusion Application 11.1.7 in premises.
• Applying patches in WebLogic server.
• Adding Cluster Environment in WebLogic Server
• Testing a Deployed application in SOA Environment
• Install Fusion Applications Provisioning Framework.
• Install Transactional Database for Fusion Applications
• Install Fusion Applications RCU.
• Install Identity Management RCU
• Install and configure Oracle HTTP Server as the entry point.
• Install Oracle Identity and Access Management Components.
• Create identity and policy stores for Fusion Applications.
• Install and configure Oracle Access Manager
• Install and configure Oracle Identity Manager.
• Creating the WebLogic Server Domain for Identity Management
• Installation, Configuration, Troubleshooting FMW Server.
• Manage and perform patching/security fixes/upgrades to WebLogic environment.
• Restarting a admin server from Node Manager
• Creating Nodemanager in WebLogic server
• Install Oracle SOA Suite 11g
• Deploy SOA Composite Applications
• Backup the Manage Server Domain in WebLogic.
• Knowledge in WLS tool
• Starting and stopping components and environment
• Starting and stopping using the node manager
• Password Change Utility options in WebLogic Server
• Production Support DBA -Provided 24*7 Support for 45+ instances of Oracle databases and Oracle EBS Applications
• Backup of database using RMAN UTILITES.
• Restore the database Using RMAN UTILITES.
• Interacting with users/developers and resolving their regular Service requests
• Resize the tablespace issue.
• Weekly twice take the cold backup/hot backup
• Monthly once taking cloning in PROD server.
• Monitoring Concurrent Manager & its operations like starting/stopping.
• Reorganizing database for better space utilization- Worked on reorg to save space and improve the performance
• Administered and Troubleshooting of Oracle applications Server issues.
• Resolved Concurrent Manager and DBA issues.
• Maintain PROD $ TEST server.
• Troubleshooting production issues for slowness of the application.
• Sys Admin functions like Creating Users, Creating responsibilities and Menus.
• Troubleshooting concurrent request and manager issues- Worked on issues related to concurrent managers and performance issues like long running concurrent jobs
• Creating Custom Top as per business requirements
• Generating and analyzing AWR reports.
• Configured Parallel Concurrent Processing, Debugging Concurrent Managers and requests
• Cloning the EBS Application once in two weeks
• Performed an Upgrade of Oracle Application from 11.5.9 To 11.5.10.2 Multimode (PRODUCTION) Environment.
• Good Experience in patching of Oracle Database & Applications.
• Database Administration like adding of data files, tablespace and monitoring table space.
• Check alert log errors and make necessary actions to rectify them.
• Extensively worked on Oracle Applications AD Utilities.
• Resizing the data files, adding new data files to the tablespace as per the necessity.
• Troubleshooting expertise for all tiers (Apache, Forms, Concurrent, Admin, J-initiator and database)
• Performing Daily Database health Checkups
• Monitoring and fixing issues related to backups
• Applying various applications patches to the instance
• Supporting developing team in day-to-day activities.
• Daily Maintenance of the Applications and Database
• Supporting all users for all the DEV instances.
• Monitoring Concurrent Manager & its operations like starting/stopping
• Backup of control files & recreating control file as and when required.
• Users Administration (Roles and Profiles)
• Installed and used RMAN for taking the backup of Oracle9i Databases
• Defined Executables, Concurrent Programs, Request Sets
• Performing Single-node/ Multi-node Cloning on 11i/R12
• Extended post upgrade support.

Oracle DBA/Apps DBA

Responsibilities:

• Installation of Red Hat Linux AS 5.x in HP DL 360, 380 and 580 server
• Using Production APPS backups to create development & UAT environment
• Installation of Oracle Apps 11i/R12 on Red Hat Linux AS 5.x to create vision instance
• Implemented physical standby database during physical server maintenance
• Applied patches into database using Opatch and application of mini-patch using adpatch
• Sysadmin responsibility to configure SMTP in workflow email and creating new users
• Installation of primavara in Oracle EBS R12
• Implemented Oracle Physical Standby database using Data guard.
• Re-org of tablespacesincase of fragmentation or when purging.
• Implementation of RMAN as a backup.
• Performing refresh of the database for development needs.
• Performed various recovery scenarios with backup taken using Hot Backup/Rman.
• Automation of statspack/awr reports and analyzing the reports.
• Troubleshooting production issues for slowness of the application.
• Cloning of Apps environment to development and UAT as required
• Implemented Data Guard using physical standby database.
• Patch Analysis for Database and Application patches including rollup patches and one - of patches.
• Applying patches using Staged APPL TOP to reduce down time of production.
• Regular backup of Application Tiers in all nodes.
• Sys Admin functions like Creating Users, Creating responsibilities and Menus.
• Created custom menus and responsibilities and created application users and assigned appropriate responsibilities.
• Create Custom Top in Production Environment.
• Defined new concurrent managers, tuned concurrent managers, defined work shifts and set incompatibility rules for efficient concurrent processing.
• Database Level Patching using Opatch
• Proactive Monitoring of the Database, Application with monitoring tools
• Coordinating with Oracle Support for logging tar and knowledge based search to find solution to the problems that are occurring in the live server and while Applying Patches (Tar, Bug Search, User Forum Participation)

Oracle DBA

Responsibilities:

• Involved in DBA support for 24/7 Production Environments
• Taking full Database and archive log backup through RMAN by weekly incremental backup and monthly full backup.
• Creation of tablespaces and datafiles for the project requirement.
• Identifying locks detecting the locked and blocked object’s session, and releasing the same for usage.
• Monitoring space of Table spaces, data files, undo and temp Table spaces.
• Checking the alert logs and trace files for errors.
• Creating users and granting roles to them.
• Granting specific privileges and roles to the users.
• Managing the Storage Clause for objects depends on the application.
• Monitoring the objects growth and space management.
• Responsible for taking logical backup using Export/import and maintaining the integrity of data of individual user.
• Dropping unused objects (or) user after taking appropriate backup