SUMMARY:

• Total 10 years of experience in the IT industry of which i performed the role as a sr. oracle application database administrator.
• Strong analytical and troubleshooting skills.
• Having experience in oracle application full life cycle implementations, QA/DEV/TEST/UAT /PROD and post go - live support.
• Excellent interpersonal skills in addition to excellent communication and strong team spirit.
• Worked on multiple operating systems like Linux, Windows, Sun Solaris, HP-UX & IBM-Aix

EXPERTISE AREA:

• Experienced working in environments like 11i, R12& 12.2 installing, configuring, administering and upgrading Oracle.
• Applications ERP R12.2, 12.1.3 & 11i in a Multi-tier architecture.
• Applications upgrade from 12.1.3 to 12.2.
• Database upgrade from 11..2.0.4 to 12c
• E-business suite up-gradation from 11.5.10.2 to 12.1.1 to 12.1.3.
• Experience in oracle applications cloning, multi-node to multi-node, multi-node to single-node.
• Experience on database Instances and cluster databases in RAC(real application clusters) environment.
• Support experience on oracle OPC(oracle open cloud) environments.
• Expertise in adop(R12.2) patching cycle.
• Experience in oracle enterprise SSO(single sign-on).
• Worked on oracle WEBLOGIC server 11g(10.3.6).
• Experience in oracle Demantra, Endeca and GRC.
• Hands on experience with SYSADMIN tasks like workflow mailer, creating users, adding responsibility, creating menu, monitoring concurrent managers, profile options, creating concurrent program etc.
• Extensively used oracle applications AD utilities like adconfig, adadmin, adpatch, adctrl, adsplice etc.
• Securing oracle applications by periodically changing APPS and schema password using FNDCPASS.
• Troubleshooting apps components like forms, apache and concurrent managers.
• Managing system configuration by using AUTOCONFIG.
• Patch analysis and application in various test, development and production instances & documenting the same.
• Technical instructions for patch application.
• Experience in database installations like 9i, 10g, 11g & 12c.
• Worked thoroughly on database backups/restore methodologies including: RMAN, hot and cold backups.
• Experience in export, import & data pumps.
• Database maintenances like create, modify, and drop schema objects.
• Tracking invalid objects, compiling and validating the invalid objects
• Created and maintained database users and Roles.
• Experience in database patching & cloning(rman duplicate).
• Refreshing development/test database from production.
• Experience in upgrading database from 10.2.0.4 to 11.2.0.3.
• Ability to grasp new technologies quickly and adapt to the same.
• Having support experience on 3rd party tools like Markview.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Oracle Apps DBA

Responsibilities:

• Supporting oracle OPC (open cloud) environments.
• Up gradation projects for multiple customers through Confidential .
• Cloning instances for dry run purpose and doing multiple iterations.
• ADOP online patching(12.2.2, 12.2.4, 12.2.6)
• Supporting GRC instances
• Supporting Endeca
• Supporting Demantra
• Troubleshooting e-business applications and database issues.
• Performance tuning
• Supported multiple architectures like multi-node, single-node.

Technologies: e-business suite R12.2.4, R12, 11i & database 12c, 11g, 10g

Tools: SQL Developer, Toad, Putty, WinSCP, Filezilla etc.

Key Achievements: up-gradation and go-live support (12.1.3, 12.2.2 & 12.2.4), (database 11g & 12c)

Confidential

Sr. Oracle Applications DBA

Responsibilities:

• Implementation of 12.1.3
• Responsible for providing 24x7 oracle apps dba support for multiple large databases in production and non-production environments.
• Managed a DBA team for development and production support which includes performance tuning, request for change tickets and Approval for patching and instance maintenance.
• Database management - backup, & recovery, performance tuning, configuration of database, table space administration and user management.
• Applying patches, mini-packs, family-packs and maintenance packs, upgrades, multi-tier installations, automatic routines apps dba task, periodic refreshes, oracle support dealing with functional, developers and end users.
• Production support of oracle applications ERP 12.1.3, cloning, patching and maintenance of instances.
• Creating custom concurrent managers and assigning work shifts to it, finding long running requests and troubleshooting.
• Troubleshooting problems with web server, web listener, workflow, forms server, and concurrent managers, and database.
• Creating similar production environment for development and test using adclone & rapid clone method and data refreshed using RMAN backup for RAC to non RAC instance.

ENVIRONMENT:

Technologies: e-business suite: R12.1.3, 11.5.10.2 & database: 11.2.0.3, 10.2.0.6

Tools: SQL Developer, Toad, Putty, WinSCP, Filezilla etc.

Key Achievements: e-business suite implementation 12.1.3 with 11.2.0.4 database and production support.

Confidential

Sr. Oracle Apps DBA

Responsibilities:

• Migrated 11.5.10.2 e-business suite to 12.1.3 through cross platform methodology.
• Migrated database from 10.2.0.6 to 11.2.0.3 through export and import.
• Post upgrade support.
• Resolving day to day issues.
• Patching (ad patch& opatch) in various instances.
• Cloning applications from production to test environment as part of dry run before go-live.
• Setting up unitask print director.
• Day to day code migrations on PROD & Non-PROD.
• Supported multiple architectures like multi-node, single-node.
• Worked on RAC and ASM

Technologies: e-business suite: R12. 1.3, 11i& database: 11g, 10g.

Tools: SQL Developer, Toad, Putty, WinSCP, Filezilla etc.

Key Achievements: Cross-platform (linux to solaris sparc 10 servers) e-business suite upgrade from 11.5.10.2 to 12.1.1 to 12.1.3 & database 10.2.0.6 to 11.2.0.3.

Confidential

Oracle Apps DBA

Responsibilities:

• Responsible for the support and maintenance of the multiple oracle databases and applications in high availability (24*7) heterogeneous environment
• Supporting day-to-day maintenance activities like resolving issues (form, report, discover etc) startup/shutdown, changing passwords of system, users & oracle etc both in application and database side (both RAC & Non-RAC Instance).
• E-business R12.1.1 installation.
• Using ad-utilities like adadmin, adpatch, adctrl.
• Applying patches and cloning instances.
• Maintaining and administering application users.
• Support and monitor oracle application instances.
• Monitoring concurrent manager & its operations like starting, stopping the concurrent managers.
• Performed tracing for various user sessions and for various concurrent programs.
• Maintenance tasks like purging concurrent manager log files, gather schema statistics
• Managing workflow and its components through OAM
• Performed database patching and cloning
• Allocating system storage and planning future storage requirements for all database systems.
• Manage user accounts and groups, database security using roles and database audit.

Technologies: e-business suite: R12.1.1, 11i & database: 11g, 10g

Tools: SQL Developer, Toad, Putty, WinSCP, Filezilla etc.

Confidential

Oracle Apps DBA

Responsibilities:

• Working with the various development teams very closely to maintain 24/7 production environment support.
• Performing daily health checks.
• Cloning with online and offline backups.
• Monitoring the mount point size limits and taking necessary actions if requires.
• Generate applications files tasks (generate applications files menu, message files, form files, report files and product jar files).
• Analyzing and applying appropriate patches as and when required.
• Creating new users, assigning responsibility using system administrator responsibility.
• Compiling invalid objects (manually and also using adadmin).
• Using ad-utilities like adadmin, adpatch, adctrl.
• Relink/rebuild/regenerate/recompile all oracle apps objects.
• Experience in managing concurrent managers, concurrent programs and defining custom managers to run
• Specific type of requests and enhance the performance.
• Taking hot, cold and rman database backup including whole database backup, control file backup, archive log backup.
• Created new user accounts, profiles, roles and privileges
• Interact with oracle support for technical assistance requests
• Monitoring tablespaces for space usage and adding required space whenever it reaches threshold.

Technologies: e-business suite: 11i& database: 10g, 9i

Tools: SQL Developer, Putty, WinSCP etc.

Confidential

Oracle Apps DBA

Responsibilities:

• Monitoring tablespaces for space usage and adding required space whenever it reaches threshold.
• Supporting development teams, general troubleshooting & support in administration of product & test instances
• Monitoring, identifying and resolving user issues.
• Compiling and validating the invalid objects
• Report and resolve all serious oracle alert log messages, monitor diagnostic and trace files. 
• Database monitoring, maintenance and backups
• Analyzing and applying appropriate patches as and when required.
• Automatic database backup procedures using cold, hot and rman backup strategies as well as using oracle export utility.
• Interact with oracle support for technical assistance requests
• Involved in hot & cold backup cloning.
• Involved in 9i to 10g upgradations.

Technologies: e-business suite: 11i & database: 10g, 9i

Tools: Putty, WinSCP etc.