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)