MS-SQL DBA Expert - Optimization & Tuning

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.

Requirements

• 8+ years of experience with at least 5 years of Core SQL Server hands-on experience as a SQL Server DBA / Engineer
• 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
• 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)
• Experience with T-SQL, PowerShell & SQL Server Agent etc.
• Having experience with Reporting Services (SSRS) performance and optimization will be preferred

Benefits

• Competitive salary
• Fuel expense reimbursement
• Paid holidays and vacations
• Medical outpatient reimbursement & health insurance facility