Sr. Oracle DBA

BHOODEV SHARMA

Cell: 91-990******* Tele: 91-79-232*****

Email – ************@*****.***

SUMMARY

Oracle 10g Certified DBA with overall 11+ years of experience in IT with 6 + years of experience in Oracle Database Administration, Oracle RAC, Oracle DataGuard, RMAN, ASM, Performance Tuning, Security Administration, Distributed Databases, Migration & Upgradations, Database Design, Data Modeling, Backup & Recovery in Windows / Linux environment.

OBJECTIVES

Intend to build a progressive career in Oracle Database Technology to constantly make my learning curve to move in a linear fashion towards highest level along with utilizing my strong Technical and Communicational skills coupled with overall personality development.

EXPERTISE

Oracle DataGuard - Oracle RAC

Oracle Administration - System Administration

EXPERIENCE

Senior Oracle DBA – Defence - Gandhinagar

Aug 2009 - Present (3 Years 01 Month) Gujarat, Rajasthan, Maharashtra Area.

Provide support in Oracle Database Administration, Oracle RAC, Oracle DataGuard, RMAN, Performance Tuning, Security Administration, Distributed Databases, Migration & Upgradations. Coordinating with other fellow DBAs and site DBAs with in Air Force for maintaining data services in 24X7 environments.

Overall Responsibilities:-

Ensuring high availability of database 10g RAC, 11g RAC with Dataguard.

Monitoring Database / Application performance, health and integrity.

Optimizing applications by using reusable components / techniques.

Addressing all Operating System, Applications and DB performance issues.

Routing Backup and Simulation of Performing Recovery on demand.

Creation of new databases in Production / Development Environment.

Purging old and unwanted files of Oracle DB and OS for better space Mgmt.

Database Re-organization of Tablespace / Datafiles for standard Management.

Relinking of RDBMS software after OS Patching, Migration, and Upgradations.

Root-Cause analysis for recurring issues in the Applications and databases.

Creation of standby databases as per the demand and need of the organization.

Turning Archivelog, Flashback, and Force Logging ON/OFF on the database.

Initialization Paramemeter changes in the production database whenever needed.

Applying Security patches to the database as and when CPU release patches.

Periodic Database Maintenance activity like Index Rebuilding, Table analyzing.

Performance Tuning of Database with Oracle Tools like AWR, ADDM, Statspack.

Performing Database Switchover / Failover on DataGuard, Clusters / Oracle RAC.

Testing and Validation of DR and HA strategies of the organization as per SLAs.

Coordinating for OS / Network Switchover / Failover on Linux / Windows Clusters.

Coordinating with App Dev, Sys / Net Admin teams for system improvement plans.

Installation and Configuration of EM Grid control for standard operation management.

Conducting Training for DBAs, and Jr. DBAs and building team for better coordination.

Audit of Database logins Using Database Trigger with user, system and IP specific.

Contacting various vendors for technical support and further solutions.

Oracle DBA - Defence - Gandhinagar

Apr 2007 – July 2009 (2 Year 4 Months) Gujarat Area.

Responsibilities:-

Installation, Creation and Maintenance of Oracle 9i, 10g databases as per OFA model.

Installation, Creation and Maintenance and Troubleshooting of 9i, 10g Oracle database.

Installation, Creation and Maintenance of Oracle 9i, 10g Data Guard and Standby databases.

Testing and Validation of Disaster Recovery using Physical, Logical standby database.

Performing the Role Transition as required and troubleshooting as DG standby issues.

Configuring and Administering Oracle Database and ASM and ASSM, ASMM.

Routine Database backups using RMAN, OS, exp, imp, Data Pump.

Managing Control, Data, Redo, Archive log files and trace files in the database.

Creating and Managing Password File, Oracle Services, Logs, Reports, Documentation.

Managing Space Management, User Management, Role Management, Quota Management

Oracle DBA - Defence - Jodhpur

July 2006 – March 2007 (09 Months)

Responsibilities:-

Installation, Creation and Maintenance of Oracle 9i database.

Creating and Maintaining RC for RMAN and refreshing database using RMAN.

Granting and Revoking privileges from and to the user as per requirement.

Routine Database backups using RMAN, OS, exp, imp as per defined in SLAs.

Managing Control, Data, Redo, Archive log files and trace files in the database.

Creating and Managing Password File, Oracle Services, Logs, Reports, Documentation.

Managing Space Management, User Management, Role Management, Quota Management.

