Project Oracle

PROFESSIONAL SUMMARY

* ***** *** ** ****** of experience in Oracle Database Administration in Oracle versions 9i, 10g, 11g and 12c in standalone, High Availability (RAC) and Disaster Recovery (Data Guard) and Maximum Availability Architecture (MAA) environment.

Expertise in Database Migration (9i/10g/11g 11g/12C) using EXPDP/IMPDP, RMAN, TTS and Oracle Golden Gate; cross-platform migration.

Experience in Oracle Exadata Machine maintenance including Exadata Patching.

Expertise in Performance Tuning and application Code/SQL tuning (using AWR, ADDM, explain plan).

Expertise on Oracle Golden Gate installation, configuration, transformation and troubleshooting.

Provisioning Servers, installing Oracle Core software versions 9i, 10g, 11g and 12C in standalone and RAC environment with ASM.

Setting up, managing and troubleshooting Oracle Real Application cluster (RAC) and Data Guard technology on Oracle 10g, 11g and ASM.

Upgrading Oracle database 9i to 10g and 11G and different PSU/CPU patch apply.

Expertise in Database backup, recovery, cloning using RMAN and other technology.

Good working knowledge in monitoring instances using Oracle Enterprise manager (OEM) 12c % 13c.

Handle large databases (10TB) and monitoring, other daily work.

Unix & Linux shell scripting

Playing a major role in decision making and providing solutions to organization and client business to avoid financial Penalties due to failure in meeting SLA and committed timelines.

Carrying Managerial Expertise like Motivating team, Building and merging teams, promoting right talent, performance appraisals, hiring, Budgeting, License negotiations, Negotiations with vendors, Project and task assignments, Technical guidance to the team, Retaining staff, Remotely managing teams

Providing RCA (Root Cause Analysis) for customer reported issues to ensure high Customer Satisfaction.

TECHNICAL SKILLS

Hardware / Platforms

Sun Solaris (10), Linux(RHEL 4,5,6),Windows

Technology

Oracle database Administration - 9i, 10g, 11g, 12C

Oracle Real Application Cluster

Physical Standby

Automatic Storage Management

Oracle Enterprise Manager

Export/Import, Data Pump, Data Guard Broker SQL Loader, RMAN, Oracle Golden gate, Performance Tuning

Programming Languages

PL/SQL, Shell Scripting

Databases

Oracle 9i,10g,11g,12C

Database Tools

OEM, RMAN Backup and Recovery, DGMGRL, Export, Import, Data Pump, TOAD, BMC monitoring tool, SQL Developer.

Other tools

UNIX Shell scripting, Putty, HP Quality Center, BMC Remedy, TOAD, Oracle EBS R12, Service-Now

Education:

Degree

College/University

Bachelor of Technology, in Electrical Engineering

Calcutta University

EXPERIENCE SUMMARY

PROJECT PROFILE 1

Project Title

KPN Exadata & Database Support

Duration

March 2016 – Till Date

Location

Kolkata

Hardware

Oracle

Operating Systems

Linux(RHEL)

Technologies

Oracle Database 11g and 12c

Tools

Database tools, Service-Now ticketing tool

ROLES AND RESPONSIBILITIES IN THE PROJECT

Oracle Exadata machine maintenance

Exadata Machine Patching (cell server, Compute node, ILOM, IB switches patching) including patch planning, outage calculation, communications, co-ordination and execution with post-patch validation.

Installation and configuration of 12c & 13c OEM.

Monitoring Exadata Machine resource and databases using OEM and scripts and troubleshooting as and when required.

Work with Oracle SR for critical issues.

Scripting, Documentation, share-point maintenance, shift roster preparation and working in shifts.

On demand Post Migration Performance Tuning using AWR, ADDM, Explain Plan and OEM grid.

Monitoring to adhere the ITIL process throughout the activity.

To generate weekly status report and present the status in weekly status call.

Monitoring, managing & troubleshooting 12c cluster, ASM with 11g and 12c databases in standalone, High Availability (RAC) and Disaster Recovery (Data Guard) environment

PROJECT PROFILE 2

Project Title

GSK R&D IT Oracle Upgrade Program

Duration

March 2014 – Till Date

Location

Kolkata

Hardware

HP

Operating Systems

UNIX, Linux(RHEL), Solaris

Technologies

Oracle Database 9i, 10g, 11g,

Tools

Database tools

ROLES AND RESPONSIBILITIES IN THE PROJECT

Application Schemas/Database Migration (9i/10g/11g 12C) using legacy export/import and data pump technology; cross-platform migration.

To lead the migration team consisting of 5 members, to create shift roaster, to raise cab request, to maintain leave request

Fixing strategy for Database Migration with Minimum Downtime.

To co-ordinate/communicate/follow up with the application owner, Global Database Team, application support team to fix up any issues, schedule the downtime window and dependent activities.

Maintain Automation Script for Application Schemas/Database Migration.

Monitoring to adhere the ITIL process throughout the migration activity.

