Oracle dba Having 3 years of experience
--------------------------------- Resume Format ----------------------------------------
Name Mobile : +91-9999999999
mail_id@gmail.com
Professional Summary
·
Having 3 years of experience as an Oracle Database
Administrator.
·
Installing and administering Oracle databases in various platforms like windows & Linux.
·
Upgrading database from lower version to higher version.
·
Database Creation, Database Monitoring and Tuning.
·
Maintaining Tablespaces, Storage management,
Undo Management.
·
Performed backup using conventional, HOT backup, cold
backup, RMAN (recovery manager).
·
Performed backup using exp\Imp and expdp\impdp.
·
Checking size of database to accommodate objects like
table spaces, tables etc.
·
Configured physical standing by database (DATAGUARD) and
tested for switchover.
·
Creating Tables, Indexes, sequences etc.
·
Resizing table spaces and addition of new database file.
·
Responsible for software installations, systems support,
performance tuning .
·
Experience
in performing Schema Refresh.
·
Knowledge
on RAC
·
Experience
in taking backup of OCR & Voting disk files.
·
Knowledge
on managing RAC database using SRVCTL and CRSCTL utilities.
·
Configured
RAC on two nodes test servers.
Work
Experience:
·
Working as a DBA in TCS from JUNE 2011 to till
Date.
·
Worked
in ACCENTURE as an associate DBA from AUG 2009 to MAY2011.
Academic Qualification:
·
Bachelor
of Commerce from Name of University
Technical Skills:
Operating System : Linux,Sun Solaris
Languages : SQL,Pl Sql.
RDBMS : Oracle 9i, 10g and 11g
Tools : SQL*PLUS, RMAN,
OEM, DBCA ,NETCA and DBUA etc.
Programming : SQL,
PL/SQL, Shell Scripts.
RAC Utilites : CRSCTL , SRVCTL , RCONFIG,CRS_STAT ,CRS_STOP
etc
·
Projects Handled:
Project#2:
Organization : TCS, Bangalore
Role : Oracle DBA
Environment : windows, Solaris 5.10, Putty,Oracle
10g
Contribution:
·
Responsible for both managing and supporting all
Production, Development and Staging instances of Oracle Version 10g & 11g.
·
Managing Data guard environments.
·
Applying CPU patches and upgrading databases from 9i to
10g.
·
Backup and recovery using RMAN, scripts for various
database activities, troubleshooting etc.
·
Monitoring various database activities like number of
users memory usage, Alert log file, Trace files, Archive log files
·
Maintaining Tablespace management
·
Maintaining data integrity and tune database for optimum
performance and availability. Excellent in troubleshooting Oracle Network
issues.
·
DB Cloning with RMAN.
·
Configuring RMAN utility
·
Creating db-links as per the requirement.
·
Changing Pfile parameters as per requirement.
·
Handle incidents Tickets like Tablespace alarms,
file system getting full alarms.
·
Monitoring RAC database through SRVCTL.
·
Knowledge on RAC utilities.
Performance Tuning
·
Configuring Statspack and Analyzing Report
·
Analyzing Automatic work load repository(AWRP)
- Automatic
Diagnostic monitor(ADDM)
- Gathering
Schema Statistics
- Creating
partitions
- Tkprof,
sql trace and Explain Plan.
Project#1:
Organization : ACCENTURE, Bangalore.
Role : Junior DBA
Environment : Windows, Linux, Oracle 10g,
Toad, Putty.
Contribution:
·
Installation and maintenance of Oracle Databases on
various environments.
·
Backup and Recovery Management.
·
Space management, User management Roles and privileges.
·
Design and implementation of Backup and Recovery
activities using RMAN& Export/Import utilities.
·
Taking HOT Backups daily base and weekly cold backup.
·
Monitoring various database activities like number of users
memory usage, Alert log file, Trace files, Archive log files.
·
Configuring
changes in oracle networking.
·
Provided
all kinds of DBA support to development teams as well as production support to
various applications.
0 comments:
Post a Comment