Qureos Mentor

NorthBay - Pakistan

<div>
 
 Job Title:
 
 MS-SQL DBA Expert &ndash; Optimization &amp; Tuning
 
 
 
 Employment Type:
 
 Contractual (Extendable)
 
 
 
 Contract Duration:
 
 2 Months
 
 
 
 Work Mode:
 
 Remote
 
 
 
 Location:
 
 Lahore, Karachi, Islamabad
 
 
 
 Experience Required
 
 
 
 <ul>
 <li>
 Overall Experience: 8+ years
 </li>
 <li>
 Relevant Experience: 5+ years as SQL Server DBA / Engineer
 
 
 </li>
 </ul>
 
 Job Summary
 
 
 
 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.
 
 
 
 Key Skills And Competencies
 
 
 
 <ul>
 <li>
 Microsoft SQL Server DBA
 </li>
 <li>
 SQL Server Performance Tuning
 </li>
 <li>
 T-SQL Optimization
 </li>
 <li>
 SQL Server Internals
 </li>
 <li>
 Query Optimization and Indexing
 </li>
 <li>
 High Availability and Disaster Recovery
 </li>
 <li>
 AWS EC2 and EBS
 </li>
 <li>
 SQL Server Monitoring and Alerting
 </li>
 <li>
 Windows Failover Clustering
 </li>
 <li>
 Always On Availability Groups
 </li>
 <li>
 Incident Management and Root Cause Analysis
 
 
 </li>
 </ul>
 
 Required Qualifications
 
 
 
 <ul>
 <li>
 8+ years of overall IT experience with at least 5+ years of hands-on SQL Server DBA or Engineering experience
 </li>
 <li>
 Strong knowledge of SQL Server internals including storage engine, query optimizer, buffer pool, plan cache, and TempDB behavior
 </li>
 <li>
 Advanced experience analyzing wait stats, DMVs, Extended Events, SQL Profiler, and execution plans
 </li>
 <li>
 Proven expertise in diagnosing CPU, memory, I/O, TempDB, and transaction log performance issues
 </li>
 <li>
 Expert-level SQL and T-SQL skills including stored procedures, functions, triggers, and views
 </li>
 <li>
 In-depth understanding of locking, blocking, deadlocks, and transactional performance issues
 </li>
 <li>
 Experience identifying and optimizing resource-intensive queries through indexing, query rewrites, and architectural improvements
 </li>
 <li>
 Hands-on experience with SQL Server HA/DR technologies including WSFC, Always On AGs, FCI, Log Shipping, Mirroring, and Replication
 </li>
 <li>
 Strong experience working with AWS infrastructure including EC2 instance sizing, EBS volumes, IOPS, throughput, and Multi-AZ designs
 </li>
 <li>
 Experience with enterprise-level SQL Server monitoring and observability tools
 </li>
 <li>
 Hands-on experience with T-SQL, PowerShell, and SQL Server Agent
 </li>
 <li>
 Experience with SSRS performance tuning is a plus
 </li>
 <li>
 Strong communication skills and ability to collaborate with cross-functional teams
 
 
 </li>
 </ul>
 
 Key Responsibilities
 
 
 
 <ul>
 <li>
 Optimize SQL Server architecture, configuration, indexing strategies, statistics, TempDB, and file layouts
 </li>
 <li>
 Analyze and resolve performance bottlenecks across CPU, memory, I/O, and network
 </li>
 <li>
 Conduct deep-dive troubleshooting using wait stats, DMVs, execution plans, and Extended Events
 </li>
 <li>
 Review and fine-tune SQL Server settings including MAXDOP, cost threshold for parallelism, memory configuration, and TempDB
 </li>
 <li>
 Tune and refactor complex SQL and T-SQL stored procedures, views, and functions
 </li>
 <li>
 Identify and resolve locking, blocking, deadlocks, transactional contention, and long-running queries
 </li>
 <li>
 Assess, troubleshoot, and stabilize existing HA/DR and cluster environments
 </li>
 <li>
 Design and implement HA/DR solutions aligned with RPO and RTO requirements
 </li>
 <li>
 Improve proactive and reactive monitoring through actionable alerts and dashboards
 </li>
 <li>
 Lead incident response and root cause analysis for production issues
 </li>
 <li>
 Provide architectural recommendations and align environments with SQL Server best practices
 </li>
 <li>
 Support capacity planning, scaling strategies, backup and restore, and maintenance plans
 </li>
 <li>
 Automate operational tasks such as index maintenance, statistics updates, log cleanup, and data archiving
 </li>
 <li>
 Maintain documentation and contribute to knowledge sharing initiatives
 
 
 </li>
 </ul>
 
 What We Offer
 
 
 
 <ul>
 <li>
 Competitive contractual compensation
 </li>
 <li>
 Contract extension opportunity based on performance and business needs
 </li>
 <li>
 Fuel expense reimbursement
 </li>
 <li>
 Paid holidays and vacations
 </li>
 <li>
 Medical outpatient reimbursement and health insurance
 </li>
 <li>
 Opportunity to work in a high-performance, cloud-focused environment
 </li>
 </ul>
</div>

MS-SQL DBA Expert - Optimization & Tuning

Join NorthBay - Pakistan and explore 1   exciting career opportunities. They're hiring for various roles with options for remote or on-site work. Apply today and become part of their innovative team.

NorthBay - Pakistan

ABOUT_COMPANY

MS-SQL DBA Expert - Optimization & Tuning