Md. A. Wahid

Oracle DBA (9i, 10g, 11g, 12c, 19c): Installation, Upgradation, Patching, Dataguard, GoldenGate replication, RAC, RMAN backup/recovery, OEM 13C, Performance Tuning, Capacity planning, Multitenant, Vulnerabilities Mitigation and security hardening. Database Automation: Developed shell & PL/SQL scripts to automate routine maintenance tasks Achievements / Projects Database Up-gradation/Migraion - Migrated & Up-graded 26 production/Pre-prod/UAT/TEST databases from 12c to 19c running on Solaris/Linux. I have used in-place approach to perform this up-gradation which help organisations in terms of cost, compliance and performance. Oracle GoldenGate - Configured oracle GoldenGate unidirectional replication between homogeneous database (oracle to oracle) for enhancing reporting services. Oracle RAC - Provisioned 10+ oracle(2 node) RAC on Linux & Solaris for new and existing database enhancements. Database Patching - Deployed patches [RU] more than 200 times on various production databases periodically which includes 2 node RAC on DC[primary], 2 node RAC on DR[Standby] & Single instance[Oracle Restart] as well. License Optimization - Work for license agreement renewal of oracle database with optimized approach - Remove unused & costly feature from oracle database Oracle Active Dataguard - Configure oracle active dataguard on 2 node RAC for our Core Banking System and ensured DR drill with switchover, which helps us to secure more in case of disaster. Performance Tuning - Troubleshooting various critical scenarios of production system MySQL - Installation, Backup, Restoration & Master-slave replication for Voice of Customer[VoC Project] & Nikash MariaDB - Installation, Backup, Restoration & Primary-Replica Configuration for DocuDex Project SQL Server - Installation, SQLServer Failover Cluster, Windows Server failover Cluster, Upgradation. Backup/Recovery, Jobs Creation, Linked Server creation with other platform DB like Oracle

Database Up-gradation/Migraion - Migrated & Up-graded 30 production databases from multiple versions like [10g to 12c] to 11g,12c & 19c. Among these databases most of them were running on Linux & AIX, some databases were running on Solaris and some were in windows also. This up-gradation took both in-place & out-of-place approach including intermediate up-gradation. Apart from that most of them were same platform up-gradation/migration whereas some were cross-platform migration/up-gradation[Windows to Linux, Solaris to Linux] for which I have used Transportable Tablespaces[TTS] approach. Database Patching - Deployed patches [PSU] more than 200 times on various production databases periodically which includes 2 node RAC on DC[primary], 2 node RAC on DR[Standby] & Single instance[Oracle Restart]. Oracle RAC - Configured 12c RAC (2 node) on linux[RHEL] for Debit Card System[IRIS] - Configured 19C 2 node RAC on AIX for Astha[UBA] production database - Configured 19C 2 node RAC on AIX for ESB production database - Configured 19C 2 node RAC on AIX for FSS production database - Configured 19C 2 node RAC on Linux for Debit Card production database License Optimization - Work for license agreement renewal of oracle database with optimized approach - Remove unused & costly feature from oracle database Oracle Active Dataguard - Configure oracle active dataguard on 2 node RAC for our Core Banking System Performance Tuning - Troubleshooting various critical scenarios of production system MongoDB - Completed M101 MongoDB Basics Training online - Single instance installation for UAT environment - Configured regular backup - Serve restoration of MongoDB for collections only, full DB etc - Configure 3 node replica set on linux with P-S1-S2 model MySQL - Installation, Backup, Restoration & User Administration SQL Server - Installation, Backup, Restoration & User Administration - Jobs Creation, Linked Server creation with other platform DB

- Maintained and support 24*7 more than 50 databases (all are oracle databases) including production, DR (Dataguard) & Test environment. - Working in Tranzware Credit Card implementation projects which conforms with 5 separate database servers of oracle 12c database. Each of the databases are replicating in real time basis using oracle active dataguard (ADG) which are acting as DR (Active Dataguard) of production system. - Upgrading the Core Banking System(Bank Ultimus) Database including OS. - Configuring Oracle Active Dataguard as Disaster Recovery for production CBS (Core Banking System) database. - Working closely with ORACLE Support Service for different issues. - Scheduling RMAN backup of production database. - Auditing database activities using SolarWinds. - Tuning the database for better performance. - Restoring the rman backup as per application needed for test area.

- Agrani Bank Exadata X5-2 Quarter Rack implementation project - Working on Exadata X5-2 Quarter Rack on DR of Agrani Bank. - Configuring Oracle 11g Active database(ADG) on AIX of Live database server at Union Bank. - Configuring active/passive database on AIX at cluster environment at Farmers Bank. - Bangladesh Post Office RAC project Experience on DELL storage for creating LUN and mounting on Redhat Linux host end for Oracle 11g Automatic Storage Management(ASM). - Agrani Bank migration project > deploying several agent on oracle 12c EM on AIX server at single node of RAC. > Creating EM notification rule to obtain e-mail notification of warning and critical event. - BCC iBAS RAC project - Deployed 2 node RAC of oracle 12c on FUSION CUBE engineered system & creating database on both 11g and 12c for iBAS. - Deployed single instance Active Dataguard (ADG) for CADB at Bangladesh Computer Council whose DC (primary) is running as 2 node cluster database. - Migrate Supreme Court Of Bangladesh database from oracle 10g to oracle 12c on OS (RHEL 6.7) cluster. - Configure oracle AVDF at National Bank & Al-arafah Islami Bank in Bangladesh - Working 24/7 support for various database which mainly banking database.

- Configuring Linux Server with installation of Oracle 11g Database and Weblogic of NRB Global Bank for HR payroll application. - Working on BCBL EBEK project of configuring Server for EBEK application. - Configuring Weblogic & Database Server of Rangs Motors & Rangs Motors Workshops Limited for implementation of HR payroll application. - Configuring Weblogic Server for EBEK application of BANK ASIA. - Successfully implementation of NPSB (National Payment Switch Of Bangladesh) switch for ATM transaction in both BANK ASIA & Standard Bank Limited. - Successfully configure Dataguard implementation on EBEK application server of BANK ASIA.

- Taking backup of oracle database on routine basis - Tuning performance of both oracle and mysql database - Monitoring both the oracle and mysql server - Working with various oracle errors occurring at production database and fixing with oracle recommended suggestion. - Able to configure Linux server for installing oracle 11g such as CentOS. - Working with business logic. - Supporting of production database for 24 hours.