Summary
Overview
Work History
Education
Skills
Certification
Experience Summary
Role and Responsibilities
Work Availability
Timeline
Vijayasree Bala

Vijayasree Bala

Oracle Apps Dba
Hyderabad,TG

Summary

Dynamic and dedicated professional seeking collaboration in a challenging and competitive environment, leveraging a strong commitment to continuous learning and improvement. Eager to enhance knowledge and capabilities while contributing effectively to organizational success. Proven track record of determination and teamwork drives the pursuit of excellence in every endeavor. Passionate about making a meaningful impact through proactive engagement and innovative solutions.

Overview

8
8
years of professional experience
3
3
Certifications
1
1
Language

Work History

DBA

Oracle
12.2021 - Current
  • Working as a DBA at Oracle from Dec 2021 to till date.

Oracle APPS DBA (Staff DBA Consultant)

Apps Associates (I) Pvt. Ltd.
08.2017 - 12.2021
  • Worked as an Oracle APPS DBA (Staff DBA Consultant) at Apps Associates (I) Pvt. Ltd. from August 2017 to Dec 2021

Education

Bachelor of Technology - Computer science and Engineering

Malla Reddy College of Engineering and Technology (JNTUH), Hyderabad
01.2017

Skills

Operating Systems: Solaris, Linux, Windows

Certification

OCI 2023 AI OCA

Experience Summary

  • Having 8 years of experience as an Oracle Apps DBA
  • Experience in database up-gradation.
  • Good exposure supporting production 24x7 Support, development & staging environments, and expertise in troubleshoot & resolving issues on regular basis on Production & other environments.
  • Planned and Implemented Disaster Recovery (DR) and High Availability(HA) using Data Guard and made sure that the database is always available for the users even at the critical times like failures and up-gradations.
  • Monitored Oracle Instances, Users, Tables, Table spaces, Memory structures, and Rollback segments, Redo logs, Archived Redo logs, and Alerts.
  • Two node and single node Cloning (Manual clone, RMAN clone).
  • Responsible in all aspects of Oracle Application database administration and maintenance of production, development, and test environments.
  • Good knowledge in Applications system administration.
  • Supporting Development Users resolving issues on regular basis Sysadmin tasks like Creating and Managing users and their responsibilities.
  • Experienced in Troubleshooting various application issues/problems related to Apache, Concurrent manager, Forms server.
  • Experience in Installation of Oracle software and creation of DB’s on Linux servers.
  • Experience in AD utilities like adadmin, adpatch, adctrl, adrelink an adop.
  • Monitoring alert log file and daily health check of Production databases and generating AWR reports.
  • Applying database patches using OPatch utility.
  • Performing Backup and Recovery activities using RMAN. Experience in Real Application Cluster (RAC) Database administrations.
  • Knowledge on AWS.
  • Experience on Oracle E-Business Suite R12.2.x patching & cloning.
  • Worked on configuring SSO/DMZ and access manager/OID on EBS and dealing with day-to-day support issues.
  • Applied various patches, such as Application patches, RDBMS patches, and CPU patches, to resolve issues and improve system performance. and applying crypto currency patches for WebLogic, enhancing security and compliance
  • Working on DR sync-related issues, ensuring data consistency and recovery readiness and DR drill activities.
  • Compiling forms, reports, and libraries as per user requirements, ensuring smooth functioning of Oracle apps products and Monitoring system administration activities, such as defining concurrent programs, profile settings, concurrent managers, and resolving CM issues.
  • Efficiently managing user and responsibility assignments.
  • Proactively identifying and troubleshooting application issues, including URL issues, clone issues, performance problems, and Single Sign-On (SSO) issues.
  • Automating refresh and patching tasks using Python scripts, streamlining the process and reducing manual effort.
  • Successfully cloning instances from production to Test and Development environments, ensuring data consistency and efficient testing.
  • Attending regular meetings with clients to discuss project progress, requirements, and addressing any concerns.

Role and Responsibilities

  • Handled Level0 and level1 backups using RMAN.
  • Cloning databases using RMAN from Production to the Test and Development
  • Troubleshooting long running Concurrent Programs.
  • Support development teams.
  • Ensure data integrity and security via backups.
  • Manage various installations.
  • Performing patching analysis and applying patches.
  • Disk Space monitoring, extending space to database.
  • Monitoring and maintaining CRON jobs.
  • Scheduling backup & other database related jobs.
  • Troubleshoot problems related to Oracle Database and Application.
  • Managing system configuration by using Autoconfig.
  • Trouble Shooting Oracle Database and Applications Performance issues like database level locks and query performance.
  • Applied application patches and database patches.
  • Troubleshooting Oracle Application problems.
  • Interact with Oracle Support for technical assistance requests.
  • Create Technical Notes and Documentation.
  • Working with action plans and follow up with pending action items.
  • Monitoring and Managing alerts
  • User & Table space management
  • Monitoring and clearing locks, Troubleshooting long running requests, Migration of custom components (forms, rdfs, views, packages, procedures, functions, scripts).
  • DB Backups with RMAN
  • Experience in using Auto Config for Oracle application system maintenance.
  • Creating users and assigning required responsibilities
  • Managing the passwords for Application users, Database users and administrative users using FNDPASS.
  • Applying WebLogic Patches and Oracle Home Patches.
  • Daily monitoring of all production databases and handling Service requests and DCR’s.
  • Used AD Utilities such as AD-admin for maintenance of Oracle Applications.
  • Used AD Utilities such as AD-Patch for applying patches to applications, applied patches to database.
  • Also having hands on Critical Process Monitoring.
  • Proven track record of reducing downtime, improving query performance, and implementing best practices in database security and compliance.
  • Proactive learner, staying updated with emerging database and cloud technologies.
  • Working as a shift lead for the team, ensuring effective coordination and task delegation.

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Timeline

DBA - Oracle
12.2021 - Current
Oracle APPS DBA (Staff DBA Consultant) - Apps Associates (I) Pvt. Ltd.
08.2017 - 12.2021
Malla Reddy College of Engineering and Technology (JNTUH) - Bachelor of Technology, Computer science and Engineering
Vijayasree BalaOracle Apps Dba