Summary
Overview
Work History
Education
Skills
Skills
Certification
AWARDS
Timeline
Generic

VENKATA VEERABHADRACHARI SOPIRALA

Hyderabad

Summary

Experienced Oracle DBA and Oracle Apps DBA with 3+ years of expertise in managing and optimizing Oracle databases with versions of Oracle 11g,12c and Oracle Applications ERP system (EBS - 12.1.3).

Overview

4
4
years of professional experience
1
1
Certification

Work History

Oracle DBA & Oracle Apps DBA

ACCENTURE SERVICES Pvt. Ltd
Hyderabad
06.2021 - Current
  • Worked in the environment of 24/7 DBA support.
  • In-depth knowledge of Oracle Database architecture.
  • Database upgrade from 11g to 12c.
  • Hands-on experience in upgrading and patching of databases.
  • Create the database manually, as well as using DBCA.
  • Creating tablespace, adding and resizing datafile.
  • Database health checkups and monitoring alert logs.
  • Performing user management task and administrative task.
  • User management includes user creation, dropping users, resetting passwords, and checking and providing required privileges and roles.
  • Database backup RMAN (Full/Incremental backups).
  • Backup of tablespace/schema/table using Data Pump utility.
  • Monitoring long-running sessions, looking for and blocking sessions, and killing the session if required.
  • Checking the concurrent manager status.
  • Configured the notification mailer in the application.
  • Applying the CPU patches at regular intervals.
  • Monitoring tablespace size, alert log, and trace files.
  • Applying the EBS patches (online and offline patches).
  • Monitoring scripts, such as long-running DB blocking sessions, etc.
  • User creation, and assignment of roles and responsibilities, with sys admin.
  • Working closely with the offshore team to deliver all the database support activities.
  • Worked with the Jenkins tool to deploy code and set up a new file transfer job based on vendor requirements.
  • Performed RMAN-based cloning to create duplicate databases for backup, testing, and disaster recovery purposes.

Education

Bachelor of Technology

QIS College of Engineering & Technology
Ongole
01-2019

Skills

  • Modules:

Oracle 11g and 12c

Linux 6,7 and 8 versions

  • Expertise:

Oracle Core DBA

Database Architecture

RMAN cloning

EXPDP, IMPDP

Data Guard

  • Delivery tools:

Jenkins

TortoiseSVN

ERP Manager

WinSCP, PuTTY

SQL Developer

  • Utilities:

Data Pump (EXPDP/IMPDP)

Recovery Manager (RMAN)

Skills

  • Knowledge of 11g,12c,19c administration
  • Excellent team, communication and organizational skills
  • Knowledge or experience with Oracle Multitenant(CDB/PDB)
  • Extensive experience in Oracle backup and Recovery using RMAN
  • Having a good knowledge of the Installation and configuration of Oracle 19c
  • Good troubleshooting skills and ability to resolve issues quickly and effectively
  • Excellent verbal and written communication skills, quick learner and ready to learn new technologies
  • Experience in configuration and working with MMAN(Recovery Manager) & Database cloning/Refresh through RMAN

Certification

  • Oracle Cloud Infrastructure Foundations 2021 Certified Associate
  • Oracle Cloud Infrastructure 2023 Certified Foundations Associate
  • Oracle Cloud Infrastructure 2023 AI Certified Foundations Associate
  • Oracle Cloud Infrastructure 2024 Foundations Associate (1Z0-1085-24)

AWARDS

  • Best Performer of the Month!

Timeline

Oracle DBA & Oracle Apps DBA

ACCENTURE SERVICES Pvt. Ltd
06.2021 - Current

Bachelor of Technology

QIS College of Engineering & Technology

Similar Profiles

CREATE PROFILE
VENKATA VEERABHADRACHARI SOPIRALA