CrawlJobs Logo

Ms-sql dba expert - optimization & tuning

northbaysolutions.com Logo

NorthBay

Location Icon

Location:
Pakistan , Lahore

Category Icon

Job Type Icon

Contract Type:
Not provided

Salary Icon

Salary:

Not provided

Job Description:

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
  • Advanced experience analyzing wait stats, DMVs, Extended Events, SQL Profiler, and execution plans
  • Proven expertise in diagnosing CPU, memory, I/O, TempDB, and transaction log performance issues
  • Expert-level SQL and T-SQL skills including stored procedures, functions, triggers, and views
  • In-depth understanding of locking, blocking, deadlocks, and transactional performance issues
  • Experience identifying and optimizing resource-intensive queries through indexing, query rewrites, and architectural improvements
  • Hands-on experience with SQL Server HA/DR technologies including WSFC, Always On AGs, FCI, Log Shipping, Mirroring, and Replication
  • Strong experience working with AWS infrastructure including EC2 instance sizing, EBS volumes, IOPS, throughput, and Multi-AZ designs
  • Experience with enterprise-level SQL Server monitoring and observability tools
  • Hands-on experience with T-SQL, PowerShell, and SQL Server Agent
  • Strong communication skills and ability to collaborate with cross-functional teams

Nice to have:

Experience with SSRS performance tuning is a plus

What we offer:
  • Competitive contractual compensation
  • Contract extension opportunity based on performance and business needs
  • Fuel expense reimbursement
  • Paid holidays and vacations
  • Medical outpatient reimbursement and health insurance
  • Opportunity to work in a high-performance, cloud-focused environment

Additional Information:

Job Posted:
January 12, 2026

Employment Type:
Fulltime
Work Type:
Remote work
Job Link Share:

Looking for more opportunities? Search for other job offers that match your skills and interests.

Briefcase Icon

Similar Jobs for Ms-sql dba expert - optimization & tuning

Ms-sql dba expert - optimization & tuning

NorthBay is looking for a hands-on Microsoft SQL Server expert who can own the p...
Location
Location
Pakistan , Lahore;Islamabad;Karachi
Salary
Salary:
Not provided
northbaysolutions.com Logo
NorthBay
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 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
  • 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
  • Ability to identify & analyze resource-heavy queries/processes and systematically optimize them (indexing, hints, plan guides, code refactoring, re-architecture where needed)
  • 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), Focus on Implementing actionable Alerting to reduce the noise
  • Experience with T-SQL, PowerShell & SQL Server Agent etc.
Job Responsibility
Job Responsibility
  • Optimize database architecture, configuration, indexing strategy, statistics, TempDB, log & data file layout in line with SQL Server best practices
  • Review MS SQL Server Configurations, Analyze and resolve performance bottlenecks across CPU, memory, I/O, and network
  • Conduct wait stats, DMVs, execution plans, and XEvents analysis to identify root causes
  • Review and refine MAXDOP, cost threshold for parallelism, memory settings, TempDB configuration, and disk layout to improve performance and stability
  • Review, tune, and refactor complex SQL and T‑SQL stored procedures, views, and functions
  • Identify and resolve locking, blocking, deadlocks, transactional contentions, and long-running queries by optimizing indexing and/or query tuning and rewrites
  • Assess and document existing HA/DR implementations across clusters, Troubleshoot and stabilize cluster switchovers/failovers, including issues seen during planned and unplanned events
  • Define and implement HA/DR designs to meet RPO/RTO targets & Develop/Test failover/runbooks
  • Improve the Proactive & Reactive Monitoring / Observability with recommending/implementing comprehensive monitoring & alerting across SQL Server health and performance, HADR/Cluster state, sync latency etc.
  • 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.)
What we offer
What we offer
  • Competitive salary and benefits
  • Fuel expense reimbursement
  • Paid holidays and vacations
  • Medical outpatient reimbursement & health insurance facility
  • Career path to make a difference in a highly productive environment
  • Fulltime
Read More
Arrow Right

