clickhouse cluster engineer distributed analytics platforms

Secure Tech Cards Pvt. Ltd

Job TitleClickHouse Cluster Engineer, Distributed Analytics PlatformsLocationIslamabad, Hybrid or Remote Full timeAbout the RoleWe are looking for a hands-on ClickHouse Cluster Engineer with 3 or more years of relevant experience who owns the reliability, performance, and scalability of distributed analytics infrastructure. This role goes beyond routine maintenance. You will design cluster architecture, solve performance challenges at scale, and build automation that keeps systems resilient as data volumes and usage grow.If you thrive on deep technical ownership, production problem solving, and building systems that remain stable under pressure, this role is for you.Core ResponsibilitiesCluster Management and Architecture<ul><li>Design, install, configure, and operate distributed ClickHouse clusters in production</li><li>Implement replication, sharding, and high availability using ZooKeeper</li><li>Continuously evolve cluster topology to support product growth and performance demands</li></ul>Performance Optimization<ul><li>Monitor and troubleshoot performance bottlenecks across large analytical workloads</li><li>Optimize queries, schemas, and storage engines, including advanced MergeTree configurations</li><li>Tune ClickHouse parameters to achieve predictable, high throughput performance</li></ul>Availability and Disaster Recovery<ul><li>Design and maintain backup, restore, and disaster recovery strategies</li><li>Ensure data integrity, fast recovery, and minimal downtime during failure scenarios</li></ul>Monitoring and Alerting<ul><li>Build and maintain proactive monitoring and alerting using Prometheus and Grafana</li><li>Define meaningful metrics and alerts that enable early detection and prevention of incidents</li></ul>Automation and Infrastructure as Code<ul><li>Automate provisioning, maintenance, and operational workflows</li><li>Use scripting languages such as Shell or Python and tools like Terraform and Ansible to eliminate manual processes</li></ul>Security and Access Control<ul><li>Manage user access, roles, and permissions</li><li>Ensure compliance with data security, privacy, and audit requirements</li></ul>Collaboration and Support<ul><li>Partner with engineering, data, and operations teams</li><li>Provide guidance on ClickHouse best practices and support application integrations and deployments</li></ul>Required Skills and Experience<ul><li>Minimum 3 years of hands-on experience managing ClickHouse or comparable distributed analytical databases in production</li><li>Strong understanding of distributed systems, replication, sharding, and high availability concepts</li><li>Proven experience in performance tuning for large-scale analytical workloads</li><li>Practical knowledge of Linux, scripting, and infrastructure automation</li><li>Experience with monitoring and observability tools such as Prometheus and Grafana</li></ul>Nice to Have<ul><li>Experience operating ClickHouse at high data volumes or in multi-cluster environments</li><li>Exposure to cloud or hybrid infrastructure</li><li>Strong ownership mindset with the ability to work independently on complex systems</li></ul>Why Join Us<ul><li>Work on real, large-scale data systems with direct business impact</li><li>High autonomy and meaningful technical ownership</li><li>Opportunity to influence architecture, standards, and best practices from the ground up</li></ul>Job Type: Full-timePay: From Rs150,000.00 per monthWork Location: In person

ClickHouse Cluster Engineer, Distributed Analytics Platforms

Information Tech Consultants

