Database Administrator Oracle

Rameswara Rao

Oracle Database Administrator

*********@*****.*** Mobile: + 234 815-***-****

Professional Summary :

Having 5 years of experience in Oracle Database Administration.

Well experienced in Installing and configuring the OEL6.5 and Oracle 12c/11g/10g database software

Familiar in Migration from windows to Oracle Enterprise Linux 6.5

Configured Data Guard (Physical standby) for the production environments and tested for fail over and switch over.

Acquired experience on Dbvisit product. It is alternate solution for Data guard.

Good experience in Toad, VMware Vsphere and Oracle vm. Troubleshoot the OS related issues and Database related issues.

Here more than 30 clients have been Migrated from windows to OELinux6.5 within 3years.

Experienced in taking regular off-line, online and logical Backups.

Checking alerts, alert log file, backup logs, trace files and make necessary actions to resolve the issues.

Enrolling users and maintaining system security and monitoring user access to the database.

Performing the backup of data bases using RMAN utility.

Monitoring the size of a table space and adding/resizing data files.

Having experience in database cloning and refresh and performing health checkups.

Applying RDBMS Patches using Opatch utility.

I have good knowledge on Oracle cloud technology.

Knowledge of various management tools and performance analysis

Good experience on Windows server (2003, 2008/R2, 2012).

Acquired experience on support, monitor and troubleshoot appropriately Oracle & MSSQL Server.

Installation and support Oracle application like forms and reports.

Work Experience :

Working as Database Administrator with Tolaram group pvt Ltd. Nigeria, Lagos from Sept-2013 to till date

As Database Administrator with SLK Software Service Pvt Ltd. India, Bangalore from Aug-2010 - Sept-2013

Educational Qualification :

B.E (Electronics and Communication) Engineering from Anna University, Chennai, INDIA, 2009

Skill Set :

Operating Systems: Windows 2003, Oracle Enterprise Linux 6.5

Languages: SQL/PLSQL

Database: Oracle10g,11g and 12C

Oracle Tools/Utilities: Data Pump, RMAN, Toad.

Technologies: Oracle DBA, Data Guard, Oracle VM,VMware vsphere

Project - I

Project Name: INDOMIE,NOBEL CORPET,HYPO,ARLA FOODS

Database: Oracle 11g, 10g,9i

Operating System: Oracle Enterprise Linux 6.5, windows 2003

Designation: Database Administrator

Duration: Sept -2013 to Till Date.

Roles & Responsibilities:

I have good experience Install and configure the OEL6.5 and Oracle 11g/10g database software

Familiar in Migration from windows to Oracle Enterprise Linux 6.5

Configured the physical standby database set up.

Migrated more than 10 servers from windows to Linux

Monitoring the database health check and growth of database, and monitoring alerts.

Creating users and assigning them roles and privileges in Database level.

Monitoring Cold, Hot and RMAN backup scripts of the databases supporting different applications

Providing *24/7 Support on Production Environment.

Project-II :

Project Name: Panabiz International,First Choice retail, VConnect.

Database: Oracle 9i & 10g

Operating System: Windows 2003,OE Linux 6.5

Designation: Sr. Oracle DBA

Duration: Sept- 2013 to Oct-2014

Description :

Checking Alert log, trace files, listener log and other database job logs.

User creation and providing necessary Roles, Privileges and quota..

Refreshing the dev/test databases from Production using export/import.

Checking for Fragmentation of tables and Indexes.

Maintaining the Cold and Hot backups of the databases.

Performing Logical backups using Export utility and recovering specific schema using Import utility.

Performed Database Cloning from Production to dev/test environment.

Installing, configuring and administering Oracle 10g /11g databases on Linux.

Done upgradation of databases from 10 to 11g.

Rebuilding Indexes periodically to gain optimal performance.

Providing *24/7 Support on Production Environment.

Project – III :

Project Name: BHN,Dufil,Power Oil,Minimie

Database: Oracle 10g, 9i

Operating System: Windows 2003, Linux

Job Roles :

Schema, Table, Database refreshes on demand for dev teams.

Maintaining the Cold and Hot backups of the databases.

Performing Logical backups using Export utility and recovering specific object or schema using Import utility.

Taking the Table spaces metadata backup by using RMAN

Configuring the RMAN in Catalog mode for taking the backups.

Cloning the databases for testing purpose.

Applying RDBMS Patches using Opatch utility.

Taking the Backup of the Production & Development Databases, based on business requirements

Checking Alert log file daily and cleaning the log files, alert log file and listener log files.

Checking for Fragmentation of tables and Indexes.

Testing the backup & recovery strategy.

Performed Database Cloning from Production to dev/test environment.

Contact this candidate