Ms-sql dba expert - optimization & tuning

NorthBay is looking for a hands-on Microsoft SQL Server expert who can own the p...
Location
Location
Pakistan , Lahore;Islamabad;Karachi
Salary
Salary:
Not provided
northbaysolutions.com Logo
NorthBay
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 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
  • 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
  • Ability to identify & analyze resource-heavy queries/processes and systematically optimize them (indexing, hints, plan guides, code refactoring, re-architecture where needed)
  • 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), Focus on Implementing actionable Alerting to reduce the noise
  • Experience with T-SQL, PowerShell & SQL Server Agent etc.
Job Responsibility
Job Responsibility
  • Optimize database architecture, configuration, indexing strategy, statistics, TempDB, log & data file layout in line with SQL Server best practices
  • Review MS SQL Server Configurations, Analyze and resolve performance bottlenecks across CPU, memory, I/O, and network
  • Conduct wait stats, DMVs, execution plans, and XEvents analysis to identify root causes
  • Review and refine MAXDOP, cost threshold for parallelism, memory settings, TempDB configuration, and disk layout to improve performance and stability
  • Review, tune, and refactor complex SQL and T‑SQL stored procedures, views, and functions
  • Identify and resolve locking, blocking, deadlocks, transactional contentions, and long-running queries by optimizing indexing and/or query tuning and rewrites
  • Assess and document existing HA/DR implementations across clusters, Troubleshoot and stabilize cluster switchovers/failovers, including issues seen during planned and unplanned events
  • Define and implement HA/DR designs to meet RPO/RTO targets & Develop/Test failover/runbooks
  • Improve the Proactive & Reactive Monitoring / Observability with recommending/implementing comprehensive monitoring & alerting across SQL Server health and performance, HADR/Cluster state, sync latency etc.
  • 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.)
What we offer
What we offer
  • Competitive salary and benefits
  • Fuel expense reimbursement
  • Paid holidays and vacations
  • Medical outpatient reimbursement & health insurance facility
  • Career path to make a difference in a highly productive environment
  • Fulltime
Read More
Arrow Right

Ms-sql dba expert - optimization & tuning

NorthBay is looking for a hands-on Microsoft SQL Server expert who can own the p...
Location
Location
Pakistan , Lahore; Islamabad; Karachi
Salary
Salary:
Not provided
northbaysolutions.com Logo
NorthBay
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 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
  • 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
  • Ability to identify & analyze resource-heavy queries/processes and systematically optimize them (indexing, hints, plan guides, code refactoring, re-architecture where needed)
  • 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), Focus on Implementing actionable Alerting to reduce the noise
  • Experience with T-SQL, PowerShell & SQL Server Agent etc.
Job Responsibility
Job Responsibility
  • Optimize database architecture, configuration, indexing strategy, statistics, TempDB, log & data file layout in line with SQL Server best practices
  • Review MS SQL Server Configurations, Analyze and resolve performance bottlenecks across CPU, memory, I/O, and network
  • Conduct wait stats, DMVs, execution plans, and XEvents analysis to identify root causes
  • Review and refine MAXDOP, cost threshold for parallelism, memory settings, TempDB configuration, and disk layout to improve performance and stability
  • Review, tune, and refactor complex SQL and T‑SQL stored procedures, views, and functions
  • Identify and resolve locking, blocking, deadlocks, transactional contentions, and long-running queries by optimizing indexing and/or query tuning and rewrites
  • Assess and document existing HA/DR implementations across clusters, Troubleshoot and stabilize cluster switchovers/failovers, including issues seen during planned and unplanned events
  • Define and implement HA/DR designs to meet RPO/RTO targets & Develop/Test failover/runbooks
  • Improve the Proactive & Reactive Monitoring / Observability with recommending/implementing comprehensive monitoring & alerting across SQL Server health and performance, HADR/Cluster state, sync latency etc.
  • 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.)
What we offer
What we offer
  • Competitive salary and benefits
  • Fuel expense reimbursement
  • Paid holidays and vacations
  • Medical outpatient reimbursement & health insurance facility
  • Career path to make a difference in a highly productive environment
  • Fulltime