<div>
 
 🌟 Senior Data Scientist SME /
 
 Data Science SME (Subject matter expert)
 
 🧠
 
 
 
 
 
 
 Location : London (Relocation required - Sponsorship will be provided)
 
 
 
 
 Experience : 9-12 years
 
 
 
 
 CTC- 40-45 lacs
 
 
 
 
 
 
 We are seeking a highly accomplished and results-oriented
 
 Senior Data Scientist Subject Matter Expert (SME)
 
 with over
 
 10 years of experience
 
 to lead our advanced analytics and AI initiatives. This is a pivotal role requiring deep technical mastery across large-scale Big Data technologies, multi-cloud environments, and cutting-edge specialized AI domains, including
 
 Generative AI, Computer Vision, and Natural Language Processing (NLP)
 
 .
 
 
 You will be the principal technical leader, driving strategy, setting standards, and delivering high-impact solutions that transform business outcomes.
 
 
 
 
 
 Key Responsibilities
 
 
 
 
 <ul>
 <li>
 
 AI/ML Strategy &amp; Architecture:
 
 Define the technical roadmap and architectural standards for deploying and scaling complex AI systems, particularly those involving
 
 Generative AI (GenAI)
 
 , large language models (
 
 LLMs
 
 ), and specialized models in Computer Vision and NLP.
 </li>
 <li>
 
 Big Data Engineering:
 
 Design, build, and optimize high-throughput, distributed data pipelines and features using
 
 Apache Spark (Scala)
 
 and
 
 Hive
 
 on massive datasets to support model training and inference.
 </li>
 <li>
 
 Cross-Cloud Execution:
 
 Lead the design and deployment of ML models and data infrastructure across multiple major cloud providers (
 
 AWS, Azure, and GCP
 
 ), ensuring portability, scalability, and cost efficiency.
 </li>
 <li>
 
 Specialized Model Development:
 
 Lead hands-on development, fine-tuning, and deployment of production-grade models in key specialized areas:
 </li>
 <li>
 
 Computer Vision:
 
 Developing and optimizing models for image recognition, object detection, and video analytics.
 </li>
 <li>
 
 NLP:
 
 Building sophisticated systems for sentiment analysis, entity extraction, semantic search, and RAG architectures leveraging LLMs.
 </li>
 <li>
 
 Generative AI:
 
 Exploring and implementing cutting-edge GenAI techniques for content creation, data augmentation, and innovative product features.
 </li>
 <li>
 
 SME Consulting &amp; Mentorship:
 
 Act as the internal authority and consultant, providing technical guidance, architectural review, and mentorship to junior data scientists and engineering teams.
 </li>
 <li>
 
 MLOps &amp; Governance:
 
 Establish best practices for MLOps, model monitoring, version control, and model risk governance in a multi-cloud production environment.
 </li>
 </ul>
 
 
 
 
 Required Skills and Expertise (10+ Years)
 
 
 
 
 
 
 
 
 1. Big Data and Cloud Mastery
 
 
 
 
 <ul>
 <li>
 
 Programming &amp; Big Data:
 
 10+ years of extensive, hands-on experience with
 
 Apache Spark
 
 , with strong preference for production development using
 
 Scala
 
 . Deep expertise with
 
 Apache Hive
 
 for data querying and management.
 </li>
 <li>
 
 Cloud Proficiency:
 
 Demonstrated expertise in deploying and managing data/ML workloads across
 
 at least two
 
 of the three major cloud platforms:
 
 AWS
 
 (Sagemaker, EMR, S3),
 
 Azure
 
 (Azure ML, Synapse Analytics), and
 
 GCP
 
 (Vertex AI, BigQuery).
 </li>
 <li>
 
 Data Architecture:
 
 Expert knowledge of distributed systems, data partitioning, optimization techniques, and data warehousing concepts in a cloud-native context.
 </li>
 </ul>
 
 
 
 
 2. Advanced AI/ML Specialization
 
 
 
 
 <ul>
 <li>
 
 Generative AI (GenAI) &amp; LLMs:
 
 Proven experience with the architecture and implementation of Generative AI solutions, including prompt engineering, fine-tuning, and deploying
 
 Large Language Models (LLMs)
 
 .
 </li>
 <li>
 
 Computer Vision:
 
 In-depth knowledge of deep learning frameworks (TensorFlow, PyTorch) and experience with Computer Vision tasks (e.g., CNNs, object detection models like YOLO).
 </li>
 <li>
 
 NLP:
 
 Expert practical experience in NLP techniques, including transformer models, embedding generation, and building complex text-based applications.
 </li>
 </ul>
 
 
 
 
 3. Leadership &amp; Soft Skills
 
 
 
 
 <ul>
 <li>
 
 Technical Leadership:
 
 Proven track record of leading complex data science projects from research to production deployment.
 </li>
 <li>
 
 Communication:
 
 Exceptional ability to translate complex technical findings into clear, strategic recommendations for technical and executive audiences.
 </li>
 <li>
 
 Mentorship:
 
 Experience mentoring and training senior engineers and data scientists.
 </li>
 </ul>
 
 
 
 
 Education and Certification
 
 
 
 
 <ul>
 <li>
 Master&rsquo;s or Ph.D. in Computer Science, Data Science, Engineering, or a highly quantitative field.
 </li>
 <li>
 Relevant professional cloud certifications (e.g., AWS Certified Machine Learning Specialty, Google Cloud Professional Data Engineer) are highly desirable.
 </li>
 </ul>
 
 
</div>

Senior Data Scientist SME & AI

Convo

