database performance engineer

NorthBay - Pakistan

<div>
 MSSQL DBA/Expert | DB Optimization &amp; SQL 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 &amp; performance optimization against high-volume production systems. You will be the go-to expert for identifying bottlenecks, tuning SQL &amp; T‑SQL (Including SPs/Functions), Stabilizing Cluster/DR failovers, and designing/improving observability including proactive monitoring and alerting
 
 
 
 Requirements
 
 
 
 <ul>
 <li>
 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
 </li>
 <li>
 Deep understanding of SQL Server internals (storage engine, query optimizer, plan cache, buffer pool, TempDB behavior etc.).
 </li>
 <li>
 Expert-level experience in diagnosing Wait stats, DMVs, Extended Events, Profiler/Tracing, Execution plan analysis, query rewrites, indexing strategy design
 </li>
 <li>
 Troubleshooting CPU spikes, I/O bottlenecks, memory pressure, TempDB contention, log bottlenecks (e.g. WRITELOG waits) etc.
 </li>
 <li>
 Expert in SQL &amp; T‑SQL optimizations including SPs, Triggers, Views, Functions etc. along with in depth understanding of locking, blocking, deadlocks, and transaction-related performance issues
 </li>
 <li>
 Ability to identify &amp; analyze resource-heavy queries/processes and systematically optimize them (indexing, hints, plan guides, code refactoring, re-architecture where needed)
 </li>
 <li>
 Hands-on expertise in designing, deploying, and troubleshooting Windows Failover Clustering (WSFC), Always On Availability Groups (AGs), Failover Cluster Instances (FCI), Log Shipping, Mirroring &amp; Replication
 </li>
 <li>
 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 &amp; Monitoring &amp; Observability
 </li>
 <li>
 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
 </li>
 <li>
 Experience with T-SQL, PowerShell &amp; SQL Server Agent etc.
 </li>
 <li>
 Having experience with Reporting Services (SSRS) performance and optimization will be preferred
 </li>
 <li>
 Strong communication skills with the ability to explain complex database issues to non-DBA stakeholders and mentor developers on SQL best practices.
 
 
 </li>
 </ul>
 
 Responsibilities
 
 
 
 <ul>
 <li>
 Optimize database architecture, configuration, indexing strategy, statistics, TempDB, log &amp; data file layout in line with SQL Server best practices
 </li>
 <li>
 Review MS SQL Server Configurations, Analyze and resolve performance bottlenecks across CPU, memory, I/O, and network
 </li>
 <li>
 Conduct wait stats, DMVs, execution plans, and XEvents analysis to identify root causes
 </li>
 <li>
 Review and refine MAXDOP, cost threshold for parallelism, memory settings, TempDB configuration, and disk layout to improve performance and stability
 </li>
 <li>
 Review, tune, and refactor complex SQL and T‑SQL stored procedures, views, and functions
 </li>
 <li>
 Identify and resolve locking, blocking, deadlocks, transactional contentions, and long-running queries by optimizing indexing and/or query tuning and rewrites
 </li>
 <li>
 Assess and document existing HA/DR implementations across clusters, Troubleshoot and stabilize cluster switchovers/failovers, including issues seen during planned and unplanned events
 </li>
 <li>
 Define and implement HA/DR designs to meet RPO/RTO targets &amp; Develop/Test failover/runbooks
 </li>
 <li>
 Improve the Proactive &amp; Reactive Monitoring / Observability with recommending/implementing comprehensive monitoring &amp; alerting across SQL Server health and performance, HADR/Cluster state, sync latency etc.
 </li>
 <li>
 Recommend and implement best-fit monitoring tools (e.g. advanced Datadog usage, plus tools such as SQL Sentry, Redgate SQL Monitor, SolarWinds DPA, native SQL tools, etc.).
 </li>
 <li>
 Incident Response &amp; Root Cause Analysis as lead on critical incident investigations for production performance and availability issues
 </li>
 <li>
 Recommendations based on Architecture, Design Best Practices by reviewing existing SQL Server architecture, and configurations and bring them in line with current best practices
 </li>
 <li>
 Advise on capacity planning, scaling strategies, backup/restore strategy, indexing &amp; maintenance plans
 </li>
 <li>
 Automate repetitive tasks e.g., index maintenance, stats updates, log cleanups, data archiving
 </li>
 <li>
 Contribute to documentation, standards, and knowledge sharing for DB usage across teams
 
 
 </li>
 </ul>
 What We Offer
 
 
 <ul>
 <li>
 Competitive salary and benefits
 </li>
 <li>
 Fuel expense reimbursement
 </li>
 <li>
 Paid holidays and vacations
 </li>
 <li>
 Medical outpatient reimbursement &amp; health insurance facility
 </li>
 <li>
 Career path to make a difference in a highly productive environment
 </li>
 </ul>
