Rahul Panwar
Mobile no-8285420912
E-mail-rahulpanwar7687 AT gmail.com
Shiva durga pg near water tank stand btm layout Bangalore
Objective :
Looking for an entry into a world class, highly professional organization with challenging and competitive environment, where I can use my knowledge base as well as personal attributes to achieve the organization goals.
Career Summary :
** Having 1 year 6 months of IT experience of Ministry of Panchayat Raj 11 core application that has been developed for public and internal official. Along with this experience I have got excellent hands on skills of oracle database 10g/11g administration and development under Linux/Unix Environments.
** Good knowledge of creating Tables, Synonyms, Views ,index, triggers, Global Temporary Table
** Strong knowledge of RMAN and Oracle secure backup and recovery tools.
** Strong knowledge of writing simple and complex SQL Queries.
** Disaster recovery planning and implementation Installation, configuration and upgrading of Oracle software and related product.
** Expertise in Database designing and creation.
** Expertise in Software Development Life Cycle.
** Expertise in requirement analysis, designing, developing, implementing and executing a project.
** Oracle DBA in various configuration and support operations which include Data restoration (in Linux), User maintenance and Security implementation (Profile, Privileges, and Roles).
** Expertise in monitoring, maintenance and administration of Oracle 10G and 11g databases.
** Remarkable ability to develop expertise in new Technologies.
** Work as part of a global team to provide 24x7 on-call support on rotational basis.
** Good knowledge of oracle net configuration assistant and database upgrade assistant.
** User group and permission in Linux.
Professional Experience :
** Company Name : Wipro InfoTech
** Role : IT consultant
** Duration : From November -2013 to March 2015
Technical Skills :
Operating System : OS – Linux (RHEL5, OEL5), Windows 2008, 2003 (Server, Professional), Unix.
Virtual Servers : VMWARE, Oracle VM.
RDBMS : 10gR1 & R2, 11g
Tuning Tool : AWR, ADDM, SQL Tuning Advisor
Backup Tool : Oracle secure backup and Recovery Manager (RMAN)
Tools : SQL Plus, Oracle Enterprise Manager (OEM), SQL * Loader.
Remote Tool : Putty, RSH/SSH
Script : UNIX/Linux shell script
Language : SQL, PL/SQL
Project name : E-Panchayat
Web address : panchayatonline.gov.in/viewPESHome.html
About the project :The Ministry of Panchayati Raj (MoPR) has undertaken E-Panchayat Mission Mode Project(e-Panchayat MMP) with a view to introduce and strengthen e-Governance in Panchayati Raj Institutions (PRIs) across the country and build associated capacities of the PRIs for effective adoption of the e-Governance initiative.
Under this project, Panchayat Enterprise Suite (PES) has been conceptualized which comprises 11 Core Common applications.
At present, Panchayat Enterprise Suite has been deployed/ operational with 10 Core Common Applications and GIS layer module is under conceptualization. The operational modules includes LGD (Local Government Directory), Area Profiler (Socio-economic &general details), PlanPlus(to strengthen Decentralized & Participatory Planning), PriaSoft(Panchayat Accounting), Action Soft(Works/scheme implementation Monitoring System), NAD(National Asset Directory), Service Plus(To facilitate Service Delivery), Social Audit, Training and National Panchayat Portal(Dynamic Website of Panchayats).
Roles & Responsibilities :
** Responsible for installing, upgrading and configuring the operating system and troubleshooting .creating multiple databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
** Create & Managing Database Structure, Storage Allocation.Involved in creating tables, indexes and views. Hot and cold backup.
** Worked extensively on Performance Tuning, RAW Devices.
** Cloned databases using scripts.
** Responsible for Load and Performance testing of the database servers and application servers
** Configuring Backup (RMAN) for database and restoring database.
** Taking backups on daily, weekly and monthly basis.
** Monitoring Schema object (Tables and indexes) growth, Monitoring server, instances, database availability.
** Monitor users and transactions and confirm that backups have been made and saved successfully in the defined location.
** Involved in creating, managing and assigning roles and privileges to users.
** Inspected log file, monitored table spaces and partitions.
Professional Qualification :
** Bachelor of Technology in Information Technology from Lovely Professional University Jalandhar in June 2012 has got 5.29 cgpa.
** Oracle database 10g DBA Training in 2012 from NIIT New Delhi.
Educational Qualification :
** Senior Secondary from Uttaranchal Board of School Education in June 2008.
** Matriculation Uttaranchal Board of School Education in June 2005.
Hobbies :
Reading novel, interaction to new people, listening to music, adventure sports.
Strength :
Good communication skill, diligent, punctuality, self-motivation, confidence, supportive and quick learner.
Date :
Place :