mssql dba

TCP Software

<div>
 
 TCP is committed to cultivating a diverse and inclusive team. However, we are not able to sponsor visas for this role.
 
 
 
 
 About TCP (TimeClock Plus):
 
 
 
 For more than 30 years, TCP has helped organizations engage their people by providing flexible, mobile timekeeping and workforce management solutions. Trusted by tens of thousands of customers and millions of users, TCP delivers best-in-class technology and personalized support to organizations of all sizes in the public and private sector to meet their complex timekeeping, employee scheduling, leave management and other workforce needs. Growth is happening and our vision for a successful future is clear - We'd love for you to join us on this journey! For more information on TCP, visit www.tcpsoftware.com or follow us on LinkedIn or Facebook.
 
 
 
 Job Overview:
 
 
 
 A Microsoft SQL Server (MSSQL) Database Administrator (DBA) is responsible for the design, implementation, maintenance, and performance of SQL Server databases. The role of an MSSQL DBA may varied, but typical job duties include:
 
 
 <ul>
 <li>
 Installing and configuring SQL Server instances and databases.
 </li>
 <li>
 Managing database security, including creating users and roles, assigning permissions, and implementing data encryption.
 </li>
 <li>
 Ensuring database backups and recovery procedures are in place and working effectively.
 </li>
 <li>
 Optimizing database performance by monitoring system resources, analyzing query execution plans, and fine-tuning indexes and database configurations.
 </li>
 <li>
 Troubleshooting and resolving database issues, such as locking and blocking, connectivity problems, and performance bottlenecks.
 </li>
 <li>
 Designing and implementing database replication, high availability, and disaster recovery solutions.
 </li>
 <li>
 Planning and executing database migrations and upgrades.
 </li>
 <li>
 Developing and implementing database maintenance plans, including data archiving and data purging.
 </li>
 <li>
 Providing technical support and guidance to developers and end-users on database-related issues.
 </li>
 <li>
 Documenting and building database configurations, procedures, and best practices.
 </li>
 <li>
 Reviewing database-related code built by software teams.
 
 
 </li>
 </ul>
 
 Benefits:
 
 
 
 <ul>
 <li>
 Competitive salary
 </li>
 <li>
 PTO and Sick leaves
 </li>
 <li>
 In-Patient Health insurance
 </li>
 <li>
 Provident fund and EOBI
 </li>
 <li>
 The work/life setup you need to be successful
 </li>
 <li>
 A creative, collaborative, supportive environment that gives you the autonomy to explore new ideas, grow your skill set and create outstanding results
 </li>
 <li>
 The chance to make a genuine impact on the company's growth
 </li>
 <li>
 Plenty of challenging work and the opportunity to stretch yourself
 </li>
 <li>
 The opportunity to work with amazing talent in a fast-growing company that really values their team
 
 
 </li>
 </ul>
 
 Requirements
 
 
 
 <ul>
 <li>
 To be successful in this role, an MSSQL DBA should have a strong understanding of database design and management principles, as well as proficiency in SQL Server administration tools and techniques.
 </li>
 <li>
 4-5+ years of an experience as DBA
 </li>
 <li>
 Can work in fast paced environment
 </li>
 <li>
 Excellent problem-solving skills, attention to detail, and the ability to work independently or as part of a team are also essential.
 </li>
 <li>
 Additionally, strong communication and interpersonal skills are necessary, as MSSQL DBAs may be required to interact with various stakeholders, including developers, project managers, and business users.
 
 
 </li>
 </ul>
 
 
 Physical Requirements:
 
 
 
 
 <ul>
 <li>
 Prolonged periods sitting at a desk and working on a computer.
 </li>
 <li>
 Must be able to lift up to 15 pounds at times.
 
 
 </li>
 </ul>
 
 Benefits
 
 
 
 <ul>
 <li>
 Competitive salary
 </li>
 <li>
 PTO and Sick leaves
 </li>
 <li>
 In-Patient &amp; Out-Patient Health insurance
 </li>
 <li>
 Provident fund and EOBI
 </li>
 <li>
 The work/life set up you need to be successful
 </li>
 <li>
 A creative, collaborative, supportive environment that gives you the autonomy to explore new ideas, grow your skill set and create outstanding results
 </li>
 <li>
 The chance to make a genuine impact on the company's growth
 </li>
 <li>
 Plenty of challenging work and the opportunity to stretch yourself
 </li>
 <li>
 The opportunity to work with amazing talent in a fast-growing company that really values their team
 
 
 </li>
 </ul>
 
 TCP is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.
 
</div>

Database Administrator

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>
8igywgb1B4</div>

Search 132+ Mssql dba jobs near you this January. New roles added regularly across leading industries. Apply today.

132 mssql dba jobs NEAR_ME

Database Administrator

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