Read More
Arrow Right

Ms-sql dba expert - optimization & tuning

NorthBay is seeking a highly experienced MS-SQL DBA Expert with strong expertise...
Location
Location
Pakistan , Lahore; Karachi; Islamabad
Salary
Salary:
Not provided
northbaysolutions.com Logo
NorthBay
Expiration Date
Until further notice
Flip Icon
Requirements
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
  • Advanced experience analyzing wait stats, DMVs, Extended Events, SQL Profiler, and execution plans
  • Proven expertise in diagnosing CPU, memory, I/O, TempDB, and transaction log performance issues
  • Expert-level SQL and T-SQL skills including stored procedures, functions, triggers, and views
  • In-depth understanding of locking, blocking, deadlocks, and transactional performance issues
  • Experience identifying and optimizing resource-intensive queries through indexing, query rewrites, and architectural improvements
  • Hands-on experience with SQL Server HA/DR technologies including WSFC, Always On AGs, FCI, Log Shipping, Mirroring, and Replication
  • Strong experience working with AWS infrastructure including EC2 instance sizing, EBS volumes, IOPS, throughput, and Multi-AZ designs
Job Responsibility
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
What we offer
What we offer
  • Competitive contractual compensation
  • Contract extension opportunity based on performance and business needs
  • Fuel expense reimbursement
  • Paid holidays and vacations
  • Medical outpatient reimbursement and health insurance
  • Opportunity to work in a high-performance, cloud-focused environment
  • Fulltime
Read More
Arrow Right
New

Product Manager

As Microsoft continues to lead the way in productivity innovation, Clipchamp is ...
Location
Location
Australia , Multiple Locations
Salary
Salary:
Not provided
https://www.microsoft.com/ Logo
Microsoft Corporation
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor's Degree AND 5+ years experience in product/service/program management or software development OR equivalent experience
  • 3+ years of Product Management (or equivalent) experience shipping user‑facing products in a cross‑functional environment
  • Demonstrated ability to deliver tightly scoped features with a strong quality bar
  • Experience writing clear product requirements, defining success metrics and driving iteration from prototype to shipped experience
  • Comfort working with technical concepts and learning complex systems quickly
  • Strong collaboration and stakeholder management skills across engineering, design and research partners
  • Clear written and verbal communication skills
  • A collaborative mindset
  • Experience using AI tools to improve personal and team productivity.
Job Responsibility
Job Responsibility
  • Own and evolve a product roadmap that delivers AI‑assisted capabilities and user‑facing improvements
  • Translate ambiguous customer needs, product strategy and emerging AI capabilities into clearly scoped, shippable product increments
  • Define and uphold a high-quality bar for AI‑powered experiences by applying best‑practice evaluation approaches
  • Partner closely with engineering, design and research to deliver cohesive end‑to‑end experiences
  • Design for controllability in AI‑assisted products
  • Identify and shape new opportunities that expand what users can achieve with Clipchamp
  • Use rapid learning loops to reduce uncertainty and convert learnings into clear product decisions
  • Define success metrics and feedback mechanisms, monitor outcomes post‑launch and drive continuous improvements
  • Influence across partner teams through strong communication and collaboration
  • Contribute to evolving PM practices for AI‑powered product development.
  • Fulltime
Read More
Arrow Right
New

Fibre Optic Engineer

As a Fibre optic engineer, you will perform your duties on existing and new buil...
Location
Location
United Kingdom , Livingston
Salary
Salary:
Not provided
comex2000uk.com Logo
Comex 2000 UK Ltd
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Organised and proactive approach to work
  • Ability to work in a strong team environment
  • Excellent communication skills
  • A high level of diplomacy and customer focused
  • Uses own initiative to develop ideas and practices
  • Excellent time-management skills
  • Ability to manage stress and have strong emotional resilience
  • Flexible approach and positive attitude to work
  • Maintaining a high level of integrity and confidentiality is key
  • OTDR Experience - EXFO, CMA NETTEST, ANRITSU, NOYES or similar
