Oracle Database

Email:***********@*****.***

Naresh Marka Mobile:+91-967*******

Summary

Over 2.5 plus Years of experience in database administration as an Oracle DBA. Having good knowledge on RAC.

Oracle Database Administration on 24x7 production and large databases using Oracle 10g, 11g

Excellent experience in Installation and configuration of Oracle10g/11g on OS environments UNIX/LINUX.

Experienced in regular Database Administration activities such as Upgrades, Patches, Backup and Recovery, Performance Tuning.

Experienced in using 11g features Data Pump, Flash-Back Recovery.

Effective troubleshooting of database and performance problems.

Experience with Logical and Physical backups.

Managing Database Structure, Storage Allocation, Table/Index segments, and Rollback segments, Database Access, Roles and Privileges

Backup of Databases - Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.

Recovery of Databases - Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, recovering from Block Corruption etc.

Performed backups and tested crash recoveries using conventional hot & cold backups with RMAN.

Experience in Backup & Recovery techniques of databases running in ARCHIVELOG MODE using RMAN.

Experience on DATAGUARD and Create and maintaining Physical stand by database.

Implementing ASM Instance, Creating database & Migrating Non ASM database to ASM on Test instance

Knowledge on Oracle Database performance-tuning services with EXPLAIN PLAN, TKPROF, AUTO TRACE, AWR& ADDM.

Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.

Result oriented, self-motivated, team player, ability to work independently.

Education:

B-Tech in Computer Science and Engineering, from Jawaharlal Nehru Technological University, Hyderabad, India. (2013).

Skill Set

Area

Worked / Knowledge/ Known

Databases Administration

Oracle (10g &11g), Oracle 11g rac

Operating Systems

Sun Solaris, Red Hat-Linux, Windows xp/2003 Server.

Languages

SQL,PL/SQL .

Backup tools/utilities

RMAN, DBCA, Export/Import, Lsnrctl, Data pump, SQL * Loader, Data Guard.

Professional Experience

Working as Oracle DBA for Tenpath Solutions as a contractor from 3cit yantra software service pvt ltd

Project 1

Duration : 2013 to Till Now

Role : Oracle Database Administrator

Client : ICON Central Laboratories,USA.

Environment : RHEL 4, WINDOWS 2000, Oracle 10g

Description:

ICON Central Laboratories, Inc. is headquartered in Farmingdale, New York. Our company provides global central laboratory services from core facilities in New York, Dublin, Singapore, India and China. Since 2000, we have successfully managed the laboratory and associated investigator and logistical support requirements for hundreds of clients in virtually every phase and therapeutic area of clinical development. Provide Oracle DBA support for multiple large databases in production, development and test environments for various types of databases - OLTP and Data warehouse. Used Oracle replication as databases used read only snapshots for maintaining local copy of master tables in OLTP systems. Part of a three-member DBA team managing 72 databases. This included 36 production databases and 36 development/test databases. Users were located in America, Europe and Asia Pacific. Databases were Oracle 10 and running on HP UNIX. Sizes of databases varied from 400 GB to 450 GB. The projects using these databases are for web development and maintenance of Client-Server OLTP systems for business applications such as cargo tracking, billing, etc. Following are some of the typical tasks carried out as part of database administration.

Responsibilities:

Activities performed as Oracle DBA:

Installing Oracle 10g, 11g databases on Red Hat Enterprise Linux 4, Sun Solaris 10, and WinNT.

Creating Oracle Databases.

Sound knowledge on backup issues.

Maintaining and Administering Oracle databases.

Migrating the databases as per the application requirement.

Configuring the standby for new servers.

Planning and Implementing Backup and Recovery Strategy for databases using Hot and Cold Backups, Logical Backups using exp and imp.

Cloning of Oracle database to different machine for testing purposes.

Tuning various Database Components, Application Tuning using Explain Plan, SQL Trace.

Refreshing development/test database from production using Export/Import. This is done so that the latest data is available in the development/test database.

Documenting Database Operations.

Administering Database space management.

Maintaining data files, control files and online redo log files.

Maintaining database objects like indexes.

Monitoring and Checking Logs.

Handling and monitoring alerts.

Working on Tickets.

Interaction with the team members.

Contact this candidate