Manager Oracle
Resume:
RESUME
NITIN KUMAR
B-***
Ashok Nagar
NEW DELHI-96
Mobile : +91-955*******
Email:******.*******@*****.***
EXPERIENCE SUMMARY
. Having 2 years of experience in oracle pl/sql, oracle forms & reports,
ETL. Having good exposure of using Oracle database administration
including installation, configuration, Monitoring, Backup/recovery,
Database design and Performance tuning on various Linux/Windows
platforms. Currently working with ACUTE INFORMATICS PVT LTD.
TECHNICAL SKILL
Operating System : Linux, Windows - 2003/XP/07/Solaris
RDBMS : Oracle 11g,10g, 9i
Language : C, HTML,SQL, Oracle PL/SQL
Tools : Toad (9.0), Web
logic 11g, SQL Developer, Oracle forms & reports
EASY
ETL
WORK EXPERIENCE
1)
Organisation : - GYANMANI TECHNOLOGY PVT LTD
Project : - RSS READER
Designation : - SQL PROGRAMMER
Duration : - DEC 2010 to May 2011
2)
Organisation : - CMC Ltd, a TATA Enterprise
Project : - CAG (Migration of Database & Application)
Designation : - IT Engineer
Duration : - JUNE 06, 2011 Oct 2012
3)
Organisation : - ACUTE INFORMATICS PVT LTD
Project : - DATA MIGRATION
Designation : - ORACLE DEVELOPER
Duration : - DEC 2012 to TILL NOW...
MY RESPONSIBILITIES
. Configure, maintain, and troubleshoot Oracle 9i/11g databases on Linux
environments.
. Tuning of databases, maintenance of small to large database. System
Analysis & Design, Implementation.
. Backup and Recovery of Database by Hot and Cold Backup, and Logical
Backup (Export-Import)
. Managing Database Structure, Storage Allocation, Table/Index Segments.
. Manage database Access, Roles and Privileges.
. Planning and scheduling backups and Recovery.
. Debugging, Migration Activities, Error log Clearance.
. Compilation of Forms & Reports on Linux 64- Bit.
. Creation of Stored Procedures, functions, cursors, triggers and packages, and database queries
PROJECTS UNDERTAKEN
Title DATA MIGRATION
Platform/ Oracle 10g, ETL /SQL,PL/SQL
Language
Job Database developer
Responsibility
OS Use Windows for Test & Development servers.
Detail Installation, DB Creation, database and any type of
Problems related to database.
Database Object Management by creation, as well as
maintenance of various types of objects such as tables,
indexes, functions, procedures, etc.
Managing Oracle Database Users. Activities includes
creation and drop users, controlling resource use with
profiles, granting and revoking privileges, creation &
assigning roles, Auditing user activities.
Configuring Oracle client server architecture. Creating
and managing Listeners using Oracle Net Manager and Net
Configuration Assistant and Registration with
database. Configuring shared server and dedicated
environment.
Debugging, Migration Activities, Error log Clearance.
Data Extraction,Transformation,Loading By using ETL .
Coding SQL, Oracle PL/SQL
PROJECTS UNDERTAKEN
1.
Title CAG(DATABASE MIGRATION)
Platform/ Oracle 11g,SQL,PL/SQL
Language
Job Database Administrator
Responsibility
OS Use Windows for Test and LINUX for Development servers.
Detail Installation, DB Creation, database and any type of
Problems related to database.
To manage the logical structure by means of managing
permanent and temporary tablespaces and undo
tablespaces,and redofiles,control files.
Database Object Management by creation, as well as
maintenance of various types of objects such as tables,
indexes, functions, procedures, etc.
Managing Oracle Database Users. including creation and
drop users, granting and revoking privileges, creation &
assigning roles, Auditing user activities.
Creating and managing Listeners using Oracle Net Manager
and Net Configuration Assistant and Registration with
database. Configuring shared server or dedicated
environment.
Taking Backups hot as well as cold backups using RMAN
(Recovery Manager) and user managed backup, and datapump,
and exports.
Debugging, Migration Activities, Error log Clearance.
Compilation of Forms & Reports on Linux 64- Bit.
Exposure in coding pl/sql, cursors, triggers &
procedures.
2
PROJECTS UNDERTAKEN
2.
Title RSS READER
Platform/ C#,Oracle 9i,SQL,PL/SQL
Language
Job SQL Programmer & Database maintenance
Responsibility
OS Use Windows 07/XP.
Detail Basically a console based application which is used to get
latest updates of the
different websites on client machine .
Developed in c# dotnet with the back end support of oracle
9i.
Managing the coding part in sql to connect the database
to the application .
Database Installation on windows environment, DB Creation,
database and any type of Problems related to database.
Database Object Management by creation, as well as
maintenance of various types of objects such as tables,
indexes, functions, procedures, etc.
Debugging and Error checking Activities, Error log
Clearance.
TRAINING
. 3 months of class room training in CMC Ltd. at Janakpuri, from June 11
to Sept 11.
EDUCATION QUALIFICATIONS
. B.TECH (computer science & engg.) from UP Tech. University, Lucknow in
the year (2006-2010).
. 12th (PCM) from UP Board Allahabad, in the year 2005.
STRENGTH
Learning ability, Smart Working, Obtain Better Result with Team Work,
Having Leadership skills and ready
to take up challenges.
PERSONAL DETAILS
Father's Name : Sh. Bhopal Singh Panwar
Date of Birth : 05th, June 1988
Permanent Address : 795, basi-4, Distt- Baghpat, UP, 250101
NITIN KUMAR
Mobile: 955-***-****
Contact this candidate