Fed IT
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.
Source ⇲
