SUMMARY

• Having 10 years of professional experience in Oracle Apps Database Administration.
• Has experience in Administering Oracle Production Databases and Oracle Applications Administration on UNIX/Linux platforms as an Oracle Applications DBA/Oracle DBA.
• Oracle E - Business Suite administration EBS and database upgrades from multiple versions to the latest versions in multiple platforms.
• Oracle E-Business Suite administration EBS 11i, R 12 12.1 / 12.2 involving Oracle E-biz cloning, patching, user administration, application upgrades and troubleshooting developer, functional and business user issues.
• Oracle Database administration (installation, backup configuration using RMAN, applying security updates and bug fixes, upgrades, cloning and user administration) of 9i/10g/11g/12c on RAC and ASM with dataguard
• Experienced in Space Management, Query Tuning and Application Tuning Cloned Oracle applications R12 and Databases.
• Leading and Managing the offshore / On site model with 24 X 7 Production support.
• Experience of handling OLTP and DATAWAREHOUSING databases ranging up to 12 TB.
• Administering Concurrent Manager and Concurrent Requests.
• Backup configuration, monitoring and schedules using RMAN and Hot backups.
• Data Guard configuration and maintenance.
• Installation, Configuration, set up replication process and maintenance of Golden Gate.
• Upgrading database, RAC instances and E-Business Suite environments.
• Support of RAC and ASM databases.
• Security Administration.
• Strong database, application and development tool troubleshooting expertise. Experienced in logical and physical database design, modelling.
• Hands on database performance and instance tuning for both RAC and NON-RAC environments.
• Performance monitoring and tuning of Database.
• Automated several routine DBA tasks and schedule jobs in CRON.
• Proficient in using 11g/12c OEM Grid.
• Weblogic server maintenance and troubleshooting.
• Working with Oracle Support for Bug fixes by raising TAR/SRs.
• Excellent interpersonal, organizational, communication and analytical skills.
• Ability to work individually as well as in a team.

TECHNICAL SKILLS

OPERATING SYSTEMS: Windows 98, NT, 2000, UNIX, Sun Solaris, Red Hat Linux, IBM/AIX

ERP: E-Business Suite R12.2.4, R12.1.3, 11.5.10.2, 11.5.9.

DATABASE: 9i, 10g, 11g

DB Management: TOAD, OEM 11gR2/ 12c,, OEM.

Operating Systems: RHEL, Solaris 5.9/5.10, AIX 6.1/7.1, HP-UX, Windows

BI/Reporting tools: OBIEE 11.1.1.5

Tuning Tools: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ASH, ADDM, SQLT

Programming: UNIX shell Programming (Bourne, corn), SQL, PL/SQL, HTML

PROFESSIONAL EXPERIENCE

Confidential, Ft. Worth, TX

Oracle Apps DBA/Oracle DBA

Responsibilities:

• Upgraded the Applications from 11.5.10.2 to R12.2.4
• Upgraded the database from 11.2.0.2 to 11.2.0.4
• Worked extensively on concurrent programs tuning and database tuning.
• Applied patches using ADOP with different adop options
• Database and application Clones from Prod to Test environments
• Setup new Dataguard Environments, Managing and Monitoring and troubleshootingto resolve the issues.
• Implemented Auditing alerts for new user creation, Responsibility Assignment in controlled environment using PL/SQL.
• ImplementedOracle database backup & recovery solutions using RMAN.
• Extensive use ofOracle Data pumps Exports/Imports utilityfor moving data among the servers.
• Creating Application Users, Profiles, Responsibilities, Menus, Functions for the user.
• Analyzing the E-Business suite patches using Patch wizard.
• Database and Schema refreshes.
• Configuring Golden Gate and maintenance.
• Continuous Performance monitoring and Database Tuning and application using OEM.
• Worked on web logic servers maintenance and trouble shooting.
• Automated several manual tasks from crontab.
• Creating SRs and worked extensively with Oracle Support to resolve issues.
• Worked on Quarterly password changes.

Environment: Sun Solaris, Linux, IBM/AIX, Oracle 10g, 11g, Oracle Applications 11i, R12, Oracle Enterprise Manager 12c and RMAN.

Confidential

Oracle Apps DBA/Oracle DBA

Responsibilites:

• Application (E-Business Suit) upgrade from 12.1.2 to 12.1.3+.
• Database upgrade from 11.2.0.3 to 11.2.0.4.
• OEM 12c upgrade from 12.1.0.2 to 12.1.0.3.
• Installation of 11.2.0.4 GI (ASM standalone database)
• Application of application patches using adpatch.
• Application of HR global patches (PAY/PER Modules).
• Analysing, planning and applying of CPU patches released every quarter.
• Performing application and database clones up on request.
• Maintenance of Physical standby using Data Guard.
• Working on regular issues raised by users through BMC.
• Worked on Backup optimisations as per the client requirements.
• Performed DR test during the Annual BCP drill.
• Installation and configuration of OEM 12c OMS and it agents
• Setup OEM metrics to all the Environments through OEM.
• Worked on quarterly password changes.
• Preparing of all the metrics report related to service we do
• Migration of storage from older to faster disks
• Managing of ASM, its disks and disk groups and creating them as per Business Requirement.
• Performing of schema refreshes using datapump.
• Performing backup and recovery using RMAN.
• Experience in handling large RAC databases.
• Automated several routine tasks - Automating cold/hot backup, Monitoring scripts - tablespace alerts, validating backup and alerting DBAs in case of backup failures.
• Troubleshooting forms server, Apache server issues
• Performing PRODUCTION maintenance activities during weekend.
• Purging unwanted log and out files and shrinking data files..
• Experience in using patch wizard.

Environment: Linux, IBM/AIX,10g, 11g, Oracle Applications R12, Oracle Enterprise Manager 12C and RMAN.

Confidential, Brea CA

Oracle Applications DBA/Oracle DBA

Responsibilities:

• Administration and monitoring of RAC Databases and EBS application.
• Patch Application including Patch analysis using adpatch.
• Performing clone as per the requests using rapid clone.
• Managing and Monitoring of various databases using OEM 12c.
• Monitoring the Automated refresh of TRB instances daily.
• Working on Concurrent request issues which are submitted through Tidal.
• Backup and recovery using RMAN and hot as well as cold.
• Working on weekly schema refreshes using Datapump.
• Creating SRs and worked extensively with Oracle Support to resolve issues.
• Configuring database user, profiles and roles.
• Exposure of Automatic Storage Management (ASM)
• Supporting issues related to OBIEE DAC and Informatica.
• Working with Third party applications like clearorbit,vertex,webtogo.
• Active support to different teams based on Remedy ticketing tool.
• Attend regular PROD issues through REACT calls.
• Monitoring Standby databases regularly.
• Performing database Clones using RMAN on request.
• Worked on Quarterly password changes.

Environment: Linux, IBM/AIX, Oracle 9i,10g, 11g, Oracle Applications 11i,R12, Oracle Enterprise Manager, and RMAN.

Confidential, Madison, WI

Oracle Applications DBA/Oracle DBA

Responsibilities:

• Developed standards for directory structures on brand new UNIX boxes.
• Oracle Software Installation.
• Created a number of database instances for development, testing and production.
• Moved databases between machines.
• Attended the regular issues related to db/environment.
• Backup configuration, monitoring and schedules using RMAN and Hot backups.
• Involved in Production Database Upgradation from 9i to 10g.
• Data Guard configuration and maintenance.
• Documented tasks in coordination with onsite team.
• Regular database activities, backups monitoring, issues resolving.
• Created number of new schemas and maintained privileges.
• Performed number of schema refreshes from production to test to dev using exp/imp.
• Migrated databases between machines.
• Installed patch sets and upgraded Oracle (RDBMS).
• Support of RAC and ASM databases.
• New environment creation, configuration and maintenance.
• Cloning of Oracle Apps Databases/Environments.
• Reactive issue resolution.
• Troubleshooting all Oracle Apps Issues like Forms, Apache, CM, and Workflow.
• Patch application - Including thorough Patch analysis.
• Resolved configuration issues raised by development teams.
• Administration by using AD Utilities.
• Application of Quarterly release of Oracle Critical Patch Updates to Oracle Application Databases.
• Managing Oracle Applications user accounts.
• User account management - creating users, disabling users, responsibility management.
• Managing concurrent managers -ensure system is running smooth, monitoring throughput, watch for long runners.
• Installed Greek, Italy and Chinese languages in test, dev and production Apps database.
• Performed sysadmin tasks as per the requirement.
• Copying new forms, reports, custom code to production environment from Development.
• Worked on Oracle Apps Upgrade project from 11.5.9 to 11.5.10.2 and Brazil Localizations.
• Worked on password changes of apps, sys, system and specialized users every quarter in TEST, DEV and PROD.
• Documented tasks in coordination with onsite team.
• Decommission of Application instances.
• Installed new Product TOPS as per business requirement.
• Applied DST Patches (Day Light Saving Patches).
• Analysis and Application of quarterly CPU Patches in TEST, DEV and PROD instances.
• Workflow setup for the Application instances.
• Worked on J2EE and HTTP server application maintenance for DTC Project.
• Maintenance of Application server - Deployments, web server management, application management etc.

Environment: Sun Solaris 2.6, 2.7, Linux, IBM/AIX, HP TRU 64 and Oracle 8i,9i, 10g,Oracle Applications 11i, Oracle Enterprise Manager, RMAN.