Founded in Montreal, Avanquest is the software publishing subsidiary of Claranova, a French group of innovative technological solutions, established in many countries, with revenues exceeding $500 million.
13 вересня 2022

Middle DB Engineer (вакансія неактивна)

віддалено

Необхідні навички

— 2+ years of experience with DBMS MS SQL Server;
— Strong knowledge of T-SQL;
— Understanding the principles of OLTP-system construction;
— Experience with building ETL-processes;
— Good performance of SQL-queries;
— Experience with SSMS, MS Visual Studio, MS SQL Profiler.

Common skills:

— Ability to work in a team;
— Ability to work with someone else’s code;
— English level: Intermediate or higher;
— Code testing skills.

Буде плюсом

— Experience with Data Warehouses;
— Experience with large volumes of data;
— Experience with Tableau or Power BI;
— Experience with cubes;
— Experience with MS Visio / UML;
— Experience with XML and JSON.

Пропонуємо

— Product company with a long-term and clear vision;
— Competitive salary and professional growth;
— High talented team and friendly working environment;
— Flexible work schedule and opportunity to work remotely;
— Paid English classes, courses, workshops or seminars;
— Regular team buildings, corporate and team activities;
— Referral program.

Обов’язки

— Database architecture development, creation, and modification of existing business logic of Database, preparation of data for analysis and reports;
— Database normalization, indexation, and optimization;
— Writing triggers, stored procedures, and functions, the ability to analyze query plans, testing code;
— Working with data arrays, extracting, transforming, and loading data;
— Development and maintenance of query execution to the linked servers;
— Technical documentation development and implementation.