PROFESSIONAL SUMMARY:

• Total 10+ years of experience in the IT industry of which i performed the role as asr. 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(HACMP).Oracle Applications database administrator skills:
• Over 10 years of Oracle Applications DBA experience in R12.2.6, R12.1.3, 11i (11.5.10/11.5.9 ) Financials, Retail 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.6.
• Oracle database upgrade from 10.2.0.4 to 11.2.0.3 &11.2.0.4 to 12c.
• Implemented DMZ setup in a multi-node architecture with Load balancing for products (iSupplier, iProcurement, Self-service HR etc.)
• 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.
• Installing and Configuring Oracle Retail 13.x.
• 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).
• 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 and Monitoring performance using AWR, SQLT, OEM Installing and managing third party software.
• 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 adop, 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 applyingCPU,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 Data Guard.
• 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, Atlanta - Georgia

Sr. Oracle Apps DBA

Responsibilities:

• Supported the client on 24*7 basis for Oracle ERP Applications and 2-node RAC databases.
• Implemented Disaster recovery solution for ERP Production.
• Performed production disaster recovery testing of EBS 12.2.5 for Business continuity
• Cloning 2-node Applications and 2-node RAC with ASM enabled.
• Applied application and database patches using Adop and Opatch utilities
• Day-to-Day maintenance activities and system administration tasks.
• Troubleshooting performance issues on database, applications and weblogic.
• 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, Chicago - Illinois

Sr. Oracle Apps DBA

Responsibilities:

• Implementation of Oracle e-business suite R12.2.5(Finance module) with 5 node application tier, 3 node internal and 2 node external DMZ with Load balancing on IBM AIX HACMP Machines..
• Creation of external application node in DMZ with reverse proxy for Oracle iSupplier, iProcurement and self-service HR.
• Implemented External DMZ node DR solution and successfully completed failover test.
• Cloning expertise on R12.2.5 multi-node architecture, 3 node internal and 2 node external applications.
• Used adop tool extensively as part of patch fixes for multiple development/functional issues.
• Implemented MWA services and dispatcher setup
• Worked with functional folks to resolve iProcurement punch out issues.
• Implemented RSYNC solution to maintain sync between Primary and DR Applications servers.
• Created backup strategy and maintained regular backups.
• 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 .

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.
• Implement and maintain oracle Retail 13.x.
• 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 ofapplicationsR12.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 oraclefinancials, 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.