Management Oracle

To work in a challenging and dynamic environment, require constant development of fresh skills and to utilize existing skills to achieve the business goal. As dedicated, hardworking, multi-skilled and technically experienced, I look forward to share my expertise and experiences of IT field for a suitable and pervasive profession.

Professional Highlights:

Total 16 years’ IT experience.

15 years’ experience in Oracle Technology

oHandling Projects (new/up-gradation/migration) to setup RAC, Dataguard, standalone as per the requirements of application & development team with consideration of suitable Hardware, OS, network, storage, type of monitoring etc. Transition of projects with KT plan, trained fresher and experienced as per project requirements.

oProviding production support On-Call 24x7, troubleshooting, and performance optimization, activities for Pro-active approach solutions, Service Delivery, Service of Excellence, inter-departmental coordination and escalation management. Consistent performer in all the sites/roles

Current organization: Dell Services (Mar 2011 to till date)

Previous with Indian Air Force (Mar 1999 to 2011) as officer-in-charge of IT, handled multiple projects, wide experience of People management globally with Individual development plan as per organization requirement, Experience in bidding and presales.

Certification:

OCP : Oracle 11c certified

OCE : RAC oracle 11g

ITIL V3 intermediate

Six Sigma Green Belt

Project Management : Portfolio, Program & Project (Dell internal certification)

Technical Summary –

Operating Systems

Windows server 2000,2003, 2008, 2012

Linux, Solaris, HP-UX, AIX

Programming Languages

SQL,PL/SQL, Java, JSP, J2EE, C, C++, HTML

Utilities / Tools

Exadata, Golden Gate, Unix shell scripting, Toad, Oracle ASO/TDE, RMAN, ASM, Export, Import, Datapump, Tkprof, STATSPACK, AWR, ADDM, RAC, Oracle LDAP, FCF, FAN, ONS, SCAN. Data Guard, database migration & Up-gradation, Oracle Partitioning, Replication & Streaming, SQL*loader, Oracle Enterprise Manager Cloud Control 12c

Web Technologies

HTML, Dream-weaver

Databases

Oracle 7i, 8i, 9i,10g, 11g & 12c

Oracle DB migration

Used shell scripts, goldengate, shareplex DB2,sybase, MYSQL server to Oracle

Oracle Application Server

(11.5 & R12), Oracle Weblogic server Administration, Oracle Access Manager (Web SSO) integration with Oracle Apps R12,

Other databases

MS SQL server,MySQL

Other technology related to database

Operating Systems, Client/Server Architecture, Middleware and Hardware (Servers, SAN, SRDF, Shadow Image, Network)

Cloud computing

Amazon Web Services, Microsoft and VMware

Project Management Process :

PM3 : Portfolio, Programme & Project

From OS installation to application/database, handling the projects independently with good liaison with other team resources

Service Management Process:

Tool - BMC

Management of Request, Incident, change, problem

OPERATIONS MANAGEMENT:

Management of Incident Management, Change Management and Problem Management, providing the RCA as per customer/management requirement

KPI calculation, Escalation Handling, Stakeholder Management, BAU handling and Management

PROACTIVE ENGAGEMENT

oUpkeep of system sanity (ensuring monitoring and health checks are compliant)

oDriving Service Improvement Plan to local and global capacity issues and develop proactive plans.

OPERATIONAL UPDATES AND MANDATE

oService Delivery Interactions, including presenting KPI

oManagement Reporting

oTeam representation

oAdhoc reporting

RESOURCE ENGAGEMENT

oResource Management

oConflict resolution

oAppraisal and Feedback

oInterviews and Onboarding

oCareer roadmap planning

Technical Skills

Installation, configuration and upgrading of Oracle server software and related products, Patch Management (RAC, Single Instance)

Database Migration including Data Guard(cross platform also) and Golden Gate

Database Up-gradation, down-gradation

Troubleshooting using logs, dumps, trace

Performance Tuning

OEM Grid Control, Cloud Control 12c

RAC (9i, 10g, 11g, 12c)

