Asad Yousuf
Database Administrator - Available to relocate
Talent
Karachi, سندھ0Member since June 23, 2022
·
Hire this person
Send a job offer directly to this candidate
About
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.
Experience
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.
