Asad Yousuf

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.

Worked as a Software Developer and responsible for developing, designing, testing, modifying, maintaining, deploying and debugging software based applications.

07/2016 – 09/2016

Web Developer (Internship), Cooperative Computing

Responsible for designing, coding and modifying websites, from layout to function and according to a client's specifications.

07/2018 – 07/2020

MS (COMPUTER SCIENCE), BAHRIA UNIVERSITY KARACHI CAMPUS

2013 - 2017

BS (COMPUTER SCIENCE), BAHRIA UNIVERSITY KARACHI CAMPUS

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        

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