Oracle Manager

PRAVEEN KAARINGULA [pic]

Mobile: +244-********* E-mail:*.***********@*****.***

https://kpraveendba.blogspot.com

INFORMATION TECHNOLOGY PROFESSIONAL

Expertise in: Oracle DBA, Oracle Apps DBA, Linux Server Administrator.

Highly accomplished, deeply driven, Oracle DBA with a successful 5 years

track record of success in oracle database administration, database design,

performance optimization and object oriented analysis. Proven ability to

tackle and succeed in all endeavors from high-dollars business development

to customized software development and implementation. Handle multiple

assignments simultaneously and coordinate deliverable with key team member

in cross-functional groups.

Technology Snapshot: Oracle 10g & 11g, RAC, ASM Oracle E-Business-suite

(11i & R2), SQL, UNIX, Linux and Windows. Extensive use and knowledge of

Oracle databases running on multiple platforms such as: Linux, Red Hat

Enterprise Linux, UNIX, Windows.

SKILLS PROFILE:

Operating System: Oracle Enterprise Linux, RHEL, Windows 2008, Windows

XP/2000/NT/98/95

Tools / Utilities : TOAD, Exp/Imp, expdp/impdp, SQL *Loader, TKPROF,

Oracle Enterprise Manager grid control

Database : ORACLE 11g/10g/ on Oracle Enterprise Linux, RHEL and

Windows 2008 & 2003

RAC on Oracle Enterprise Linux, Oracle E-

business Suite Oracle Enterprise Linux.

High Availability : RAC, CRS, Grid Infrastructure, Automatic Storage

Management (ASM).

CAREER HIGHLIGHTS

Company: Noble Group LDA.

