Recovery Manager Dba

NAVEEN KUMAR DARLA Email: *************@*****.***

Mobile: +91-630*******

Professional Summary:

3.9 years of IT experience as Apps DBA/ Oracle DBA in supporting, maintaining, patching and cloning of 12.1.3 and 12.2.5 Instances.

Strong skills in Oracle Applications R12.1 & R12.2, Oracle 11g/12C Database Administration including System Administration of Oracle Apps.

Having experience on R12.2 implementation.

Good Experience on R12.2 Patching

Upgraded database 11.2.0.3 to 12.1.0.2

Upgraded Application 12.2.0 to 12.2.5 Applied weblogicpatches .

Having good experience on R12.2 cloning.

Experience on weblogic as per pat of R12.2

Experience in Managing Concurrent Managers.

Extensive experience in Maintaining Single Node, Multi Node of Oracle ApplicationsR12.

Excellent experience in Oracle Applications Cloningusingrapidclone.

Cloned the instances using manual cloning method when needed.

Excellent experience in cloning from multi node to single node.

Excellent experience in Oracle Applications patching using adop&adpatch utility.

Administration of Oracle Applications using OAM &Sysadmin.

Experience in Cloning databases using RMAN.

Creating Users with restricted access with required Privileges.

Exporting and Importing database backups using Exp& Imp and Datapump utilities.

Working 24/7 in rotational shits .

Troubleshoot the issue as and when required.

Education Details:

•Graduation In BSC Computers from Sri KrishnaDevaraya University in 2018 year.

•Intermediate From Board of intermediate Education A.P.

•SSC From Sri Sharada Vidhyanikethan School.

Experience Summary:

Working with CGI from May 2018 – Till date

Technical Skills:

ERP

Oracle E-Business Suite

Tools

Toad, OEM, RMAN Export/Import, Data Pumps, AD Utilities, DBCA,putty.

Databases

Oracle 12C/11g,

R12.1.1,R12.1.3 & R12.2.5

Languages

SQL,PLSQL

Operating Systems

Linux, MS Windows 2003

Server,IBM-AIX

Environment : Oracle Applications R12.2.

Role : Oracle Applications DBA.

Responsibilities as Apps DBA :

Installation, Setup, Implementation, Customization & Product Support of Oracle Applications R12.2.

Upgraded application R12.2.0 to R12.2.4

Clone the application from production to non production.

Applied weblogic patches.

Installed 12C grid for monitoring database and applications.

Installation of Unix Flavours (Linux, Solaris) in view of Apps Requirements.

Patch applications to implement new features and bug fixes.

Registration and Configuration of Printers in Oracle Apps.

Refresh/Cloning of Oracle application environment using Rapid clone Multi Node And Single Node instances and it includes Multi Node to Single Node Refreshes as well.

When required Applying patches Using adop.

Used Oracle Application tools ADUTILITIES for maintaining database and application

Like adpatch, adadmin, adctrl etc.

Strong experience in Creating Users, Responsibilities, Menus and Form Functions.

Good Knowledge of Release 12i.

Extensive DBA experience in maintenance, development, Export/Import, Backup/Recovery.

Registering Concurrent Programs with Concurrent Managers, Registering of Reports and Creation of Additional Concurrent Managers and Maintenance.

Shell Scripts, SQL and PL/SQL scripts to manage administration tasks.

Day-to-day database and Oracle Apps maintenance tasks like checking alert logs, Analyzing tablespacemgtetc.

Performed Application admin tasks using ADADMIN utility.

Monitoring Oracle Database using OEM as well as from V$DBA Views.

Applying patches using distributed AD.

Using the AD utilities for maintaining the application systems (adpatch, adctrl, adadmin, adrelink).

Managing system configuration by using AutoConfig.

Taking Hot/Cold Backups.

Administration of Concurrent Managers and Concurrent Processing.

Upgraded Oracle e-business suite database from 11.2.0.3 to 12.1.0.2

Managing database security. Creating and assigning appropriate roles and privileges to usersdepending on the user activity.

Client: TNT

Environment : Oracle Applications 12.1.3

Role : Oracle Applications DBA.

Responsibilities:

Upgraded database 11.1.0.7 to 11.2.0.4

Checking alert log file on daily basis.

Daily health checks on production databases.

Applied patches using adpatch utility for resolving bug fixes and consuming new features.

Used Oracle Application tools for maintaining application like adpatch, adadmin, adctrl, adrelink etc.

Refreshed Oracle Applications from Production to Test, Dev instances using Rapid clone.

Setting up and managing Concurrent Managers.

Monitoring the concurrent processing manager status.

Performed SysAdmin functions like creating users, assigning/de-assigning responsibilities etc.

Performed log files check-up and regularly purging them.

Creation of database users and registering in oracle Apps.

Administration of concurrent managers and concurrent processing.

Monitored the applications and database status using OAM.

Running the scripts provided by developers if there is any deployment at Production side.

Create and manage users, privileges, profiles, schemas as per user request.

Working closely with Data reorganization, table partitioning for plane tables.

Managing of Table space for different databases by adding the space and allocated system storage and planned for Future storage requirements for the databases.

Utilized Oracle Enterprise Manager (OEM) to manage users, privileges, profiles, schemas.

Export and Import of database objects to copy from one database to another database.

Monitoring the database daily activities.

Created and implemented Oracle database backup and recovery strategies using RMAN.

Used Recovery Manager (RMAN) and Enterprise Manager for various maintenance tasks like backing up of database, restoration and recovery of database.

Contact this candidate