Ankit Rathi

House No. **, Btm *st stage Bangalore

Email:acgf7p@r.postjobfree.com

Phone: 91-805*******

CAREER OBJECTIVE:-

To evolve into a hardworking and sincere professional, contributing to the success of the

organization and at the same time to enhance my knowledge and communication skills.

Career Summary

2 years of total IT experience in Database.

Good Knowledge in Installation of Oracle with 10g, 11g, and Grid Infrastructure on

various platforms like LINUX, WINDOWS etc.

Experience in Creating and maintaining Physical Standby Database.

Managing Tablespace Utilization.

Managing the production database for Oracle and resize the space of

database/Datafiles/Tablespace/Transactional Logs

Creating, Updating, Altering Tablespace, Indexes, Tables, Views, Synonyms, Profile,

Role, Privileges

Strong experience in administration and database Backup & Recovery.

TECHNICAL SKILLS:-

Languages: SQL, PL/SQL, java, Networking.

Database: DBMS, SQL, ORACLE 10G, MS Access.

Database Backup Tool/Utilities: Cold, Hot backup, RMAN, Import/Export, Lsnrctl.

Tools: SQL Plus, Oracle Enterprise Manager (OEM), SQL * Loader.

Virtual Machine: VM Ware server 2.0 to 2.2, Oracle VM Virtual box 4.0.

CERTIFICATION:-

Oracle Certified Associate (OCA, IZ0-042).

Oracle Certified Expert (OCE, IZ0-047).

WORK EXPERIENCE:-

Council of Scientific and Industrial Research (CSIR) (21 Aug 2013 to 20 Aug 2014)

Experience in ERP (Enterprise Resource Planning) in CSIR complex in Engineering

Services Division, on ERP Project.

Role:- ERP Data Analyst

Project Name:- CSIR Enterprise Transformation Portal (One CSIR)

About the project:

CSIR Organization Transformation is an initiative to streamline, reengineer and automate the

current process. The main objective of the transformation is to evolve the organization in

terms of optimum utilization of available resource and maximizing the output by minimizing

the turn-around time, fast availability of data and information aiding fast decision making,

this is turn improve the productivity in keeping pace with progressive mandate and aiming at

contd. on next page...

contd. from pre page...

transforming CSIR is an organization the ERP application is being implemented. This paves

the way to perform culture, leveraging process, redesigning the current processes,

automation of administrative procedures, team performance, electronic self service,

transparent mechanism for decision support/enhanced efficiency at all levels.

Work and Responsibility:-

Implemented PL and SQL queries, triggers and Stored Procedures as per the design

and development related requirements of the project.

Involved in creating and managing users and objects.

Involved in assigning roles and privileges to different users.

Inspected log file, monitored table spaces and partitions

Involved in creating tables and indexes, views. Hot and cold backup.

Time to time create a backup of the Database.

Writing SQL quires and creating/modifying Oracle tables.

Using Advanced Excel/Access to verify data.

Give the training on ERP as a Consultant.

Maintaining, Handling and Monitoring the Data.

TRAINING (Career Development):- (July 2012 to June 2013)

An Oracle Database Administrator with over 12 months of training in SQL, PL/SQL, security,

backup & recovery in NIIT Connaught Place Delhi.

Oracle Database 10g: Administration Workshop 2

Oracle Database 10g: Administration Workshop 1

PL/SQL Programming for Oracle 10g

SQL Fundamental: I & II for Oracle 10g

Role:- DBA Trainee.

Project Name:- Human Resource (Hr) Schema.

About the Project(Schema):

The human Resources (HR) schema is a part of the Oracle sample schema that can be

installed into an Oracle database. As the name indicates, the HR Schema has tables that

store all the information about all employees working in the organization. To reduce the

complexity and volume of data, information about employees is stored in more than one

table. Instead, you can store employee information in the employees table and department

information in the department table. This is how to HR Schema is built.

Work and Responsibility:-

Implemented PL and SQL queries, triggers and Stored Procedures as per the design

and development related requirements of the schema.

Involved in creating and managing users and objects.

Involved in assigning roles and privileges to different users.

Inspected log file, monitored table spaces and partitions

Involved in creating tables and indexes, views. Hot and cold backup.

Writing SQL quires and creating/modifying Oracle tables.

Restore & Recover Database, when recovery is required.

contd. on next page...

contd. from pre page...

EDUCATION:-

B.TECH (CS) from J.N.I.T Jaipur (R.T.U.) in 2012 with 62%.

Oracle Certified Professional from NIIT, Connaught Place, Delhi.

Senior Secondary from SVM College UP Board in 2008 with 61%.

Secondary from SVM College UP Board in 2006 with 75%.

EXTRA-CURRICULAR ACTIVITIES:-

LAN Gaming - Participated in University level College’s Fest and won 1st Prize.

Best Player award for cricket in annual championship organized by University.

STRENGTH:-

My unique abilities include my analytical, logical and intellectual skills. I am confident, focus

and willing to work hardly & smartly.

HOBBIES:-

LAN Gaming

Cricket

Swimming

Photoshop

PERSONAL DETAILS:-

Father’s Name : Sh. Kanwarpal Singh

: 08th July 1992

Date of Birth

Gender : Male

Marital Status : Single

Nationality : Indian

Language Known : Hindi, English

DECLARATION:-

I hereby declare that the above information is true to the best of my knowledge and belief.

Date: 08-10-2014

Place: Bangalore (Ankit Rathi)

Contact this candidate