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:
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.
