Pranav Pareek

Phone: +91-889*******/935-***-****

Email: abn9l9@r.postjobfree.com

**, *********** ******, ****** ***** 'Clarks Amer', Durgapura, Jaipur – 302018 Rajasthan

OBJECTIVE

To work in a stimulating and challenging milieu that would facilitate the maximum utilization and application of my broad skills and expertise in making a positive difference to the organization

SYNOPSIS

Young, energetic and result oriented MCA and Oracle Certified Professional with 3.7 years of experience in IT as DBA. Deep understanding of technology with focus on delivering business solutions; Persuasive communicator with exceptional relationship management skills with ability to relate to people at any level of business and management; highly ethical, trustworthy and discreet.

Skilled team member with proven ability to lead and motivate teams to maximize productivity

Dedicated and highly ambitious to achieve personal as well as organizational goals

Adroit at learning new concepts quickly, working well under pressure and communicating ideas clearly and effectively

Proficient in self adaptation within a dynamic environment

EDUCATION

MCA from University of Rajasthan, Jaipur in 2009 with 71.40%

BCA from University of Rajasthan, Jaipur in 2005 with 62.00%

COMPUTER SKILLS

Database: Oracle 9i/10g/11g

Operating Systems: Windows 7/2003/Vista/9x/XP, Red Hat Linux, Solaris

Languages: C, SQL, PL/SQL

Tools and Utilities: Toad, Export/Import & Expdp/Impdp, SQL*Loader, Pl/SQL Editor, OEM, MS Office, RMAN, HP Data Protect

WORK EXPERIENCE

1)Efkon India Private Limited (June'12 – Till Date)

Database Administrator

2) Trimax IT Infrastructure & Services Limited (Oct’10 – May’12)

Database Administrator

3) Yusata InfoTech (Sept’08 – Feb’10)

Database Administrator

CERTIFICATIONS

Oracle Certification for Oracle Certified Professional (OCP) in the academic year 2009 -10

Oracle Certification for Oracle Certified Associate (OCA) in the academic year 2008 – 09

Cleared ESOL Examination (English for Speakers of Other Language) conducted by University of Cambridge, UK. Received Business English Certificate in the academic year 2007 - 08

Turbo C and Data Structures Certification course from NIIT, Jaipur in 2006 - 07

Core Java Certification course from Compro Institute, Jaipur in 2004 – 05

PROJECTS

Client: Jaipur City Transport Services Limited (JCTSL), (India)

Company: Efkon India Private Limited

Role: DBA

Platform: Windows/Linux

Database: Oracle 10g/11g

Duration: June’12 to Till Date

Description: Automated Fare Collection System (AFCS)

Responsibilities:

Work as part of a team and provide 7x24 support when required

Database management, performance monitoring and tuning

Implementing and maintaining database security (create and maintain users and roles, assign privileges)

Managing schema objects like tables, indexes, views, tablespaces, datafiles etc.

Analyzing tables, indexes, schema and online index rebuilding

Data pump, export/import of tables, schemas, tablespaces and database

Managing and performing hot and cold backups, logical backups and user managed recoveries and RMAN recoveries, database cloning (RMAN, expdp/impdp, export/import, HP Data Protect)

Managing users on Windows and Linux server and remote server

Application tuning and database tuning

Interface with Oracle Corporation for technical support

Client: Rajasthan State Excise Department (RSED), (India)

Company: Trimax IT Infrastructure & Services Limited

Role: DBA

Platform: Windows/Linux

Database: Oracle 10g

Duration: Oct’10 to May'12

Description: RSBCL - Rajasthan State Beverages Corporation Ltd.

RSGSM - Rajasthan State Ganganagar Sugar Mills Ltd.

Responsibilities:

Perform database tuning and performance monitoring

Managed and monitored tablespaces and datafiles

Performed general technical trouble shooting and give consultation to development teams

Analyzed tables, indexes, schema and online index rebuilding

Monitored database activity for specific client performance issues

Checked alert log errors and make necessary actions to rectify them

Data pump, export/import of tables, schemas, tablespaces and database

Managed and performed hot and cold backups, logical backups and user managed recoveries and RMAN recoveries, database cloning (RMAN, expdp/impdp, export/import)

Client: Vertical Pharmaceuticals, New Jersey (USA)

Company: Yusata Infotech

Role: DBA

Platform: Windows/Linux

Database: Oracle 10g

Duration: Sept’08 to Feb’10

Description: Vertical is meant for the medical representatives and doctors

Responsibilities:

Creation of Project QA and Development environments, using export/import and edited DDL script to generate customized versions of the production environment

Creation and execution of DDL scripts to create tables, table spaces, triggers, views, synonyms, indexes, integrity constraints, users, grants, etc.

Inserting data using scripts and other tools

Managing users on Windows and Linux server and remote server

Client: Smart-fleet, New Jersey (USA)

Company: Yusata Infotech

Role: DBA

Platform: Windows/Linux

Database: Oracle 10g

Duration: Sept’08 to Feb’10

Description Smart-fleet is meant for the transport companies

Responsibilities:

Monitored and maintained overall database

Provided troubleshooting and problem solving support to application developers

Performed and managed logical and physical backup

Moved database schema changes to stage or production

Maintenance and monitoring of table spaces, data file, control files etc.

MISCELLANEOUS

Volunteered many cultural events

Passionate about workout in gymnasium, swimming and traveling

Attended Annual Training Camps of NCC at Jamdoli, Jaipur in 1996-97 and 1997-98

Participated in the Independence Day Program held at Sawai Man Singh Stadium, Jaipur in 1994-1995

NCC ‘A’ certificate holder under the authority of Ministry of Defense

STRENGTHS

Possess good relationship building and interpersonal skills

Hardworking, patient and quick learner

Commitment towards work

Sincerity and Self-Confidence

Good team player

Quick adaptability to challenging situations

PERSONAL DETAILS

Date of Birth: 13th Nov, 1982

Languages Known: English, Hindi

References: Available on request

Passport Number: H5070634

Contact this candidate