To generate weekly status report and present the status in weekly status call.

To take part actively in organizational audit for the project.

To create and maintain migration tracker.

To provide/arrange post migration application remediation support with high level solution in accordance with the scope.

To provide performance tuning support on demand

PROJECT PROFILE 3

Project Title

L2 DBA Support for Sanofi Pharmaceuticals

Duration

Oct 2012 – Nov 2014

Location

Kolkata

Hardware

HP

Operating Systems

UNIX, Linux(RHEL), Solaris, Windows

Technologies

Oracle Database 9i, 10g, 11g, RAC, ASM, Physical Standby, RMAN, Oracle Golden Gate 11G

Tools

HPDP, BMC ticketing Tool, Database tools

ROLES AND RESPONSIBILITIES IN THE PROJECT

Provisioning new databases in standalone, RAC and Data Guard environments with maintenance and troubleshooting.

Installing and configuring Oracle Golden Gate for unidirectional and Bidirectional Replication, Data Transformation, monitoring and troubleshooting.

Database Migration with Minimum Downtime using Oracle Golden Gate.

Automation Script for Oracle Golden Gate Installation and configuration.

Setup, monitor and maintain all databases jobs such as gather stats, backups etc.

Created generic backup shell script to take backups of all the databases in different level (Full/Incremental/Archive log)

Upgrade database from 9i to 11g and from 10g to11g.

Ticket Management – Incident, Change and Problem management

Maintain a consistent level of availability for supported Databases

Database patching – Planning and Implement.

Refreshing Dev/Test databases with production using RMAN cloning, exp/imp and data pump.

PROJECT PROFILE 4

Project Title

Technical Assurance in British Telecom : OpenReach and Merlin

Duration

Jan 2010 - Oct 2012

Location

Kolkata

Hardware

HP

Operating Systems

UNIX, Linux(RHEL), Solaris

Technologies

Oracle Database 9i, 10g, 11g, Performance Tuning

Tools

Database tools

ROLES AND RESPONSIBILITIES IN THE PROJECT

Planning, Feasibility Analysis, Impact Analysis with database backup design, migration etc.

Reviewi systems and implementing necessary changes in the database and kernel parameters.

Reviewing PL/SQL codes from system, database and application point of view.

Linux/Unix scripting.

PROJECT PROFILE 5

Project Title

British Telecom : Oracle DBA (Siebel CRM Upgrade)

Duration

Nov 2009 - Jan 2010

Location

Kolkata

Hardware

HP

Operating Systems

UNIX

Technologies

Oracle Database 10g, 11g, Performance Tuning

Tools

Database tools

ROLES AND RESPONSIBILITIES IN THE PROJECT

Planning, Feasibility Analysis, Impact Analysis From database point of view.

Oracle provided wizard have been modified for large tables with parallel hint to reduce the downtime of upgrade process.

PROJECT PROFILE 6

Project Title

British Telecom : L2 Oracle DBA (Production Application Support)

Duration

Mar 2008 - Nov 2009

Location

Kolkata

Hardware

HP

Operating Systems

UNIX

Technologies

Oracle Database 10g, 11g, Performance Tuning

Tools

Database tools

ROLES AND RESPONSIBILITIES IN THE PROJECT

Providing application supports for Oracle 9i and 10g running on HP.

Monitoring and tuning Application Server performance.

Identifying, resolving, or providing recommendations to other different kinds of the performance problems ranging from Database performance problems to I/O hardware performance problems.

Upgrading and migrating Databases for Dev, Test, and Production environments.

Created roles, configured Application Server, setup Process Scheduler, brought up Web Server, updated report repository and changed passwords through Application Design, etc.

Creating new databases and users, setting up RMAN backups, Export, and other monitoring scripts.

Expert in Oracle Replications.

Performing database tuning using Explain Plan, hints, Toad, and Enterprise Manager.

Providing 24x7 on call production support.

PROJECT PROFILE 7

Project Title

British Telecom: Quality Assurance Team Lead(IVV&T)

Duration

July 2007 - Feb 2008

Location

Kolkata

Hardware

HP

Operating Systems

UNIX

Technologies

Oracle Database 10g, 11g, Performance Tuning

Tools

Database tools

ROLES AND RESPONSIBILITIES IN THE PROJECT

Analyzing of Business Scenarios and Preparation of Test cases, Test plans (Includes interaction with the End to End Designers, to understand the actual flow and also to track down minute changes from previous Quarter).

Test Data Preparation (Both Stubbed and Real Data).

Execution of Test Cases using the relevant hardware, software environment configured for the same.

Logging the defects in Mercury Quality Centre.

Tracking the defects till the Issue is resolved (Includes interaction with the concerned Component Team and the other related Teams).

Retesting of Defects.

Taking active part in IQA.

Preparation of tracking sheet on a Daily basis to track the progress of the Testing process to ensure Productivity, maintain Traceability and avoid Confusion.

Perform as the Point of Contact for the Team.

Contact this candidate