Database Performance Engineer - Toronto - Astra North Infoteck Inc.

    Astra North Infoteck Inc.
    Astra North Infoteck Inc. Toronto

    1 day ago

    Description

    Role Overview

    Strong expertise in enterprise database performance tuning across mainframe and cloud environments. The ideal candidate will have deep knowledge of SQL optimization, workload management, concurrency handling, and high-throughput system stabilization.

    Key Responsibilities

    • Perform database engineering and performance tuning across large-scale enterprise systems.

    • Optimize SQL queries and analyze execution plans using tools such as:

      • EXPLAIN

      • Query Store

      • AWR / ASH

      • DB2 Visual Explain

    • Work with mainframe data technologies including:

      • DB2 for z/OS

      • IMS DB

      • VSAM

      • Knowledge of JCL/COBOL for understanding data-access patterns (preferred)

    • Manage and tune AWS database services including:

      • AWS RDS (MySQL, PostgreSQL, SQL Server, Oracle)

      • Redshift

      • Athena

      • Glue

      • S3

    • Configure and optimize:

      • Workload Management (WLM)

      • Distribution and sort keys

      • Partitioning strategies

      • Compression techniques

    • Improve high-throughput workloads (>1000 TPS), reduce query latency, and stabilize peak-hour performance.

    • Design and manage:

      • Indexing strategies

      • Statistics collection

      • Partitioning models

      • Locking and concurrency control (deadlocks, isolation levels)

    • Apply data modeling best practices, including:

      • OLTP vs. OLAP design considerations

      • Normalization and denormalization trade-offs

    • Utilize Linux and mainframe utilities for performance diagnostics.

    • Develop automation scripts using Python or Shell scripting.

    • Collaborate with stakeholders and communicate performance insights effectively.

    Required Skills

    • Data Concepts & Data Modelling

    • Python for Data Science

    • MySQL

    • Statistics & Analytics

    • SQL Performance Tuning

    • AWS Data Services (RDS, Redshift, Athena, Glue, S3)

    • Mainframe Database Technologies (DB2 z/OS, IMS, VSAM)

    Experience Required

    6–8 Years


  • Work in company

    Performance Engineer

    Only for registered members

    + · Permettre aux systèmes/dapplications de fournir une gamme large de soutien / recherche et analyse, · +Fournir un support efficace jour le jour aux applications/systèmes via l’identification précise des problèmes · & la résolution rapide des incidents. · ...

    Toronto $65,600 - $98,400 (CAD)

    1 month ago

  • Work in company

    Performance Engineer

    Only for registered members

    We are looking for a Performance Engineer with 8-10 years of experience in LoadRunner JMeter. · Resiliency testing · Disaster recovery testing · ...

    Toronto, ON

    1 week ago

  • Work in company

    Performance Engineer

    Only for registered members

    Tata Consultancy Services (TCS) is an equal opportunity employer, embracing diversity in race, nationality, ethnicity, gender, age, physical ability and sexual orientation. · ...

    Toronto, Ontario

    3 weeks ago

  • Work in company

    Performance Engineer

    Only for registered members

    This is a performance engineer role that involves performance testing using JMeter and Load Runner. · ...

    Toronto, Ontario

    3 weeks ago

  • Work in company

    Performance Engineering

    Only for registered members

    Inclusion without Exception: Tata Consultancy Services (TCS) is an equal opportunity employer and embraces diversity in race, nationality, ethnicity, gender... · Minimum years of experience in Performance TestingProficiency in Load runner with hands-on scripting experience. · ...

    Toronto, Ontario

    1 month ago

  • Work in company

    Performance Engineer

    Only for registered members

    Performance Engineer · Location – GTA, 4 days / week in office Toronto downtown – no exceptions · 6+Months · Must Have: · Need a lead level resource who is self-starter and can work independently. · Strong hands-on knowledge of · LoadRunner tool (scripting and analysis), Dynatrac ...

    Greater Toronto Area

    1 week ago

  • Work in company

    Performance Engineer

    Only for registered members

    Cerebras Systems builds the world's largest AI chip, 56 times larger than GPUs. Our novel wafer-scale architecture provides the AI compute power of dozens of GPUs on a single chip, · ...

    Toronto, Ontario, Canada

    3 weeks ago

  • Work in company

    Performance Engineer

    Only for registered members

    Role Name: Performance Test Lead · Location: 4 Days onsite - Toronto · Contract: Long Term · Required Experience: · • 12+ years in IT and Financial Services with a strong focus on Performance Engineering and Testing. · • 10+ years designing and implementing Performance Test Strat ...

    Toronto, Ontario

    1 week ago

  • Work in company

    Performance Engineer

    Only for registered members

    Proven experience in performance testing with strong understanding of performance testing tools and methodologies. · ...

    Toronto, Ontario

    2 weeks ago

  • Work in company

    Performance Engineer

    Only for registered members

    We are seeking a Performance Testing professional with over 5 years of hands-on experience. · The ideal candidate will have strong expertise in performance testing tools such as JMeter and LoadRunner, along with a solid understanding of workload modeling.Familiarity with Performa ...

    Toronto, Ontario

    1 month ago

  • Work in company

    Performance Engineer

    Only for registered members

    Job Summary · We are seeking an experienced Performance Engineer with strong hands-on expertise in Apache JMeter and Micro Focus LoadRunner to design, execute, and analyze performance tests for enterprise-grade applications. The ideal candidate will be responsible for ensuring sy ...

    Toronto

    1 week ago

  • Work in company

    Performance Engineer

    Only for registered members

    Tata Consultancy Services (TCS) is an equal opportunity employer, · Inclusion without Exception: · Our continued commitment to Culture and Diversity is reflected in our people stories across our workforce, · About TCS: · TCS is an IT services, consulting, and business solutions o ...

    Toronto $90,000 - $120,000 (CAD)

    3 weeks ago

  • Work in company

    Performance Engineer-3

    Only for registered members

    Toronto, Ontario M5V 3L9 Posted February 24th, 2026 · Looking for more job opportunities? Click here · Job Type: Full Time · Job Category: IT · Job Description · Performance Engineer · Toronto, ON - Onsite · "Total Experience: 8-10 years · Required Skill Set: · 10 years of hand ...

    Toronto, ON

    1 week ago

  • Work in company

    Performance Engineer-5

    Only for registered members

    Toronto, Ontario M5V 3L9 Posted February 26th, 2026 · Looking for more job opportunities? Click here · Job Type: Full Time · Job Category: IT · Job Description · Performance Engineer · Toronto, ON - Onsite · "Total Experience: 8-10 years · Required Skill Set: · 10 years of hand ...

    Toronto, ON

    5 days ago

  • Work in company

    Performance Engineer-1

    Only for registered members

    Toronto, Ontario M5V 3L9 Posted February 20th, 2026 · Looking for more job opportunities? Click here · Job Type: Full Time · Job Category: IT · Job Description · Performance Engineer · Toronto, ON - Onsite · "Total Experience: 8-10 years · Required Skill Set: · 10 years of hand ...

    Toronto, ON

    1 week ago

  • Work in company

    Performance Engineer

    Only for registered members

    Performance Engineer · Location – GTA, 4 days / week in office Toronto downtown – no exceptions · 6+Months · Must Have: · Need a lead level resource who is self-starter and can work independently. · Strong hands-on knowledge of LoadRunner tool (scripting and analysis), Dynatrace ...

    Toronto

    1 week ago

  • Work in company

    Performance Engineer

    Only for registered members

    Performance Testing using JMeter Load Runner and Workload Model · More than 5 years of experience in Performance Testing. · ...

    Toronto

    3 weeks ago

  • Work in company

    Performance Engineer

    Only for registered members

    Cerebras Systems builds the world's largest AI chip, · 56 times larger than GPUs. · Build performance models (kernel-level, · end-to-end) to estimate the performance of state of the art and customer ML models. · ...

    Toronto Full time

    1 month ago

  • Work in company

    Performance Engineer-4

    Only for registered members

    Toronto, Ontario M5V 3L9 Posted February 25th, 2026 · Looking for more job opportunities? Click here · Job Type: Full Time · Job Category: IT · Job Description · Performance Engineer · Toronto, ON - Onsite · "Total Experience: 8-10 years · Required Skill Set: · 10 years of hand ...

    Toronto, ON

    6 days ago

  • Work in company

    Performance Engineer-2

    Only for registered members

    Toronto, Ontario M5V 3L9 Posted February 21st, 2026 · Looking for more job opportunities? Click here · Job Type: Full Time · Job Category: IT · Job Description · Performance Engineer · Toronto, ON - Onsite · "Total Experience: 8-10 years · Required Skill Set: · 10 years of hand ...

    Toronto, ON

    1 week ago

  • Work in company

    Performance Engineer

    Only for registered members

    Role Name: Performance Test Lead · Location: 4 Days onsite - Toronto · Contract: Long Term · Required Experience: · • 12+ years in IT and Financial Services with a strong focus on Performance Engineering and Testing. · • 10+ years designing and implementing Performance Test Strat ...

    Toronto

    1 week ago

Jobs
>
Toronto