Database Engineer

Compunnel Inc.; Montreal; Hybrid; CAD 60,000 - 100,000; Full time

Job summary

An innovative firm is seeking talented data engineers to join a global team managing extensive databases, including Big Data volumes. This role involves designing and developing applications across various database environments while collaborating with IT partners to meet business requirements. Candidates should have a strong foundation in relational databases, particularly DB2 and Sybase, and possess scripting skills in Perl or Python. This is an exciting opportunity to work in a dynamic environment that emphasizes effective communication and agile methodologies, making a significant impact on data management and analytics.

Qualifications

• 3-5 years experience with relational databases, especially DB2 Linux or Sybase.
• Strong knowledge of database performance tuning and ability to create optimized stored procedures.

Responsibilities

• Database infrastructure engineering for stability, scalability, and capacity planning.
• Database development including stored procedures, ETL, and tool creation.

Skills

DB2 Linux

Sybase

Perl

Python

Unix/K-Shell

Database Performance Tuning

Stored Procedures

ETL

CI/CD Tools

Education

Graduate degree in Computer Science

Graduate degree in Information Systems

Tools

Greenplum

Business Objects

Qlikview

Tableau

Job description

Get AI-powered advice on this job and more exclusive features.

Direct message the job poster from Compunnel Inc.

Experience Level: Level 2 (intermediate): 2-5 years

Location: Montreal (Day 1 onboarding onsite / in office presence 3x week)

About the Department

The Internal Trade Activity and Reporting Applications (ITARA) department manages and develops databases and processes data across all divisions (ISG and MSWM) and business lines (FID, IED), including front office trading, reference, finance and risk data. The databases run on Sybase, DB2, KDb, Greenplum, Hadoop, and MongoDB technologies. ITARA owns several datamarts and business intelligence platforms (Business Objects, Qlikview, Tableau) to enable end user data analysis. Responsibilities include database modeling, physical database design, SQL development, capacity planning, performance tuning, database maintenance, and ETL pipelines.

Role Overview

The Datamarts Analytics team seeks talented data engineers to join our global, highly technical team managing extensive databases, including Big Data volumes. We work on multiple projects across various business areas simultaneously. Effective communication with globally distributed business owners and subject matter experts is essential. The candidate will collaborate closely with IT partners to analyze and deliver on business requirements. Development follows agile methodologies, including Scrum and XP practices. The role involves designing, enhancing, and developing applications across different database environments.

Responsibilities

1. Database infrastructure engineering for stability, scalability, and capacity planning.
2. Database development, including stored procedures, ETL, and tool creation, as well as review and optimization of queries and stored procedures.

Technical Skills and Qualifications

• 3-5 years of experience with relational databases, especially DB2 Linux or Sybase.
• Scripting on Linux platforms using Perl/Python and Unix/K-Shell.
• Strong knowledge of relational database performance tuning—indices, database statistics, reorganization, de-normalization, memory management, configurations.
• Ability to create high-quality, optimized stored procedures and queries.
• Experience with Greenplum or familiarity with Datalakes is a plus.
• Knowledge of finance domain is a plus.
• Familiarity with CI/CD tools.
• Graduate degree in Computer Science, Information Systems, or a related field.

Personal Skills

• Integrity and ownership, good teamwork skills.
• Ability to work under time/resource constraints.
• Problem-solving skills to find simple, effective solutions.
• Motivation to expand technical and business knowledge.

Additional Details

• Seniority level: Mid-Senior level
• Employment type: Contract
• Job function: Information Technology

Referrals can double your chances of interviewing at Compunnel Inc. and you can get notified about new Database Engineer jobs in Montreal, Quebec, Canada.