Post Job Free

Resume

Sign in

Database Administrator Oracle

Location:
Al Dafna, Qatar
Posted:
November 29, 2022

Contact this candidate

Resume:

Mohamed Bishrul Hussain

Unit No*, Building No **, Zone No 56, Street No 423,

Doha, Qatar.

Phone : +974-********

Email : adtq8s@r.postjobfree.com

LinkedIn : http://www.linkedin.com/profile/view?id=139551880 Summary

More than Twelve years of Oracle / MySQL / MS-SQL / Cassandra Database Administrator Experiences covers in different areas including RMAN, DR, ASM, RAC, Administration, Performance Tuning, analyzing, designing, development and implementation of business requirements. Having work experience as an oracle Application Database Administrator (EBS 11i,12.1 and 12.2) in Linux/Unix Environments and Oracle Core DBA in Linux/Solaris/AIX and Windows Environments. During my tenure, Experience in Oracle Cloud Infrastructure (OCI) / AWS Administration and Migration also Manage / maintain Oracle Fusion Middleware including WebLogic and Jasper server within OCI compute instance and oracle Exadata administration. Additionally, I have experienced in Oracle Technologies and tools like PL/SQL, Oracle API’s, Oracle Application Framework, Oracle Reports, Oracle workflows and Oracle Forms.

Education

Academic Qualification

Master of Business Administration in Information Technology (MBA in IT) University of Moratuwa (2019-2020)

B.Sc (Hons) in IT Specialized in Software Engineering Sri Lanka Institute of Information Technology (2009–2012) Professional Qualification

Oracle 11g Database, Oracle Certified Associate (OCA)

Oracle 11g Database, Oracle Certified Professional (OCP)

Oracle Certified Expert, Oracle Database 12c-RAC and Grid Infrastructure Administrator

Oracle E-Business Suite R12 Applications Database Administrator Certified Professional (OCP R12)

Oracle Cloud Infrastructure Foundations 2020 Certified Associate

Oracle Cloud Infrastructure 2019 Architect Associate

Oracle Cloud Infrastructure 2019 Architect Professional Publications

http://mohamedbh.blogspot.com/

Pearson Lanka (Pvt) Ltd.

200, Nawala Road, Narahenpita, Colombo 05, Sri Lanka. http://www.pearson.com

Senior Database Administrator - (July 2019 to Present)

Working as a Senior DBA for Oracle, MySQL and Sybase databases.

Support and Maintenance Oracle Database Version 10g,11g,12C,18C,19C and MySQL 5.5,5.6 Databases which owned by Pearson

Good knowledge and hand-on experience on high availability with oracle RAC, ASM and Data Guard with multiple nodes.

Upgrade older version (10g,11g) oracle databases to 18C / 19C.

Manage Oracle Database on OCI Gen1 and Gen2 as Infrastructure as services.

Manage and Maintain Exadata machine including Patching

Expert on performance tuning via SQL

Maintain and support AWS EC2, RDS and Aurora Clusters.

Experience on database migration from on premise to AWS RDS and vice versa using Data pump for large databases.

Performed and schedule cold & hot backup, RMAN and Oracle Data pump

Strong Knowledge on Perl and shell scripting skill

Hands on experience of Oracle Enterprise Manager Grid Control

Install and Administration of MySQL databases

Configure and mange MySQL master slave replication

Backup and restore MySQL databases

Support and Maintain Cassandra and MSSQL databases. WebQuarters (Pvt) Ltd.

58, Anagarika Dharmapala Mawatha, Colombo 03, Sri Lanka. http://www.webquarters.com

Senior Database Administrator - (January 2017 to July 2019)

Working as a Senior DBA for Oracle and MSSQL databases.

Support and Maintenance Oracle Database 10g,11g,12C, MS-SQL server 2012,2008R2 and 2008 Instances for Reputed companies.

Installed, Maintained and Patched Oracle Databases on UNIX/LINUX/WINDOWS and MS-SQL server on Windows platforms.

Support and Maintain Oracle EBS Instances

Support and Maintain Oracle Fusan Middleware Instances which deployed in Professional Experience

Oracle Cloud Infrastructure as Compute instances.

Manage Oracle Cloud Infrastructure DB systems

Patching EBS Instance, Oracle Database, Exadata machine (Exadata Database Server, DB Node Update, Exadata Storage Server and Fabric Switch) and Fusion Middleware including bugfixes and Quarterly CPU’s

Backup and Restore Oracle Database using RMAN Utilities.

Performance Monitoring and Tuning Oracle/SQL Databases.

Upgrade Oracle Databases from 11gR1 to 11gR2, 18c and 19c

Developed and schedule Shell scripts and windows batch file for Automate RMAN backups and Database maintenance task.

Created, moved, upgraded, and deleted MS-SQL databases

Implemented and Scheduled backup and recovery processes on MS-SQL Servers

Monitored and tuned databases using Performance Monitor, SQL Server Profiler and Dynamic Management Views

Configured and support MS-SQL Disaster Recovery processes like Log Shipping methodologies, Clustering and Mirroring.

