PROFESSIONAL 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
• Over 10 years of Oracle Applications DBA experience in R12.2.6, R12.1.3, 11i (11.5.10/11.5.9 ) Financials, and Manufacturing, SCM, Inventory, Order Supply, Incentive Compensation, Healthcare, HRMS and Payroll applications install and upgrade.
• E-business suite applications upgrade from 11.5.10.2 to 12.1.1 to 12.1.3 & 12.1.3 to 12.2.0 to 12.2.5.
• Oracle database upgrade from 10.2.0.4 to 11.2.0.3 & 11.2.0.4 to 12c.
• 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).
• Install and setup WEBLOGIC server 11g(10.3.6), oracle application server and Websphere.
• Experience in Patching/Upgrade on WebLogic.
• Integrated Oracle Access Manager 11g, OID 10g/11g on WebLogic 11g with OHS 11g web server
• OBIEE 11g, ODI 11g, and OSB 11g integration with WLS and Oracle Fusion Middleware stack.
• OAM/OID/OHS/WebGate 11g LDAP implementations.
• Hands on experience in Oracle Identity Manager (OIM), Oracle Access Manager (OAM) & Oracle Internet Directory (OID)Support.
• Experience in supporting IBM DB2 LUW, Microsoft SQL Server, Mysql, Postgres, Cassandra, Mongo DB.
• Experience in oracle Demantra, Endeca and GRC with EBS.
• Configured DMZ setup, JDK upgrade, Monitoring performance using AWR, SQLT, OEM Installing and managing third party software.
• Configure, Maintaining and trobleshhing Exadata machines
• Experience in grid 11g/12c, Grid 12c upgradation.
• Extensive hands-on experience in setting up multiple clusters and implementing Load Balancing, High Availability and Failover functionality.
• 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, providing technical instructions for patch, application in various test, development and production instances & documenting the same.
• Have expertise in analyzing and applying CPU, PSU patches.
• As part of support I did evaluate, test, and work with the Infrastructure group to deploy HR/Payroll maintenance and security patches as required.
• Supported HRMS and applied all HRMS related patches.
• Experience in database installations like 9i, 10g, 11g & 12c.
• Working knowledge on shell/perl scripting.
• Hands on Experience in DR setup on UNIX cluster software HACMP and maintaining along with Oracle DataGuard..
• 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.
• Having support experience on 3rd party tools like Kofax Markview & Unitask printer.

PROFESSIONAL EXPERIENCE:

Confidential, Austin, Texas

Sr. Oracle Apps DBA

Responsibilities:

• Performing test Installation of e-business suite R12.2.6 with Oracle 12c
• Backup, Patching on day to day basis as per client requirement.
• Cloning of oracle applications and handing to functional team for testing purpose.
• Working closely with Techno-functional team and monitoring day to day code migrations.
• Troubleshooting installation issues and documenting the same by preparing a proper tid (tracing and diagnostics) for future reference.
• Working closely with oracle technical support team on service requests and getting speedy resolution/bug fixes.

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

Confidential

Sr. Oracle Apps DBA

Responsibilities:

• Supporting oracle OPC (open cloud) environments.
• Up gradation projects for multiple customers through oracle managed cloud services.
• Cloning instances for dry run purpose and doing multiple iterations.
• ADOP online patching(12.2.4, 12.2.5, 12.2.6).
• Supporting GRC, Endeca, Demantra instances.
• Administer all WebLogic servers, domains, clusters in all environments: Production and non-Production.
• Design and implement Oracle Fusion Middleware components for systems integration on WebLogic 11g and OAS 10g platforms.
• Integrated Oracle Access Manager(OAM) 11g, OID 10g/11g on WebLogic 11g with OHS 11g web server.
• Implement, Maintain, and Troubleshoot WebLogic SSL/LDAP integration with SSO (OSSO 11g).
• Troubleshooting e-business applications and database issues.
• Performance tuning Applications and Databases.
• Supported multiple architectures like multi-node, single-node.

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

Confidential

Sr. Oracle Applications DBA

Responsibilities:

• Implementation of applications R12.1.3, DB 11.2.0.4.
• 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.
• Specific Oracle Applications modules installed include AP, GL, AR, FA, PO, PA, QA, INV, OE/ONT, CM, HR/Payroll, I Procurement and OPM.
• 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.
• Experience in patching oracle financials, HRMS & Payroll.
• 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.

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

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

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

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.

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.

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.

Tools: SQL Developer, Putty, WinSCP etc.