Oracle dba 2+ Resume

Oracle dba Having 2 years of experience   

--------------------------------- Resume Format  ----------------------------------------

Your Name

                                                                                                       Email: mailid@gmail.com

                                                                                                       Mobile No:+91-9888888888

                                   

Summary

• Over 2 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.
• Having Experience to Upgradation of database from 9.2.0.6 to 10.2.0.1 and 10.2.0.1 to 10.2.0.4 and 10.2.0.4 to 11g.
• 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.
• Oracle 11g RAC implementation & administration using Oracle Cluster ware (Oracle Cluster ware setup and configuration, RAC installation using ASM, Configuration and Migrating Non ASM database to ASM on Test instance)
• Experience on DATAGUARD and Create and maintaining Physical standby 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, AP, India. (2010)

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 presently as Oracle DBA in CTS , Hyderabad, India.

Project 1

Duration         :  April 2011 to Till Now

Role                :  Oracle Database Administrator

Client              :  Standard Chartered Bank

Environment  : RHEL 4, WINDOWS 2000, Oracle 10g

Description:        

The Standard Chartered Bank Group operates in all the main business and financial centres across India. We offer a full range of tailored advisory, financial and operational services in both corporate, investment banking and also focus strongly on our consumer and commercial offering in India.
In addition, we employ a significant number of individuals in SCB Technology Services India (TSS). This team are responsible for developing and supporting business critical technology applications across the SCB Group. We take pride in our delivery culture, concentrating on excellence in origination, execution and distribution globally.

Responsibilities:

Activities performed as Oracle DBA:

• Installing Oracle 10g, 9i 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.
• Documenting Database Operations.
• Administering Database space management.
• Maintaining data files, control files and online redolog files.
• Maintaining database objects like indexes.
• Monitoring and Checking Logs.
•  Handling and monitoring alerts.
• Working on Tickets.
•  Interaction with the team members.

Project 2

Duration                                 : June 2010 to March 2011                                   

Role                                        : Oracle DBA

Client                                      : ICICI LOMBARD

Environment                          : Oracle 10g, RHEL 4, WINDOWS NT

 Description:        

ICICI Lombard is the largest private sector general insurance company in India . The company presently has around 4,777 employees in 357 branches. ICICI Lombard allows instant policy issuance and renewal through its website www.icicilombard.com for all retail insurance products including Car Insurance, Health Insurance, Travel Insurance, Two Wheeler Insurance and Home Insurance. There are multiple payment options available including internet banking, credit card, debit card and cash card

Responsibilities:

Activities performed as Oracle DBA:

• Installation, maintenance of Oracle databases/Oracle Applications and currently working in 10g database.
• Production support for Oracle Database and Applications in 24*7 environments
• Resource management at database level
• Managed Tablespaces and other database objects
• Creating users, allocation to appropriate Tablespaces, Quotas with necessary privileges and roles for all databases.
• Monitoring Tablespaces size, resizing Tablespaces, relocating datafiles for better disk I/O
• Database backup and recovery (Hot and Cold Backups), logical backup using Import and Export
• Checking space availability in Tablespaces and adding space if They reaches Threshold
• Documenting Database Operations.
• Responsible for troubleshooting of the connectivity problems for end-users by configuring tnsnames.ora, listener.ora.
• Performed all performance related activities on objects, sessions and tablespace level
• Implemented Database Security using password management policy
• Maintaining data files, control files and online redolog files.
• Maintaining database objects like indexes.
• Monitoring and Checking Logs.

LINUX Administrative activities

·         Installation of Oracle Red Hat Linux.

·         File system management, user accounts, and quotas.

·         Performed user Administration.

·         Performed file system Backup and Restores.