PROFILE:

• Having total 7+ years of experience in IT as Oracle DB administrator and 5 years as Oracle EBS.
• Energetically visualize and Implement tactical initiatives in DBA role.
• DB Core DB and HA Infrastructure Administration. Adopt Backup strategy
• Administration and Disaster Recovery Process for Database Environment.
• EBS Administration, Maintenance and Troubleshooting of EBS R12Administration Worked in Single and Multi Node Environment.

TECHNICAL SKILLS:

• Oracle 9i/10g/11g/12c 10g /11g RAC & ASM 10g/11g Datagaurd
• Oracle 11i/R12/R12.2 10g iAS LDAP, OID
• 11g WLS 10g/11g/12c Grid Unix Scripting
• Solaris/Linux/HP - UX AIX/Windows AWR,ASH,ADDM

PROFESSIONAL EXPERIENCE:

Confidential

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

Platform: Linux

Responsibilities:

• Working closely with Functional/ Technical and business operations team to ensure delivery of database/application services within the SLA's.
• Installation and configuration of Oracle Application of Oracle EBS R12 on Linux server.
• Create CUSTOM-TOP and assign the required responsibilities for application user.
• User account management - creating users, disabling users, responsibility management.
• Implementation of DMZ Configuration in EBS R12.1.
• Workflow Mailer Configuration and Resolving Workflow issues.
• Configured EBS DR for Single instance and Done the Switchover/DR Test.
• Audit trail functionality.
• Basic level administration skill for Peoplesoft application.
• Expertise in Patch management, cloning, code migrations, release management etc.
• OBIEE and Informatica Repository on Windows o/s.
• Managing concurrent managers - ensure system is running smooth, monitoring throughput, watch for long runners.
• Work with Oracle Support to provide technical assistance to users and troubleshoot and resolve application and database related problems.
• Fixed the Leak Connections issue in Oracle Application.

Confidential

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, Oracle ASM, 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 Cloning 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 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.
• Proficient in Oracle Weblogic server administration, setup and troubleshooting.
• Oracle software installations using Binary Clone and Silent mode, Database creations, Managing Users, its Roles and security management.
• Involved in Various third party application’s oracle Database upgrade, Cloning and Refresh like SAP and Peoplesoft application databases.
• Good experience in working with large size Databases of 20 Terra Byte size.
• 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.
• Troubleshooting all Oracle Apps Issues like Forms, Apache, Concurrent Managers.
• 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.
• Monitoring, Configuring All Databases, E-business Suite through OEM 12 cloud.

Confidential

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

Platform: AIX, Linux

Responsibilities:

• Performing daily health check on Oracle Databases.
• Sending Database health checkup report to client.
• Logical Backup using exp/imp and Data pump Utilities.
• Users, Tablespace, Data Objects and Space Administration.
• Analyzed AWR, ADDM and Explain Plan reports.
• Scheduling the monitoring scripts in Cronjobs and Finding and releasing DB lock.
• Writen/maintained OS level scripts for DB maintenance.
• Applyed patches on oracle single instance databases using Opatch Utility.
• Upgrade database from 11gR1 to 11gR2.
• Installation and configuration of Oracle RDBMS Software using DBCA & manual method.
• Regular database capacity planning related to database growth and system utilization, trend analysis, future database resource requirements.
• Analyze problematic SQL quires and provide the better solution to Developers.

Confidential

Technology: 11g,10g, 10g/11gR2 RAC, RMAN, 11g Grid

Platform: Solaris, AIX and Linux

Responsibilities:

• Responsible for administrating Single instance databases and 10g/11g RAC database instances.
• Responsible for Database administration work like applying CPU patches, Interim patches for the single instance and 11g RAC.
• Knowledge in setting up Application Load Balancing in RAC and Creating services using DBMS SERVICE
• Installation of Oracle Binaries/Oracle Client and Database Creation.
• Cluster database Node addition and Deletion and convert database from Single instance to RAC instance using manual and rconfig
• Installed 11g Grid management repository and agent for Grid Control.
• Successfully done database upgrade 11.1.0.7 to 11.2.0.2 .
• Refreshed RAC to Non-RAC environment using RMAN.
• Successfully implemented RMAN Backup and developed script
• Schema Refresh using exp/imp and expdp/impdp utilities.
• Successfully done cross platform migration using Transportable database.
• Configuration of TSM with Oracle RMAN.

Confidential

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

Platform: Solaris and AIX

Responsibilities:

• Day-to-day 24x7 mission critical production supports (incident, service and change requests) .
• Successfully done database upgrade 10g to 11gR1.
• Successfully Migrate Database from Solaris server to AIX server.
• Managing the daily / weekly scheduled jobs: Gathering statistics, Purging data etc.
• Assisting End-Users and fix their issues.
• Applied patches with adpatch and opatch utility for Prod and non-prod environments.
• Installation and Configuration of Oracle E-Business Suite R12 on Linux for Development Sever.
• Worked in Concurrent Manager and Long running concurrent request Issues.
• Experience in Oracle Applications 11i/R12 - System Administrator responsibility (creating users, creating responsibilities, using profiles, registering forms, reports, concurrent requests).
• 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 GAP.
• Performed yearly once COB Test for all Production Database's using Switchover and Failover/ Flashback option.
• Configuration of Netbackup with Oracle RMAN.
• Reorg the tablespace and File system and reclaim the OS level space.
• Monitoring and taking care of File system/Blocking sessions issues.