| Resume |
A competent professional with over 1.6+ Years of experience in Oracle DBA.
Hands on Experience in installing, configuring, managing oracle9i and oracle10g.
A skilled communicator with strong interpersonal & relationship management skills.
Completed GNIIT in Software Engineering from NIIT
Pursuing post graduation degree MCA (5th sem. ) from Sikkim Manipal university.
Graduation from Lucknow University.
TECHNICAL SKILL (Set As a DBA)
Well command on SQL queries.
Managing redo log group and members.
Creation and Alteration of Table spaces.
Creation and managing Undo Table spaces.
Creation, Alteration, Reallocation of Tables and Indexes.
Installation and configuration of Oracle server on Linux and windows platforms.
Knowledge of Performance Tuning.
Conversion of Database in Archive Log/ No Archive Log Modes.
Creating and managing database objects, users, roles, privileges, profiles.
Implementing backup and recovery strategies using Hot/ Cold backup.
Knowledge in using Oracle utilities and tools such as SQL loader, Export/ Import, etc.
Complete and Incomplete recovery with Rman and User_ managed.
SKILL SET (FUNCTIONAL)
Created backup and recovery implementation specification document.
Managing Database objects.
Security administration and user management involving roles, privileges etc.
SKILL SET (TECHNICAL)
Languages : Sql, PL/ Sql
Operating Systems : Window, Linux Red Hat
Database : Sql Server 2000/ 2005, Oracle9i/ 10g.
Office Automation : MS Office
Associated with ITC. Ltd, Gurgaon
Since May 10
Project Name: Loyalty
Project Description: Loyalty program is a structured marketing effort that reward, and encourage, loyal buying behavior. In ITC LRBD Loyalty program recognizes and rewards the loyal customers by providing loyalty card. By presenting the card, the purchaser is entitled to an allotment of loyalty points that can be used for future purchases. In loyalty program, cards are classified in mentioned categories i. e. Privilege, Silver, Gold and Platinum respectively depending on the purchases made by the customer(s).
Client: ITC LRBD
Environment SQL Server 2005 and Oracle Server
Role Junior Oracle DBA
Duration May 2010 to till date
Maintenance and Monitoring of Loyalty database
Maintenance and Monitoring of CMM database.
Maintenance and Monitoring of LMPOS database.
Monitoring of Log files
Maintenance and Monitoring activities included verifying that databases are up, databases have enough space in the tablespaces, reviewing alert logs, etc.
Recovery of database.
Verifying alert log file and resolving errors obtained.
Daily Exporting All Tables and Taking Hot Backup, Archive logs backups to disk as well as to tapes. Sometimes Cold backup.
Table space monitoring and Resource monitoring
Adding data file to table space and managing the Loyalty and CMM database users.
Checking Alert log file for diagnosing the database.
Every week once export the table and import into backup server
Analyzing the table to collect the statistics as well as Rebuilding the index and creating indexes for faster access.
Analyzing all the Components logs
Monitoring The customer Status, Stores database status, Customer Points status, Customer Transaction Status, Customer Net Purchase value status
Loading and transforming data using SQL Loader, etc
Date of Birth : 28th nov 1987
Marital status : Marred
Nationality : India
Language Known : English, Hindi