RMAN(backup and recovery)

Unix, Linux and good in Unix command, shell script

Oracle interactions with VMware, network, firewall, storage, OS, monitoring, backup etc.

DR and BCP planning

Non-Technical Skills

oMust have handled a team and have performed end-to-end resource management from onboarding to appraisals.

oworked as an Operations DBA

oGood troubleshooting skills is must

oDocumentation of all critical process and functions

oCapable to evaluate/suggest database tools based on customer need

oGood in risk identification and recommendation customer with mitigation

oAbility to collaborate with a Global team, share relevant information, seek to convince others, know how to listen effectively and promote a team spirit

oClient focused and service minded to truly listen and understand the Voice of the Customer.

oCreativity, problem solving and analytical skills to effectively translate technical issues into key activities and develop new methods and approaches to satisfy requirements

oGood Communication skills (both oral and written) to develop and deliver the key messages for our customer and internally

oWilling to work as part of a team and provide 24X7 support when required

oTarget driven, strong focus in achieving joint agreed tasks

Managerial skills

Provide technical and operational direction to team.

Review standard deliverables worked by team.

Recognize system deficiencies and implements effective solutions.

Consistently deliver high-quality services.

Facilitates team and client meetings effectively.

Holds regular status meetings with team.

Delivers engaging, informative, well-organized presentations.

Resolves and/or escalates issues in a timely fashion.

Understands how to communicate difficult/sensitive information tactfully.

Identifies opportunities for improvement and makes constructive suggestions for change.

Manages the process of innovative change effectively.

Facilitates effective team interaction.

Acknowledges and appreciates each team member's contributions.

Effectively utilizes each team member to his/her fullest potential.

Keeps track of lessons learned and shares those lessons with team members.

Manages client interaction and expectations regarding service quality.

Communicates effectively with clients to identify needs and evaluate alternative technical solutions.

Continually seeks opportunities to increase customer satisfaction and deepen client relationships.

Builds a knowledge base of each client's business, systems and objectives.

Good knowledge of sales proposal

Good knowledge in Oracle Licensing

Assignment Details –

Project 01 – handling 780 databases at a time

Wolters Kluwer, CHEP,MSA, HILTON, TOWER WATSON,SEAWORLD,

Demographics- Health Care, production, US Government Tax, Legal, Finance and Banking 10 Mar 2011– till date

Environment worked on; server platforms: Linux, AIX, Solaris, HP-UX, Windows database: Oracle 7i, 8i, 9i, 10g, 11g & 12c

Project Description :

Database migration: cross/same platform with transportable Tablespaces, using RMAN. Up-gradation (9i to 11g and 12c), patching,

Data Guard : 10g & Active dataGaurd 11g, 12c setting up dataguard RAC to RAC environment.

Oracle RAC (Real Application Clusters),

Advanced Replication, Cluster Maintenance (Failover / switchover) at the Operating System Level,

D.R. (Disaster Recovery) Implementation & Configuration

Analyzing performance, recommending solutions to enhance performance

Project 02

Demographics – Aircraft Software, Jan 2003- 08 Mar 2011 Indian Air Force

Environment with oracle worked on; Linux 4.6, Database oracle 10g, VB with crystal Report

Project Description – The project was implemented for having the records of aircraft servicing (Daily Inspection, 50 hrs, 100 hrs, 200 hrs, overhaul), Defect report, Refueling, Calibration of components, Details of Components, Records of servicing tradesman(who has done what, when and why), Flying record of Pilots, Flight Engineers & Navigators.

Role –

Installation (OS, Oracle Cluster ware Software, Oracle software on Linux, Solaris, HP-UX & AIX).

Creation of Database

Monitoring and tuning database performance

Installation, Setup and Maintenance of Standby & Data-Guard(RMAN & Manual)

Installation, Setup and Maintenance of Streaming

Installation, Setup and Maintenance of Replication

Installation, Setup and Maintenance Oracle RAC (Linux, Solaris, HP-UX & AIX)

Adding & Deleting node