Job Responsibility
Job Responsibility
  • Install, terminate and test on all fibre optic cable types -SM - 8 core up to 432 core fibre cables
  • Advanced Fibre optic testing - OTDR/ILM/CD/PMD/IOLM/PON
  • Installation of enclosures, couplers, ODF’s and cabinets
  • Execution and Maintenance/fault finding on new or existing fibre optic infrastructure
  • In constant communication with the Project Manager to assist with completion of fibre works
  • The usage of plant, materials, care of tools and equipment in a way to minimize unnecessary waste and damage
  • Adherence to all health and safety practises
  • Ensure to bring sufficient hardware & tools out to site each day
  • Ensure all daily reporting, fibre characterization and documentation is mailed to the Project Manager daily
  • Identify quality problems and recommend solutions. Report back to Project Manager any compliance issues
What we offer
What we offer
  • Make a Real Difference: Your expertise will directly impact the rollout of groundbreaking telecoms projects, keeping Virgin Media at the forefront of the industry
  • Be Part of a Winning Team: Collaborate with a passionate and supportive team who share your drive for excellence
  • Embrace Continuous Learning: We invest heavily in your development, offering ongoing training and opportunities to expand your skillset
  • Unlock Your Potential: Enjoy a career path brimming with possibilities, where your contributions are valued and rewarded
  • Great Benefits: Competitive salary, pension scheme & heavily discounted Virgin Media products
  • Fulltime
Read More
Arrow Right
New

Senior Surgery Manager

Optical Express is focused on delivering exceptional patient care, outstanding c...
Location
Location
United Kingdom , Glasgow or Manchester
Salary
Salary:
Not provided
opticalexpressgroup.com Logo
Optical Express Group
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • excellent communication and presentation skills
  • an adaptable, flexible approach to work
  • top notch Microsoft office and outlook
  • meticulous attention to detail
  • confidence, and integrity to operate with the upmost discretion
  • A proven track record of leading MDT across different locations.
  • Enthusiasm and a willingness to learn
  • A hands-on and customer-centric approach
Job Responsibility
Job Responsibility
  • Identifying and implementing systems to ensure world class surgical treatments and appropriate patient outcomes.
  • To motivate the surgical team to achieve the clinical KPIs and targets for treatment volumes.
  • Providing support for the team in efficient and productive use of surgery time, maximisation of surgery lists, accurate and timely reporting is key to success.
  • Taking responsibility for managing the Clinical Governance and HCC systems centrally and ensuring full compliance – first time, every time.
What we offer
What we offer
  • Exposure to cutting edge technology and techniques
  • Competitive salary and additional company benefits including product/treatment discounts
  • The opportunity to work with talented colleagues to truly change people lives
  • Free or discounted optical products/procedures
  • Competitive/ and industry leading salaries
  • Career progression / Defined and unparalleled career path and progression opportunities
  • Modern working environment with superb technology support
  • Fulltime
Read More
Arrow Right
New

Supervisor-engineering

Install, maintain, perform preventative maintenance on, and recommend replacemen...
Location
Location
Barbados
Salary
Salary:
Not provided
https://www.marriott.com Logo
Marriott Bonvoy
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Technical, Trade, or Vocational School Degree
  • At least 2 years of related work experience
  • At least 2 years of supervisory experience
Job Responsibility
Job Responsibility
  • Install, maintain, perform preventative maintenance on, and recommend replacement of tools, appliances, and equipment
  • Calibrate all controls, gauges, meters, etc
  • Identify, locate, and operate all shut-off valves
  • Order, mark, and stock parts and supplies as needed
  • Maintain inventory and purchase orders log
  • Inspect tools, equipment, or machines
  • Enter and locate work-related information using computers
  • Operate power lift
  • Complete the life safety checklist, including the fire-pump run test and generator run test
  • Inspect fire sprinkler valves and alarm systems
  • Fulltime
Read More
Arrow Right