workrr

Description

Mohit Pahwa

 

Address: Noida, sec: 56

Mobile   : +91- 94650-51560

E-mail: mohitpahwa46@gmail.com
Objective
To work in a stimulating environment where I can apply & enhance my knowledge, skill to serve the firm to the best of my efforts.

Work Experience
·         HI-Tech Polytechnic college: – lecturer and lab instructor   15th June 2015 to 19th December 2015(6 month).

 

·         Ajani InfoTech pvt. Ltd: -Junior Graphic Designer from 14th April 2014 to 20th March 2015 (1 year).

 

·         C-Force computer hardware and mobile institute: -Computer Hardware Engineer from 5th Aug 2010 to 24th Feb 2012(1.5 year).

 

 

Role and responsibilitess
Installation, configuration and maintenance of 10g database on Linux platform.
Experience in user management, roles and profiles.
Management of table spaces, objects and creating profiles and attaching them with users and monitoring the users.
Creating users.
Exporting and Importing database backups using Exp & Imp.
Experience in RMAN configuration using recovery catalog a without recovery catalog. Taking HOT and COLD backups as required.
Performed Logical Backup using Export/Import.
Performed Backups using Recovery Manager.
Created Users, Roles, Profiles and granted privileges and profile to users.
Troubleshooting any SQL related issues.
SQL:-

·         Strong T-SQL proficiency.

·         Create database objects such as tables, views, stored procedures, Triggers etc.

·         Maintain referential integrity, domain integrity, and column integrity by using the available options such as constraints etc.

·         Create functions to provide custom functionality as per the requirements.

·         Be aware of potential blocking, deadlocking and write code to avoid those situations.

·         Strong experience with performance tuning and understand query execution plan (query optimization).

·         Must be able to port the queries, database objects from sql-server to oracle and vice-versa.

·         Sql Install other server Install (oracle10g).

·         All basic commands (insert, delete, update, Alter Truncate).

·         Multiple Query run.

·         Constraint(Primary, Foreign key, Default Unique, Composite Key)

·         Procedure, Trigger, Function.

·         Grouping Function.

 

ACHIEVEMENTS
·         Oracle 10g – SQL Certified in 2014

 

Industrial TRAINING
·         Completed 6 months training in Oracle 10g (DBA & Developer) from S.O. InfoTech.

·         Completed 6 weak training in Networking & Administration from Vishvas institute of it.

·         Completed 6 weak training in Computer hardware from C-force.

.

Qualifications’ Summary
·         BTech (CSE) from G.T.B.K.I.E.T CHAPPIANWALI, UNi.-Jalandhar (Punjab) with 72%. Passed in 2014.

·         Diploma. (CSE) from G.T.B.K.POLLY TECHNICAL Collage, Chappianwali with 61%. Passed in 2011.

·         10th from G.T.B.K. Sen. Sec School, malout with 72%. Passed in 2008

.

Technical Skills
·         Hardware                                  : Installation, Maintenance of Desktop, Laptop

·         Networking & Administration       : Networking & Installation of Windows Server  2008

·         Database                                  : SQL,PL/SQL

: Oracle10g DBA (Database design, Installation,

: Managing Instance, Recovery, Flashback, Backup,

RMAN, Import & Export, etc.)

 

Area of interest
·         SQL,PL/SQL

·         Oracle Database Administration
PERSONAL STRENGTHS
·         Team player

·         Firmly believe in smart and hard work

·         Quick learner and self-motivated towards the work

 

 

HOBBIES
·         Surfing and listening to music

·         Watching Movies

PERSONAL PARTICULARS
Name                               : Mohit Pahwa

Father’s Name                  : Raj Kumar

Date of Birth                    : 30-07-1993

Marital Status                   : Single

Languages known            : Hindi, English, Punjabi

Current Address                : Adarsh nagar, ward no-1, Street no-8,

city malout (Punjab)

 

 

I hereby declare that all statements made in this application are true, complete and correct to the best of my knowledge.

 

Mohit Pahwa