Summary

Highly skilled and experienced Database Administrator with a proven track record of
successfully managing and optimizing Oracle, MySQL, and SQL Server databases. Proficient in database design, implementation, maintenance, and troubleshooting. Adept at developing and implementing robust backup and recovery strategies, ensuring data integrity and system reliability. Strong analytical and problem-solving skills and a commitment to delivering exceptional database solutions.

Projects

BI APPS Lift & Shift | Department of Transport Government Agency Australia
SSO Implementation on EBS | Royal Children Hospital, Australia

Experience

Company Logo
Database Administrator
ITANZ Group Pty Ltd
Nov 2021 - Present | Lahore, Pakistan

Oracle Database Management includes (installation, configuration, backup, and recoveryvia RMAN, Data Guard, RAC, Database Security, Database Upgrade, Database migration,troubleshooting, and developer end support etc).
MySQL Database Management includes (installation, configuration, backup, and recoveryvia mysqldump,xtrabackup, and mysqlbackup, Database Security, Database replicationusing Binary log position or using GTID, and developer end support, etc).
SQL Database Management includes (installation, configuration, backup, and recovery viaMaintenance plan or T-SQL, Database Security (login, users, server roles, database roles),Database replication, and developer end support, etc).
EBS Administration R12.2 with DB 11g to 19c includes ( installation, Application patchingvia ADOP utility, Cloning, Upgrading, Backup/ Recovery, Performance issues andTroubleshooting). SSO implementation on EBS (OUD, OAM, DIP, MSAZURE AD).
Oracle Utilities Application Framework (OUAF) based environments (WAM, C2M, MDM,CCB) installation, administration, patching, cloning, upgradation, backup and recovery, andtroubleshooting.
Oracle Cloud Infrastructure: OCI Identity and Access Management, OCI Storagemanagement, Instance OS Hardening (Vulnerabilities scanning), Configuring NLB (NetworkLoad Balancer) for instances, Configuring Bastion Host for instances, JCS (Java CloudInstance) provision, instance patching, instance start/stop, and Troubleshooting JCSstartup issues. Analytics instance provisioning, Configuring PAC (Private Access Channel)for OAC, PAC connectivity issues with private end data sources for Analytics instance. VCN(Virtual Cloud Network) provision and ManagingSL (Security List) of subnets for instanceaccess. OCI notification and alarm services. Oracle Integration instance administration etc.

Company Logo
Assistant DBA
Mukhtar Ahmed Shaikh Hospital (Fatima Group)
May 2019 - Oct 2022 | Multan, Pakistan

·         Oracle 11g/12c/18c/19c Database installation & Administration on Linux & Windows
·         EBS Administration R12.1. R12.2 with DB 11g to 19c
·         Oracle Data Guard Configuration and Management
·         Oracle OBIEE 12.2.1.3/12.2.1.4 Installation and Management
·         Application patching via ADOP utility, Patching and Issue resolutions
·         Installation, Cloning, Patching, Upgrading, Backup/ Recovery
·         Core Database Management (Installation, Backup Recovery, Upgrade)
·         Apache Tomcat Installation and Management
·         Database Health check reports like AWR, ADDM
·         OBIEE Installation and Configuration
·         Samba configuration with Linux
·         Shell Scripting
·         Data pump (import & export)
·         Virtualization ESXI
·         Connecting Oracle to no-oracle databases (Gateways)
·         SQL Server Installation, management, backup etc.
·         Oracle Apex 5.1 & 11gR1, Oracle Apex 19.2 & 12c
·         Oracle APEX+ BI+ Apache Tomcat + ORDS Configuration for HIMS,
·         Support to Custom Build Health Management Information System
·         Oracle Apex with ORDS configuration
·         Assisting Technical and Functional Team Over ERP & Apex Development
·         Plan and implement the synchronization of data across several developments, testing and production environments; evaluate the merits/ benefits of available system upgrades and enhancements. 
·         Monitor performance and manage parameters to provide fast query responses to 'front end' users. 

Education

Bahauddin Zakariya Unversity Multan
Bachelors, BSc, ‎
Computer Engineering
CGPA 3.3/4
2017
BISE
Intermediate/A-Level, , F.Sc Pre-Engineering‎
Pre-Engineering
Percentage 81%
2012
BISE
Matriculation/O-Level, , Matric in Science‎
Science
Percentage 88%
2010

Skills

Expert Backup and Recovery
Expert Capacity Planing
Expert Data Guard
Expert Data Pump
Expert Database Administration Tools
Expert Database Cloning
Expert Database High Availability
Expert Database Management
Expert Database Performance Tuning
Expert Database Replication
Expert Database Security
Expert Maintenance plan
Expert MySQL Bin Log Position Replication
Expert MySQL GTID Replication
Expert OBIEE Administration
Expert OEM
Intermediate RAC
Expert RMAN
Expert SQL Server Agent
Expert SQL Server Profiler
Expert SSMS
Expert TDE
Expert WebLogic

Languages

Intermediate Saraiki
Expert Punjabi
Expert Urdu
Intermediate English