Implemented and maintained security rules and security audits Aitken Spence Technologies (Pvt) Ltd.

305, Vauxhall Street, Colombo 02, Sri Lanka.

http://www.aitkenspence.lk/

Senior Applications Database Administrator - (March 2014 to January 2017)

Implemented, Support and Maintenance EBS and Oracle Database Instances for Reputed companies in Sri Lanka

Working as an Oracle Senior Apps DBA and playing key role within the team.

Installation and maintenance of Oracle E-Business Suite and Oracle Databases on UNIX/LINUX/WINDOWS platforms.

Maintain Oracle RAC Database with Exadata Machine

Restore Single node DB from RAC DB

Install and Upgrade Oracle E-Business Suite and Oracle Database

Working with Oracle Exadata Machine with ASM Instance and Successfully Migrated Oracle R12 instance to Exadata box.

I have Experienced with different EBS and DB upgrade such as

• EBS Upgrade 12.1.1 to 12.1.3

• EBS Upgrade 12.2.0 to 12.2.3 / 12.2.4 / 12.2.5 So on

• EBS Upgrade 12.1.1 to 12.2.5

• EBS Upgrade 11i to 12.2.5

• DB Upgrade 11.1.0.7 to 11.2.0.4

• DB Upgrade 11.2.0.3 to 11.2.0.4

Migrate EBS Instance from linux 32-bit to linux 64-bit

Install and Configure Oracle 12c Database.

Enabling Audit for oracle EBS Application and Database.

Patching Oracle E-Business Suite including RDBMS, APPS AD patch by using utility such as Opatch, Adadmin/Adpatch and ADOP.

Cloning Oracle EBS (12.1 and 12.2) production environment (Using RMAN backups and Cold backup), Support and manage large number of development and test instances.

Configure Workflow notification mailer with cloud e-mail servers in EBS 12.2

Troubleshoot problems in concurrent managers, workflow, web server, web listener, forms server and database.

System administration activities such as creating users, executable, programs, request sets and attaching program to request group.

Managing application user account, responsibilities and database user accounts.

Handling day-to-day DBA activities using Oracle utilities and tools, monitoring space and memory requirements and Memory tuning. Checking Alert Logs, Archive Logs, Trace files and work proactively on alerts for the file system and CPU issues.

Developed Shell scripts to automate database operation, daily backups and database monitoring.

Virtusa (Pvt) Ltd.

NASDAQ quoted CMMI Level 5 Company

752, Dr Danister De Silva Mawatha, Colombo 09, Sri Lanka. http://www.virtusa.com

Software Engineer – Specialist (DBA) - (November 2010 to March 2014)

Working as an Oracle Apps DBA and playing key role within the team.

Monitoring and Diagnosing Database, Application, Network and Client issues.

Maintaining Oracle Database, Applications (EBS).

Patching Oracle E-Business Suite including RDBMS, APPS AD patch by using utility such as Opatch and Adadmin/Adpatch.

Database backup and recovery using RMAN. Written RMAN scripts to perform automatic full and incremental backup.

Cloning Oracle EBS production environment (Using RMAN backups/Duplicate database-EM), Support and manage large number of development and test instances.

Build and Maintain fully functional disaster recovery (DR) site for Oracle EBS, include database (Oracle Data Guard) and application server.

Troubleshoot problems in concurrent managers, workflow, web server, web listener, forms server and database.

Configured and maintain workflow mailer and Oracle EBS workflow administration.

System administration activities such as creating users, executable, programs, request sets and attaching program to request group.

Managing application user accounts and responsibilities and database user accounts.

Handling day-to-day DBA activities using Oracle utilities and tools, monitoring space and memory requirements and Memory tuning. Checking Alert Logs, Archive Logs, Trace files and to work proactively on alerts for the file system and CPU issues.

Database and SQL tuning to improve performance.

Troubleshooting, maintaining, scripting in multiple OS Platforms

(Linux/Unix/Windows)

Developed Unix Shell scripts to automate database operation and database monitoring.

Working closely with teams including development and functional, Oracle Support for doing all kind of production migration /deployments and troubleshooting.

Worked on most of the Application modules like Oracle Human Resource Management System (HRMS), Performance Management, Learning Management, Financial (GL, AP, AR, PO, CM), Projects, Workflow etc.

Writing PL/SQL Queries to provide various functionalities

Data migration of time variant data from various internal systems to Oracle ERP using oracle API.

Create OAF pages in Oracle E-Business Suite

Create XML Reports with BI Publisher Desktop for Oracle E-Business Suite.

Configuring Alerts in E-Business Suite.

Various types of R&D Oracle EBS related initiatives. Personal Information

Name : Mohamed Bishrul Hussain

Date of Birth : 23rd Of April 1987

Gender : Male

Marital Status : Married

Nationality : Sri Lankan

I hereby declare that the information given is correct to the best of my knowledge and that I have not withheld any information which might reasonably be calculated to adversely affect my suitability for employment.

Sincerely,

Mohamed Bishrul Hussain.

25th Nov 2022

Reference Available on Request



Contact this candidate