MS-SQL DBA Expert - Optimization & Tuning

Location : Lahore / Islamabad / Karachi

Experience : 8+ years

NorthBay is looking for a hands‑on Microsoft SQL Server expert who can own the performance, stability, and availability of multiple clustered SQL Server environments running on AWS Windows‑based EC2. The role is focused on assessment / discovery, deep‑Dive / troubleshooting & performance optimization against high‑volume production systems. You will be the go‑to expert for identifying bottlenecks, tuning SQL & T‑SQL (including SPs / Functions), stabilizing cluster / DR failovers, and designing / improving observability including proactive monitoring and alerting.

Requirements

• Overall 8+ years of experience with at least 5 years of Core SQL Server hands‑on experience as a SQL Server DBA / Engineer, with a strong focus on performance and HA / DR in mission‑critical environments
• Deep understanding of SQL Server internals (storage engine, query optimizer, plan cache, buffer pool, TempDB behavior etc.).
• Expert‑level experience in diagnosing wait stats, DMVs, extended events, profiler / tracing, execution plan analysis, query rewrites, indexing strategy design
• Troubleshooting CPU spikes, I / O bottlenecks, memory pressure, TempDB contention, log bottlenecks (e.g. WRITELOG waits) etc.
• Expert in SQL & T‑SQL optimizations including SPs, triggers, views, functions etc. along with in depth understanding of locking, blocking, deadlocks, and transaction‑related performance issues
• Ability to identify & analyze resource‑heavy queries / processes and systematically optimize them (indexing, hints, plan guides, code refactoring, re‑architecture where needed)
• Hands‑on expertise in designing, deploying, and troubleshooting Windows Failover Clustering (WSFC), Always On Availability Groups (AGs), Failover Cluster Instances (FCI), log shipping, mirroring & replication
• Experience with AWS Cloud, EC2, instance families / sizes, EBS volumes, IOPS, throughput, networking, and Multi‑AZ designs in relation to MSSQL Server performance, HA / DR & monitoring & observability
• Strong experience with database monitoring tools and enterprise level monitoring / observability expectations, including SQL Server dashboards (performance, waits, blocking, deadlocks, availability), focus on implementing actionable alerting to reduce the noise
• Experience with T‑SQL, PowerShell & SQL Server Agent etc.
• Having experience with Reporting Services (SSRS) performance and optimization will be preferred
• Strong communication skills with the ability to explain complex database issues to non‑DBA stakeholders and mentor developers on SQL best practices.

Responsibilities

What We Offer

#J-18808-Ljbffr