<div>
 
 Job Description
 
 
 
 Location: Islamabad, PK
 
 
 Work Model: Hybrid
 
 
 No. of Positions: 3
 
 
 
 About The Role
 
 
 
 We are seeking a
 
 Senior Software Development Engineer in Test (SDET)
 
 who brings a strong
 
 software engineering mindset
 
 and is passionate about building
 
 high-quality, scalable test systems
 
 for large-scale enterprise and distributed applications.
 
 
 This role is
 
 coding-intensive
 
 and focuses on designing and developing
 
 test infrastructure, automation frameworks, and quality tooling
 
 using
 
 JavaScript/TypeScript
 
 . You will work alongside software engineers to influence architecture, improve testability, and ensure quality is built into the system from day one.
 
 
 Manual testing is minimal and used only where automation is not feasible. The primary responsibility is to
 
 write production-grade test code
 
 , build automation platforms, and enable continuous quality at scale.
 
 
 
 Key Responsibilities
 
 
 
 <ul>
 <li>
 Design, develop, and own test automation frameworks and libraries using JavaScript/TypeScript and Playwright, following engineering best practices.
 </li>
 <li>
 Write clean, maintainable, and scalable code for functional, integration, API, and end-to-end testing.
 </li>
 <li>
 Build and evolve test infrastructure integrated into CI/CD pipelines, enabling fast, reliable feedback.
 </li>
 <li>
 Develop performance, load, and stress testing solutions using JMeter, k6, or Gatling, including custom scripts and metrics analysis.
 </li>
 <li>
 Collaborate with Software Engineers to improve system testability, define acceptance criteria, and validate architectural decisions.
 </li>
 <li>
 Analyze failures at scale, debug complex issues across UI, API, database, and backend services, and drive them to resolution.
 </li>
 <li>
 Design test strategies for microservices and distributed systems, including contract and integration testing.
 </li>
 <li>
 Own release quality metrics, automation coverage, and test execution health.
 </li>
 <li>
 Continuously improve tooling, frameworks, and engineering standards across the quality organization.
 </li>
 <li>
 Mentor junior SDETs and promote a software-engineering-driven quality culture.
 </li>
 <li>
 Participate in Agile ceremonies and contribute to sprint planning, stand-ups, and retrospectives.
 </li>
 <li>
 Drive continuous improvement in QA processes, tools, and automation best practices.
 </li>
 <li>
 Contribute to release readiness and support end-to-end quality initiatives across projects.
 
 
 </li>
 </ul>
 
 Requirements
 
 
 
 <ul>
 <li>
 5+ years of experience as an SDET / SET / Software Engineer in Test, with a strong focus on coding and automation architecture.
 </li>
 <li>
 Advanced proficiency in JavaScript/TypeScript, including async programming and modern tooling.
 </li>
 <li>
 Hands-on experience building automation frameworks from scratch using Playwright or similar modern frameworks.
 </li>
 <li>
 Strong understanding of software design patterns, test architecture, and clean code principles (SOLID, DRY).
 </li>
 <li>
 Experience designing and executing performance and scalability tests using JMeter, k6, or Gatling.
 </li>
 <li>
 Strong experience with SQL and backend validation, including data consistency and system workflows.
 </li>
 <li>
 Experience working in Agile, fast-paced engineering teams.
 </li>
 <li>
 Strong analytical, troubleshooting, and communication skills with excellent attention to detail.
 
 
 </li>
 </ul>
 
 Nice to Have
 
 
 
 <ul>
 <li>
 Experience with API testing tools (Postman, REST Assured, etc.).
 </li>
 <li>
 Familiarity with CI/CD tools (Azure DevOps, Jenkins, GitHub Actions).
 </li>
 <li>
 Exposure to cloud environments (AWS, Azure, or GCP).
 </li>
 <li>
 Knowledge of microservices and distributed architectures.
 </li>
 <li>
 Experience mentoring or guiding QA engineers on automation or performance testing.
 
 
 </li>
 </ul>
 
 Why Join Us
 
 
 
 <ul>
 <li>
 Work on cutting-edge enterprise solutions that drive collaboration and scalability.
 </li>
 <li>
 Influence test automation architecture and overall quality strategy.
 </li>
 <li>
 Be part of a forward-thinking, collaborative QA culture focused on excellence.
 </li>
 <li>
 Competitive compensation and professional growth opportunities.
 
 
 </li>
 </ul>
 
 What We Have For You
 
 
 
 We offer a comprehensive compensation package along with medical benefits for you and your family. Enjoy free lunch, annual performance-based increments, annual bonus, and performance recognition awards in a lean and agile work culture that encourages growth and collaboration.
 
 
 At Convo, we proudly embrace diversity and are committed to building an inclusive team of talented and unique individuals.
