Database Administrator Oracle

Venkata Sivakumar Vuradalla

Lead Database Administrator

Email: ********@*****.*** Phone number: +1-818-***-****

Professional Summary:

Having hands on experience on various database management systems and Oracle Applications with over 12+ years of experience as Oracle Database Administrator.

Extensive experience in managing shared service model containing more than 3000 Oracle Database RAC and NON-RAC instances of 10TB size which includes Production, Stage, and Development Test instances on OMCS, OPC and OCI Environments.

Good experience on oracle High availability tasks like ASM, RAC, Data Guard, Exadata and Golden Gate.

Managed team of DBA’s (Infra structure) Onsite and offshore across the globe.

Well versed with installation & configuration of oracle 9i, 10g, 11g,12c and 19c databases on Linux & Windows servers.

Expertise in Handlining Linux Environments

Experience in handling Multitenant Architecture.

Hands on Experience in migrating databases from AIX to Linux

Experienced in upgrading Oracle E-business Suite applications from 11.5.10 to R12.2.8 version.

Solid hands-on experience in installation, configuration, performance tuning of oracle database Environments

Hands-on experience in converting Oracle databases from conventional to Multi-tenant (PDB CDB).

Hands on experience with Unix/Linux environments.

Defined the cost saving structured shared service model for the operational DBA team servicing multiple projects

I specialize in migrating various flavors of databases including Oracle, PostgreSQL databases from on-premise environments to AWS, Azure cloud platforms.

Performed multiple Upgrades from lower version to latest version like 9i,10G,11g,12c to 19c.

Configured Data guard setup on different versions like 11g,12c and 19c databases.

Responsible for database switchover from primary to standby mode and vice versa;

Having good experience in Database Backups and Restores for Disaster Recovery purpose.

Experience in Performance tuning and Query optimization using Oracle supported tools.

Implementing backup strategy (hot) for production & non-prod restoring full DB/schema/object level backups.

Ability to perform all Database Administration (DBA) tasks like performing database backups and recovery, monitoring logs and hard disk consumption growth rate etc.

Responsible for the installation, configuration, and maintenance of databases for Oracle E-Business Suite R12 environments.

Represent Oracle team in Root cause analysis meetings related to severity-1 issues like Node Reboot, Instance Crash/recovery and Critical outages.

Worked closely with development teams to support application upgrades, patches, and enhancements, ensuring smooth integration with the existing environment.

Implemented and managed backup and recovery strategies to safeguard critical data and ensure minimal downtime in case of system failures.

Worked on Golden Gate for Data Replication.

Assisted in the design and implementation of disaster recovery solutions for Oracle Database environments.

Collaborated with cross-functional teams to plan and execute database migrations and upgrades while minimizing disruptions to business operations.

Manage and maintain the logical structure of the database.

Experience in Handling AWS EC2, RDS instances.

Developed and maintained documentation of system configurations, procedures, and troubleshooting guidelines.

Handling Client weekly status calls and monthly report review meetings.

Daily Calls with internal team members for Ticket review and issue resolutions.

Experience on applications like EBS, SOA, OBIEE, Endeca, Apex.

Basic knowledge on Cassandra, Mssql and Postgres databases.

Technical Skills:

Oracle 10g,11g,12c,18c,19c and PostgreSQL

Databases

Oracle Apps Dba 11i & R12.13 and 12.2

ERP Databases

AWS, Azure, Oracle

Cloud Providers

Linux, Virtual Box, VMware, Windows.

Operating Systems/Virtualization Tools

OKTA, BMC remedy, LANDesk, Service Now

Ticketing Tools

OEM, NAGIOS, Service now, OKTA, OTRS, BMC remedy, LANDesk

Monitoring Tools

CERTIFICATIONS:

OCI – Oracle Cloud infrastructure architect professional

AWS – AWS Solution Architect – Associate

Technical Experience:

Project 1#

Client: Landsend, USA Duration: DEC 2023 – Till date

Role: DBA team Lead

Responsibilities:

Upgrading the Oracle EBS and NON EBS Databases to 19c and migrating to Exadata X5 to X9 servers

Planning and implementing DR & high availability solutions using Oracle 12c/19c Standby Database using DG.

Installing agent 13c on the server. Adding high Available database with CRS, backup’s through OEM12c.

Configured Data Guard Broker and used for switchover and stopping and Starting Media recovery process.

