SUMMARY

• Having 13 years of experience as Oracle Apps DBA (11i, R12 & R12.2) / Oracle DBA (9i, 10g, 11g & 12c) & Oracle Fusion Middleware DBA which includes Installation, upgrade, migration, System maintenance, Cloning, patching, user support, Trouble shooting, database design, Documentation, Performance tuning, Backup and Recovery, Space management and Integration of third party products. Providing 24x7 support of Production, Development & UAT environments on Various Platforms.
• Highly Experienced with Installation, Up - gradation, Cloning and Recovery of Oracle E-Business suite in RAC (ASM) and Non RAC (ASM).Applications administration from 11.5.10.2, R12.1.x and R12.2.4/5/6 and Oracle Database 9.2.0.7, 10.2.0.x, 11.2.0.x & 12.1.0.2
• Expertise in installation, configuration and administration of WebLogic 10.1.3.x and 10.3.6 11g in various environments
• Experienced in Planning, Installation, Physical and Logical Database Design, Backup and Recovery, Cloning, Refreshing Databases on Oracle Applications.
• Experienced in Performance tuning of Applications & database using Oracle OEM, ADDM, AWR, Statspack, Grid Control, Tkprof, Trace Analyzer, SQL scripts.
• Expertise in Maintenance, Patching, Cloning, Troubleshooting of Oracle Applications e-Business Suite.
• Expertise in Oracle applications e-Business Suite i.e., from 11.5.10.2 to 12.1.3; 12.1.1 to 12.1.3 & 12.1.3 to 12.2.4/5/6
• Performed Applications installations, migrations and upgrades of 11i, R12.1.x & R12.2.x (single node and multinode)
• Expertise in shared appltop application systems and configured BigIP to load balance mid-tiers Implemented Parallel Concurrent Processing to load balance CP tier.
• Expertise in integrated Oracle Applications 11i/R12 with OID/OAM SSO .
• Has extensively designed Disaster Recovery (DR) sites for various clients and have successfully conducted DR exercises / drills as part of recovery best practices.
• Experience in High Availability solutions with Oracle 10.2.0.4 /11.2.0.4 RAC, ASM and DATAGUARD.
• Performed Upgrade of Oracle Applications from 11.5.10.2 to R12.1.1
• Extensive knowledge on Oracle tools and utilities (Export, Import, SQL*Loader, PL/SQL, OEM, Data Load, SQL Expert, iSQLplus) in UNIX (Sun Solaris, AIX, HP-UX, Linux) & Windows environment.
• Has hands on experience in PL/SQL, UNIX Shell scripting.
• Worked independently to ensure that the databases and applications are operating efficiently and ensure proper backup and disaster recovery methods are maintained.
• Installed taxing software VERTEX on Weblogic Server 10.3.6.
• Performed Installation of Oracle Webcenter Imaging.
• Knowledgeable to design and Implement the Disaster Recovery Solutions.
• Maintaining SLA promptly, User level security implementation. Experience in implementing three-tier security architecture, Space Management, Memory Tuning and Application Tuning.
• SOX compliance, Create and Maintaining the Technical Notes and Documentation.
• Excellent communication, problem-solving and Client Management skills
• Coordinate with Offshore development team, Unix team, all other admin teams
• Ability to work independently and learn new concepts quickly. Open to work new modules and new technologies
• Experience in requirement gathering and working closely with Business Users.

TECHNICAL SKILLS

Operating Systems: Linux, IBM AIX, Solaris and Windows

Databases: Oracle 12.1.0.2, 11.2.0.3/11.2. x, 10.2.0.4/10.2. x and 9.2.0.7

Applications: EBS R12.2.5/6, R12.1.2/3 and 11.5.10.2

Weblogic: 10.1.3.x & 10.3.6

Tools: Autoconfig, Rapid Clone, Opatch, AD Utilities, RMAN, Export/Import, Putty, Winscp, VNC, SQL Loader, netca, netmgr, TKPROF, STATSPACK, Explain Plan and OEM, foglight, STAT. SVRMGR, SQL Plus, SQL*Net8 Assistant, SQL Loader, dbverify, tkprof, Utlbstat/Utlestat scripts, STATSPACK, Opatch, Oracle Diagnostics Pack, AD Utilities, Oracle Applications Manager (OAM), Oracle Enterprise manager (OEM), Discoverer, Quest Software (TOAD), GoldenGate, Oracle Exadata, Kintana, Telnet, X-windows clients such as X-Win32, VNC, Xvfb and X-terminal. Virtual Network Computing with pcANYWHERE, WinVNC, 170 Systems (Markview), XIGN Agent, STR Fax Manager, Applimation, Humming Bird (EXCEED), WRQ Reflection, Putty, Oracle ADI (Applications Desktop Integrator 7.2.0. Bit).)loftware, Hudson.

