SUMMARY

• Confidential has 9+ 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

ERP: E-Business Suite R12.2.3, 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, NY

Oracle Apps 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.
• 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 and STATSPACK.
• Reviewed the procedures and methods used to manage the staging and production data feeds all via materialized views (replication).
• Monitoring the Production Environment using Foglight and OEM Grid Control.
• Worked on web logic servers maintenance and trouble shooting.
• Automated several manual tasks from cron.
• 24x7 Production support of Oracle Applications Administration.
• Provided application support to users and created a log of all the problems with solutions for future reference.

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

Confidential, MA

Oracle Apps DBA/Oracle DBA

Responsibilities:

• Member of a team of 50 DBA’s, administering 40+ Clients taking owner ship of databases, problem analysis, resolution and escalation to Global DBA manager.
• Worked on implementing 11gR2 RAC database.
• Worked on Database and RAC upgrade from 10.2.0.4 to 11.2.0.3.
• Managing and Monitoring databases using Grid control.
• Performing Clonings and Database Refreshes
• Performing daily backups using rman
• Database and applications Performance issues.
• Installed and configured 10g Discoverer.
• 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
• Knowledge in 10gAS and self-service.
• Performing PRODUCTION maintenance activities during weekend.
• Experience in using FRA snaps (taking snaps and restoring snaps).
• Configured alerts for database and application monitoring.
• Purging unwanted log and out files and shrinking data files.
• Dataguard configuration and maintenance.
• Administering and maintaining Production Apps 11i and R12 instances, 24X7 Production Database Support and maintenance.
• Worked on table compression.
• Experience in using patch wizard.

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

Confidential

Oracle Applications DBA/Oracle DBA

Responsibilities:

• Responsible for day-to-day monitoring of Confidential EBS 11.5.10.2 production instance.
• Implemented performance tuning and streamlined the processes of monitoring and implemented pro-active alerts
• Cloning and troubleshooting of Production and test instances
• Patching the Application whenever needed.
• Managing and Troubleshooting the Oracle Application 11i.

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.
• Reactive issue resolution.
• 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.
• Working with Oracle Support for Bug fixes by raising TAR/SRs.
• 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.
• Applications of LAZZINS Patches.
• 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.