</div>

Senior Software Development Engineer in Test (SDET)

convo

<div>Job Description 
Location: Islamabad, PK
Work Model: Hybrid
No. of Positions: 3 
About the Role
We are seeking a Senior Software Development Engineer in Test (SDET) who brings a strong software engineering mindset and is passionate about building high-quality, scalable test systems for large-scale enterprise and distributed applications.
This role is coding-intensive and focuses on designing and developing test infrastructure, automation frameworks, and quality tooling using JavaScript/TypeScript. You will work alongside software engineers to influence architecture, improve testability, and ensure quality is built into the system from day one.
Manual testing is minimal and used only where automation is not feasible. The primary responsibility is to write production-grade test code, build automation platforms, and enable continuous quality at scale. 
Key Responsibilities<ul><li>
Design, develop, and own test automation frameworks and libraries using JavaScript/TypeScript and Playwright, following engineering best practices.</li><li>
Write clean, maintainable, and scalable code for functional, integration, API, and end-to-end testing.</li><li>
Build and evolve test infrastructure integrated into CI/CD pipelines, enabling fast, reliable feedback.</li><li>
Develop performance, load, and stress testing solutions using JMeter, k6, or Gatling, including custom scripts and metrics analysis.</li><li>
Collaborate with Software Engineers to improve system testability, define acceptance criteria, and validate architectural decisions.</li><li>
Analyze failures at scale, debug complex issues across UI, API, database, and backend services, and drive them to resolution.</li><li>
Design test strategies for microservices and distributed systems, including contract and integration testing.</li><li>
Own release quality metrics, automation coverage, and test execution health.</li><li>
Continuously improve tooling, frameworks, and engineering standards across the quality organization.</li><li>
Mentor junior SDETs and promote a software-engineering-driven quality culture.</li><li>
Participate in Agile ceremonies and contribute to sprint planning, stand-ups, and retrospectives.</li><li>
Drive continuous improvement in QA processes, tools, and automation best practices.</li><li>
Contribute to release readiness and support end-to-end quality initiatives across projects.</li></ul>
Requirements<ul><li>
5+ years of experience as an SDET / SET / Software Engineer in Test, with a strong focus on coding and automation architecture.</li><li>
Advanced proficiency in JavaScript/TypeScript, including async programming and modern tooling.</li><li>
Hands-on experience building automation frameworks from scratch using Playwright or similar modern frameworks.</li><li>
Strong understanding of software design patterns, test architecture, and clean code principles (SOLID, DRY).</li><li>
Experience designing and executing performance and scalability tests using JMeter, k6, or Gatling.</li><li>
Strong experience with SQL and backend validation, including data consistency and system workflows.</li><li>
Experience working in Agile, fast-paced engineering teams.</li><li>
Strong analytical, troubleshooting, and communication skills with excellent attention to detail.</li></ul>
Nice to Have<ul><li>
Experience with API testing tools (Postman, REST Assured, etc.).</li><li>
Familiarity with CI/CD tools (Azure DevOps, Jenkins, GitHub Actions).</li><li>
Exposure to cloud environments (AWS, Azure, or GCP).</li><li>
Knowledge of microservices and distributed architectures.</li><li>
Experience mentoring or guiding QA engineers on automation or performance testing.</li></ul>
Why Join Us<ul><li>
Work on cutting-edge enterprise solutions that drive collaboration and scalability.</li><li>
Influence test automation architecture and overall quality strategy.</li><li>
Be part of a forward-thinking, collaborative QA culture focused on excellence.</li><li>
Competitive compensation and professional growth opportunities.</li></ul> 
What We Have For You
We offer a comprehensive compensation package along with medical benefits for you and your family. Enjoy free lunch, annual performance-based increments, annual bonus, and performance recognition awards in a lean and agile work culture that encourages growth and collaboration. 
At Convo, we proudly embrace diversity and are committed to building an inclusive team of talented and unique individuals.</div>

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>

Explore 339+ Clickhouse cluster engineer distributed analytics platforms in Islamabad this January. Find roles across top companies and apply now to boost your career.

339 clickhouse cluster engineer distributed analytics platforms jobs IN Islamabad

ClickHouse Cluster Engineer, Distributed Analytics Platforms

Senior Data Scientist SME & AI

Senior Software Development Engineer in Test (SDET)

Senior Software Development Engineer in Test (SDET)

SQL DBA Expert - Optimization & Tuning

SQL DBA Expert - Optimization & Tuning

SQL DBA Expert - Optimization & Tuning