(Sept'2012 - Till Date)

Clients: Noble Group LDA, Sanco Geral, Brouti Group Limitada.(Luanda,

Angola)

Role: Oracle DBA / Oracle Linux Administrator.

Environment: Oracle 11gR2 & Windows Server 2008.

Noble Group is a large privately owned trading and distribution company

operating in Angola, Democratic Republic of Congo, Cameroon and Namibia and

is one of Central Africa Leading FMCG Company.

Real Application Cluster (11gR2) 2 node Implementation

< Architecting, planning, designing, developing, deploying and supporting

RAC/ASM environment

< Installing & configuring Oracle clusterware & Database Software

(Troubleshooting using cluvfy & handling common issues that arise during

integration of the whole - bugs, network issues, configuration files

issues, OCR issue, deinstallation & cleanup of clusterware)

< Implementation Oracle Grid Control 11g.

< Configuring and Administering Oracle 11g Automatic Storage

Management(ASM).

< Worked with customer for different RAC related issue:[RAC recovery, ASM,

OCR corruptions, Voting disk loss & so on]

< Troubleshoot performance issues for the RAC instances.

< Backup and Recovery issues related (loss of OCR, Voting Disk and Oracle

clusterware) & also issues with corruption of individual disk data

blocks, loss of OS configuration files, loss of net configuration files.

Also used the Merge backup for backing terabyte databases. Issues with

block change tracking & also flash recovery area.

< Resolved/Diagnose Node Eviction.

< Monitoring the Cluster services, ASM Instances and Oracle Instances.

< Health Check monitoring and trouble shoot ora errors.

< Sql tuning and trouble shoot the ADDM finding issue.

< Listener and tns issue between the 2 nodes and across workaround.

< RMAN backup and cron jobs.

Platform Migration with ASM standalone Server. (Implementation and Platform

Migration )

Oracle Linux Server Administrator: (Implementation)

< Installing & configuring Oracle Enterprise Linux for Oracle Database

Server with RAID Partition.

< Creating user accounts on application servers & internal application

tools, providing access to files on file servers.

< Create Groups and assign to the users and assigning file system

Permission.

< Install and uninstall Packages as per system requirement.

< Network configuration and I.P configuration.

< Stop / Start the Network services.

< Mount / Un mount the Disk and adding

< Troubleshooting issues with live production Linux servers.

< Create file systems for Oracle Database installation and daily

operations.

< Monitor network communication

< Password and identity management

< Resetting user passwords

< Lock/unlock user accounts

< Working with disk management & creating new Disk label and RAW disk for

ASM maintenance.

Oracle Database Automatic Storage Management (ASM) Standalone Server

< Installation, Configuration and Administration of Oracle 11g Automatic

Storage Management (ASM) Standalone Server .

< Creating Disk for ASM.

< Oracle 11gR2 Grid infrastructure software installation for ASM

configuration.

< ASM configuration with ASMCA and assign the ASM Disks group and Disk

members.

< Oracle Home Installation and for Standalone server.

< Oracle Database configuration with DBCA and ASM disk allocation.

< Disaster Recovery.

< Logical & Physical Database Design

< Installed and configured OEM Grid control and intensively used Diagnostic

& tuning packs along with AWR & ADDM reports Listener & TNS

configuration.

< Database Platform migration with Traditional Import and Export full

database.

< Sql tuning and Database performance monitoring.

< Oracle ASM performance monitoring with Oracle Enterprise Manager.

< Working with Oracle Enterprise Manager and performing daily activities.

< Working User sessions, Sql sessions and blocking session.

< Creating Index, Materialized Views and rebuild the Index.

< Database performance monitoring.

< Configure schedule backup with Oracle Enterprise Manager.

< Working with Impdp & Expdp Schema level, table level.

< Database Recovery, Tablespace recovery and Data file recovery.

< Maintaining Archive logs and deleting expired Archive log.

< Tablespace Point In Time Recovery (TPIT)

< Working with Flashback recovery.

< Implemented backup and recovery procedures (Cold/Hot backups, RMAN

Incremental backups & Import/Export)

< Working with schedule jobs with CRONTAB.

< Mail notification configuration.

Company: Reliance Communication Pvt Ltd.

(Sept'2010 - Sept'2012)

Role: Oracle Applications DBA. (Hyderabad, India)

Environment: Oracle Apps 11.5.10.2 & R12 and Oracle 9i,11g & Oracle

Enterprise Linux.

Reliance Communications is India's foremost and truly integrated

telecommunications service provider. The Company, with a customer base of

around 71 million including over 2 million individual overseas retail

customers, ranks among the Top 10 Telecom companies in the world by number

of customers in a single country. Reliance Communications corporate

clientele includes 2,100 Indian and multinational corporations, and over

800 global, regional and domestic carriers.

Key Responsibilities:

< Refresh of Databases, Cloning and Patching.

< Monitoring the Application services like Appache, Concurrent Manager,

Forms, Reports, Admin Server (Start/Stop).

< Comfortable in Cloning Instances from single node to Multi-node, Multi-

node to Multi-node using Rapid Clone utility.

< Used Oracle Application tools for maintaining database and application

like adpatch, adadmin, adctrl etc.

< Developed various scripts to automate the regular activities like start,

stop concurrent managers, cleanup log and report directories.

< Applied RDBMS patches using Opatch.

< Applied Patches using adpatch utility on Applications File system and

Technology stack

< Comfortable with enabling and Disabling of Maintaining Maintenance Mode

during Patching and Autoconfig.

< Applied Mini Packs, Family Packs and One-Off Patches.

< Responsible for day-to-day administration of various Oracle Applications

environments.

< Making table spaces available to users, adding data files to the table

spaces.

< Performed up gradation 10g to 11g & maintain the Snapshot information.

Company:- Orapundits Consulting Services.

(Jan'2010 - Aug'2010)

Role: Jr. Oracle Database Administrator (Hyderabad, India)

Environment: Oracle Database 10g & Oracle Enterprise Linux.

OraPundits is a fast growing Database Consulting Services Company in

Hyderabad, run by a team of experienced IT Professionals. Professional,

consistent, high quality, easy to work with. I have used DBA Consulting on

various projects of different sizes. The consistency and success rate is

second to none.

Key Responsibilities:

< Remote Database Support with remote tools with Team Viewer & Ammyy Admin.

< Installation of oracle software

< Database creation Oracle 10g.

< Trouble shooting the problems related to oracle database errors.

< Working with Listener & TNS Issues.

< Managing Of Tablespaces for Different User by Granting Quota on Default &

Temporary Tablespaces.

< Creating the Tablespaces and Add the new Datafiles.

< Monitoring Tablespaces Issues.

< Creating Users and Roles and Assigning Different Roles to Users and

Assign the Tablespaces.

< Plan and implements backup and recovery of the Oracle database. Taking

cold/hot backups using RMAN and ensuring that they are usable for future

recoveries.

< Working with third party Tool TOAD.

< Applying the RDBMS Patches with using Opatch Utility (TEST, SIT).

< Cloning with Hot backup / Cold backup PROD to TEST.

< Database Refresh.

Company:- APEX Coventage.

(July'2008 - Feb'2009)

Client: AT&T, USA. (Hyderabad, India)

Role: Oracle Applications DBA / Oracle DBA.

Environment: Oracle Apps 11.5.10.2 (11i) and Oracle 9i & Oracle Enterprise

Linux.

Apex CoVantage is comprised of four divisions: Content Solutions,

Engineering Solutions, Smart Grid Solutions, and Technology Products.

Apex's Content Solutions converts every conceivable form of paper-based and

born-digital content. Our current digitization projects include

digitization of journals, books, transcripts, catalog records, diaries,

personal papers, and written correspondence. The Content Solutions division

also provides imaging, OCR, copyediting, indexing, content creation, and

Knowledge Solutions services.

Key Responsibilities:

< Installation of 11.5.10.2.

< Copy/Clone of Oracle application environment using Rapid clone

< Monitoring the Application services like Appache, Concurrent Manager,

Forms, Reports, Admin Server (Start/Stop).

< User Access Administration.

< Used Oracle Application tools for maintaining database and application

like adpatch, adadmin, adctrl etc.

< Applied RDBMS patches using Opatch.

< Applied Patches using adpatch utility on Applications File system and

Technology stack.

< Comfortable with enabling and Disabling of Maintaining Maintenance Mode

during Patching and Autoconfig.

< Applied Mini Packs, Family Packs and One-Off Patches.

< Maintaining archived log files.

< Created Database instances for development, testing and production.

< Managing Concurrent Managers such as starting, stopping and

troubleshooting concurrent managers, re-schedule the requests, purging

the concurrent requests historical data, and monitoring of the concurrent

manager operations.

< Monitoring weekly/daily backups.

< Application user creation / responsibilities assignment.

< Database monitoring and Health Check.

< Tablespace and Datafile Monitoring.

< User Creation grants the roles and privileges.

< Working with Hot / Cold, Data pump and RMAN Backup

< Database refresh and Cloning

< Application closing for Development testing.

EDUCATION

B.TECH from Anwarul-uloom College of Engg & Tech (E.C.E), JNT University,

Hyderabad,2009

PERSONAL DETAILS

Date of Birth : 10th October 1987

Linguistic Abilities : English, Hindi, Telugu.

PASSPORT : Available

VISA : Sponsorship required.

I hereby declare that the information furnished above is authentic to the

best of my knowledge and belief.

Date :

Place : [pic]

Contact this candidate