Summary
Overview
Work History
Education
Skills
Languages
Timeline
Generic
Rochelle Crasta

Rochelle Crasta

Mysuru

Summary

Software Engineer with over 5 years of expertise in Oracle Database Administration, specializing in performance optimization, data migration coordination, and providing 24x7 production support. Demonstrated success in cross-functional collaboration.

Overview

5
5
years of professional experience

Work History

Oracle Database Administrator

Wipro
Mysore
06.2019 - Current
  • Creating and managing database and database objects, tablespace, data files, object sizing as well as monitoring database usage and growth.
  • Multiple customer Project including BFSI automobiles, Manufacture FMCG industry
  • Setting up and managing the sync between the primary and standby databases using Data Guard.
  • Analyzing and enhancing the database performance, working on optimizing queries to identify solutions that increase overall efficiency.
  • Tasks that include database conversion and the execution of switch-over drill.
  • Established RMAN backups and performed database restores, ensuring data integrity.
  • Provided on-site customer support during critical activities, showcasing commitment.
  • Prepared comprehensive Technical Documents on relevant topics.
  • Worked on configuring the ASM instances and setting up databases on ASM and non-ASM environments.
  • Applying security patches on standalone and RAC environments in rolling fashion.
  • Generating and analyzing AWR, ADDM report for database performance monitoring.
  • Provided 24x7 production support, resolving tickets, and managing OSS tasks for optimal system performance.
  • Set up crontab to manage database health checks, perform housekeeping tasks,optimize performance, and schedule backup activities.
  • Proven team player with strong communication and interpersonal skills.
  • Demonstrated ability to work independently and lead initiatives for goal achievement.
  • Ability to interact with end users self-motivated and team player
  • Coordinated with on-site and off shore teams for efficient database migration.
  • Engaged in database conversion tasks as part of End-of-Day (EOD) and Beginning-of-Day (BOD) activities.
  • Set up and control user access levels across databases to protect important data.

Education

M.TECH - Computing System & Infrastructure

Birla Institute of Technology & Science
Pilani
01-2024

Bachelor of Computer Applications -

St Philomena's College
Mysuru
01.2019

PUC -

St Philomena's College
Mysuru
04-2016

SSLC -

Fr. Gregorios High School
Mysuru
04-2014

Skills

  • Extensive knowledge on Oracle Architecture And Hands on experience on Oracle Database creations
  • Competence in working with ASM
  • Knowledge and understanding of Real Application Cluster (RAC)
  • Knowledge on ORACLE Golden Gate(OGG)
  • Monitoring the performance and analyzing using AWR, ADDM,SQLT reports and Execution plans
  • Good Knowledge on Oracle 19c,21c New features
  • Knowledge on Oracle Enterprise Manager
  • Expertise in Data guard

Languages

  • Konkani, First Language, C2
  • Kannada, Proficient, C1
  • English, Proficient, C1
  • Hindi, Upper Intermediate, B1
  • Tamil, Intermediate

Timeline

Oracle Database Administrator

Wipro
06.2019 - Current

M.TECH - Computing System & Infrastructure

Birla Institute of Technology & Science

Bachelor of Computer Applications -

St Philomena's College

PUC -

St Philomena's College

SSLC -

Fr. Gregorios High School
Rochelle Crasta