[email protected]
www.linkedin.com/in/saad-khan12
httpshttps://youtube.com/@kpkfoodwalks?si=uEvkD2Gyv_N36hxj
Al Jaradiyah, Riyadh 12771, Kingdom of Saudi Arabia
(+966) 556102218 (Mobile)
Career Overview
As a database administrator I have 3+ years of experience in managing different types of Database related
Projects specially Oracle and MySQL Databases Administration related projects which includes
Implementation of Advance security compliances, apart from that I have strong hands on experience Oracle
Database, Oracle Data guard, Oracle Real Application Cluster (RAC),Oracle Restart, Oracle Cross Platform
database migration, Oracle Database Upgrades, Oracle Database Patching , Performance tuning, Backup
and Recovery, Point-In-Time Recovery, day-to-day database monitoring and so on. Likewise I have strong
hands on with Implementation and Management of MySQL Standalone, Disaster Recovery setups (Replicas),
High Availability Clustering (Innodb,NDB), Performance Tunning and so on.
Work Experience
Database Administrator Techvisions Pvt. Ltd., Riyadh, Saudi Arabia
Sep-2025 to Current
Database Administrator Corvit System Peshawar, Peshawar, Pakistan
May-2025 to Sept-2025
Database Administrator Arcana Info Pvt. Ltd., Islamabad, Pakistan
Oct-2024 to May-2025
Database Administrator Mobilink Microfinance Bank, Islamabad, Pakistan
April-2023 to Oct-2024
Database Administrator Ora-Tech Systems Pvt. Ltd., Islamabad, Pakistan
Aug-2022 to April-2023
Projects
ï€
MariaDB Implementation and Support Project
ï‚· Successfully implemented MariaDB as the backend database for Splunk, ensuring optimal
configuration and performance.
ï‚· Configured a replication setup with a standby MariaDB server of identical specifications and version
to ensure high availability.
ï‚· Planned and automated, scheduled physical backups using the mariabackup utility, ensuring data
integrity and rapid recovery.
ï‚· Planned and conducted regular Disaster Recovery (DR) drills, validating backup and failover
procedures to meet business continuity requirements.
MySQL Migration from NDB Clusters and Standalone Databases to Innodb Cluster
ï‚· Performed end-to-end Migration from MySQL NDB Cluster 8.0.4 to Innodb Cluster 8.4.ï€
ï‚· Performed end-to-end Migration from MySQL 5.6 Commercial edition MySQL Innodb Cluster.ï€
ï‚· NDB to Innodb Cluster migration has been performed using mysqldump (logical backup) utility as
engine changing was involved before importing the database into Innodb cluster.ï€
ï‚· 3 Nodes Innodb clusters with one node read/write and two of them read only were used as
destination clusters.ï€
ï‚· Before migration application compatibility, sanity testing, stress tasting were performed multiple
times on the destination clusters to ensure after migration the cluster will be able to bear the load.ï€
ï‚· Innodb clusters were configured with Keep Alive utility which was scripted such that the VIP will be
assigned to the node only which is running in read/write mode.ï€
ï‚· Physical backups were planned in-place using mysqlbackup native utility.ï€
ï‚· Nodes role switch was planned, performed and documented in-place.ï€
Implementation of Security Appliances on Oracle Database 19c
ï‚· Performed end-to-end implementation of Transparent Data Encryption (TDE) on 2-nodes RAC
with 2-nodes DR configured.
ï‚· Performed end-to-end implementation of Transport Layer Security (TLS).
ï‚· Implementing Data Masking for QA and Development database.
ï‚· Implementation of Virtual Private Database (VPD).
ï‚· Installation and configuring Oracle Audit Vault and Database Firewall (OAVDF)
ï‚· Setting up Oracle Enterprise Manager (OEM) for Monitoring production databases.
Operational Support to Khyber Teaching Hospital Peshawar
ï‚· Operational support was provided to KTH hospital, as a part of this project I was responsible to
properly perform the health check and take pro-active actions like adding datafiles to tablespaces,
monitoring alert log files, ensure the DR side sync.
Technical Skills
Oracle Database
ï‚· Experience with Installation and configuration Oracle (11g,12c,19c) on different operating Systems.
ï‚· Experience with Configuration of 2-Nodes Real Application Cluster (RAC).
ï‚· Experience with patching RAC environment configured with DR.
ï‚· Experience with Setting up Oracle Restart database.
ï‚· Experience with Data guard Configuration (Configured DR for T24 and Moneta after upgrade).
ï‚· Experience with Production DR drill using manual steps.
ï‚· Experience with enabling and configuring Data Guard broker in production environment.
ï‚· Experience with Production DR drill using Data Guard broker.
ï‚· Experience with Production Temenos T24 Upgrade from Oracle12c to 19c using Manual Upgrade.
ï‚· Experience with Production Database (Moneta) Upgrade from 11g to 19c using Auto upgrade.
ï‚· Experience with Snapshot, physical standby and Active Data guard.
ï‚· Experience with Backups and specially Point-In-Time Recovery.
ï‚· Experience with Backup and recovery of Oracle multi-tenant architecture.
ï‚· Experience with Backup and recovery of whole container and separate pdbs, specially point-in-time
Recovery.
ï‚· Experience with Restore on different location and database name.
ï‚· Experience with setting up Different levels of Flashback Technology for Database.
ï‚· Experience with Configuration of Oracle Enterprise Manager Cloud Control 13c and using it for
monitoring.
ï‚· Experience with Configuration of WebLogic Server 14c on Oracle Linux 8.
ï‚· Experience with Configuration and Upgrade of Oracle Application Express as part of Database
Upgrade.
ï‚· Experience with Configuration and setting up of Net Services (Listeners, Tnsnam