Address: Noida, sec: 56
Mobile : +91- 94650-51560
To work in a stimulating environment where I can apply & enhance my knowledge, skill to serve the firm to the best of my efforts.
· 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.
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.
· 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.
· Oracle 10g – SQL Certified in 2014
· 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.
· 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
· 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
· Oracle Database Administration
· Team player
· Firmly believe in smart and hard work
· Quick learner and self-motivated towards the work
· Surfing and listening to music
· Watching Movies
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.
- sql developer oracle dba
G.T.B Khalsa poly tech and insitude collage of chappianwali
c-force computer center
- 2010-2012 computer hardware and network
ajani infotech pvt ltd
mobile application graphic designer
hitech ploytech collage
- 2015-2016 computer lect. and lab instructor