</div>

SQL DBA Expert - Optimization & Tuning

NorthBay Solutions

<div>
 &nbsp;
 
 
 
 
 
 
 
 MSSQL DBA/Expert | DB Optimization &amp; SQL Tuning
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 &nbsp;
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 Location: Lahore/Islamabad/Karachi
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 Experience: 8+ years
 
 
 
 
 
 
 
 &nbsp;
 
 
 
 
 
 
 
 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 &amp; performance optimization against high-volume production systems. You will be the go-to expert for identifying bottlenecks, tuning SQL &amp; T‑SQL (Including SPs/Functions), Stabilizing Cluster/DR failovers, and designing/improving observability including proactive monitoring and alerting
 
 
 
 
 
 
 
 &nbsp;
 
 
 
 
 
 
 
 Requirements:
 
 
 
 
 
 
 
 <ul>
 <li>
 
 
 
 
 
 
 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
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 Deep understanding of SQL Server internals (storage engine, query optimizer, plan cache, buffer pool, TempDB behavior etc.).
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 Expert-level experience in diagnosing Wait stats, DMVs, Extended Events, Profiler/Tracing, Execution plan analysis, query rewrites, indexing strategy design
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 Troubleshooting CPU spikes, I/O bottlenecks, memory pressure, TempDB contention, log bottlenecks (e.g. WRITELOG waits) etc.
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 Expert in SQL &amp; T‑SQL optimizations including SPs, Triggers, Views, Functions etc. along with in depth understanding of locking, blocking, deadlocks, and transaction-related performance issues
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 Ability to identify &amp; analyze resource-heavy queries/processes and systematically optimize them (indexing, hints, plan guides, code refactoring, re-architecture where needed)
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 Hands-on expertise in designing, deploying, and troubleshooting Windows Failover Clustering (WSFC), Always On Availability Groups (AGs), Failover Cluster Instances (FCI), Log Shipping, Mirroring &amp; Replication
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 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 &amp; Monitoring &amp; Observability
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 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
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 Experience with T-SQL, PowerShell &amp; SQL Server Agent etc.
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 Having experience with Reporting Services (SSRS) performance and optimization will be preferred
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 Strong communication skills with the ability to explain complex database issues to non-DBA stakeholders and mentor developers on SQL best practices.
 
 
 
 
 
 
 </li>
 </ul>
 &nbsp;
 
 
 
 
 
 
 
 Responsibilities:
 
 
 
 
 
 
 
 <ul>
 <li>
 
 
 
 
 
 
 Optimize database architecture, configuration, indexing strategy, statistics, TempDB, log &amp; data file layout in line with SQL Server best practices
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 Review MS SQL Server Configurations, Analyze and resolve performance bottlenecks across CPU, memory, I/O, and network
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 Conduct wait stats, DMVs, execution plans, and XEvents analysis to identify root causes
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 Review and refine MAXDOP, cost threshold for parallelism, memory settings, TempDB configuration, and disk layout to improve performance and stability
 
 
 
 
 
 
 </li>
 </ul>
 <ul>
 <li>
 
 
 
 
 
 
 Review, tune, and refactor complex SQL and T‑SQL stored procedures, views, and functions
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 Identify and resolve locking, blocking, deadlocks, transactional contentions, and long-running queries by optimizing indexing and/or query tuning and rewrites
 
 
 
 
 
 
 </li>
 </ul>
 <ul>
 <li>
 
 
 
 
 
 
 Assess and document existing HA/DR implementations across clusters, Troubleshoot and stabilize cluster switchovers/failovers, including issues seen during planned and unplanned events
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 Define and implement HA/DR designs to meet RPO/RTO targets &amp; Develop/Test failover/runbooks
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 Improve the Proactive &amp; Reactive Monitoring / Observability with recommending/implementing comprehensive monitoring &amp; alerting across SQL Server health and performance, HADR/Cluster state, sync latency etc.
 
 
 
 
 
 
 </li>
 </ul>
 <ul>
 <li>
 
 
 
 
 
 
 Recommend and implement best-fit monitoring tools (e.g. advanced Datadog usage, plus tools such as SQL Sentry, Redgate SQL Monitor, SolarWinds DPA, native SQL tools, etc.).
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 Incident Response &amp; Root Cause Analysis as lead on critical incident investigations for production performance and availability issues
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 Recommendations based on Architecture, Design Best Practices by reviewing existing SQL Server architecture, and configurations and bring them in line with current best practices
 
 
 
 
 
 
 </li>
 </ul>
 <ul>
 <li>
 
 
 
 
 
 
 Advise on capacity planning, scaling strategies, backup/restore strategy, indexing &amp; maintenance plans
 
 
 
 
 
 
 </li>
 </ul>
 <ul>
 <li>
 
 
 
 
 
 
 Automate repetitive tasks e.g., index maintenance, stats updates, log cleanups, data archiving
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 Contribute to documentation, standards, and knowledge sharing for DB usage across teams
 
 
 
 
 
 
 </li>
 </ul>
 
 
 
 
 
 
 
 What We Offer&nbsp;
 
 
 
 
 
 
 
 <ul>
 <li>
 
 
 
 
 
 
 Competitive salary and benefits
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 Fuel expense reimbursement
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 Paid holidays and vacations
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 Medical outpatient reimbursement &amp; health insurance facility
 
 
 
 
 
 
 
 
 
 
 
 
 &nbsp;
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 Career path to make a difference in a highly productive environment
 
 
 
 
 
 
 </li>
 </ul>
