Liaqat Ali

Consultant DBA

Pulse • Tiempo completo

Nov 2025 - Present • 7 mos

Lead database administration for enterprise-scale SQL Server environments in government and industrial and production systems. Manage high availability and disaster recovery (HA/DR) solutions using Always on Availability Groups, Failover Cluster Instances, SQL Replication, and cross-platform DR delivering 99.99% uptime in SLA-driven environments. Design and enforce secure, compliant multi-tenant database architectures, implementing RBAC, schema isolation, auditing, encryption, and access controls aligned with regulatory and information security standards. Integrate SQL Server with Oracle, PostgreSQL, and third-party industrial systems using Linked Servers, OPENQUERY, and optimized cross-database queries to enable reliable enterprise data exchange. Design and automate enterprise ETL pipelines using SSIS, SQL Server Agent, and T-SQL, ensuring data accuracy.

Database Administrator/Developer

ABC • Tiempo completo

Jun 2022 - Nov 2025 • 3 yrs 5 mos

Managed 20+ SQL Server databases (2016, 2019, 2022) used in real-time production monitoring and analytics for textile and manufacturing clients. Developed and optimized complex queries, stored procedures, functions, triggers, views used in reporting and production environment. Monitored and troubleshot expensive queries, blocking, deadlocks, and CPU/memory issues using Activity Monitor, Query Store, DMVs and Third-Party tools. Performed regular backup/restore operations, database integrity checks, and index maintenance tasks to ensure data integrity and reduce downtime. Gained hands-on experience with SQL performance tuning, partitioning, stored procedure optimization, and SQL Server monitoring using DMVs, along with a strong understanding of data security, auditing, and cloud database administration (Azure SQL, Amazon RDS). Configured and managed Always-on-Availability groups, Replication, Email Alerts and Performance metrics in SQL Server and Azure SQL