Post Job Free

Resume

Sign in

Oracle DBA

Location:
San Jose, CA
Posted:
February 01, 2017

Contact this candidate

Original resume on Jobvertise

Resume:

T Siva Prasad Phone: +1-408-***-****

Mail Id:acyleq@r.postjobfree.com

PROFESSIONAL SYNOPSIS

SUMMARY:

Having 8 years of Experience as Oracle DBA (Core) in Database Management System

Had experience in 27X7 Oncall support

Experience of successfully planning, implementing & supporting O racle RAC

10g/11g and 12c

(non CDB) with D ata Guard as Oracle Maximum Availability Architecture (MAA).

Responsible for planning & implementing DR exercise (Disaster Recovery) using

B roker and

F SFO (via observer).

Experience in configuring Snapshot Standby Database for DR testing

Have good knowledge on Oracle Streams. Designed and Implemented Golden Gate for data

replication on high transactional database.

Handled 50 TB large OLTP systems with 12 node RAC

Experience in installing/upgrading Grid Infrastructure versions 11g and 12c (non CDB

environments)

Good knowledge on RAC architecture and troubleshooting Cluster ware issues

Successful planning and implementation of rebuild activity on large critical databases, part of

archiving, purging and storage reclaim.

Users/ Tablespace management

Good experience in ASM administration and online storage migration

Good knowledge on traditional and RMAN backups and maintenance

Performed RMAN incremental and compressed backups

Experience in restoration from offline/online backups through RMAN, up on application teams

request

Good knowledge on export/import and expdp/impdp utilities

Performed couple of RDBMS upgrades from 11.2.0.2/11.2.0.3 11.2.0.4 with application

version 12.1.3 and 11.2.0.4 12.1.0.2 with application version 12.1.3

Experienced in cloning from RAC to Standalone and vice Versa

Good experience in RDBMS patching (Opatch). Bug fix patches and PSU patches

Good knowledge in reviewing workload repository AWR, ASH and ADDM

Good experience in monitoring and performance tuning using OEM (Oracle Enterprise

Manager), versions 10g and 12c

Good in understanding OS/Kernel level issues and reviewing system logs (messages)

Configuring OS Watcher for DB and Application nodes

Have knowledge on OCM (Oracle Connection Manager), LDAP (Lightweight Directory Access

Protocol) OID ( Oracle Internet Directory) and IDM (Oracle Identity Manager)

Have installed and supported Fusion Apps 11.1.4

Fusion middleware components (SOA Suite 11.1.6, WebLogic 10.3.6). RCU, OHS

Domain

C reation, Managed Server and Node manager configuration.

Performed SOA Active-Active setup along with proxy enablement from 11g OHS to

12c OHS

Active participation in M onth-end/Quarter-end/Year-end activities

Have knowledge on APACHE HADOOP,MAPR HADOOP and looking for platform

to get

p rofessional hands-on

Periodic meetings with clients.

SR follow up on bug fixes and upgrade queries

Experienced in Shell scripting

Excellent team player, oral and wri t ten communication skills

TECHNICAL SKILLS:

Oracle Real Application Clusters (RAC), Oracle Enterprise

Oracle Technologies:

Manager (OEM), Oracle Recovery Manager (RMAN), Data

Guard, Oracle Golden Gate, Automatic Storage Management

(ASM), Flash Recovery Area (FRA), Performance

Tuning.

Oracle 12c (non CDB)/11g/10g/9i/8i

RDBMS:

Oracle APPS 11.5.10.2 & R12, R12.2, R12.2.5

ERP :

Shell, Python(beginner)

Scripting languages

HP-UX, Solaris, RHEL 6,5

Operating Systems:

RMAN,OEM, OCM, ASM, Export/Import, Toad, Data pump,

Tools & utilities

TKPROF, EXPLAIN PLAN, AWR, Crontab, putty, Net

backup, DBUA, DBCA, DGMGRL,FNDPASS, SQL *

Developer

CAREER CONTOUR

Project II:

Client: Cisco Systems, Inc, CA, USA

Jan 2014 Present

About Client:

Cisco Systems, Inc. is an American multinational corporation headquartered

i n San Jose, California, United States, that designs, manufactures, and sells

networking equipment. Cisco Systems is a large corporation that produces computer

networking products and services. The L inksys brand of consumer networking

