SUMMARY

• Over 10+ years of experience in IT industry, as an Oracle Application DBA (EBS 11i/R12) and core DBA (9i, 10g, 11g, 12c) supporting multi - Terabyte databases on multiple environments.
• Experience in Installation, Setup, Implementation, Customization & Product Support of Oracle Applications 11i (11.5.9, 11.5.10, 11.5.10.2 modules like HR, Finance and supply chain) and R12 (12.1.3) and 12.2.4
• Experience on 12.2.4 ADOP Patching, troubleshooting adop and fs clone issues.
• Experience on upgrading Database from 10g (10.2.0.5) to 11g (11.2.0.4).
• Having 5 Years of R12 upgrade and production support experience.
• Experience on upgrading Oracle EBS applications from 11.5.10.2 to 12.1.3 and 12.2.4
• Monitored the Applications and database using OEM and OAM,XML publisher
• Experience in maintaining and quick problem solving ability for 24x7 Oracle Application databases and core databases.
• Experience managing on RAC and grid infrastructure for prod and non-prod for 11gr2
• Experience in Patching (using adpatch, Kintana, Ring Master), Cloning (Rapid Clone and Manual Clone) using AD utilities and Grid.
• Apply Quarterly CPU’s, Family packs and one off patches to databases and applications
• Strong Experience with Application database Administration Utilities (AD Utilities), autoconfig
• Excellent troubleshooting skills in Apache, Forms, Database, Concurrent node issues.
• Experienced in Single node, Multi node cloning process with Extranet configuration
• Exposure on Core DBA activities like DB Refresh Table - Reorg, Index re-builds Export& Import etc.
• Building new databases with grid infrastructure
• Experienced in System Administrator activities, Concurrent managers, application user setup, defining responsibilities, Concurrent Managers, planning for concurrent manager workers, Oracle Workflow Administration, as per requirement.
• Experience in User & RMAN managed backup/disaster recovery/standby server recovery.
• Excellent Troubleshooting skills for p1 issues, related to user errors, alert log errors
• Ability to work independently with little or no supervision, TAR Resolution for Bugs reported
• 5 Years of Experience in on-site off-shore model.
• Hands on Experience Golden gate 11.2.0.2, extracts process, patching, start and stop extracts
• Experienced in Production Support and Co-ordination of Critical issues.
• Worked on Solix environment for archiving data from PRD for better performance and keeping old data in other production.
• Exposure on Major CPU patching releases on Non RAC and RAC databases for 11.1.0.7 and 11.2.0.4
• Efficient Team Player, hardworking, good in analytical and logical problem solving abilities with excellent communication skills.
• Strong work experience in RAC, ASM (srvctl, crsctl).
• On call support on rotation basis.
• 24x7 support of both Production & non-production on various Platforms.
• Worked on Performance tuning and data guard with disaster recovery
• Knowledge on middleware components Web logic, OAM, OIM, OID SOA.
• Strong interpersonal skills, good communication and presentation skills

TECHNICAL SKILLS

Databases: Oracle 9i/10g/11g, Golden Gate 11.2.0.2

ERP: 11.5.9, 11.5.10.2, R12 (12.1.3), 12.2.4

Middleware: Oracle 10g AS, OID & LDAP Server

Oracle Tools: OEM, Toad, PLSQL developer, RMAN, Data guard, explain plan, OAM

Other Tools: Remedy, HP Open View, TSG Service now, Jira

Operating Systems: Linux, HP-UX 11, Solaris, Exadata, Exalogic

Programming: Shell scripting, SQL

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Oracle Apps DBA

Environment: Oracle EBS11.5.10.2, R12.1.3, 12.2.4, 11gr2 RAC, Exadata, Exalogic, Linux

Responsibilities:

