This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
NorthBay is seeking a highly experienced MS-SQL DBA Expert with strong expertise in SQL Server performance optimization, tuning, and high availability. The role involves hands-on assessment, troubleshooting, and optimization of mission-critical SQL Server environments running on AWS Windows-based EC2 instances. The selected candidate will lead performance tuning initiatives, stabilize HA/DR setups, and enhance monitoring and observability for high-volume production systems.
Job Responsibility:
Optimize SQL Server architecture, configuration, indexing strategies, statistics, TempDB, and file layouts
Analyze and resolve performance bottlenecks across CPU, memory, I/O, and network
Conduct deep-dive troubleshooting using wait stats, DMVs, execution plans, and Extended Events
Review and fine-tune SQL Server settings including MAXDOP, cost threshold for parallelism, memory configuration, and TempDB
Tune and refactor complex SQL and T-SQL stored procedures, views, and functions
Identify and resolve locking, blocking, deadlocks, transactional contention, and long-running queries
Assess, troubleshoot, and stabilize existing HA/DR and cluster environments
Design and implement HA/DR solutions aligned with RPO and RTO requirements
Improve proactive and reactive monitoring through actionable alerts and dashboards
Lead incident response and root cause analysis for production issues
Provide architectural recommendations and align environments with SQL Server best practices
Support capacity planning, scaling strategies, backup and restore, and maintenance plans
Automate operational tasks such as index maintenance, statistics updates, log cleanup, and data archiving
Maintain documentation and contribute to knowledge sharing initiatives
Requirements:
8+ years of overall IT experience
At least 5+ years of hands-on SQL Server DBA or Engineering experience
Strong knowledge of SQL Server internals including storage engine, query optimizer, buffer pool, plan cache, and TempDB behavior