Talent.com
SQL programmer

SQL programmer

Fed GroupCanada, Québec, Mirabel
5 days ago
Salary
CA$80,000.00–CA$110,000.00 yearly
Job type
  • Full-time
Job 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.