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 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 & performance optimization against high-volume production systems. You will be the go-to expert for identifying bottlenecks, tuning SQL & T‑SQL (Including SPs/Functions), Stabilizing Cluster/DR failovers, and designing/improving observability including proactive monitoring and alerting

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.)
  • Incident Response & Root Cause Analysis as lead on critical incident investigations for production performance and availability issues
  • Recommendations based on Architecture, Design Best Practices by reviewing existing SQL Server architecture, and configurations and bring them in line with current best practices
  • Advise on capacity planning, scaling strategies, backup/restore strategy, indexing & maintenance plans
  • Automate repetitive tasks e.g., index maintenance, stats updates, log cleanups, data archiving
  • Contribute to documentation, standards, and knowledge sharing for DB usage across teams

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.
  • Strong communication skills with the ability to explain complex database issues to non-DBA stakeholders and mentor developers on SQL best practices.

Nice to have:

Having experience with Reporting Services (SSRS) performance and optimization will be preferred

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

Additional Information:

Job Posted:
December 26, 2025

Employment Type:
Fulltime
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 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

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

Housekeeping House Attendant

The Four Seasons Resort Hualalai is looking for a Housekeeping House Attendant w...
Location
Location
United States of America , Kailua-Kona, Hawaii
Salary
Salary:
25.37 USD / Hour
fourseasons.com Logo
Four Seasons
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Successful candidate must possess legal work authorization in United States
  • High School Diploma preferred
  • Ability to read, write and speak English
  • Working knowledge of iPod Touch device or similar hardware and applications
  • Weekend & Holiday availability required
Job Responsibility
Job Responsibility
  • Assist the Guest Attendants as necessary i.e. assist in putting on bed skirts, rotating mattresses, replacing canopies, etc
  • Maintain and resupply the guest room supplies and linen in the F-station service areas daily
  • Ensure cleanliness, neatness, and free of liter of hotel pathways, F-stations, guest laundry rooms, and all assigned areas
  • Remove all garbage and recyclable items and discard of in the appropriate areas
  • Clean and prepare arrival rooms
  • In the room clean glass windows and glass doors
  • Conduct high dusting of the room (i.e. headboard, ceiling fans, and vents)
  • Ensure the cleanliness of all lanais, lanai furniture, railings, fixtures, entryways, and stairs of all guest rooms
  • Delivery and pick-up guest request items when assigned (i.e. irons, ironing boards)
  • This also includes making up and delivering cribs and rollaway beds
What we offer
What we offer
  • An on-site Physical Therapist
  • 24-hour access to Indoor and Outdoor Gym
  • Holiday, Vacation & Sick pay
  • Robust Benefit Plan
  • Company Match 401K Plan
  • Laundered Employee Uniform
  • Free employee meals prepared by the Four Seasons Culinary ‘Ohana
  • Complimentary stays at Four Seasons Worldwide
  • Training and Development Opportunities
  • Employee Recognition Programs
  • Parttime
Read More
Arrow Right
New

Global Procurement Manager

Lead how our global marketing investments support and strengthen our brands worl...
Location
Location
United Kingdom , Darwen
Salary
Salary:
Not provided
crownpaints.co.uk Logo
Crown Paints
Expiration Date
April 03, 2026
Flip Icon
Requirements
Requirements
  • Experienced procurement professional with global category management experience
  • Collaborative, outcome focused approach
  • Comfortable working within a complex, multi brand environment
  • Experience in global or regional indirect procurement/category management within international or complex organisations
  • Experience working with media agencies, creative suppliers or retail marketing investments
  • Experience supporting value optimisation and scalable sourcing approaches
  • Experience establishing or managing supplier agreements and partnerships
  • Experience engaging stakeholders across seniority levels and functions
  • Experience applying structured sourcing, negotiation and contract management practices
  • Communicates clearly
Job Responsibility
Job Responsibility
  • Holding Procurement responsibility for end to end management of the global Marketing category
  • Developing and implementing Procurement related category strategies aligned with business and brand priorities
  • Guiding structured sourcing initiatives using Hempel’s standard sourcing framework
  • Establishing and managing global framework agreements with agencies and marketing suppliers
  • Supporting cost optimisation and continuous improvement across regions
  • Partnering with brand and commercial teams to support the One Deco strategy while recognising local brand needs
  • Maintaining strong governance, compliance and contract lifecycle practices
  • Fulltime