PROFESSIONAL EXPERIENCE

Confidential, Blue Ash, Ohio

Sr. Oracle Apps DBA

Environment: oracle applications 12.2.5 on IBM AIX Power systems with Database 12.1.0.2 and Oracle Database 11.2.0.4 & 12.1.0.2

Responsibilities:

• Implementation of Oracle E-Business Suite - supplier hub 12.2.5 and Oracle Databases 12.1.0.2 with GRID ASM file system.
• Implementation of the SSL in Oracle E-Business Suite on Internal and External Tiers.
• Installation of Oracle Access Manager / Single Sign On.
• Integrated Oracle E-business Suite 12.2.5 with OID/OAM.
• Upgraded Oracle E-business Suite from R12.2.5 to R12.2.6.
• Workflow Notification mailer setup for the Supplier Hub in EBS.
• Resolved workflow related issues for inbound and outbound in EBS
• Implementation of Oracle Databases on AIX power systems.
• Implementation done for the EDQ Oracle Enterprise Data Quality on Weblogic server & Integrated Oracle Watchlist to EDQ.
• Configuring WebLogic Servers in a clustered environment.
• Integrated SOA REST services with Oracle EBS.
• Troubleshooting WebLogic situations and finding solutions where necessary.
• Deploying custom code in to the Oracle E-Business Suite.
• Restored Oracle databases from tapes as per the client requirement.
• Supporting and monitoring for RAC and Non-RAC Oracle applications.
• Expertise in Active Clone of Oracle Databases online clone
• Support to the production, Development and Test instances.
• Analysed and Applied latest CPU patches.
• Oracle applications upgrade from 12.2.0 to 12.2.5 and 12.2.5 to 12.2.6.
• Monitoring Table spaces, Disks spaces, Concurrent Managers, locks, invalids in database with shell scripts.
• Monitoring of long running jobs on the oracle applications with shell scripts.
• Installed OEM and configured alerts for databases.
• Configured RMAN backups in Oracle Databases.
• Monitoring backup jobs, oracle database and applications services. DB Backups are done using Tivoli
• Expertise in patching using Opatch, ADOP and weblogic patches.
• Managing passwords of oracle products and schemas using FNDCPASS.
• Validating the requests against SOX processes.
• Created concurrent managers as per client requirement and for existing concurrent managers changed sleep time and priority.
• Printer issues and setups done in Oracle applications.

Confidential, West Allis, Wisconsin

Sr. Oracle Apps DBA

Environment: oracle applications 12.2.4/5, 12.1.3(RAC) on Linux 6 and 11.5.10.2 on HP-UX 11.31 with Database 11.2.0.4 and Oracle Database 10.2.0.5, 11.2.0.4 & 12c.

Responsibilities:

• Upgraded Oracle applications from 12.1.3 to 12.2.4
• Used ADOP tool for applying patches on 12.2
• Integrated OAM / OID SSO in EBS 12.2 & 12.1.3
• Installed OBIEE and integrate it with OAM.
• Supporting for Oracle Fusion Middleware Components. WebLogic server, OAM, SOA, OBIEE, BPEL .
• Integrated EBS with Discoverer.
• Resolved workflow related issues for inbound and outbound in EBS
• Supporting printer using the loftware.
• Implementation of the weblogic 11g (10.3.6.0)
• Configuring WebLogic Servers in a clustered environment.
• Troubleshooting WebLogic situations and finding solutions where necessary.
• Deploying the applications in weblogic server.
• Basic knowledge on OTM (Oracle Transport Management).
• Implementation done for the Oracle Applications with RAC environment.
• Restored Oracle databases from tapes as per the client requirement.
• Supporting and monitoring for RAC and Non-RAC Oracle applications.
• Expertise in Active Clone of Oracle Databases online clone
• Handling tickets for the support to the production, Development and Test instances through JIRA ticketing tool.
• Analysed and Applied latest CPU patches.
• Code migrations done using Hudson tool.
• Monitoring Table spaces, Disks spaces, port availability, Concurrent Managers, locks, invalids.
• Installed OEM and configured alerts for databases.
• Monitoring backup jobs, oracle database and applications services. DB Backups are done using Tivoli
• Expertise in patching using Opatch and AD patch.
• Managing passwords of oracle products and schemas using FNDCPASS.
• Validating the requests against SOX processes.
• Created concurrent managers as per client requirement and for existing concurrent managers changed sleep time and priority.
• Printer issues and setups done in Oracle applications.