• Majorly working on 11.5.10.2 to 12.2.0 to 12.2.4 upgrade.
• Troubleshooting after upgrade issues.
• Post patching after upgrade on build instances.
• Documenting post upgrade patches, issues and configuration changes.
• Working on Exadata Linux and Exalogic servers.
• Supporting 11.5.10.2, 12.1.3 and 12.2.4 instances.
• Clone Oracle applications (ERP) 12.1.3 and 12.2.4 instances using rman backups.
• Database cloning and 11i/R12 Apps Cloning
• Setting up the cron for backups, scheduled jobs, alerts and cleanup.
• Applying Oracle Application patches using adop patch cycle with minimal downtime.
• Preparing the patch analysis reports.
• Handling all the aspects of administration tasks such as day-to-day site monitoring and maintenance
• Installation, Configuration, Clustering, Deploying Applications, Troubleshooting, and Maintenance of Oracle EBS.
• Working with end users and Oracle Support in resolving application and database issues for test environments
• Implement new changes to monitoring scripts as per new requirements.
• Experienced on R12 trouble shooting.
• Off-hours support when required.
• Using OEM 12C creating groups, users, re-org, tablespace alteration, setting alerts for prod.
• Working on defect using HP ALM tool for issue resolutions with Strict SLA’s.
• Support for Production and non-production databases.
• Weekend scheduled activities like patching, re-org, bounces, code moves for Production.
• Applying Oracle Application and database patches (patch analysis and application using adpatch, opatch) and schedule downtime for applying of patch.
• Experienced in RAC administration (Srvctl, crsctl), applied application patches and RDBMS patches.)
• Monitoring storage and creating storage reports and calculating storage growth for Prod environments.
• Worked closely with different teams to consolidate work.
• Installing and supporting for Oracle Agile PLM and GRC Applications

Confidential, Charlotte, NC

Oracle Apps DBA

Environment: Oracle EBS 11i (11.5.10.2), R12.1.3, 11g, OEM, Linux, OAM, RAC,JIRA

Responsibilities:

• Oracle Application upgrade from 11.5.10.2 to R12.1.1 to R12.1.3.
• Working as 24*7 supports for production databases and supporting for 9TB Prod database.
• Applying Oracle Application and database patches (patch analysis and application using adpatch, opatch) and schedule downtime for applying of patch.
• Worked on Tickets on Regular basis with Strict SLA’s.
• Worked on CORE DBA activities like installation, configuration, create database, alerting tablespaces and data file management, file system management, re-org, export, import.
• Managing users and security, database objects, such as tables, indexes, and views
• Performance Tuning - Query, Instance, Database, I/O, handing long running queries
• Worked with Storage, Network & Backup teams in setting up environments.
• Extensive DBA experience in maintenance, development, Export/Import, Backup/Recovery, RMAN, and 11g and 12C grid control.
• Worked on the JIRA ticketing system.
• Support for Production and non-production databases.
• Weekend scheduled activities like patching, re-org, bounces, code moves for Production.
• Implement new changes to monitoring scripts as per new requirements.
• Clone Oracle applications (ERP) 11.5.10.2/12.1.3 instances using rman backups
• Trouble shooting for concurrent manger, Apache and form issues for 11i and R12 instances.
• Performance tuning in Oracle Applications instances and other production DBs
• Experienced on R12 trouble shooting.
• Experienced in RAC administration (Srvctl, crsctl), applied application patches and RDBMS patches.)
• Monitoring storage and creating storage reports and calculating storage growth for Prod environments.
• On call support on rotation basis.
• Working on Exadata.
• Using OEM 12C creating groups, users, re-org, tablespace alteration, setting alerts for prod.
• Installed OEM Grid control 12c to monitor multiple SOA, WEBLOGIC instances and their databases.
• Worked on golden gate 11.2.0.2, extracts process, support, patching, start and stop extracts and managers, registering, unregistering, deleting and adding extracts.
• Dividing extracts into multi node, creating failover for extracts.
• Worked on Data guard and disaster recovery.

Confidential

Oracle Application DBA

Environment: Oracle E-Business Suite 11i (11.5.10.2), R12, 10g, 11g,(OEM), Solaris, Linux -86, OAM,RAC

Responsibilities:

• Database upgrade from 10g (10.2.0.5) to 11g(11.2.0.4).
• Oracle Application upgrade from 11.5.10.2. to R12.1.1 to R12.1.3.
• Have done 3 iterations of 11g and R12 upgrade
• Applying Oracle Application and database patches (patch analysis and application using adpatch, opatch including CPU Patches) and schedule downtime for applying of patch
• Assignment of work distribution and Managing the shift in shift lead role.
• Work on Cloning, Patching and Tickets on Regular basis with Strict SLA’s.
• Support for 11i, R12 application and databases for Prod and non-prod.
• Working with VERITAS cluster for production databases.
• 11i Clones using Grid.
• Cloning using rapid clone using cold, hot and rman backups.
• Trouble shooting for concurrent manger, Apache and form issues for 11i and R12 instances.
• Performance tuning in Oracle Applications instances and other production DBs
• Attending CCB Calls, Performance calls weekly and Monthly basis.
• Creating Data source for E-business suite to SOA databases.
• Working SOA bounces for weekend activities.
• Weekly maintenance on production and Major Cut-over activities.
• Experienced in RAC administration (Srvctl, crsctl), applied application patches and RDBMS patches.
• Handled P1, P2 Service Requests with oracle.
• Create databases, table space monitoring, alert log, db activities, resolving long running issues.
• Ability to learn new technologies like fusion apps.
• Experience of managing multiple RDBMS on large systems
• Weekend scheduled activities like patching, re-org, bounces, code moves for Production.

Confidential, Louisville, KY

Oracle Application DBA

Environment: Oracle 10g and11g and Oracle Apps 11i.

Responsibilities:

• Applied HRMS Patches like High priority patches, mandatory patches and hrglobal patches to 11i.
• Applying minimum baseline patches as per recommended by oracle.
• Applying Oracle Application and database patches (patch analysis and application using adpatch)
• Clone and Patch Oracle applications (ERP) 11.5.10.2 instances
• Regular database backup activity using RMAN
• Participated on upgrade on 10g to 11g
• Started Unix Shell scripting for automating startup/shutdown of databases
• Worked on CORE DBA activities like installation, configuration, create database, alerting tablespaces and data file management, file system management, re-org, export, import
• Patch analysis and schedule downtime for applying of patch
• Upgrade forms patch set 18 to 19.
• Prepared process oriented documentation for patching process as well as streamlined the process.
• Applied Database and application security CPU patches for every quarterly as per recommended by oracle and applied using Ring master tool.
• Day to day activities and troubleshooting for issues.
• Worked on SSO, OID cloned instances after the clones.

Confidential, Burbank, CA

Oracle Application DBA

Environment: Oracle 9i/10g and Oracle Apps 11i.

Responsibilities:

• Support for prod and non - prod instances and troubleshooting all types of issues
• Worked on code migrations for non-prod and prod.
• Set up all sysadmin activities like user creation, assigning responsibilities, menus, functions, requests groups, request set,
• Patching and cloning and Managing Oracle Applications on 11.5.10.2 using adpatch, rapid clone
• Remedy Ticket solution for Oracle Application and database users
• Patch analysis and schedule downtime for applying of patch
• Maintained all documents of Oracle database operations. Prepared documentation of database backup and recovery standards.
• Worked on CORE DBA activities like installation, configuration, create database, alerting tablespaces and data file management, file system management, re-org, export, import.

Confidential

Team member (Oracle Application DBA)

Environment: Oracle 9i and Oracle Apps 11i, Oracle 10g RAC.

Responsibilities:

• Applying Oracle Application and database patches (patch analysis and application using adpatch and KINTANA)
• Experience on 9i to 10g upgrade and Fix upgradation issues in coordination with Oracle Support
• Implement Oracle Enterprise Manager (OEM) 10g Grid Control database.
• Support US/Europe instances.
• Cloning Oracle Application Instances to build Development, UAT and QA instances
• Created automated clone scripts for ASM instances to reduce manual intervention during cloning
• SSO registration, de-registration.
• Oracle Workflow Administration (Notification Mailer issues)
• Oracle Application System Administration (managing concurrent managers, user creation, creating responsibility, menu and functions, register new applications, managing profiles)
• Planning database and application outages for maintenance window
• Remedy Ticket solution for Oracle Application and database users
• Worked as Non-prod and tech support team.
• Worked closely with different teams to consolidate work
• Level 3 support for troubleshooting issues.
• Pro-active maintenance and looking after system health in production environments.
• Clone and Patch Oracle applications (ERP) 11.5.10.2 instances.
• Maintained all documents of Oracle database operations. Prepared documentation of database backup and recovery standards.

Confidential

Oracle Application DBA

Environment: Oracle 9i and Oracle Apps 11i.

Responsibilities:

• Patching, Cloning and other maintenance activities for 11i apps and 9i databases
• Cloning with cold backup and Oracle DB refreshes.
• Reduced the timelines of patching using features like defaults file, merge patch
• Multi Node installation & configuration of Oracle Applications
• Documenting & interacting with team for issues logged and monitoring system performance
• Worked on CORE DBA activities like installation, configuration, create database, alerting tablespaces and data file management, file system management, re-org, export, import.
• Creating Oracle databases, Managing users and security, database objects, such as tables, indexes, and views
• Monitoring and handling Concurrent Managers related issues. Monitoring DB processes activities at OS level using top, glance etc.
• Creation of menus, request groups and responsibilities.
• Registration of new Oracle Apps users and system printers.
• Compilation of custom forms and libraries on UNIX, LINUX environments
• Support functional and development teams for customization or development requirements.
• Single-node Install & Multi-node Install
• Assigning the Program to Concurrent Manager (scheduling).