Name : Joshi Pranali Prabhakar
Mobile : +918*********
E-mail : *****.*********@*****.***
OBJECTIVE
To be the part of good and knowledgeable environment which help me to
increase and apply my knowledge for achieving objectives of organization.
EDUCATIONAL QUALIFICATIONS
Branch: - Information Technology
Qualification Year of University / Board Percentage
passing
Final Year 2012 Pune University 61.73%
Third Year 2011 Pune University 54.93%
Second Year 2010 Pune University 52.6%
Diploma (Comp 2009 M.S.B.T.E 80.06%
Engg.)
H.S.C 2006 Maharashtra State 69.67%
Board
S.S.C 2004 Maharashtra State 82.26%
Board
TECHNICAL SKILLS
1. Programming Language :PL/SQL, Java, VB
2. Operating systems :HP Tru64
3. Database :Oracle 10.2.0.4.
CERTIFICATIONS
Oracle Certified Associate 10g [DBA Track - 1Z0-042]
Technical Skills:
DATABASE ADMINISTRATION
1. Database creation from scratch using oracle scripts and using
DBCA.
2. Tablespace creation and maintenance of data files.
3. Datafile, Tempfile management.
4. Undo Tablespace management.
5. Setting of initialization parameter.
SQL and PL/SQL
1. Good knowledge of database objects like table, complex views,
synonyms, sequences, triggers, packages, procedures, functions
etc.
2. Good understanding of Dynamic Performance Views and Data
Dictionary Views.
3. Creation and Usage of Constraints.
4. Good understanding of Transaction.
Performance Tuning
1. Can tune SQL Queries.
2. Creation and Rebuild of Indexes.
3. Explain Plan creation.
4. Init Parameters setting for high performance and usage of ASMM.
5. DB Cache sizing, Redo Sizing, DB and Library Hit Ratios.
6. AWR and ADDM Report creation and tuning DB.
Backup and Recovery Manager
1. Export and Import of data in the database.
2. RMAN Architecture.
3. Consistent and Inconsistent backups.
4. Incremental (differential and cumulative) backups.
5. Restoration of database.
6. Recovery of database and apply of Archive Logs.
7. Recovery from loss of Control file and SPfile.
8. Cloning of database using RMAN.
9. Cross Platform database refresh.
. Knowledge of Schema management, Partitioning the tables and indexes,
data file and extent management, as well as user and privilege
management.
. Planning and scheduling Backups, Database Recovery, taking Logical
Backups (with Exp/Imp)
. Perform Daily Monitoring of Oracle instances using Oracle Enterprise
Manager, monitor users, tablespaces, memory structures, rollback
segments, logs, and alerts
. Supported the system 24x7, ability to work beyond regular hours.
ADDITIONAL ACTIVITIES
. Organizer for P.C.Hardware Workshop in TEXPLOSION 2k10.
. Organizer for Laptop Assembly Workshop in TEXPLOSION 2k11.
. Certificate of participation of Microsoft Dream Spark Yatra 2011.
STRENGTHS
. Quick learner
. Patience
PERSONAL DETAILS
1. Date of Birth : 29th Mar,1989
1. Gender : Female
1. Languages Known : English, Hindi, Marathi