</div>

<div>MSSQL DBA/Expert | DB Optimization &amp; SQL 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 &amp; performance optimization against high-volume production systems. You will be the go-to expert for identifying bottlenecks, tuning SQL &amp; T‑SQL (Including SPs/Functions), Stabilizing Cluster/DR failovers, and designing/improving observability including proactive monitoring and alerting 
Requirements:<ul><li>
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</li><li>
Deep understanding of SQL Server internals (storage engine, query optimizer, plan cache, buffer pool, TempDB behavior etc.).</li><li>
Expert-level experience in diagnosing Wait stats, DMVs, Extended Events, Profiler/Tracing, Execution plan analysis, query rewrites, indexing strategy design</li><li>
Troubleshooting CPU spikes, I/O bottlenecks, memory pressure, TempDB contention, log bottlenecks (e.g. WRITELOG waits) etc.</li><li>
Expert in SQL &amp; T‑SQL optimizations including SPs, Triggers, Views, Functions etc. along with in depth understanding of locking, blocking, deadlocks, and transaction-related performance issues</li><li>
Ability to identify &amp; analyze resource-heavy queries/processes and systematically optimize them (indexing, hints, plan guides, code refactoring, re-architecture where needed)</li><li>
Hands-on expertise in designing, deploying, and troubleshooting Windows Failover Clustering (WSFC), Always On Availability Groups (AGs), Failover Cluster Instances (FCI), Log Shipping, Mirroring &amp; Replication</li><li>
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 &amp; Monitoring &amp; Observability</li><li>
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</li><li>
Experience with T-SQL, PowerShell &amp; SQL Server Agent etc.</li><li>
Having experience with Reporting Services (SSRS) performance and optimization will be preferred</li><li>
Strong communication skills with the ability to explain complex database issues to non-DBA stakeholders and mentor developers on SQL best practices.</li></ul> 
Responsibilities:<ul><li>
Optimize database architecture, configuration, indexing strategy, statistics, TempDB, log &amp; data file layout in line with SQL Server best practices</li><li>
Review MS SQL Server Configurations, Analyze and resolve performance bottlenecks across CPU, memory, I/O, and network</li><li>
Conduct wait stats, DMVs, execution plans, and XEvents analysis to identify root causes</li><li>
Review and refine MAXDOP, cost threshold for parallelism, memory settings, TempDB configuration, and disk layout to improve performance and stability</li></ul><ul><li>
Review, tune, and refactor complex SQL and T‑SQL stored procedures, views, and functions</li><li>
Identify and resolve locking, blocking, deadlocks, transactional contentions, and long-running queries by optimizing indexing and/or query tuning and rewrites</li></ul><ul><li>
Assess and document existing HA/DR implementations across clusters, Troubleshoot and stabilize cluster switchovers/failovers, including issues seen during planned and unplanned events</li><li>
Define and implement HA/DR designs to meet RPO/RTO targets &amp; Develop/Test failover/runbooks</li><li>
Improve the Proactive &amp; Reactive Monitoring / Observability with recommending/implementing comprehensive monitoring &amp; alerting across SQL Server health and performance, HADR/Cluster state, sync latency etc.</li></ul><ul><li>
Recommend and implement best-fit monitoring tools (e.g. advanced Datadog usage, plus tools such as SQL Sentry, Redgate SQL Monitor, SolarWinds DPA, native SQL tools, etc.).</li><li>
Incident Response &amp; Root Cause Analysis as lead on critical incident investigations for production performance and availability issues</li><li>
Recommendations based on Architecture, Design Best Practices by reviewing existing SQL Server architecture, and configurations and bring them in line with current best practices</li><li>
Advise on capacity planning, scaling strategies, backup/restore strategy, indexing &amp; maintenance plans</li></ul><ul><li>
Automate repetitive tasks e.g., index maintenance, stats updates, log cleanups, data archiving</li><li>
Contribute to documentation, standards, and knowledge sharing for DB usage across teams</li></ul>
What We Offer<ul><li>
Competitive salary and benefits</li><li>
Fuel expense reimbursement</li><li>
Paid holidays and vacations</li><li>
Medical outpatient reimbursement &amp; health insurance facility</li><li>
Career path to make a difference in a highly productive environment</li></ul>
mE5HagbcO1</div>

