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.

CERTIFICATES & 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

Overall Responsibilities as Database Administrator

 

• 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.