Confidential, Hoboken, New Jersey

Sr. Oracle Apps DBA

Environment: oracle applications 12.2.4/5 12.1.3 (RAC) and 11.5.10.2 on Solaris & Linux with Database 11.2.0.3

Responsibilities:

• Upgraded Oracle applications from 12.1.3 to 12.2.4
• Used ADOP tool for applying patches on 12.2
• Implementation of the weblogic 11g (10.3.6.0)
• Configuring WebLogic Servers in a clustered environment.
• Troubleshooting WebLogic situations and finding solutions where necessary.
• Deploying the applications in weblogic server.
• Installation of the OHS for weblogic servers.
• Implementation done for the Oracle Applications with RAC environment.
• Supporting and monitoring for RAC and Non-RAC Oracle applications.
• Handling tickets for the support to the production, Development and Test instances through service desk tool.
• Analysed and Applied latest CPU patches.
• Installation and troubleshooting of Markview.
• Monitoring Table spaces, Disks spaces, port availability, Concurrent Managers, locks, invalids through foglight and manual scripts.
• Added custom top to Oracle applications R12.
• Monitoring backup jobs, oracle database and applications services.
• Good knowledge in patching using Opatch and AD patch.
• Installation of Oracle Webcenter Imaging with OCS team.
• Experienced in installation of Oracle Fusion Middleware OBIEE, BPEL, SOA, Webcenter Imaging, OAM, Weblogic server .
• Managing passwords of oracle products and schemas using FNDCPASS.
• Validating the requests against SOX processes.
• Created concurrent managers as per client requirement and for existing concurrent managers changed sleep time and priority.
• Printer issues and setups in Oracle applications.
• For File transfers created ssh connection between the servers.
• P2p certificate installations in R12.
• Configured SSL in oracle applications.
• Involved in developing a disaster recovery (DR) plan for Oracle Applications 11i/R12 and successfully executed DR test.
• Responsible for analyze and apply application patches eg (CPU) & database pachtes.
• Performed jar files, forms, flex fields, messages files generation, compiling invalids of apps schema and jsp’s and clearing cache in application server as post patch steps.
• Performed research for patches for specific problems.
• Oracle Applications Cloning done for the Test, Dev, SIT env’s.
• Configured RMAN Scripts for the backups with using catalog database.
• Installation of taxing software VERTEX (o- series), on weblogic Domain.
• Installation of monitoring tool FOGLIGHT for all EBS and Databases
• Registering the new Forms, Reports, PL/SQL scripts as concurrent programs.
• Monitoring tablespace usages using foglight tool and manual scripts.
• Database performance tuning using STATSPACK, TKPROF, SQL Trace, Explain Plan.
• Compiling forms/pll’s, DB invalids, creating DB links
• Upgraded Databases from 11.2.0.2 to 11.2.0.4 for test, development environments.
• UNIX Shell scripting to simplify the day to day activities and monitoring of database and applications.
• Have basic knowledge of Revenue Management and Billing (deployments).
• Upgraded oracle applications database from 10.2.0.4 to 11.2.0.3.3
• Integrated applications with SSO (OAM, OID).
• Implementation of 12.1.3 done on RAC with ASM.

Confidential

Sr. Oracle Apps DBA

Environment: oracle applications 12.1.2 and DB version 11.1.0.7 on hp ux itanium 11.31Location: Bangalore, India.

Responsibilities:

• Implementation done on dev, test & PROD server (oracle applications R12).
• Involved in implementation of production server (oracle applications R12 with ASM & RAC).
• RMAN backups automated in TEST and PRODUCTION.
• Giving support core DBA activities to the windows based oracle databases (oracle 10g).
• Monitoring database alert log for oracle errors in all the databases.
• Created db link from oracle 11g to MS SQL database on request of users to get the data from MS Sql database.
• Configured notification mailer in production (SMTP).
• Have basic knowledge on Datagurad.
• Created custom concurrent managers & assigned responsibilities to the users as per client requirement.
• Added custom top to Oracle applications R12.
• Upgraded oracle database of windows based from 9.2.0.8 to 10.2.0.1.
• Supporting for financial users of R12, compiling forms, moving reports to destination servers.
• Responsible for applying application patches & database pachtes.
• Cloning done for oracle databases and oracle applications R12.
• Configured RMAN in oracle database 10g (windows) and oracle applications R12 (HP UX).
• Monitoring table spaces for space usage and adding required space whenever it reaches threshold, monitoring alert log for errors.
• Create db links for users to access from test to production i.e., from RAC to non - RAC.
• Implementation done for the third party software PGP for encrypting and decrypting files and written shell scripts to encrypt and decrypt which concurrent programs will use.
• Implementation done for RMS (Revenue management Service) on Linux servers with Oracle 11gR2 RAC.

