Talent.com
Lorven Technologies Inc.
Lead Software Engineer with ClickHouse, Terraform - oshawaLorven Technologies Inc. • oshawa, on, ca
Lead Software Engineer with ClickHouse, Terraform - oshawa

Lead Software Engineer with ClickHouse, Terraform - oshawa

Lorven Technologies Inc. • oshawa, on, ca
1 day ago
Job type
  • Full-time
Job description

Hi

Role: Lead Software Engineer

Location: Canada- Remote

Working hours - PST time zone from 9 till 5 pm.

Skills: ClickHouse,Kubernetes, Terraform, Helm charts

Contract role


Job description:

What you’ll do

  • Lead the migration of large-scale logs and distributed traces from existing Analytics Database to ClickHouse
  • Design scalable ClickHouse schemas optimized for high-ingestion telemetry workloads
  • Architect ingestion pipelines for logs and trace data
  • Translate existing queries and data models into performant ClickHouse equivalents
  • Develop and execute backfill and cutover strategies to ensure seamless migration
  • Optimize query performance, partitioning, storage layout, and retention strategies
  • Benchmark and validate performance under production-scale workloads
  • Establish monitoring, alerting, and operational best practices for ClickHouse
  • Design and support alerting workflows powered by ClickHouse queries
  • Document architecture decisions, tuning approaches, and operational runbooks
  • Partner with platform and SRE teams to ensure production readiness


Responsibilities

  • ● Design and tune distributed ClickHouse clusters (sharding, replication, partitioning)
  • ● Configure and optimize MergeTree engines, TTL policies, indexing, and compression
  • ● Improve ingestion throughput and query latency at scale
  • ● Deploy and operate ClickHouse workloads in Kubernetes environments
  • ● Implement backup and restore strategies
  • ● Identify and resolve performance bottlenecks
  • ● Ensure reliability, scalability, and maintainability of the platform
  • ● Support security and production-readiness reviews


Basic Qualifications

  • ● 12+ years of experience in backend, infrastructure, or data platform engineering
  • ● Hands-on production experience with ClickHouse
  • ● Strong experience with Terraform and Helm charts
  • ● Experience deploying and operating stateful systems on Kubernetes
  • ● Strong understanding of distributed systems and high-throughput ingestion architectures
  • ● Experience designing schemas for large-scale analytical or telemetry workloads
  • ● Strong SQL skills and performance tuning expertise
  • ● Experience migrating data between large-scale analytical systems
  • ● Familiarity with at least one major cloud provider: Azure, GCP, or AWS



Email:

Create a job alert for this search

Lead Software Engineer with ClickHouse, Terraform - oshawa • oshawa, on, ca

Similar jobs

Technical Lead – Interoperability and Integration - oshawa

Randstad Digitaloshawa, on, ca
Full-time +1

Our Client has a new product called CarePath, based on artificial intelligence, for which they lack consultants.The need is also related to the Canadian-wide expansion of the existing LinX product,... Show more

 • Promoted • New!

Lead Principal Software Engineer - oshawa

Auxo | Growth Partneroshawa, on, ca
Full-time

SaaS products and platforms at scale.You’ll work closely with the Head of Product & Technology to shape technical direction across multiple teams.This is a high-impact IC role where you’ll influenc... Show more

 • Promoted

Software Engineer – Advanced Systems - oshawa

Draganfly Inc.oshawa, on, ca
Full-time

Company”) has been a recognized technology leader within the commercial UAV space for over two decades.We helped establish the commercial market & adoption of multi-rotor helicopters for public saf... Show more

 • Promoted

Remote Software Developer - oshawa

Turingoshawa, on, ca
Remote
Full-time

Based in San Francisco, California, Turing is the world’s leading research accelerator for frontier AI labs and a trusted partner for global enterprises deploying advanced AI systems.Turing support... Show more

 • Promoted • New!

Senior Data Engineer - oshawa

KPG99 INCoshawa, on, ca
Full-time

Role : Senior Data Engineer (Cloud).Top Must have: AWS / EKS ( Amazon Elastic Kubernetes Service) Spring Boot.Design and implement ingestion pipelines from multiple source systems into Snowflake us... Show more

 • Promoted • New!

