About the role

Database Developer designing and maintaining database systems for a global financial services firm. Responsibilities include database optimization, data integration, and collaboration with stakeholders in Montreal.

Responsibilities

Design and implement logical and physical data models to support business requirements
Develop, optimize, and maintain database schemas, tables, views, and stored procedures
Collaborate with stakeholders to gather and analyze data requirements
Ensure database performance through query optimization and indexing strategies
Implement and maintain ETL processes for data integration and transformation
Perform data profiling, cleansing, and validation to ensure data quality
Monitor and troubleshoot database performance, availability, and security
Work with development teams to integrate databases with applications
Document database designs, data dictionaries, and processes

5+ years of strong hands-on work experience with relational databases (e.g., DB2, PostgreSQL)
Proficiency in SQL and database programming (e.g., stored procedures, triggers)
Expertise in data modelling tools (e.g., ERwin, PowerDesigner, or similar)
Knowledge of ETL tools (e.g., Informatica, Talend, SSIS) is preferrable
Strong understanding of normalization, de-normalization, and database design principles
Experience with performance tuning and query optimization
Knowledge of data warehousing concepts and star schema design
Understanding and implementing job schedules, dependencies, and workflows (e.g. Autosys)
Excellent problem-solving and communication skills