Confidential

Sr. Oracle Apps DBA / Oracle core DBA

Environment: is 11.5.10.2 on Solaris 10, using sun tools like service desk, control point.

Responsibilities:

• Handling tickets for the support to the production, Development and Test instances through service desk tool.
• Monitoring Table spaces, Disks spaces, port availability, Concurrent Managers, locks, invalids through Control point tool.
• Monitoring backup jobs, oracle database and applications services.
• Monitoring database alert log for oracle errors.
• Having knowledge on RAC, ASM, and CRS.
• Cloning the databases for test instances.
• Monitoring Application system with Oracle Application Manager.
• Good knowledge in patching using Opatch and AD patch.
• Managing passwords of oracle products and schemas using FNDCPASS.
• Performed jar files, forms, flex fields, messages files generation, compiling invalids of apps schema and jsp’s and clearing cache in application server as post patch steps.
• Performed research for patches for specific problems and downloaded patches.
• Done merging of patches of different languages (MLS patches), and applied in alpha, beta environment and in production.
• Created concurrent managers as per client requirement and for existing concurrent managers changed sleep time and priority.
• Assigning responsibilities to the users as per client requirement.
• Using Oracle Diagnostic Tool in oracle applications and uploaded to Oracle Support as per client’s requirement.
• Responsibilities related to AD utilities like AD admin, AD relink, AD splice, AD patch, AD ctrl, AD merge, AD ident & Auto config.
• Daily backups took using RMAN through CRON jobs.
• Ran Diagnostics Tool and uploaded to Oracle Support as per user request.
• Raised SR’s to resolve new issues and interacting with support team for fixing new issues.
• Done applications services bouncing and apache bouncing as per user requirement.
• Done upgradation oracle applications DB 10.2.0.3 to 10.2.0.4
• Involved in Integration of SSO & Discoverer in Oracle applications 11i.
• Done DB Manual RMAN cloning.
• Involved in up gradation of oracle applications from 11i to 12i.
• Switching of archive log destinations, if archive destination is full.
• Applied patches in multinode environment and shared file system.
• Cloning of oracle applications in test instances from beta environments using rapid clone.
• Involved in the up gradation of oracle applications from 11. .5.10 CU2.
• Having knowledge on oracle applications 12i.

Confidential

Oracle Apps DBA / Oracle Core DBA

Environment: is 11.5.10.2 on Linux AS 4.0.

Responsibilities:

• Monitoring Application system with Oracle Application Manager.
• Installation of Oracle Applications (11.5.10 & 11.5.10.2).
• Installation of oracle applications 11i on single node and multi node.
• Taking logical backups and physical backups.
• Having good knowledge on database architecture.
• Monitoring table spaces for space usage and adding required space whenever it reaches threshold, monitoring alert log for errors.
• Cloning oracle applications to test instances.
• Monitoring Concurrent Managers and troubleshooting.
• Assigning Responsibilities to the users.
• Applied RDBMS patches and application patches.

Confidential

Oracle Apps DBA / Oracle Core DBA

Environment: is 11.5.10.2 on Linux AS 4.0.

Responsibilities:

• Installed oracle 9i on Linux AS 3.0 and oracle 10g on Linux AS 4.0 for test instances.
• Recovery of data files in Archive log mode and no archive log mode.
• Compiling Forms / Pll’s, generating message files in Applications.
• Have knowledge on RMAN Configuration.
• Cloning the Oracle apps instances (scheduled or on-demand) from prod to test using rapid cloning.
• Responsibilities related to AD Utilities like adadmin, adpatch, adctrl, adrelink.
• Analysing the schemas / objects and collected statistics.
• Monitoring the mount points for the threshold value, and resolving the issues accordingly.
• Changed test instance from no archive log mode to archive log mode.
• Having knowledge in application level tuning (Tk-prof and Explain plan).
• Upgrading of database from 9i to 10g using DBUA.
• Having knowledge on Datagaurd.

Confidential

Oracle DBA

Environment: Oracle 9i on Solaris 9

Responsibilities:

• Monitoring Table spaces, Disks spaces, port availability, locks & invalids.
• Monitoring backup jobs, oracle database.
• Monitoring database alert log for oracle errors.
• Creating users, table spaces, tables and indexes as per requirement.
• Cloning the databases for test instances.
• Good knowledge in patching using Opatch.