G
ghazanfaralirafiq's photo
ghazanfar ali Rafiq
From Pakistan 05:55 PM (GMT+05:00)
$20/hr

Active 1 hour ago


Member since Aug 2026

Share this profile:

Senior SQL Server Database Administrator

Database Administrator
Available for hire
Years of experience
15+ years
Experience level
Senior
Available for
Full-time, Part-time, Contract, Freelance
Available from
10 Sep 2026

Senior SQL Server Database Administrator with over 15 years of experience managing enterprise-scale database environments across government and defense sectors. Extensive expertise in Microsoft SQL Server administration, high availability and disaster recovery solutions, database performance tuning, automation, security hardening, and infrastructure support. Proven track record supporting large-scale production environments with high uptime requirements, implementing Always On Availability Groups, optimizing critical workloads, and automating database operations using PowerShell and T-SQL. Experienced in managing mission-critical systems in highly regulated environments with strong focus on operational continuity, reliability, and security.

Languages

Employment History

Senior SQL Server Database Administrator at Punjab Information Technology Board Current 2022 - Now
Senior Programme Manager – Database Administration August 2022 – Present Programme Manager – Database Administration August 2022 – August 2023 Responsibilities & Achievements:  Manage enterprise-scale SQL Server environments supporting high-transaction government applications and citizen-facing systems.  Administer and maintain more than 2,000 production SQL Server databases with focus on availability, security, and operational stability.  Design, implement, and manage Always On Availability Groups and high availability solutions for critical applications.  Perform database performance tuning, query optimization, index maintenance, and workload analysis using DMVs and execution plans.  Lead database backup, recovery, disaster recovery, and business continuity operations.  Develop and maintain PowerShell and T-SQL automation scripts for monitoring, maintenance, alerting, and operational efficiency.  Implement database security hardening and access control policies aligned with government compliance requirements.  Troubleshoot production incidents, identify root causes, and implement preventive measures to improve system reliability.  Collaborate with development, infrastructure, and application support teams to ensure stable production operations.
Senior SQL Server Database Administrator at Pakistan Air Force 2010 - 2022
Senior Database Administrator / IT System Support Engineer August 2010 – July 2022 Responsibilities & Achievements:  Managed secure enterprise database infrastructure supporting operational and administrative systems within defense sector environments.  Administered Microsoft SQL Server databases with emphasis on high availability, security, backup management, and system reliability.  Supported critical production systems operating in 24/7 environments with strict uptime requirements.  Performed database installation, configuration, patching, maintenance, and performance optimization activities.  Participated in disaster recovery planning, backup validation, and emergency recovery operations.  Implemented database monitoring and preventive maintenance procedures to minimize operational disruptions.  Coordinated with infrastructure and application teams to support enterprise IT systems and resolve technical incidents.  Assisted in deployment and support of healthcare and laboratory information management systems across multiple operational locations.

Education

MSC Computer Sciences at Mohi ud din Islamic University 2003 - 2007