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.
Aujourd'hui, je recrute pour un de mes beaux clients situé à Mirabel, un programmeur SQL avec minimum 5 ans d'expérience. Le poste est temporaire avec possibilité de passer permanent, mode sur site pendant le premier mois et en mode hybride par la suite.
- 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.
Use of English is required for this position for the following reasons :
Communication with international clients : As some of our clients are based abroad, you will be required to communicate regularly with them in English, both orally and in writing.Collaboration with English-speaking partners : You will need to collaborate with English-speaking suppliers and partners for order tracking and contract management.Writing documents in English : You will be responsible for writing reports, proposals or contracts in English for our international clients.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.