<div>MSSQL DBA/Expert | DB Optimization &amp; SQL 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 &amp; performance optimization against high-volume production systems. You will be the go-to expert for identifying bottlenecks, tuning SQL &amp; T‑SQL (Including SPs/Functions), Stabilizing Cluster/DR failovers, and designing/improving observability including proactive monitoring and alerting 
Requirements:<ul><li>
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</li><li>
Deep understanding of SQL Server internals (storage engine, query optimizer, plan cache, buffer pool, TempDB behavior etc.).</li><li>
Expert-level experience in diagnosing Wait stats, DMVs, Extended Events, Profiler/Tracing, Execution plan analysis, query rewrites, indexing strategy design</li><li>
Troubleshooting CPU spikes, I/O bottlenecks, memory pressure, TempDB contention, log bottlenecks (e.g. WRITELOG waits) etc.</li><li>
Expert in SQL &amp; T‑SQL optimizations including SPs, Triggers, Views, Functions etc. along with in depth understanding of locking, blocking, deadlocks, and transaction-related performance issues</li><li>
Ability to identify &amp; analyze resource-heavy queries/processes and systematically optimize them (indexing, hints, plan guides, code refactoring, re-architecture where needed)</li><li>
Hands-on expertise in designing, deploying, and troubleshooting Windows Failover Clustering (WSFC), Always On Availability Groups (AGs), Failover Cluster Instances (FCI), Log Shipping, Mirroring &amp; Replication</li><li>
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 &amp; Monitoring &amp; Observability</li><li>
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</li><li>
Experience with T-SQL, PowerShell &amp; SQL Server Agent etc.</li><li>
Having experience with Reporting Services (SSRS) performance and optimization will be preferred</li><li>
Strong communication skills with the ability to explain complex database issues to non-DBA stakeholders and mentor developers on SQL best practices.</li></ul> 
Responsibilities:<ul><li>
Optimize database architecture, configuration, indexing strategy, statistics, TempDB, log &amp; data file layout in line with SQL Server best practices</li><li>
Review MS SQL Server Configurations, Analyze and resolve performance bottlenecks across CPU, memory, I/O, and network</li><li>
Conduct wait stats, DMVs, execution plans, and XEvents analysis to identify root causes</li><li>
Review and refine MAXDOP, cost threshold for parallelism, memory settings, TempDB configuration, and disk layout to improve performance and stability</li></ul><ul><li>
Review, tune, and refactor complex SQL and T‑SQL stored procedures, views, and functions</li><li>
Identify and resolve locking, blocking, deadlocks, transactional contentions, and long-running queries by optimizing indexing and/or query tuning and rewrites</li></ul><ul><li>
Assess and document existing HA/DR implementations across clusters, Troubleshoot and stabilize cluster switchovers/failovers, including issues seen during planned and unplanned events</li><li>
Define and implement HA/DR designs to meet RPO/RTO targets &amp; Develop/Test failover/runbooks</li><li>
Improve the Proactive &amp; Reactive Monitoring / Observability with recommending/implementing comprehensive monitoring &amp; alerting across SQL Server health and performance, HADR/Cluster state, sync latency etc.</li></ul><ul><li>
Recommend and implement best-fit monitoring tools (e.g. advanced Datadog usage, plus tools such as SQL Sentry, Redgate SQL Monitor, SolarWinds DPA, native SQL tools, etc.).</li><li>
Incident Response &amp; Root Cause Analysis as lead on critical incident investigations for production performance and availability issues</li><li>
Recommendations based on Architecture, Design Best Practices by reviewing existing SQL Server architecture, and configurations and bring them in line with current best practices</li><li>
Advise on capacity planning, scaling strategies, backup/restore strategy, indexing &amp; maintenance plans</li></ul><ul><li>
Automate repetitive tasks e.g., index maintenance, stats updates, log cleanups, data archiving</li><li>
Contribute to documentation, standards, and knowledge sharing for DB usage across teams</li></ul>
What We Offer<ul><li>
Competitive salary and benefits</li><li>
Fuel expense reimbursement</li><li>
Paid holidays and vacations</li><li>
Medical outpatient reimbursement &amp; health insurance facility</li><li>
Career path to make a difference in a highly productive environment</li></ul>
BACqRGKEVv</div>

Search 10000+ Database performance engineer jobs near you this January. New roles added regularly across leading industries. Apply today.

10000 database performance engineer jobs NEAR_ME

SQL DBA Expert - Optimization & Tuning

SQL DBA Expert - Optimization & Tuning

SQL DBA Expert - Optimization & Tuning

SQL DBA Expert - Optimization & Tuning

SQL DBA Expert - Optimization & Tuning

SQL DBA Expert - Optimization & Tuning

SQL DBA Expert - Optimization & Tuning