Handled Physical and Logical Corruptions and recovery using RMAN (Recovery Advisor).

Hands on experience in Data Import/Export and backup using full file Import/Export.

Applied database patches using Opatch utility & building Clone instances for Development and Test teams.

Implemented Data Guard with maximum availability and performance configurations for production databases.

Performance tuning of oracle databases using SQL Performance Analyzer, SQL Tuning Advisor, AWR.

Database monitoring and maintenance activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues, scheduling of jobs, creation of users, schemas, table spaces and other database objects.

Prepare weekly status reports and presentation slides for monthly review meetings with client.

OEM implementation and applied patches to OEM agents.

Configured OEM alerts using existing templates.

Database monitoring and reporting using OEM.

Performed PDB refreshes

Created shell scripts for automating backups and database clones.

Worked closely with Client to understand the Project deadlines.

Maintenance Activities on Multitenant Architecture.

Performed clones of single and multimode RAC databases using RMAN.

Worked in Rotational shifts and as an On-Call DBA for this client.

Environment: Oracle 19c/12c, Exadata X9, OEM, RAC, ASM, Data Guard, AWS

Project 2#

Client: Emersion, USA Duration: MAR 2023 – DEC 2023

Implementation Partner: Datavail

Role: Lead Oracle DBA

Responsibilities:

Migration on existing EBS databases from AIX to Linux servers.

Migrated existing on-premise Oracle databases to AWS Cloud.

Build physical and logical standby databases using DG Broker.

Troubleshooting standby databases sync issues.

Lead regular review meetings to discuss performance metrics, incidents, and improvements.

Prepared and worked on various Cloning procedures based on the client requirement from PROD to Non-Prod

Managing daily DB activities like RMAN backup and recovery strategies through physical and logical backups.

Responsible for database switchover from primary to standby mode and vice versa;

Handling export/import of schemas & activities like creating tables, indexes, granting privileges etc.

Migrating the Oracle databases from conventional to Multi-tenant (PDB CDB).

Performed single and multimode RAC databases using RMAN.

Managing RDS databases oracle, Postgres and Mssql on AWS.

Creating S3 buckets, EBS volumes, snapshot backups, IAM user creation.

Experienced in PDB clones.

Data replication using Golden Gate.

Performance tuning by using tools like AWR & ASH reports.

Documenting DBA activities for standardization and for future iterations.

Environment: Oracle 19c/12c, EBS R12.2, OS - Red Hat Linux, OEM, RAC, ASM, Data Guard, Golden gate

Project 3#

Client: On Semi, USA Duration: APR 2022 – FEB 2023

Implementation Partner: Datavail

Role: Lead Database administrator

Responsibilities:

Troubleshooting various end user issues and Troubleshooting performance issues of the database.

Stabilized the environments by following standard Oracle Methodologies.

Stabilized the cloning processes and automated the cloning procedures to reduce manual work.

Reduced the cloning process time period from 24hrs to 12 hours by automation and procedural changes.

Responsible for continuous database monitoring and reorganization for ensuring optimum performance.

Cloning of Oracle databases from PROD to NON-PROD using SPARSE Clone mechanism

Implemented OEM templates to Monitor all the targeted instances and enhanced the alert monitoring.

Used Oracle 12c/11g Automatic Storage Management to fulfill the storage needs

Involved in creating the Disaster Recovery (DR) for all the production databases using Data Guard (Physical Standby)

Worked on the database decommission

Using RMAN, Expdp/Impdp, data refresh from Production to Non-prod

Working knowledge of the DGMGRL tool for switchover and switchback on data guard

SQL Tuning using SQL tuning advisor, creating SQL plan management, SQL plan baselines and SQL profiles

Provided resources and skill sets to support DBA functions for applications.

Create standby database from backup copy of the primary database

Manage operations of Physical /Logical standby databases archival stuck, space management

Patch implementation on RAC and non-RAC environments

Prepare weekly status call reports and presentation slides for monthly review meetings with client.

Experience to work on data guard using DGMGRL tool to perform switchover/switchback.

Environment: EBS 12.2.6 applications with Oracle 19c RAC database on Exadata Servers

Project 4#

Client: Oracle India Pvt limited Duration: Mar 2020 – APR 2022

Implementation Partner: Oracle Pvt Ltd

Role: Oracle Consultant (Oracle, Oracle Apps DBA)

Responsibilities:

Extensive experience in managing shared service model containing more than 3000 Oracle E-business suite instances which includes Production, Stage, and Development Test instances on OMCS, OPC and OCI Environments

Initial point of contact to All Oracle customer outages and handling the Outages with SLA time.

Managing all Oracle product Customers

Extensive experience in administering maintaining Oracle Applications E-Business Suite,12.1.1,12.1.2,12.1.3,12.2.0,12.2.2,12.2.3,12.2.6 and Oracle Databases 10g, 11gR1/R2,12C

Expertise in Oracle WebLogic Administration.

Communicating with the Respective Teams members frequently, effectively involving them in the work and making sure to complete the outage/issue within the SLA time.

Effectively sharing the work across Team members. Taking responsibility of allotting work and making sure of all the SRs in the queues were addressed.

Experience on other Application Products like Hyperion, PeopleSoft, OBIE and Apex.

Working with Oracle SME Team on SRs in case of P1 issues.

Installed and Configured OEM 13c.

Project 5#

Client: Huntington, USA Duration: Nov 2017 – MAR 2020

Implementation Partner: NTT - Secure24

Role: Sr Oracle DBA consultant

Responsibilities:

Installed & configured the five Node RAC with ASM on Linux as part of upgrade project.

Involved in Schema management, Table space Management, User Creation and management

Analysing tables and creating/ignoring indexes wherever applicable.

Extensive use of tools like Explain Plan, AWR for tuning application and instances

Creating and dropping accounts, granting necessary privilege on request.

Coordinating with OS Team when they apply patches.

Import and Export of Schema and databases across various stages of the project using data pump.

Resolving Tablespace issues (Adding datafile, resizing datafile if it is in warning or critical state responding to alters received via mail).

Performance tuning whenever their slow performance of query execution.

Upgrade database from Oracle 12c to 19c.

Worked on database wallets

Performance tuning on long running queries.

Configured Backups using RMAN.

Replication using Cassandra.

Multimode database cloning using rapid clone method.

Patching activity on database using opatch and opatch auto on single node and RAC Databases.

Environment: Oracle 19c database with RAC

Project 6#

Clients: JIBE, US Duration: May 2011 – NOV 2017

Implementation Partner: Doyen systems pvt Ltd

Role: Oracle Associate consultant

Responsibilities:

Maintaining the Production & Non-Production Oracle DBA and Oracle Apps DBA instances by 24X7.

Implementation of Oracle EBS R12 on IBM AIX and Red hat Linux.

Doing proper patch analysis before patching of Oracle EBS and Oracle database.

Upgrade of Oracle Database to 11.2.0.2 after the base install Oracle EBS Rel 12.1

Cloned TEST, DEV and UAT instances from PROD instance using Rapid Clone

Proactive monitoring of the database with respect to space, instance, CPU usage, memory usages on

the server and application server process availability.

Creating users adding responsibilities, scheduling concurrent programs.

Worked on expdp and impdb for schema, table, database level migrations.

Performed SYSADMIN Activities like User Creation, assigning responsibilities and scheduling concurrent requests.

Configured RMAN and Performed RMAN cold backup and Restoring the Database using with RMAN backup.

Troubleshooting Oracle application issues related to Apache, forms, concurrent managers and Database.

Implementation of user security by defining the responsibilities, custom applications and custom menu.

Implemented OEM monitoring templates to configure OEM alerts for the database.

Installed and Configured Apex applications.

Performing the Failover and Failback operations in the cluster environment.

Configuring and maintaining and troubleshooting the Database Log Shipping.

Establishing weekly maintenance plans such as Integrity check, Rebuilding indexes, Update statistics and monthly maintenance plans such as clean up history etc. to run the databases efficiently.

Daily checking the assigned tickets and resolve the tickets depends on the priority levels.

Daily working on the issues like backup failures, failed logins and resolve the issues.

Resolving disk space issues and data base growth issues.

Changing the backup policies whenever necessary.

Environment: Oracle 9i, 10g, 11g, Oracle Apps DBA 11i, R12.1.3, RMAN, Sun Solaris, Linux, RMAN, RAC, Data Guard, SQL*Plus, SQL, PL/SQL, UNIX Shell Scripting, SQL*LOADER, Oracle OEM, Import/Export Data pump.

EDUCATION:

MCA (Master of Computer Applications) - 2005-2008, Andhra University, INDIA.

- Sivakumar

Contact this candidate