Ishani Shome
Kolkata
Summary
Committed job seeker with a history of meeting company needs with consistent and organized practices. Skilled in working under pressure and adapting to new situations and challenges to best enhance the organizational brand.
Overview
3
3
years of professional experience
Work History
Oracle Database Administrator
Wipro limited
Bengaluru
07.2021 - 06.2024
- My responsibility being a Oracle Database Administrator is to maintain ,secure and operate databases and ensuring the data is being correctly stored and retrieved.
- Managing the Database Availability and performance, including incident ,Changes and problem management both in Production and Non-Production Environment.
- Defining and implementing event triggers that will alert on potential database performance or integrity issues .
- Performance Tuning of database systems.
Setting and maintaining database standards.
Managing Database Access. - Expertise in Oracle RAC database Administration and activities
- Expertise in performing EXADATA DMA[ Database Machine Administration] activities
- Skilled in database Performance Tuning and troubleshooting critical database
Expertise in Database Administration of Oracle 10.x / 11.x / 12C / 19C production databases - Successfully managed 24*7 Database Administration & database design & planning , installation & configuration, Backup & recovery and patch management.
- Database Backup and Recovery , Refreshing dev , UAT, test instances with data from production on a regular basis , high performance in expdp / impdp activities.
- Database Restores
- Databases Decommission
- Familiar with Oracle Enterprise Manager
- Managing user management, space management granting required privileges to users
- Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.
- Performance Tuning of Database , managing and supporting the 75+ Oracle databases.
- Aware of Oracle Database Security comprising of User accounts , Authentication methods and providing privileges and Roles, application security , user session information using application context
- Aware of generating reports like AWR, ASH and ADDR Tuning SQL statement against database and its objects.
- Managing table spaces, data files, redo logs, tables and its segments.
- Ensured data integrity through regular validation checks on data quality and consistency.
- Scheduled jobs for maintenance activities like index rebuilding.
- Worked closely with application developers to ensure proper design of applications and database structures.
- Provided 24x7 on-call support for critical incidents related to databases.
- Developed and ran autonomous database backups.
- Created and altered database storage structures to meet user needs.
- Detected and resolved data quality issues and discrepancies for integrity and quality control.
- Partnered with project management teams on development of scope and timelines.
Education
Bachelor's of Computer Applications (BCA) - Computer Science
Heritage Institute of Technology
06.2021
High School Education (12th Standard) - Commerce with Mathematics and Computer Science
Shri Shikshayatan School
06.2018
10th Standard Education - Science with Social Studies
Shri Shikshayatan School
07.2016
Skills
- Performance tuning
- ExaData RMAN
- Oracle SQL developer
- Oracle Database
- Administration
- Backup and Recovery
- Data Security
- Strong Communication
- Adaptable to new challenges
- Patch management
- Storage Management
- Incident Management
- Performance Tuning
- Data Migration
Accomplishments
- Database Decommission
Hobbies and Interests
- Painting
- Gardening
- Art & Craft
- Travelling
Languages
Bengali
First Language
English
Proficient (C2)
C2
Hindi
Proficient (C2)
C2
Timeline
Oracle Database Administrator
Wipro limited
07.2021 - 06.2024
Bachelor's of Computer Applications (BCA) - Computer Science
Heritage Institute of Technology
High School Education (12th Standard) - Commerce with Mathematics and Computer Science
Shri Shikshayatan School
10th Standard Education - Science with Social Studies
Shri Shikshayatan School
Similar Profiles
Diksha GuptaDiksha Gupta
Administrator at WIPRO LIMITEDAdministrator at WIPRO LIMITED
Sachin WasonSachin Wason
Practice Manager at Wipro LimitedPractice Manager at Wipro Limited
Vidhya SLVidhya SL
Project Engineer (Developer L2) at Wipro LimitedProject Engineer (Developer L2) at Wipro Limited