Ismail Hossain

Ismail Hossain

Professional Experience:

Assistant Manager (DBA) – May 16, 2022- present Genex Infosys Limited

ROLE: DBA

Responsibility:

  • Configured MySQL innoDB cluster on Prod, Dev as well as Test environments.
  • Install MySQL server 8 on Rahat Linux 8.
  • Configured MySQL sell for cluster administration, MySQL Router for high availability and scalability which handles the database traffic.
  • Performed troubleshooting of innoDB cluster database.
  • Performed plan for MySQL database backup and recovery strategies and replication.
  • Involved in trouble shooting and fine-tuning of databases performance.
  • Performed query optimization by help of execution plan and created necessary indexes.
  • Recovering database from backup in disasters.
  • Performed MySQL enterprise schedule (full and incremental) backup configuring crontab.
  • Performed backup automation using shell scripting.
  • Performed cluster trouble shooting.
  • Configured MySQL enterprise monitoring tools for health monitoring.
  • Performed MySQL innoDB cluster memory level tuning.
  • configured Warehouse database for string historical data.
  • Assist Development team for tuning the complex sql-satements.
  • Monitoring database logfile, database growths, and backup.

Project: ODA Re-imaging and Database Migration Client: Dhaka Power Distribution Company (DPDC) Role: DBA

Responsibility:

  • Performed Oracle Database Appliance Re-imaging on X7-2 HA.
  • Performed system administrating for database installation
  • Installed oracle 19c RAC database on Oracle Linux 7.
  • Tablespace and user Created as per requirement.
  • Performed Database Migration plan.
  • Performed Database Migration from 12c to 19c using datapump.
  • Performed backup and restore plan
  • Configured Shell script for schedule rman and datapump backup.
  • Configured remote standalone DR setup from RAC database.

Database Administrator- (January 1, 2018 – May 14, 2022) Computer Network Systems Limited (CNS)

Location: House# 967, Road# 12, Avenue-2, Mirpur (DOHS), Dhaka-1216, Bangladesh Department: Software and Systems.

Project: Port Automation

Client: Chittagong Port Authority (CPA) Role: DBA

Responsibility:

  • Install oracle database 12c for production and development environment.
  • Configured oracle Datagurad for disaster recovery.
  • Involved in database schemas Design and Development of Central Inventory, Vessel Billing, Water Billing, On- stop billing as well as complex report development and deployment at production.
  • Created stored procedure, package, function, and trigger for business logic implementation.
  • Planning database capacity Management.
  • Planed for database backup strategies
  • Performed business data migration of (HR, Account, PF).
  • Configured Oracle Business Intelligence tool for business report.
  • Performed switchover and failover on a periodical basis for testing.
  • Worked on the creation of users, granting roles and privileges to users, tablespace management
  • performed the backups Hot & COLD backup, Incremental Level 0 and Level 1 Back and scheduling.
  • Taken logical database Backup (impdp/expdp) using data pump utility.
  • Creating scheduling jobs with crontab.
  • Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files.

Project Name: Water, Electricity And Vessel Billing System Client: Chittagong Port Authority (CPA)

Role : PL/SQL Developer

  • Involved in the design of database schema.
  • Writing complex SQL query and PL/SQL procedure to extract from various sources table data.
  • Created PL/SQL package, procedure, function and trigger as per business requirement.
  • Involved in optimization of SQL queries.
  • Develop complex Report using oracle BI reporting tools.
  • Prepare (System Design and Requirement Specification) documentation for CMMI.

    Professional Training:

    Training NameDurationInstitute
    Diploma in Database Design and Development1 YearIDB-BISEW IT Scholarship, Round-26
    Oracle Database Administration (I and II)120 HoursIBCS-PRIMAX Software Ltd.
    Red Hat Linux Administration (I, II and III)3 MonthsLinux Pathshala, Banani
    Cisco certified Network Associates (CCNA)60 HoursLinux Pathshala, Banani

    Professional Certificate:

    1. Oracle Cloud Infrastructure 2019 Certified Architect Professional           August 11, 2020
    2. Oracle Autonomous Database Cloud 2019 Specialist                              May 30, 2020
    3. Oracle Database 11g Administrator Certified Professional (OCP)            March 10, 2018
    4. Oracle Database 11g Administrator Certified Associate (OCA)               November 14, 2017
    5. Oracle Forms Developer Certified Professional (OCP)                            June 25, 2016
    6. Oracle PL/SQL Developer Certified Associate (OCA)                            May 26, 2016
    7. Red Hat Certified Engineer (RHCE)                                                      November 12, 2018
    8. Red Hat Certified System Administrator (RHCSA)                                 August 11, 2018

    Academic Background:

    Post-Graduate Diploma in IT (PGDIT)
    Institute of Information Technology (IIT)
    Jahangirnagar University