OBJECTIVE:

To work in challenging, responsible and demanding position as an Oracle Apps DBA position in a dynamic & sophisticated organization which can utilize my potential to its full extent and where opportunities exist for the growth of my career and personality

SUMMARY:

• Having 5 years of experience as an Oracle Apps DBA/Oracle DBA
• Implementation of EBS R12.2.0 oracle database Technology Stack 11gR2 Oracle Fusion Middleware 11gR1 web logic server 11g on RAC 11gr2 on RHEL 7.1 version 64 bits using Rapid Install utility by following Oracle Document ID.
• Worked on Oracle E - Business 11i/R12 database version 10gR2 & 11gR2 and Oracle Fusion Middleware 11g R1.
• Applied Patch on EBS R12.2.0 and Upgraded Application server from EBS R12.2.0 to R12.2.2.
• Upgraded of EBS from 12.2.2 to EBS 12.2.6 RDBMS 12.1.0.2.0 Oracle fusion middleware 11.1.1.9.0 oracle weblogic server (WLS) 11g by applying Database Patches and Application patches.
• Implementation and maintenance of RAC databases.
• Applied latest ETCChecker patch on database and application to list out bugs and patches to get applied.
• Installation of Oracle Database 10gR2, 11gR2 &12c with RAC.
• Install new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database.
• Applied Database patches (Intrim, CPU, PSU) on Database to maintain standards of Database as per Application.
• Troubleshoots problems regarding the databases, applications and development tools.
• Cloning of different versions of Database from prod to dev, test, education usage
• Managing Multi-node Oracle Apps EBS with RAC database.
• Backup and Recovery using RMAN and User managed backups (Hot, Cold & Logical).
• Administering and maintaining Oracle Application with AD utilities- adpatch, adadmin, adctrl, adclone, adrelink, etc.
• Periodically refreshing Oracle databases and Applications for business reasons.
• Intensive analytical & problem-solving skills, highly productive, Innovative (Team work/Individual).

TECHNICAL SKILLS:

Operating system known: Linux (RHEL & OEL)

Languages & RDBMS: Basic Sql queries, Oracle 10g, 11g, 12c Database Administrator.

EBS&ERP: Oracle Applications 11.5.10.2, R12.1.1/3, R12.2.0/2/6

Oracle Advance concepts: ASM, RMAN, RAC, Dataguard

PROFESSIONAL EXPERIENCE:

Confidential

Environment: Oracle EBS R12.1.3

• Maintaining and monitoring Oracle EBS R12.1.3 Oracle Fusion Middleware 11gR1, Application Server 10g Databases.
• Performing DBA activities such as Security Management, Space Management, User and Responsibility set-up, Performance Tuning & Monitoring, Concurrent Manager Monitor, defining printers, and setup Oracle Alerts/Auditing.
• Online Cloning and Offline Cloning of Production application & Database to test, dev.
• Creates and maintains all databases required for development, testing, education and production usage.
• Install new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database.
• Plans and implements backup and recovery of the Oracle database.
• Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
• Assists with impact analysis of any changes made to the database objects.
• Troubleshoots problems regarding the databases, applications and development tools.
• Troubleshooting Oracle Applications & Database performance Issues.
• Monitoring concurrent requests, kill concurrent request if it running for long time.
• Troubleshooting AutoConfig Issues monitoring log file generated at AutoConfig and fixing accordingly.
• Applying Patches on Application using adpatch utility.
• Troubleshooting patching issues like workers fails while applying patches, Using Adctrl while patching to monitor workers.
• Extensively using AD utilities like Adadmin, Adrelink, Adctrl, Adpatch, Autoconfig, Rapid clone etc.
• Registering New Concurrent Programs, Concurrent Types, Defining Work Shifts, and Specialization Rules, Defining New Concurrent Managers.
• Experience in registration and configuration of printers in Oracle EBS R12.
• Having Knowledge on WebLogic administration.

Confidential

Oracle Apps DBA/Oracle DBA

Environment: Oracle EBS R12.1.1 on RHEL x64

• Responsible for the maintenance of Oracle Application EBS R12 & 11i, Database administration of RAC, non RAC Databases, and Dynamics & Backup strategies.
• Upgraded Oracle EBS from 11i (11.5.10.2) to R12 (12.1.1) as team member.
• Upgraded Oracle database 9i (9.2.0.6) to 11g (11.1.0.7).
• Cloning the Applications using rapid cloning for testing purposes.
• Appling the Database and Application Patches.
• Patch analysis, applied patches and checked the patch impact.
• Merging of patches using admrgpch.
• Applied One-Off, Mini-Pack, Family-Pack and Maintenance patches.
• Cloning is done from prod to test and dev using rapid clone utility.
• Creating and Maintaining Custom Responsibilities, Menu’s and User Security.
• Backups and recoveries of Database and Application done with RMAN utility & user-managed.
• Managing passwords of apps and Product passwords using FNDCPASS.
• Monitoring and administrating with Oracle Applications Manager (OAM).
• Relinking of Oracle applications programs and regeneration of Oracle Forms and Reports.
• Troubleshooting Listener issues.
• Monitoring alert log file of application database daily if any issues then troubleshooting.
• Troubleshooting User Issues like concurrent request hanging, IE issues etc.
• Monitoring the Apache log files, concurrent manager log files, patch log files for application related issues
• Involved in on-call support on a rotating basis with other team members to support production systems environments.
• Export/import of schemas and tables from production to test/dev

Confidential

Jr. Oracle DBA

• Managing the daily scheduled jobs: Backups, refresh database (expdp & impdp).
• Monitoring db usage/load, space utilization, users sessions, locks.
• Applying Patches (Interim and Patchset) Using OPatch and OUI.
• Cloning the production db for testing, development and reporting purpose.
• Configuring and troubleshooting clients connectivity and connectivity related issues.
• Managing the user accounts, Troubleshooting users applications login.
• Providing Technical support to Production Environment and developers.
• Creating databases according to clients need by generating scripts or by Database Configuration Assistant (DBCA).
• Health Checks (Production Database status, Tablespaces Free Space, Backup status).
• Creating Users Profiles Granting specific Privileges and roles to the Users.
• Control File, Redo log File and Archive Log Maintenance.
• Tablespace & Data file creation and Maintenance by Adding and Resizing data file if needed.
• Cloning of database to different machine for testing purpose through RMAN or Manual.
• Database backups and recovery using RMAN and User managed backups (Hot & Cold).
• Installing and configuring Oracle NET on Server and Client machines.
• Gathering STATS for tables, indexes, schemas, database level.