TECHNICAL SKILLS

• Oracle 9i/10g/11g/12c 10g /11g RAC
• ASM 10g/11g Datagaurd
• Oracle 11i/R12 10g iAS LDAP
• OID
• 11g WLS 10g/11g/12c Grid Unix Scripting
• Solaris Linux AIX

PROFESSIONAL EXPERIENCE

Confidential

Technology: R12,11g, DG, OBIEE, Peoplesoft 8.4

Responsibilities:

• Closely work with Functional and Technical Team and fix the issue.
• Create custom top and assign the required responsibilities for application user.
• Ins Confidential tall, patch, configuration, fine tuning and maintenance of Oracle EBS R12.
• Configure workflow mailer. Troubleshoot workflow related issues.
• Implementation of Data Guard for database failover between Production and DR site, perform switchover activities.
• Audit trail functionality.
• Responsible for administrating R12 Application, Peoplesoft and OBIEE ETL job.
• Applied one - off and mini patches in 12.1.3 applications using adpatch.
• Cloning of EBS R12 for various environments.
• Providing Technical Support to Developers.
• Experienced in handling regular maintenance tasks like Purging Concurrent manager log files and Workflow.
• Experience in Managing Concurrent Managers.
• Worked with Oracle Applications AD Utilities like AD Administration, AD Controller, AD Merger Patch, Auto Patch and AD Relink etc.
• Monitoring and Troubleshooting of Apache, Conc. Manager, Forms and Database issues
• Knowledge in R12.2 ADOP patching and cloning
• Work with Oracle Support and Fix the Leak Connections issue in Oracle Application.

Confidential

System Analyst

Technology: R12,11i,11g,10g, Oracle Apex,11g Web logic (10.3),11g RAC & ASM, DG, 12c Grid

Platform: Linux

Responsibilities:

• Responsible for administrating 11i/R12 Applications, Single instance/Cluster databases, ASM, 10g Applications Server, 11g Weblogic and Physical & Snapshot standby database.
• Applied one-off, mini and family pack patches in 12.1.3 applications using adpatch. And Periodical Applications and Database refresh.
• Installation and Configuration of Oracle E-Business Suite R12 on Linux for Development box.
• Administrating OID, LDAP and SSO.
• Performed R12 apps Clone of 8 nodes Apps Tier and 3 node DB Tier.
• Upgraded Standalone Databases from 10g to 11g. also Performed Database upgrade from 11.2.0.2 to 11.2.0.4. and Applied Database Bug fixing and security Patches using OPatch Untility.
• Build 11g Physical Standby for Disaster Recovery.
• Performed 10g iAS Infrastructure installation. And setup for Database using LDAP to OID.
• Administration of Weblogic server and installation and configuration of Weblogic server.
• Experienced in handling regular maintenance tasks like Purging Concurrent manager log files.
• Involved in Various third party application’s oracle Database upgrade, Cloning and Refresh like SAP and Peoplesoft application databases.
• Well versed with adadmin, adpatch, adrelink, adctrl.
• Experience in forms, Apache load balancing, PCP for concurrent managers.
• Exposure in RAC to NON-RAC and RAC to RAC DB cloning.
• Cluster database Node addition and Deletion.
• Tuning expensive and long running SQL’s programs in Oracle Applications.
• Successfully done Oracle ASM diskgroup migration activity and Migrating an existing Non-ASM Database into ASM.
• Knowledge in Shared Application Environment.
• Successfully Migrate Database (10g-11g) from HP-UX server to Linux server.
• Complete implementation of DB and applications monitoring using Grid control 12c.

Confidential

Technology: R12, 9i, 10g, 11g, RMAN

Platform: AIX, Linux

Responsibilities:

• Performing daily health check on Databases as well as Oracle Application.
• Installation and Configuration of Oracle E-Business Suite 11i/R12 on Linux for Development, UAT, and Sandbox.
• Performed Oracle EBS upgrade from 12.1.1 to 12.1.3
• Configured Workflow and PCP Load balancing for R12 EBS.
• Worked in Concurrent manager and Long running concurrent request Issues.
• Experience in Oracle Applications R12 - System Administrator responsibility (creating users, creating responsibilities, using profiles, registering forms, reports, concurrent requests).
• Worked in Concurrent manager, Concurrent request, Application tuning and OAM
• Responsible for Database administration work like applying CPU patches, Interim patches for the single instance.
• Patch analysis using Patch Wizard and Applying Patches on test and productions.
• Schema Refresh using exp/imp and expdp/impdp.
• Oracle software installations using Binary Clone and Silent mode, Database creations, Managing Users, its Roles and security management.
• Monitoring tablespace growth and add spaces when necessary also done reorg to reclaim spaces.

Confidential

Sr. Database Administrator

Technology: R12,11i, 10g, 10g/11g RAC, 10g/11g RMAN, 11g GridPlatform: Solaris and AIX

Responsibilities:

• Responsible for administrating Multi Node 11i Applications, Single instance databases and administrating 10g/11g RAC database instances.
• Responsible for Database administration work like applying CPU patches, Interim patches for the single instance/11g RAC.
• Knowledge in setting up Application Load Balancing in RAC and Creating services using DBMS SERVICE
• Periodical Applications Refresh and Patching in 11.5.9 and 11.5.10.2 Instances.
• Performed Applications Periodical Password reset using FNDUSER
• Installation of Oracle Server/Client and Database Creation
• Installed 10g Grid management repository and agent for Grid Control
• Successfully done database upgrade 11.1.0.7 to 11.2.0.2
• Successfully implemented RMAN Backup and developed script to run Full/Inc Scheduled Backup.
• Performed Upgrade using Gold Image Binaries using Binary Clone.
• Schema Refresh using exp/imp and expdp/impdp
• Monitoring tablespace growth and add spaces when necessary also done reorg to reclaim spaces.
• Worked in Tivoli for RMAN and Hot Backup.

Confidential

Sr. Database Administrator

Technology: 11i, 9i,10g, 11g, 10g Physical Standby, 10g RMAN, 10g Grid

Platform: Solaris and AIX

Responsibilities:

• Successfully Migrate Database from Solaris server to AIX server.
• Successfully done database upgrade 10.2.0.4 to 10.2.0.5 .
• Involved in Various third party application’s oracle Database upgrade and Refresh like Peoplesoft application databases.
• Installed 9i,10g and 11g Oracle Server and Client
• Successfully performed database refresh in many Business Critical databases using Rman
• Schema refresh using expdp/impdp with Transport Tablespace option.
• Monitoring database using 10g Grid control during month end load and taken AWR, ASH, ADDM reports for analyze the performance issue.
• Build 10g Physical Standby database and monitor Primary and Standby synchronize. If not is in sync, take the SCN based incremental backup and roll forward the standby database.
• Performed yearly once COB test for all applications like Switchover and Failover using Flashback option.
• Well versed in dbv utility to find and eradicate block corruptions.
• Worked in Netbackup for RMAN and Hot Backup.
• Working Tablespace Space issues and and allocating tablespaces to users.
• Monitoring and taking care of Mount point issues.
• Monitoring sessions requested for any locks.
• Maintaining users security.