p roducts is also an owned subsidiary of Cisco Systems.

Function & Scope: Continuous support to 500 + Production databases and alerts monitoring for all non

Production and Production databases

Current Responsibilities:

Providing 24/7 support of Production, Development and Test instances on various platforms in Unix

environments like Sun Solaris, HPUX and Linux

Alert handling for Prod and Non Prod databases for Standard and User Defined Metrics in

Enterprise Manager.

Following up with oracle through SR for critical issues

Responsible for database Installation Software (9i & 10g Enterprise Edition for

Databases and Clients)

Upgrade of databases from Oracle 9i to 10g and 10g to 11g, CRS upgrade from

11.1.0.7 to 11.2.0.4 with scan configuration

Cloning databases with various strategies like Cold/Hot/Logical Refresh including

R MAN Cloning also.

Migrated 10g databases on AMS three node cluster from one Cluster to another without

any down time as a part of Servers lease (By switching of VIPs)

Proficient in DBA tools 10g Grid, OEM and Approx. (Scheduling tool).

Performed refreshes from non-RAC database to a RAC environment and vice versa.

Worked on a project to upgrade several GEHC 9i Databases to 10g/11g and 10g to 11g on

L inux/Solaris servers.

In teracting with several teams like Web services, application & Sys-Admins.

Documenting the steps involved and rolling out the action plan.

Resolved many issues during database migration from Solaris normal mounts to L inux

w ith ASM disk groups following up with oracle.

Applied database patches using O-Patch utili ty

Installed patch sets and upgraded Oracle (RDBMS).

Regular maintaining and supporting the Oracle ERP Systems

PSU Patching for oracle applications

User creation, ending, responsibility adding

Key Tasks Handled:

Operational Excellence

Incident Management : Working on escalated cases from L1/L2

Problem Management : Working on Problem tickets under P1/P2 incidents

Change Management: Working on Change implementation on non-prod and production

environments.

Regular Database health checkups and performance tuning through memory advisors

Providing Long Term Fix and documentation for alerts trigger by OEM 12c

Troubleshooting user connectivity issues/DB slowness issues/Job performance issues

Online storage frame migration on ASM DBs and supporting offline migration for RAW devices

Troubleshooting RAC node eviction issues

Troubleshooting SCAN and Service failover issues

Troubleshooting Data Guard Broker issues and root causing for failover/switch over failures.

Deep drive on tablespace consumption and working with application teams on data purge and

storage reclaim

Follow up with Oracle for bug fixes and computing team for host or storage level issues

Periodic password changes for super users RDBMS:sys/system ERP:apps/sysadmin

Applying bug fix patches and Quarterly released CPU/PSU patches (opatch)

Troubleshooting load balancing issues for RAC DBs

Troubleshooting connectivity issues which connects through OCM

Proactive space addition as part of organic growth for both ASM and RAW devices

Audit report generation as per SOX compliance based on Audit team request

Analyzing AWR/ASH reports

Analyze job maintenance

Troubleshooting RMAN backup failures

Performing RMAN incremental backups during Standard Database lag.

Weekly meeting with application teams

Writing and Scheduling shell scripts based on adhoc requests

Participating in Month-End/Quarter-End/Year-End closure.

Documenting best practices and solutions for team

Performing Standby Database build based on application team requests.

Installing Weblogic, SOA suite

Installation of OHS 11g and 12c with proxy enabled

Configuring Active-Active configuration for SOA

Configuring Standard Database along with Database broker configuration

Performing Data Guard failover and Switch over use cases.

Customizing Standard Database to make other Standard Database as fal_client

Upgrading Grid Infrastructure from 11.2.0.3 12.1.0.2

Upgrading RDBMS 11.2.0.3 12.1.0.2 (PSU 16)

Upgrading RDBMS 11.2.0.4 12.1.0.2 (PSU 16) ERP: 12.1.3

Table space/Schema mapping based on application team requirements.

Project I:

Client: Cisco Systems, Inc, India

Jan 2009 Dec 2013

About Client:

Cisco is the worldwide leader in networking that transforms how people connect, communicate and

collaborate. At Cisco (NASDAQ: CSCO) customers come first and an integral part of our DNA is

creating longlasting customer partnerships and working with them to identify their needs and provide

solutions that support their success.

Function & Scope: To provide Continuous support for production Database and Non Databases to clients

