Sriharsha
Oracle DBA
Mobile: 8951093593
E-mail: harsha.dba08@gmail.com
PROFFESSIONAL SUMMURY:
Having 2+ years of experience as Oracle Database Administrator
Experience in installation, configuration, backup &recovery.
Knowledge on RAC concepts.
Implemented AWR, OEM, Data Pump & ADDM.
Managing Tablespaces and CRD files.
Creation of ASM instances and databases.
Involved in configuration of DATAGAURD (standby database).
Creation of users, Managing roles and profiles in the schemas.
Creation of Database links and Materialized Views.
Involved in Backup and Recovery using RMAN.
Involved in logical (EXPdp, IMPdp and EXP, IMP) and Physical backups.
Knowledge on Recovery of the database in case of failures (loss of Control file,
loss of Data file(s), loss or crash of Table space(s), entire database crash. etc.)
Performed Cloning and Refresh the databases.
Upgradation of databases from lower version to higher version.
Applying patches using Opatch utility.
Good team spirit and organized working habits with a willingness to learn new
concepts and ability to work individually and work as part of a team.
Worked as a team member to provide 24x7 on-call production support.
PROFFESSIONAL EXPERIENCE:
Working as Oracle DBA with NOUS Info systems, Bangalore from May ’08 to
till date.
TRAINING:
Authorized Training by Oracle as Database Administrator (DBA) in SQL STAR
INTERNATIONAL PRIVATE LIMITED, Hyderabad from Dec 2007 to Apr
2008.
Responsibilities as Oracle DBA:
Providing L1 support for Oracle Databases (10.x and 9.x) development and
production support including on-call requirements
Installations upgradation,cloning and DB Creations activities
Upgrading database from 9.2.0.6 to 10.2.0.2
Regular monitoring of Alert log file on day-to-day basis.
Check out the standby database with primary database.
Creation of database Users and by setting the default tablespaces, Assigning
quotas, roles, privileges and profiles to users.
Creating the necessary tablespaces, data files, rollback segments, redo log
maintenance.
Monitoring and managing day-to-day operations, maintaining Tablespaces and
CRD files.
Planning for backup and recovery of database information and maintaining hot
backups, cold backups, and also include RMAN backup.
Refresh the database export/import form production to development databases
for the further testing purposes.
Cloning the database.
Exporting and importing schemas.
Report generation by Gathering statistics using SQL Trace, TKproof,
STATSPACK, AWR.
TECHNICAL EXPERTISE:
Databases : Oracle /9i/10g.
Operating Systems : Red Hat Linux, Sun Solaris,
Windows 2000/NT/XP
Programming Language : C, C++
Procedural Languages : SQL
Backup and Recovery : RMAN
Tools & Utilities : DBCA, EXPORT/IMPORT, TOAD.
Tuning Tools : EXPLAIN PLAN, STATSPACK,
And, AWR/ADDM.
EDUCATIONAL QUALIFICATION :
MCA From Navabharathi College Engg & Technology Affiliated to Osmania
University with 69.2 %
Bsc (Electronics & Computer Science) From Kavitha Degree College Affiliated to
Kakatiya University with 76.6 %
CERTIFICATIONS:
1Z0-007 Introduction to Oracle9i: SQL
1Z0-031 Oracle9i Database: Fundamentals I
1Z0-032 Oracle9i Database: Fundamentals II
1Z0-033 Oracle9i Database: Performance Tuning
Personal Profile:
Date of Birth : 07-01-1985
Gender : Male
Address : #63, Cyril Nilayam, KrishnaMurthy layout
5th Cross, Thaavarkeri Main Road.
Bangalore-560029.
Place: Bangalore SRIHARSHA.R
Date:
