Database Engineer

Axelon Services Corporation; Montreal; Hybrid; CAD 60,000 - 100,000; Full time

Job summary

An established industry player is seeking a skilled Database Engineer to join their dynamic team. In this role, you'll manage and develop databases across various business lines, ensuring stability, scalability, and performance. You'll work closely with IT partners to analyze business requirements and deliver innovative solutions using agile methodologies. This position offers the opportunity to enhance your skills in database development, performance tuning, and application support while collaborating with talented professionals in a supportive environment. If you're passionate about database technologies and eager to make an impact, this role is perfect for you.

Qualifications

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

Responsibilities

• Database Infrastructure Engineering for stability and scalability.
• Plan and execute database schema changes and performance improvements.
• Develop applications across different database environments.

Skills

DB2 Linux

Sybase

Perl

Python

Unix / K-Shell

Database Performance Tuning

SQL Development

Education

Graduate degree in Computer Science

Information Systems

Tools

Business Objects

Qlikview

Tableau

CI/CD tools

Job description

Job Title: Database Engineer
Experience Level: Level 2 (intermediate): 2-5 years
Open positions: 1

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

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 and Tableau) to enable end user data analysis. Ownership includes database modeling, physical database design, SQL development, capacity planning, performance tuning, database maintenance and ETL pipelines.

The Datamarts Analytics team is looking for talented data engineers to join our global team of highly technical individuals who manage many databases that include Big Data volumes. We deliver multiple projects for multiple business areas in parallel. The business owners and subject matter experts are globally distributed, making strong communication skills important to the position. The candidate will be expected to work closely with our IT partners in analyzing and delivering on business requirements. Development will utilize an agile methodology, which is based on scrum (time boxing, daily scrum meetings, retrospectives, etc), and XP (continuous integration, refactoring, unit testing etc.) best practices. Candidates must therefore be able to work collaboratively, demonstrate good ownership and be able to work well in teams. Work will include designing, enhancing and developing applications across different database environments.

The job will involve considering all aspects of the project life cycle and includes proof-of-concept evaluations, coding, designing, testing, implementing, deploying, and continued support of project releases as well as on-call Level 3 support. Collaboration with the firm’s engineering teams is expected.

Major Role & Responsibilities:

• Database Infrastructure Engineering for stability, scalability and capacity planning.
• Application DBA functions: plan & execute database schema changes, bottleneck analysis, outage prevention/resolution, server/database performance improvements, database maintenance, database recovery, etc.
• Database development (stored procedures, ETL, tools) and queries/stored procedures review and optimization.
• Enforce database security, standards & guidelines.

Technical Skills Requirement:

• 3-5 years of experience with relational databases - especially with DB2 Linux or Sybase
• Scripting on linux platforms in languages such as Perl/Python and Unix / K-Shell
• Strong knowledge base of relational database performance and tuning such as: proper use of indices, database statistics/reorgs, de-normalization concepts, memory management, database configurations, etc.
• Create high quality and optimized stored procedures and queries

Skills Desired:

• Knowledge of other databases like Greenplum is a big plus
• Familiarity with Datalakes
• Finance domain background is a plus.
• Familiarity with CI/CD tools
• Graduate degree in Computer Science, Information System or equivalent field

Personal skills:

• Integrity & ownership, good team player
• Ability to work under time and resource dependencies and constraints
• Ability to find simple and effective solutions
• High motivation to expand technical and business knowledge

*** is an equal opportunities employer. We work to provide a supportive and inclusive environment where all individuals can maximize their full potential.