SQL programmer

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.

Location: Sainte-Marthe-sur-le-Lac, CA

Posted Date: 11/5/2024