Summary
Overview
Work History
Education
Skills
Certification
Interests
INTRODUCTION
Timeline
Generic
BIDHAN MANDAL

BIDHAN MANDAL

Senior ORACLE APPS DBA
Karimpur,WB

Summary

Results-driven database administrator with extensive expertise in Oracle database management and administration. Proficient in optimizing database performance and ensuring data integrity across diverse environments, adept at troubleshooting complex issues and implementing effective solutions. Strong background in database security and backup strategies contributes to robust data protection and reliability. Committed to leveraging technical skills to enhance operational efficiency and support organizational goals.

Overview

19
19
years of professional experience
10
10
Certifications

Work History

Oracle Core DBA & Apps DBA (client KOPT) & EVEREADY INDUSTRIES INDIA LTD

Wizertech informatics Pvt Limited
05.2015 - Current
  • 5 years of hands-on experience as an Oracle Apps DBA supporting Oracle E-Business Suite 12.1 and 12.2 production, UAT, and development environments.
  • Extensive experience in Oracle EBS architecture, including application tier, database tier, WebLogic, OHS, and concurrent processing.
  • Performed EBS cloning using RMAN duplicate and Rapid Clone (adcfgclone.pl) for DEV, TEST, and UAT environments, including post-clone configuration.
  • Strong experience with EBS 12.2 Online Patching (ADOP): prepare, apply, finalize, cutover, cleanup, and validation activities.
  • Implemented and managed RMAN backup and recovery strategies, including archive log backups and restore validation.
  • Hands-on experience with Oracle Data Guard for disaster recovery and high availability of EBS databases.
  • Monitored and tuned EBS performance using AWR/ASH, SQL execution plans, concurrent request analysis, and database statistics.
  • Performed index maintenance, schema statistics gathering, and space management to improve application performance.
  • Managed EBS security by controlling responsibilities, menus, roles, and coordinating database-level access controls.
  • Coordinated with functional teams, developers, and infrastructure teams during patching, cloning, migrations, and outages.
  • Assisted in on-prem to cloud (OCI/AWS) migrations for Oracle EBS environments, including post-migration validation.
  • Ensured compliance with change management, documentation, and audit requirements for production environments.
  • Streamlined backup and recovery processes, enhancing overall system stability and availability.

Oracle Core DBA(client KOPT)

PCS Technology Limited
03.2014 - 04.2015
  • Involved in DBA activities, supporting Production Environments
  • Installation, creation and support of Oracle 9i and 10g database in Production Environments.
  • Monitoring databases, which include basic health checks, growth of objects, performance of the database and giving recommendations how to resolve it.
  • Performing status checks by monitoring the Alert log, Trace files of the database.
  • Performing backups and restoration.
  • Creating new databases under various environments and maintaining different oracle homes in the same servers.
  • Support has Database administration on Development and Production databases.
  • Rebuilding the indexes and Gather statistics of tables to improve the performance.

Oracle Core DBA(ERP) & APPS DBA

CARNATION INDUSTRIES LTD
09.2013 - 12.2013
  • Involved in DBA activities, supporting Production Environments
  • Installation, creation and support of Oracle 9i and 10g database in Production Environments.
  • Monitoring databases, which include basic health checks, growth of objects, performance of the database and giving recommendations how to resolve it.
  • Performing status checks by monitoring the Alert log, Trace files of the database.
  • Performing backups and restoration.
  • Creating new databases under various environments and maintaining different oracle homes in the same servers.
  • Support has Database administration on Development and Production databases.
  • Rebuilding the indexes and Gather statistics of tables to improve the performance.
  • Monitoring and Reorganizing Database objects Tables & Indexes to minimize fragmentation in the database using logical backup and restoration. (Export and import ) and Data pump.
  • RMAN Cloning , restorations and recover ( block level recoveries , Data file recovery)

Oracle DBA

SMSRC Pvt Ltd
06.2012 - 07.2013
  • Installation, configuration of the databases.
  • Managing Database Structure, Storage Allocation, Table/Index segments, Rollback segments, Database Access, Roles and Privileges.
  • Imports and exports.
  • Configuring Database in Archive log mode.
  • Monitoring the table spaces periodically for growth.
  • Refreshing the test database with the production database.
  • Perform backup and recovery of database
  • Verification of backup.
  • Multiplexing of log files and control files
  • Developing database links for remote database access
  • Data synchronization
  • Data Analyze

Oracle DBA

Zenith Software Pvt Ltd
06.2011 - 05.2012
  • Installation, configuration of the databases server.
  • Imports and exports.
  • Configuring Database in Oracle.
  • Monitoring the table spaces periodically for growth.
  • Refreshing the test database with the production database.
  • Perform backup and recovery of database
  • Verification of backup.
  • Multiplexing of log files and control files
  • Developing database links for remote database access
  • Finacle Training for Branch label
  • Supporting Production Environments

Oracle DBA/ Banc mate Service Desk

HCL Info system Pvt Ltd
05.2008 - 05.2011
  • Installation, configuration of the databases server.
  • Imports and exports.
  • Configuring Database in Oracle.
  • Monitoring the table spaces periodically for growth.
  • Refreshing the test database with the production database.
  • Perform backup and recovery of database
  • Verification of backup.
  • Multiplexing of log files and control files
  • Supporting Production Environments

SQL Server Banc mate Service Desk

Natural Technologies private Ltd
08.2007 - 04.2008
  • Installation, configuration of the databases server.
  • Configuring Database in SQLSERVER.
  • Refreshing the test database with the production database.
  • Perform backup and recovery of database
  • Verification of backup.
  • Supporting Production Environments 24X7
  • Patch Update
  • Application Software Training

Education

Bachelor of Arts -

Calcutta University
04.2001 -

H.S -

KARIMPUR JAGANNATH HIGH SCHOOL
Karimpur, India
01-1997

M.P -

KARIMPUR JAGANNATH HIGH SCHOOL
Karimpur, India
01-1995

Skills

RDBMS: Oracle 19C 11g Releases 1,2

Certification

Oracle 19C Certified Associate(year-2022)

Interests

Traveling, Driving, Watching People, Game

INTRODUCTION

  • Date of Birth : 19th December 1978
  • S/O : Late- Brindaban Mandal
  • Religion : Hindu
  • Nationality : Indian
  • Sex : Male
  • Marital Status : Married

Timeline

Oracle Core DBA & Apps DBA (client KOPT) & EVEREADY INDUSTRIES INDIA LTD

Wizertech informatics Pvt Limited
05.2015 - Current

Oracle Core DBA(client KOPT)

PCS Technology Limited
03.2014 - 04.2015

Oracle Core DBA(ERP) & APPS DBA

CARNATION INDUSTRIES LTD
09.2013 - 12.2013

Oracle DBA

SMSRC Pvt Ltd
06.2012 - 07.2013

Oracle DBA

Zenith Software Pvt Ltd
06.2011 - 05.2012

Oracle DBA/ Banc mate Service Desk

HCL Info system Pvt Ltd
05.2008 - 05.2011

SQL Server Banc mate Service Desk

Natural Technologies private Ltd
08.2007 - 04.2008

Bachelor of Arts -

Calcutta University
04.2001 -

H.S -

KARIMPUR JAGANNATH HIGH SCHOOL

M.P -

KARIMPUR JAGANNATH HIGH SCHOOL
BIDHAN MANDALSenior ORACLE APPS DBA