Configuration of Statspack and generating reports as and when required as per SLAs.

System / Network Administrator - Defence - Jodhpur

Apr 2001 – June 2006 (05 Years 03 Month)

Responsibilities:-

Designing, managing the architectural and technical aspects.

Configuration and Maintenance of Servers & Services and AD Domain.

Configuration of DNS, DHCP, Firewall, Web, Mail, File/AV Server, GFI etc.

Design, Implementation and Review of AD Polices and Organizational Policies.

Implemented & Configuration of Hardware for data redundancy like RAID, LVM.

Installation and Configuration of Storage like SAN/NAS/NFS systems.

Management of Users, Roles, Quotas and Privileges in Domain Environment.

Setting up Virtualization environment for optimal utilization of resources.

Backup of Servers, Services and Analyzing & Testing of backups for real-time.

Using Sync Back tool to backup and restore large data like file servers.

Conducting reviews and helping the team on architectural and technical aspects.

Analysis of audits and reports on System security and Network security aspects.

Analyzing the requirements and provided the estimates from time to time.

Analyzing end-user needs, troubleshooting complex information systems mgmt.

Planning, implementation, updating and review of the project from time to time.

Planning, Design, Implementation of LAN/WAN and network topologies.

Installation, Configuration of Various Hardware and Network Devices.

Ensuring smooth Planning, installation & commissioning of the projects.

Implementing Disaster Recovery plan by implementing a good backup plan.

Preparing, Analyzing and Maintaining the ITIL related to each service and project.

Conducting of IT Training for Development of IT Team on New Technologies and Tools.

HR Admin / Discipline & Mgmt - Defence - Thane / Shillong

Nov 1993 – March 2001 (07 Years 05 Month)

Responsibilities:-

Experience as HR Admin to deal the matters related to Discipline, Admin and Management.

Management of Manpower, Performance Measurement and quality control as per SLAs.

Liaison and Co-ordination with Civil Authorities for ensuring vigilance with in organization.

Planning and Allocation of Budgets for Admin, Discipline and Facility Management.

Implementing short / long term policies to achieve Organizational and Operational goals.

Judicious utilization and deployment of available resource to achieve defined targets.

Responsible for the accomplishment of Annual Reports in respect of person working under me.

Responsible for arrangement of VIP tour to the stations and out of stations.

TECHNOLOGY DOSSIER

Database Administration Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g, Oracle XE.

Operating Systems WinNT, Win2003, Win 2008, Windows Professional 2000, XP, Windows 7, RHEL AS-ES -3/4/5/6, OEL 4/5/6 .

Virtualization VMWare Server, VMware Workstation, Oracle VM, all VMware suits

HA & DR for DB RAC & DataGuard.

HA & DR for OS OS Clustering and Network Load Balancing, Replication using DFS

Database Utilities RMAN, EXP & IMP, DATA PUMP, OPATCH, CLUVFY, TKPROF, SRVCTL, CRSCTL, OIFCFG, NETCA, NETMGR, LSNRCTL, SCAN, TNSPING, OLSNODES,ORAPWD,ORADIM.

Storage RAID, LVM, NFS, NAS, SAN, Openfiler.

Languages SQL, PL/SQL, SHELL Script, Java.

Database Tools OEM DB Control, OEM Grid Control, iSQL Plus, Sql Developer, Oracle Toad, Putty,

OS Tools SSH, Telnet, Syncback, FTP.

EDUCATION / CERTIFICATIONS / TRAININGS

MCA Pursuing (2010-2013) from ICFAI University.

MA English, Economics (1998, 2000) from Meerut University.

Oracle9i OCA, OCP, Oracle 10g OCP– DBA (2009) from Oracle Corporation.

Received Training in Oracle10g, Oracle11g RAC (2011) from HCL Noida UP.

Received Training in Oracle9i, Oracle10g Data Guard (2008) by Air Force.

Received Training in Oracle9i (2006), Oracle10g (2007) by Air Force.

Received Training in Network / System Administration by Air Force.

PERSONAL DOSSIER

Name Bhoodev P Sharma

Father’s Name Shri Mahesh Chand Sharma

Date of Birth 28th April 1974

Languages Known Hindi, English

Passport Number H9880666

Notice Period 30 days

Hobbies Reading, Writing, Keen Learner of New IT Implementations, R&D

Date: 14 Sep 2012 Bhoodev Sharma

Contact this candidate