Database Administrator - Saint-Bruno-de-Montarville, Canada - ISAAC Instruments

ISAAC Instruments

Verified Company

Saint-Bruno-de-Montarville, Canada

2 weeks ago

Posted by:

Sophia Lee

beBee Recruiter

Description

Company Description

ISAAC partners with North American fleets to provide a user-friendly solution that simplifies trucking. Focused 100% on the trucking industry, we help carriers overcome challenges, while boosting driver happiness.

With proven system reliability and system integration capabilities driven by our open platform, our solution helps your drivers and back-office team work smoothly.

Job Description:

Our cloud-based platform combines enterprise communications such as video, mobility, collaboration, and messaging.

This is your opportunity to join an exciting business that is poised to experience significant growth. You will work closely with the Cloud team, the IT, and the DBA.

Responsibilities

Assess and develop longterm strategic goals for production databases
Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure adequate protection and integrity of data assets
Gather requirements and translate them into data distribution and utilization needs; design databases meeting specifications addressing content management, content indexing, reporting, and workflow requirements
Plan and coordinate data migrations between systems
Develop, implement, and maintain change control and testing processes for modifications to databases
Design, implement and maintain cloudbased database systems when required.
Provide timely responses and resolution towards database backup, restore, mirroring, and synchronization requests
Assist the development team in the optimization of queries and scripts
Other duties as assigned to meet the requirements of the position.

Qualifications:

Bachelor's degree in computer science, information systems or related certifications
Expert understanding of concepts of High Availability and Disaster Recovery with respect to database systems
Strong experience with SQL 2016 or newer version
Knowledge of implementation, configuration, and management of high availability SQL clusters
Strong understanding of cloud database technologies (Microsoft Azure, Amazon Web Services, etc.)
Ability to document processes and procedures, including technical diagrams towards organizational data flow
Able to interact positively and with tact with all levels and be a good team player
Able to make decisions and remain calm while under pressure particularly when dealing with difficult situations
Experience with Postgres, timeseries databases, or other NoSQL databases
Full proficiency in French and English.

Asset

Knowledge about ETL (Extract, transform, load process) process
Experience of working with databricks, azure data platform tools, azure data factory
Experience of data modelling, data model optimization, SQL query optimization to support big data processing.

Additional Information

Collaborators are at the center of ISAAC's interests and values.

This explains the numerous benefits of working at ISAAC, namely:

- varied career opportunities
- a stimulating work environment focused on innovation
- enthusiastic and collaborative teams
- competitive salaries and benefits promoting work-life balance: a complete group insurance plan, group RRSP, an EAP, flexible hours, 4 weeks of vacation, etc.
- various social activities and free snacks and coffee every day.