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
New

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

1st Shift Material Handler

Alro Steel, a family-owned company, is currently seeking 1st Shift Material Hand...
Location
Location
United States , Pensacola
Salary
Salary:
Not provided
alro.com Logo
Alro
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • previous experience in a machine shop or metal distribution (preferred)
  • light machine operation experience (preferred)
  • excellent attendance
  • safe work habits
  • computer and keyboard skill development
  • a record of accurate order fulfillment
Job Responsibility
Job Responsibility
  • filling and preparing material orders for shipment to customers
  • operation of overhead cranes, forklifts, metal saws, shears, and lasers
What we offer
What we offer
  • Outstanding low cost 90/10 Healthcare Benefits after 30 days of employment
  • Medical/Dental/Vision/Prescription
  • Competitive compensation paid weekly
  • retirement savings plan
  • flexible spending accounts
  • paid parental leave
  • bereavement, and disability insurance
  • Paid vacation and holidays
  • Extensive upfront training and ongoing mentoring
  • Opportunities to grow and advance
  • Fulltime
Read More
Arrow Right
New

Group Product Manager

We’re looking for an experienced Group Product Manager to join the Canvas team -...
Location
Location
Hungary , Budapest
Salary
Salary:
500000.00 - 2200000.00 Ft / Month
instructure.com Logo
Instructure
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 5+ years of product management experience, ideally in edtech or adjacent industries where outcomes and trust matter
  • Proven ability to define measurable success criteria – and hit them
  • A bias to action, you move quickly from ideas to experiments, reduce time-to-learning, and aren’t afraid to make informed decisions with imperfect information
  • Strong customer empathy and ability to translate insights into actionable product direction
  • Excellent collaboration skills, with experience aligning diverse stakeholders and working within cross-functional teams. You view “we” as stronger than “me.”
  • Comfort with ambiguity, and the ability to bring clarity, structure, and measurable outcomes to evolving product spaces
  • An innovative spirit. You’re comfortable challenging the status quo and experimenting with new approaches
Job Responsibility
Job Responsibility
  • Contribute to the vision and strategy of Canvas, prioritizing the most impactful investments so that product outcomes drive measurable value for learners, learning organizations, and partners
  • Lead product development from discovery to general availability, ensuring successful development, delivery and go to market
  • Deeply understand our user’s, customer’s, and partner’s needs through interviews, data, and experimentation – and bring their voice into every decision
  • Define success measures that matter, then track and report against them to ensure accountability and progress
  • Collaborate relentlessly with other product managers, design, engineering and go-to-market teams to define strategy, align on priorities and solutions, and ship with speed
  • Leverage AI-powered workflows in your daily practice to drive efficiency, reducing time-to-validation while delivering innovative solutions
What we offer
What we offer
  • Competitive compensation and participation in Instructure’s equity program
  • Flexible schedules and a remote-friendly culture, with hybrid or onsite work based on business needs
  • Annual “Dim the Lights” company-wide shutdown from December 26 to December 31
  • Comprehensive wellness programs and mental health support
  • Annual learning and development stipends to support your growth
  • We provide the technology and tools you need to do your best work—typically a Mac, with PC options available in some locations
  • A culture rooted in inclusivity, support, and meaningful connection
  • Fulltime
Read More
Arrow Right
New

Cluster Manager

The Cluster Manager plays a pivotal role in driving RedCloud’s growth within the...
Location
Location
Nigeria , Owerri
Salary
Salary:
Not provided
redcloudtechnology.com Logo
RedCloud
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor’s degree in business administration, Marketing, or a related field
  • Previous experience (5 - 10 years) in retail, preferably within an FMCG or a B2B marketplace environment
  • Strong understanding of customer experience and relationship management
  • Good business writing and interpersonal skills to effectively collaborate with internal and external stakeholders at all levels
  • Excellent analytical skills, with the ability to interpret data, derive insights, and make data-driven decisions
  • Knowledge of MS Excel at intermediate level a must have
  • Self-starter with a proactive approach, able to work independently and take ownership of projects
  • Proficiency in the use of ERP and CRM tools would be a great advantage
Job Responsibility
Job Responsibility
  • Identify all prospective Distributors & Wholesalers within their cluster to ensure assortment as per demand from the local retail ecosystem
  • Pitch and sell RedCloud’s value proposition to prospective Distributors/Wholesalers
  • Lead commercial discussions and secure signed agreements and invoicing
  • Deliver monthly targets for TTV (including direct engagement to facilitate Bulk trade via TradeX), Acquisition, Revenue and Monthly Active Retailers
  • Build and execute strategic growth plans to drive platform adoption and consistent trading performance across all partners
  • Act as the ongoing success owner for all Distributors/Wholesalers in the cluster
  • Develop a monthly visit plan covering every Distributor/Wholesaler in the cluster
  • Ensure Distributors/Wholesalers maintain accurate product listings, pricing, inventory levels, and assortments on the platform
  • Proactively prevent stock-outs and guide partners on improving catalogue quality
  • Diagnose challenges early (pricing, assortment, logistics, platform usage, retailer activation) and coordinate cross-functional solutions
What we offer
What we offer
  • First Class Salary
  • 25 days annual leave increasing to 26 days after your first 12 months in the business
  • Company Equipment
Read More
Arrow Right
New

Receptionist

One of the fastest-growing accounting firms in the country is seeking a Receptio...
Location
Location
United States , St. Louis
Salary
Salary:
45000.00 - 55000.00 USD / Year
anderscpa.com Logo
Anders Minkler Huber & Helm LLP
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • High school diploma or equivalent required
  • 4+ years of experience in a professional support role
  • Experience with Microsoft Office programs including Word, Excel, Outlook, Teams and PowerPoint
Job Responsibility
Job Responsibility
  • Maintain the Firm’s reception area
  • Answer the Firm’s main phone line and route incoming calls professionally and appropriately
  • Answer inquiries about the Firm
  • Greet, assist, and/or direct vendors, guests and clients
  • Maintain security by following procedures and monitoring visitor logbook
  • Notify staff members on arrival of guests
  • Validate parking for clients
  • Track parking validation usage, purchase parking validations as needed
  • Coordinate and schedule various daily deliveries via courier’s website
  • Sign for and distribute incoming courier packages and overnight deliveries
What we offer
What we offer
  • Professional development opportunities
  • Benefits that directly impact mental, physical and financial wellness
  • Work Flex program which gives you the opportunity to work at our Chesterfield office, our Downtown St. Louis office, remotely, adopt a hybrid approach or even switch between these options as you prefer
  • Fulltime
Read More
Arrow Right