Muhammad Yousaf

Engineer, Critical Services (Database Administration) @Yahsat Space Services

AE

Spearheaded the administration and management of various operational databases such as Billing, Intelligent Network,Value Added Services, Satellite Operations Center, Advance Operation Center, Satellite & Payload Control Point, Satellite Telemetry and Commanding, Data Warehouse, and Shared Point Services.Managed and optimized High Availability (HA) solutions with Oracle Clusterware, ASM, RAC and SQL Server clustering to ensure maximum uptime and minimal downtime.Implemented Disaster Recovery (DR) solutions utilizing Oracle Data Guard, MS SQL Server Mirroring, Replication, Log Shipping and Always On to safeguard data and minimize data loss.Migrated SQL Server Databases Microsoft Azure hosted DB\'s and Managed Instances.Successfully set up a four-node cluster for MS SQL Server 2016 on MS Windows 2016, which included two production nodes and two DR nodes. Implemented AlwaysON AGs to ensure the smooth operation of business-critical applications.Implemented partitioning and compression techniques in a Business Intelligence MS SQL database to optimize large FACT tables, resulting in a significant space saving of 5TB.Successfully reduced job processing time by 60% through the application of partitioning and compression methodologies.Conducted extraction of various database reports across diverse business units.Conducted regular backup and recovery procedures to ensure data availability and minimize data loss.Applied patches and updates for hybird and IaaS deployment