Description
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.
