Database Performance Engineer – DB2 - Toronto - Astra North Infoteck Inc.

    Astra North Infoteck Inc.
    Astra North Infoteck Inc. Toronto

    18 hours ago

    Description

    Database Performance Engineer – DB2 & Cloud (AWS RDS, Redshift, Athena)

    Role Overview:
    We are seeking a Database Performance Engineer with 8–10 years of experience in database engineering and performance tuning across enterprise systems. The ideal candidate will have deep expertise in SQL optimization, query plan analysis, and hybrid mainframe-cloud database environments.

    Key Responsibilities:

    • Perform SQL query optimization and analyze execution plans using tools such as EXPLAIN, Query Store, AWRASH, DB2 Visual Explain.
    • Work hands-on with Mainframe data technologies: DB2 for z/OS, IMS DB, VSAM. Knowledge of JCL/COBOL for data access patterns is a plus.
    • Design, implement, and tune AWS database services: RDS (MySQL, PostgreSQL, SQL Server, Oracle), Redshift, Athena, Glue, S3. Optimize tuning parameters, WLM, keys, partitions, compression, and throughput.
    • Improve high-throughput workloads TPS), reduce query latency, and stabilize performance during peak hours.
    • Expertise in index design, statistics management, partitioning, and locking/concurrency issues (deadlocks, isolation levels).
    • Provide guidance on data modeling strategies (OLTP vs OLAP) and normalization/denormalization trade-offs for performance.
    • Utilize Linux and mainframe utilities for performance diagnostics. Automate processes with Python or Shell scripting.
    • Collaborate with stakeholders and communicate complex database performance findings clearly to technical and non-technical audiences.

    Required Skills:

    • SQL optimization and query plan analysis (EXPLAIN, Query Store, AWRASH, DB2 Visual Explain)
    • DB2 for z/OS, IMS DB, VSAM, JCL/COBOL (preferred)
    • AWS RDS (MySQL, PostgreSQL, SQL Server, Oracle), Redshift, Athena, Glue, S3
    • Database tuning parameters, WLM, partitioning, compression, keys
    • Index design, statistics management, locking/concurrency (deadlocks, isolation levels)
    • Data modeling (OLTP vs OLAP), normalization/denormalization
    • Linux and mainframe utilities, Python/Shell scripting for automation
    • Strong communication and stakeholder management

    Preferred Qualifications:

    • Proven experience improving high-throughput workloads TPS)
    • Track record of reducing query latency and stabilizing peak-hour performance
    • Experience in hybrid mainframe + cloud database environments


  • 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

    Cerebras Systems builds the world's largest AI chip. · ...

    Toronto, Ontario, Canada

    2 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. 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

    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

    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

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

    Toronto, Ontario

    3 weeks 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 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

    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. · Focus on CPU and memory subsystem optimizations for our Runtime software driver, · enabling faste ...

    Toronto, Ontario, Canada

    2 weeks 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

    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

    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

    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

    Only for registered members

    Veeva Systems is a mission-driven organization and pioneer in industry cloud, helping life sciences companies bring therapies to patients faster. As one of the fastest-growing SaaS companies in history, we surpassed $2B in revenue in our last fiscal year with extensive growth pot ...

    Toronto $100,000 - $150,000 (CAD)

    5 days 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

    Design and execute performance testing strategies for PeopleSoft and Mainframe systems to ensure optimal system performance under varying workloads. · ...

    Toronto

    3 weeks 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-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

Jobs
>
Toronto