Md. Mahadi Hasan

Md. Mahadi Hasan

Trainer, LEADS Training & Consulting Ltd
Education: Post Graduate in Information Technology from Dhaka University (IIT)

Certifications & Trainings:
 Oracle Database 12c Administrator Certified Professional (OCP 12c)
 Oracle Database 12c Administrator Certified Associate (OCA 12c)
 Oracle Cloud Infrastructure Foundations 2020 Certified Associate
 Oracle Autonomous Database Cloud 2019 Certified Specialist
 Oracle Forms Developer Certified Professional (OCP 11g)
 Oracle PL/SQL Developer Certified Associate (OCA 11g)
 Red Hat Certified System Administrator

Project Work:

Citizens Bank PLC
Designation: Senior Officer

Subject Matter of experience
 Install oracle 19c database to oracle Linux 8.2 for production and uat.
 Upgrade oracle patch 19.3 to 19.11 all production database
 Implement Oracle 19c Data Guard (One primary and two standby ) for core
Banking system.
 Implement oracle enterprise manager cloud control 13.4 and agent install on all production database.
 Implement Oracle 19c Data Guard (One primary and one standby) for Internet Banking and e-kyc.

AB Bank Limited
Designation: Officer

Subject Matter of experience
 Implement Oracle 11g Data Guard with Data Guard Broker on IBM Aix Server 7.1.
 Scripting Rman Backup and Recovery.
 Monitoring Database Performance.
 Transform mySql data to oracle using BICS Data Sync

LEADS Corporation Limited
Designation:Senior Software Engineer

Subject Matter of experience .
 Implement RAC One node on National Bank of Pakistan.
 Implement two node RAC on Rajshahi Krishi Unnayan Bank.
 Implement DRBD solution on Shahjalal Islami Bank Limited
 Data Guard configuration (Primary and Stand by) in FAS Finance & Investment Ltd.

Infinity Technology International Ltd
Designation: Programmer May 2015 – September 2017
Dhaka, Bangladesh

Subject Matter of experience
 Writing SQL Query.
 Writing PL/SQL code.
 Build application using Oracle Forms developer.
 Build reports using Oracle Report developer and crystal report.
 Build web application using Oracle Application Express.
 Configure database both windows and oracle linux etc.

Overall Experience as DBA:

 Excellent in Installation and configuration of Oracle11g ,12c, PostgreSQL in Linux and Windows environment.
 Creation of Database Using DBCA GUI utility and silent mode.
 Experience in capacity planning, space management, database upgrades/migration.
 Good experience on User management, Roles and Profiles creation
 Monitoring the table fragmentation and rectify by online redefinition of tables.
 Experience in Cold backup, hot backup and recovery in RMAN.
 Restore database in PITR through RMAN.
 Tablespace management chained rows, extent and segment management.
 Implementation of Tablespace Encryption (TDE).
 Monitoring the use of UNDO segment and temporary segments.
 Analyzing the SQL queries using explain plan and creating necessary indexes.
 Designing and implementing backup and recovery strategies.
 Ensuring security of the database.
 Backup on Tables, Schema and Database level using datapump Utility.
 Handling Partitioning on tables.
 Cloning database from production to testing using RMAN Backup.
 Experience in Upgrade database (11g to 12c).
 Performance turning to the SQL query, Analyzing AWR report, ADDM report.
 Configuring OEM and monitoring database through OEM console.
 Installation of RAC/ASM and managing RAC Environment efficiently in 11gR2,12R2.
 Creating ASM disk group using ASMCA.
 Data guard setup and DGMGRL configuration.
 Periodically Switchover the database from primary to standby and standby to primary.
 Oracle 12c new features, CDB/PDB concepts and database creation.