Data Engineer - Montreal

Job Description

Note : This position does not offer any visa sponsorship. We are looking for applicants who are already living in Canada.

Our client is seeking for talented Data Engineers to design, build, and maintain the backbone of our data infrastructure, ensuring it is reliable, scalable, and optimized for performance.

Job Summary :

As a Data Engineer, you will be responsible for the architecture, development, and maintenance of database systems that support our applications and services.

You will work closely with software engineers, data analysts, and DevOps teams to ensure our databases are efficient, secure, and capable of handling large volumes of data.

Your role will also involve optimizing existing database structures, automating processes, and implementing best practices for data management.

Key Responsibilities :

• Design, develop, and optimize database architectures to meet the performance, scalability, and security needs of our applications.
• Implement and maintain database schemas, tables, views, indexes, and stored procedures.
• Collaborate with software development teams to design data models that support application requirements.
• Ensure data integrity and consistency across distributed systems and environments.
• Develop and implement strategies for database monitoring, performance tuning, and capacity planning.
• Automate routine database tasks, such as backups, performance monitoring, and disaster recovery processes.
• Work with DevOps teams to integrate database solutions into CI / CD pipelines and cloud environments.
• Manage and optimize database storage, indexing, and query performance.
• Implement and enforce database security policies, including access controls and encryption.
• Stay current with emerging database technologies, industry trends, and best practices.
• Troubleshoot and resolve complex database issues in production environments.

Qualifications :

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• 5+ years of experience in data engineering or a related role.
• Strong proficiency in SQL and experience with DBMS such as SQL Server, MySQL, PostgreSQL, or Oracle.
• Experience with database design, data modeling, and normalization techniques.
• Hands-on experience with database performance tuning, indexing, and query optimization.
• Familiarity with cloud-based database solutions (e.g., AWS RDS, Azure SQL Database) and their associated services.
• Proficiency in scripting languages (e.g., Python, Shell, PowerShell) for database automation.
• Knowledge of database security practices, including encryption and access control mechanisms.
• Strong problem-solving and analytical skills, with the ability to troubleshoot complex database issues.
• Excellent communication and collaboration skills, with the ability to work effectively in a team environment.

Preferred Qualifications :

• Experience with NoSQL databases (e.g., MongoDB, Cassandra).
• Familiarity with big data technologies (e.g., Hadoop, Spark) and data warehousing solutions.
• Experience with DevOps tools and practices related to database management.
• Relevant certifications (e.g., Microsoft Certified : Azure Database Engineer, Oracle Certified Professional).

Requirements

Qualifications : Bachelor’s degree in Computer Science, Information Technology, or a related field. 5+ years of experience as a Database Administrator, with a strong understanding of database architecture, management, and performance tuning.

Proficiency with one or more DBMS, such as SQL Server, Oracle, MySQL, or PostgreSQL. Experience with database backup, recovery, and security procedures.

Strong knowledge of SQL and experience with writing complex queries, stored procedures, and triggers. Familiarity with database design, normalization, and data modeling techniques.

Experience with database monitoring and performance tuning tools. Knowledge of scripting languages (e.g., Python, PowerShell) for automation tasks.

Strong problem-solving and analytical skills. Excellent communication and collaboration skills, with the ability to work effectively in a team environment.

Preferred Qualifications : Experience with cloud-based database solutions (e.g., AWS RDS, Azure SQL Database). Familiarity with DevOps practices and tools related to database management.

Relevant certifications (e.g., Microsoft Certified : Azure Database Administrator, Oracle DBA Certification). Experience with data warehousing, ETL processes, and big data technologies.