概要

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.

项目

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

工作经历

公司标识
Database Administrator
ITANZ Group Pty Ltd
Nov 2021 - 代表 | 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.

公司标识
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. 

学历

Bahauddin Zakariya Unversity Multan
学士, BSc, ‎
Computer Engineering
CGPA 3.3/4
2017
BISE
中级/A级, , F.Sc Pre-Engineering‎
Pre-Engineering
所占比重 81%
2012
BISE
大学入学/0级, , Matric in Science‎
Science
所占比重 88%
2010

技能

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

语言

中级 Saraiki
熟练 旁遮普语
熟练 乌尔都语
中级 英语