Adding and Removing Instance

Migration of Oracle Database on different platform and same platform

Cloning of Database (RMAN, DBCA, Manual, OEM)

Setup and Maintenance of ASM instance

Up-gradation of database (Manual, DBUA)

RMAN utility for database backup and recovery solution

Logical backup using export-import, oracle data pump

Experience in managing security in the database level using roles, privileges, profiles etc.

Project 03

Demographics – Hospital Software, Oct - 2005- 08 Mar 2011 Indian Air Force

Environment worked on; Platform AIX(5.3), Database oracle 10g, Java

Project Description – The project was implemented to have the medical record of personnel and dependents (Mother, Father, spouse and children)., like Medicine prescribe by doctor, How many times fall sick, hospitalized, operation details, allergic medicine, all tests, medical category, Hospital Inventory

Role –

Installation (OS, Oracle Clusterware Software, Oracle software on Linux, Solaris, HP-UX & AIX).

Creation of Database

Backup and Recovery policies (Offline, online, Incremental RMAN)

Monitoring and tuning database performance

Implementation, Managing and Switchover of Oracle 9i/10g Data guard

Oracle Database Performance Tuning

Installation, Setup and Maintenance of Replication

Installation, Setup and Maintenance Oracle RAC (Linux, Solaris, HP-UX & AIX)

Adding and Removing Instance

Migration of Oracle Database

Cloning of Database

Setup and Maintenance of ASM instance

Up-gradation of database (Manual, DBUA)

RMAN utility (backup and recovery, cloning, migration, duplicate)

Physical backup

Experience in managing security in the database level using roles, privileges, profiles etc.

Project 04

Demographics – Manpower Software, Jan 2008 - 08 Mar 2011 Indian Air Force

Environment worked on; Platform Sun Solaris 5.9, Database oracle 10g java

Project Description – The project contains record of Manpower (attendance, leave, pay, posting, temporary duty, training, family detail, dependents, address, contact number, courses undergone, achievement, awards, punishment, appreciation,

Role –

Installation (OS, Oracle Clusterware Software, Oracle software on Linux, Solaris, HP-UX & AIX).

Creation of Database

Backup and Recovery policies (Offline, online, Incremental RMAN)

Monitoring and tuning database performance

Installation, Setup and Maintenance of Standby & Data-Guard(RMAN & Manual)

Installation, Setup and Maintenance of Streaming

Installation, Setup and Maintenance of Replication

Installation, Setup and Maintenance Oracle RAC(Linux, Solaris, HP-UX & AIX)

Employed various Oracle 10G Features/tools such as Automatic Database Diagnostics Monitor (ADDM), Automatic Shared Memory Management (ASMM) for Performance diagnosis/tuning and Automatic Segment Space Management (ASSM)

Analyze and Audit on databases, check space, index rebuilding.

Migration of Oracle Database

Cloning of Database (RMAN, DBCA, Manual, OEM)

Setup and Maintenance of ASM instance

Up-gradation of database (Manual, DBUA)

RMAN utility for database backup and recovery solution

Logical backup using export-import, oracle data pump

Enrolling the custom users by assigning appropriate roles and profiles at the RDBMS levels as per the need

Professional Training –

Oracle DBA :

(9i, 10g, 11g & 12c) Trained by Oracle Corporation India

Oracle Developer :

(9i, 10g, 11g) Trained by Oracle Corporation India

Apps DBA:

(11.5 & R12 installation & maintenance multi user, multi Platform)

Developer :

Java, JSP, J2EE, C, C++, HTML

Multimedia :

(Sound forge, Adobe photoshop, Flash, Premiere, 3D Max, Director)

System and Network Administrator :

(Windows & UNIX)

Linux (3, 4 & 5) from Redhat

AIX (5.3), HP-UX, Solaris

Academics –

BE (electrical) 74%

MBA (Systems) 60%

Personnel Details:

Mobile no=096********

Name : Sanjeev kumar

Father’s Name : Braham Singh

********************@**********.***

Contact this candidate