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
Pilani01-2024
Bachelor of Computer Applications -
St Philomena's College
Mysuru01.2019
PUC -
St Philomena's College
Mysuru04-2016
SSLC -
Fr. Gregorios High School
Mysuru04-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