Read More
Arrow Right
New

Project Manager

Make your mark as a Project Manager/Senior Project Manager for Boskalis Subsea S...
Location
Location
United Kingdom , Aberdeen
Salary
Salary:
Not provided
boskalis.com Logo
Boskalis
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • At least 5 years relevant work experience as a Project Manager/Senior Project Manager or a project lead or a senior/lead project engineer
  • Background/experience in Subsea IRM, Decommissioning and Construction projects, international experience is desirable
  • Bachelor’s degree in a technical domain such as civil, mechanical or Offshore engineering, or BSc/MSc in Quantity Survey or MSc in Project Management
  • In-depth knowledge of certified Project management principles such as Prince2, PMP, MSP, IPMA
  • Good command of written and spoken English
  • Strong stakeholder management and communication skills
  • Flexibility to travel internationally, depending on the project requirements and demand
Job Responsibility
Job Responsibility
  • Define project control structure, manage project budget, risks and opportunities to accomplish optimal profit margin
  • Plan and manage the safe execution of the project, in compliance with the BMS, the contract, whilst maximizing the efficient use of available resources
  • Manage, coach and appraise the performance of your project team
  • Manage the relationship with the client, whilst creating commercial opportunities
  • Manage problem analyses and generate creative solutions for high-level project plans and translate project plans into operational plans
  • In the tender phase, you will contribute to project management-specific aspects
  • Developing, implementing and maintaining (inter) departmental policies, procedures and processes
  • Stakeholder management and draft progress and project close-out reports for these internal and external stakeholders
What we offer
What we offer
  • Holiday entitlement of 34 days
  • Contributory pension scheme
  • Private medical insurance
  • Death in service benefit
  • Range of flexible benefits including the opportunity to buy additional holidays each year
  • (Online) courses at Boskalis academy
  • Fulltime
Read More
Arrow Right
New

Plastics Supply Handler

This is where your work makes a difference. At Baxter, we believe every person—r...
Location
Location
United States , Marion
Salary
Salary:
21.60 USD / Hour
https://www.baxter.com/ Logo
Baxter
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • High school Diploma or GED
  • Ability to read, write and perform basic mathematics calculations
  • Physical Requirements: Lifting and carrying 26-50 lbs., an average of 3 ft., approximately 18 times per shift
  • Lifting over 75 lbs. approximately 160 times per shift
  • Frequent or continuous lifting or moving, occasionally in difficult work positions, with walking, pulling, stretching, bending, pushing and /or reaching effort required
  • Manual dexterity and visual acuity required
  • Good eye/hand/foot coordination could be necessary as well
Job Responsibility
Job Responsibility
  • Reviews Kiefel schedule and goes to warehouse to procure vinyl rollstock, stage in ante-room, breaks down pallets, loads rollstock onto buggies and supplies Kiefel machines with correct vinyl rollstock
  • Operates pneumatic hoist, worksaver, reach truck and performs housekeeping duties
  • Operates grind, blender machines converting vinyl trim scrap into reusable material for extruders
  • Delivers various raw materials to the extrusion department and removes and stages finished goods
  • Performs various required GMP cleaning duties, supplies Kiefels with belt material, plastic liners, performs routine bag closet maintenance and other duties as assigned
  • Supports Safety, 6S, GMP, and TPM efforts in the area and reports any of these or quality issues to Supervision as needed
  • Loads vinyl rollstock onto carts and stages behind designated Kiefels
  • Supplies department with Kiefel tubing
  • Completes required documentation and labeling
  • Maintains Ante Room per GMP requirements
What we offer
What we offer
  • Shift flexibility to trade shifts and leverage overtime opportunities
  • Medical, Dental and Vision coverage
  • 160 hours of Paid Time Off and Paid Holidays
  • 401K match
  • Employee Stock Purchase Program
  • Paid Parental Leave
  • Tuition Reimbursement
  • Comprehensive compensation and benefits packages
  • Health and well-being benefits include medical and dental coverage that start on day one
  • Insurance coverage for basic life, accident, short-term and long-term disability, and business travel accident insurance
  • Fulltime
Read More
Arrow Right