Asad Yousuf

Database Administrator with expertise in Database Administration of Oracle, SQL Server, MySQL including Cloud technologies like Oracle Cloud Infrastructure (OCI) and Microsoft Azure. I am responsible for Installation, Configuration, Migration, Backup & Recovery, Data Pump, Recovery Manager (RMAN), Data Guard, Real Application Cluster (RAC), Automatic Storage Management (ASM), Golden Gate, Advance Compression, Performance Tuning and Capacity Monitoring, analyzing large clusters of data, database design, storing and organizing data. I also worked with multiple OS like Linux, AIX, Centos and Windows based environments.

07/2021 – PRESENT

Senior database ADMINISTRATOR, Techlogix

• Worked for multiple international clients including banks and financial organizations of US, Europe and UAE.
• Performed oracle installation, configuration, management and administration of oracle databases on Linux, AIX and Windows based environments
• Proactively identify issues by regular monitoring of database performance and logs.
• Monitored and administered multiple databases as 24x7 Production DBA.
• Configure Oracle Data Guard / Standby Database to protect database against failures.
• Performed switchover and failover activities in case of disaster.
• Oracle Real Application Cluster (RAC) and Automatic Storage Management (ASM) configuration, implementation and maintenance on 11g and 19c
• Manage Oracle RAC cluster environment database design & implementation.
• Configure Oracle Enterprise Manager Cloud Control 13c to manage/monitor various databases which may be running on Cloud infrastructure or on premise.
• Performed backups and recovery of multiple databases using RMAN and data pump.
• Database upgrade from 11g to 12c and 19c.
• Database Management and configuration in Microsoft Azure according to the user needs.
• Remove table fragmentation, which cause slowness and wastage of space and reclaim the unused space which also increases database performance.
• Perform database-related performance tuning and optimization such as improving and revising poorly written queries, rebuilding/updating table indexes and statistics, performing database cleanups and archives, reconfiguring default configuration, and other database tuning processes that help to improve the performance of the system.

04/2018 – 06/2021

Senior database ADMINISTRATOR, ora-tech systems (Pvt) Ltd

• Worked for leading banks, insurance and investment companies including government sectors.
• Performed switchover and failover activities in case of DR drills and disaster.
• Implemented Advanced Compression to improve database performance and reduce storage costs.
• Worked with multitenant architecture by using container database (CDB) and pluggable databases (PDBs).
• Performed migration from 11g (11.2.0.4) to 19c (19.3.0.0.0).
• Ensure database performance by performing periodic database health-checks, troubleshoot bottlenecks, fine-tune SQL queries, dissect execution plans, and effectively manage database indexes.
• Setup and manage replication topologies for high-availability.
• Perform periodical audit of database access rights to prevent unauthorized access compliance with regulatory requirements
• Performed installation, configuration and administration of Oracle Web Logic Servers.
• Plan, Design and implementation of Backup & Recovery strategies using RMAN.
• Applied patches as per the oracle recommendations.
• Worked on Data Pump to move data and objects.
• Configure OEM to monitor and maintain numerous databases.
• Design and implement various auditing polices.
• Utilize oracle support to troubleshoot and solve critical database issues.
• Responsible of creation and management of users, roles, profiles and privileges.
• Troubleshoot and resolved user connectivity and account lock issues.
• Responsible for creating and managing tablespaces, data files, profiles etc.

07/2017 – 04/2018

Software developer, E-commerce Gateway Pakistan (Pvt) Ltd.

07/2016 – 09/2016

Web Developer (Internship), Cooperative Computing

07/2018 – 07/2020

MS (COMPUTER SCIENCE), BAHRIA UNIVERSITY KARACHI CAMPUS

2013 - 2017

BS (COMPUTER SCIENCE), BAHRIA UNIVERSITY KARACHI CAMPUS

Certifications

ORACLE CERTIFIED professional (OCP) - oracle

ORACLE CERTIFIED Associate (oca) - oracle

Oracle Autonomous Database Cloud 2021 Specialist - oracle

OCI 2021 Cloud Operations Associate - oracle

OCI Foundations 2021 Certified Associate - oracle

Trainings

Oracle SQL Performance Tuning Masterclass 2021 - udemy

Oracle Database, 12C R2 RAC Administration - udemy

Professional Azure SQL Database Administration - udemy

Mysql Database admin - udemy

microsoft Windows applicatons - Sir Syed University

microsoft web applicatoins - Sir Syed University