SQL programmer

Introduction

Are you looking for a new professional challenge?
SQL development no longer holds any secrets for you?
Do you want to join a company that combines high standards, performance and kindness?
So take 5 minutes to read this ad, your future may be at the bottom of this offer!
First of all, let me introduce myself, I am Earvin from the Fed IT recruitment firm in Canada.
My job? Create meaningful professional meetings every day!
Today, I am recruiting for one of my great clients located in Mirabel, a SQL programmer with minimum 5 years of experience. The position is temporary with the possibility of becoming permanent, on-site mode for the first month and in hybrid mode thereafter.

Mission

- Design and develop complex SQL queries, including stored procedures, functions, and views.
- Develop relational and dimensional data models adapted to the specific needs of projects.
- Collaborate closely with application developers and clients throughout the development cycle: identification of needs, definition of architecture, design of tables, implementation and feedback with the client.
- Develop the database elements necessary to meet the requirements of software applications and operational and industrial systems.
- Guarantee the integrity and availability of data.
- Design and implement local and Cloud data structures for several sites (Datawarehouses/Data Lakes).
- Ensure maintenance, updates, backup, optimization and troubleshooting of existing database systems (SQL Server).
- Rigorously apply the security policies established by the Safran group.
- Write and maintain documentation that complies with corporate standards.
- Integrate agile project management principles into development processes.
- Actively contribute to the multisite R&T project with a view to setting up a data structure allowing the integration of artificial intelligence solutions.
- Support the acquisition of new software as well as the associated data architecture.
- Participate in the drafting of budget requests for the acquisition of hardware and software.

Your profile

- Hold a bachelor's degree or college diploma in software engineering, computer science or an equivalent field.
- Proof of significant experience in a position with similar responsibilities.
- Excellent command of MS-SQL Server functionalities (functions, views, stored procedures, etc.).
- Solid mastery of SQL Server suite tools (SSIS, SSAS, SSRS, etc.).
- Expertise in ETL processes (SSIS and/or Talend).
- Proven skill in the configuration and maintenance of SQL servers (management of alerts, disk space, blockages, configuration, resolution of job errors, etc.).
- Experience with AWS cloud technologies, including Redshift.
- Knowledge of reporting tools such as Power BI and Crystal Reports.
- Mastery of version management tools, in particular Git.
- Knowledge of the C# language and the Entity Framework.
- Experience developing C# APIs in an ASP.NET Core environment (asset).
- Familiarity with Typescript, Javascript, HTML5 and CSS languages.
- Good understanding of object-oriented programming concepts.
- Knowledge of PowerShell scripts.
- Familiarity with business systems (MES, LIMS, MRP, ERP, etc.).
- Knowledge of SSL certificates.
- Bilingualism in French and English, both oral and written.

Other openings that may pick your interest