Senior Analytics (AWS DBT) Engineer - oshawa

Mastech Digitaloshawa, on, ca
Full-time

We are seeking a Senior AWS DBT Engineer to play a critical role in transforming an existing analytics ecosystem into a modern, scalable Databricks + dbt architecture (Bronze → Silver → Gold).This ... Show more

 • Promoted

Senior API and Middleware Developer - oshawa

Coforgeoshawa, on, ca
Full-time

Job Title/Role: API Middleware Developer.We at Coforge are seeking a API Middleware Developer with the following skillset:.As a Senior API & Middleware Developer for the Platform Engineering team, ... Show more

 • Promoted

Sr AWS Cloud Engineer (Banking/Capital Markets) - oshawa

companyoshawa, on, ca
Full-time

Senior AWS Cloud Engineer / Sr AWS DevOps (10+ years of experience).Duration: 6mo (high change of extension).Location: Downtown Toronto or remore (within Canada only).AWS cloud infrastructure / pla... Show more

 • Promoted

Senior Java Software Engineer - oshawa

Luxoftoshawa, on, ca
Full-time

One of the world's largest providers of products and services to the energy industry has a need to develop and support enterprise information system in Oil & Gas domain.Product being developed is a... Show more

 • Promoted

Director of Microsoft Cloud and Cloud Solution Provider (CSP )Operations - oshawa

Buchanan Technologiesoshawa, on, ca
Full-time +1

Director of Microsoft Cloud & CSP Operations.Remote, anywhere in North America.The Director of Microsoft Cloud & CSP Operations is responsible for the day-to-day management and optimization of the ... Show more

 • Promoted

Principal AI Engineer - oshawa

Workerbeeoshawa, on, ca
Permanent

No C2C or third-party submissions.Workerbee connects workers with employers through trusted introductions.By joining Workerbee you can be matched for project-based, contract, or permanent opportuni... Show more

 • Promoted

Software Quality Assurance Engineer - oshawa

TEEMAoshawa, on, ca
Full-time

Software Quality Assurance Engineer/Lead.Duration: one (1) year with two (2) one-year optional renewal periods.A minimum of 2 years in tester/QA role executing test plans and test cases for Salesfo... Show more

 • Promoted • New!

Software Engineer – Advanced Systems - Draganfly Inc.

Draganfly Inc.oshawa, on, ca
Full-time

Company”) has been a recognized technology leader within the commercial UAV space for over two decades.We helped establish the commercial market & adoption of multi-rotor helicopters for public saf... Show more

 • Promoted

Lead Software Engineer with ClickHouse, Terraform - Lorven Technologies Inc.

Lorven Technologies Inc.oshawa, on, ca
Full-time

Working hours - PST time zone from 9 till 5 pm.Skills: ClickHouse,Kubernetes, Terraform, Helm charts.Lead the migration of large-scale logs and distributed traces from existing Analytics Database t... Show more

 • Promoted

DevOps Engineer (AI) - oshawa

Affinityoshawa, on, ca
Full-time

Client: Enterprise class EMR provider.On behalf of our client, Affinity is seeking a DevOps Engineer to build and evolve the infrastructure behind its flagship EMR platform.You’ll own Kubernetes-ba... Show more

 • Promoted

Developer/Analyst - oshawa

Navacordoshawa, on, ca
Full-time

Navacord is hiring technical talent in the insurance industry! We are accepting applications for a dynamic individual with 5+ years experience in a full stack development environment and with at le... Show more

 • Promoted

Sr AWS DBT Engineer - oshawa

Mastech Digitaloshawa, on, ca
Full-time

Design and implement robust dimensional and relational data models.Own transformation and modeling of curated (Silver/Gold) datasets.Collaborate with analysts, product analytics, data scientists, a... Show more

 • Promoted

Senior Java Software Engineer - oshawa

Rocket Financial Incoshawa, on, ca
Full-time

Senior Software Engineer (Java / AI-Enabled).Rocket Financial builds innovative fintech products that improve how money moves globally.You’ll play a key role in shaping systems, building scalable a... Show more