Debashish Banerjee
Oracle / SQL Database Administrator
Thane
Summary
Provide ongoing technical support and maintenance of production and development systems and software products (both remote and onsite) and for configured services running on various platforms (operating within a defined operating model and processes). Provide hardware/software support and implement technology at the operating system-level across all server and network areas, and for particular software solutions/vendors/brands. Work includes L1 and L2/ basic and intermediate level troubleshooting.
Overview
2
2
years of professional experience
3
3
Certifications
3
3
Languages
Work History
Oracle Database Administrator
Accenture
03.2022 - Current
- Having good knowledge of Oracle Architecture.
- Installing and maintaining the Oracle database software.
- Experience in configuring ASM for managing disk groups (cluster) and databases.
- Experience in Data guard configuration and managing Standby databases. Monitoring and resolving log gap issues, performing methods like switchover.
- Experience in Patching for PSU patches.
- Experience about Tablespace management, user management roles & privileges.
- Knowledge for Indexing, partitioning, views, Mviews, sequences and synonyms.
- Knowledge for configuring oracle network files tnsnames.ora, listener.ora.
- Experience in loading data to Oracle from different sources using export/import & Experience for backup in logical level via using expdp/impdp. As well refreshes Object (Table) and Schema also via using same mythology.
- Worked on Database Upgradation from 11g to 12C,19C and ASM upgradation from 11g to 12c and 19C.
- Restored and Recovered database for missing data files / Block Corruption by using RMAN.
- Manage and operate infrastructure and operations in line with service and experience level agreements. Maintain reliable and secure IT infrastructure. Identify ways to continually improve services and increase operational effectiveness
SQL Database Administrator
Accenture
03.2022 - Current
- Participated and Implemented the SQL L1 Activities.
- Worked with staff to develop and implement procedures to prevent data loss and maximize system availability.
- Built databases and table structures for web applications.
- Configuring the Database backup on new SQL Servers.
- Troubleshooting database issues by analyzing logs and querying database.
- Troubleshooting common database issues checking system health resources.
- Working with Transaction Log file and its common issues like shrink file.
- Creating Users, managing Permissions and Role management.
- How to identify & fix orphan users.
- SQL Server Monitoring with job subsystem alerts.
- Sql server management studio install/upgrades.
- Managing SAP PIT backup & restore.
Education
Bachelor of Science - Industrial Engineering
Yashwantrao Chavan Open University
Nashik, India 04.2001 -
Skills
SQL Database Adminstrator
Oracle Database Administration
Oracle ASM Management
Incident Management
Backup and recovery
Database Cloning
Certification
Oracle Cloud Infrastructure
Singing, Cooking, Reading Books
- Cooking various types of Indian, Chinese, Keto, Junk Food Items and South Indian Food.
- Reading Different types of Novels such as THE POWER OF YOUR SUBCONCIOUS MIND, THINK AND GROW RICH, THE RICHEST MAN IN BABYLON, DIVINE BOOKS SUCH AS BHAGWADGEETA, RAMAYAN, ARTHASHASTRA, BUDHBHUSHAN, etc.
- Singing Such as Classical Singing, Bollywood etc
Timeline
Oracle Cloud Infrastructure
07-2023
Oracle Cloud Infrastructure Architect Associate
07-2023
Oracle Database Administrator
Accenture
03.2022 - Current
SQL Database Administrator
Accenture
03.2022 - Current
Oracle Cloud Infrastructure
02-2022
Bachelor of Science - Industrial Engineering
Yashwantrao Chavan Open University
04.2001 -