through low and High priority incidents through Remedy tool.

ERP and Non ERP databases refreshes.

Current Responsibilities:

Cloning of database for development teams, import and export of data. Applied all type of patches to

11.5.9, 11.5.10, 11.5.10.2, R12 versions of ebusiness suite and Databases

Supporting clients for connectivity issues, performance issues, data loss issues through incidents.

Proficient in Database Administration activities such as Upgrades, Patches, SRSupport, Cloning

Key Tasks Handled:

Operational Excellence

Working as Technical Lead for Refresh Team of 12 members and responsible for delivering around 50

ERP and non ERP environments every month

Avoided Business escalation for multiple clone issues by root causing and fixing the problems

and delivered environments within SLA under tremendous pressure.

Prepared technical and process documents on need basis.

Played major role in automating Core and ERP Database clones.

Conducted trainings for team on process changes and technical issues.

Expertise in upgrade from 11.5.10.2 to R12(12.1.x/12.2.x) and also database upgrade from 9i to

10g/11g.

Expertise in Oracle cluster ware/RAC/ASM

Extensive experience in setting, implementing and maintaining Dataguard in 9i,10g and 11g on

standalone and RAC database

Having very good experience in DB (9i to 10g/11g) Refreshes and EBS clone (11i/R12). We have

executed nearly 50 DB Refreshes and over 30 EBS clonings per month.

Good knowledge in troubleshooting cloning issues.

Good knowledge in RMAN backup and recovery scenarios like Database full and incremental

backups and Full Database Restoration, Partial Database Restoration and Partial Table space

Restoration etc.

Extensive experience with RMAN 11g features, Active Database duplication using RMAN.

Expertise in implementing Oracle Cluster ware installation and configuration.

Involved in various projects for capacity planning.

Strong Oracle RAC performance tuning and troubleshooting skills.

Performance analysis, Workload repository and Active Session History analysis.

Expertise in Oracle ASM administration

Applying CPU and PSU patch sets every quarter for bug fixes and security vulnerable.

Good knowledge in Data Guard Failover/Switch over scenarios and active participation in Data

Guard FSFO testing.

Regular schema refresh using Datapump, exp/imp.

Troubleshooting of concurrent manager, concurrent requests related issues.

Work Flow Mailer configuration and troubleshooting Workflow issues.

Miscellaneous tasks such as printer related issues, scheduler tasks, etc.

Running Autoconfig and fixing autoconfig related issues

Good knowledge in TKPROF and analyze

Expertise in Defragmentation and reclaiming space through rebuild.

Expertise in cloning nonshared to Shared APPL_TOP

Creating Application and Database Users, Granting Privileges, Creating Roles on the databases

Preparing Detailed PATCHING execution plans as per the customer requirement.

Applying latest releases of the application patches (with/without hot patch option) to resolve any kind

of application issues.

Applying the Application of Security Patches, RDBMS Patches, Functional Patches, JDK upgrade and

Jinitiator upgrade patches, isetup Patches and isetup configuration.

Regular use of adadmin activity for various maintenance tasks.

Good knowledge in performance tuning by analyzing AWR and ADDM reports

Brief knowledge on weblogic for administrative activities.

Worked on Database Decommissions.

Creating database users and granting privileges

Adding datafiles to a Tablespaces and allocating quota to the users

General Management

Responsible for taking actions to improve personal and professional skills, knowledge and abilities.

Responsible for focusing on discovering and meeting customer/client needs.

Responsible for fostering the longterm learning or development to the team.

Responsible to take independent action or proactively create opportunities to resolve or prevent

problems in keeping with role.

Notable Credits

Received Connoisseur Award for Technical support and decision making at critical situation for the

year 20132014

Received Innovation Award for exceptional ideas that lead to a high proficiency in project for the

year 20142015

SCHOLASTICS

MS from BITS PILANI in the Academic year 2012

BEHAVIOR COMPETENCIES

Excellent communication skills

Motivational and mentoring skills

Ability to work around limitation

Good Interpersonal skills

Ready to work at any shift

Time Management

Planning & Prioritization

Problem Solving

Multitasking

Boundary less behavior

PERSONAL DOSSIER

Languages Known : English, Hindi and Telugu

Nationality : Indian

Marital Status : Single

Passport : Valid

Visa : H1B (Valid)



Contact this candidate