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
Solution Architect in AI & Data Analytics / M365 / Power Platforms/ Azure at WiproSolution Architect in AI & Data Analytics / M365 / Power Platforms/ Azure at Wipro