Database and Solution Architectfreelance.ca • Montreal, Canada

Database and Solution Architect

freelance.ca • Montreal, Canada

30+ days ago

Job type

Full-time

Job description

DATABASE AND SOLUTION ARCHITECT

INFORMATIONS CLÉS / KEY INFORMATION

Référence / Reference : 377590
Lieu / Location : Toronto, ON
Type d’emploi / Employment Type : Contrat (6 mois, renouvelable) / Contract (6 months, renewable)
Mode de travail / Work Mode : Hybride ou télétravail / Hybrid or Remote

RÉSUMÉ / SUMMARY

Professionnel polyvalent recherché en architecture de bases de données et de solutions, possédant une expertise complète en modélisation de données, développement SQL, administration et architecture de solutions distribuées.

A versatile database and solution architecture professional with expertise across data modeling, SQL development, database administration, and distributed data systems.

RESPONSABILITÉS / RESPONSIBILITIES

Concevoir des architectures de solutions de bout en bout intégrant bases de données, lacs de données et microservices.

Design scalable, end-to-end solution architectures integrating databases, data lakes, and microservices.

Construire et maintenir des modèles de données conceptuels, logiques et physiques pour des environnements OLTP et OLAP.

Build and maintain conceptual, logical, and physical data models for OLTP and OLAP environments.

Développer et optimiser des requêtes SQL, procédures stockées et vues.

Develop and optimize SQL queries, stored procedures, and views.

Mettre en œuvre des bases de données distribuées et des lacs de données (Iceberg, Parquet, moteurs de requêtes).

Architect and implement distributed databases and data lake solutions (Iceberg, Parquet, query engines).

Intégrer des composantes de bases de données aux applications Spring Boot et microservices, avec une gestion correcte des transactions et de la concurrence.

Integrate database components with Spring Boot and microservices, ensuring proper transaction isolation and concurrency control.

Effectuer des optimisations de performance, d’indexation et de partitionnement pour des systèmes distribués à grande échelle.

Perform performance tuning, indexing, partitioning, and query optimization for large-scale systems.

Administrer CockroachDB et PostgreSQL (installation, configuration, sauvegarde / reprise, reprise après sinistre).

Administer CockroachDB and PostgreSQL (installation, configuration, backup / recovery, DR).

PROFIL RECHERCHÉ / REQUIREMENTS

Expérience confirmée en développement de bases de données, modélisation, architecture de données, fonctions DBA et architecture de solutions.

Proven experience in database development, data modeling, data architecture, DBA functions, and solution architecture.

Maîtrise du SQL, CockroachDB, PostgreSQL.

Strong SQL, CockroachDB, PostgreSQL skills.

Solides compétences en optimisation de performance sur systèmes distribués.

Expertise in performance tuning for distributed and high-throughput systems.

Bonne compréhension de Java, Spring Boot et des niveaux d’isolation de transaction.

Understanding of microservices, Java, Spring Boot, and transaction isolation.

Connaissance des meilleures pratiques ETL, d’entreposage et d’intégration de données.

Knowledge of ETL, data warehousing, and data integration best practices.

COMPÉTENCES TECHNIQUES / TECHNICAL SKILLS

Expérience Cloud (IBM Cloud, AWS, GCP, Azure) et OpenShift.

Cloud experience (IBM Cloud, AWS, GCP, Azure) and OpenShift.

Automatisation / scripting (Python, Shell, Ansible).

Automation / scripting (Python, Shell, Ansible).

Connaissance des cadres de gouvernance et qualité des données (MDM).

Familiarity with data governance, MDM, and data quality frameworks.

LANGUES / LANGUAGES

Français et anglais.

French and English.

Create a job alert for this search

Database and Solution Architect • Montreal, Canada

Similar jobs

Lead Data Platform Architect

Oliver Wyman • Montreal

Full-time

A global management consulting firm seeks a Principal Engineer for its Performance Transformation team in Montreal.In this role, you will lead cross-functional teams to deliver innovative tech solu...Show more

Last updated: 13 days ago • Promoted

Senior Solutions Engineer : Architect Winning Tech Solutions

CyberArk • Montreal

Full-time

A leading identity security firm is seeking a highly motivated Solutions Engineer based in Montreal, Canada.This role combines technical knowledge with sales skills to drive the technical evaluatio...Show more

Last updated: 13 days ago • Promoted

Enterprise Architect / Solutions Architect - - KUMDC5690453

Compunnel Inc. • Montreal

Full-time

Enterprise Architect or Solutions Architect.Montreal (day 1 onboarding onsite / in-office presence required 3x / week).Design and then implement solutions that align with business and IT strategy.Tra...Show more

Last updated: 13 days ago • Promoted

Senior Solution Architect

National Bank • Montreal, Canada

Full-time

A career as a Senior Solutions Architect in the wealth Management Solutions Architecture and Data team at National Bank will lead the definition and implementation of innovative solutions.You will ...Show more

Last updated: 7 days ago • Promoted

Solution Architect (Architecture & Engineering focus)

GRAITEC GmbH • Montreal

Full-time

GRAITEC Group Company est un éditeur de logiciels mondial, leader des solutions Building Information Modeling (BIM).Nous accompagnons nos clients dans l’architecture, l’ingénierie, la construction ...Show more

Last updated: 13 days ago • Promoted

Solutions Architect

LeverageTek Staffing Solutions • Ahuntsic North, ca

Permanent +1

LeverageTek is actively seeking a.Solutions Architect (Laboratory Information Systems).Architect and support enterprise solutions to modernize laboratory operations and services.Design, implement, ...Show more

Last updated: 2 days ago • Promoted

Solution Architect, Product

Kinaxis • Ahuntsic North, ca

Full-time

Elevate your career journey by embracing a new challenge with Kinaxis.We are experts in tech, but it’s really our people who give us passion to always seek ways to do things better.We’re serious ab...Show more

Last updated: 3 days ago • Promoted

Sr. Solutions Architect to support ongoing development, maintenance, and integration of software solutions in a Devops environment

S.i. Systems • Montreal

Full-time

Our valued client is looking for a Sr.Solutions Architect to support ongoing development, maintenance, and integration of software solutions in a Devops environmentTasks include : Design, maintain, a...Show more

Last updated: 9 days ago • Promoted

Solution Architect

Coveo • Montreal

Full-time

Be among the first 25 applicants.Design intelligent experiences that actually make sense.How do you translate complex business needs into elegant technical solutions that deliver real impact? As a ...Show more

Last updated: 13 days ago • Promoted

Solutions Architect

Compunnel, Inc. • Montreal

Full-time

Client is seeking an accomplished Enterprise Architect or Solutions Architect with a broad, organization-wide architecture guidance-setting mindset. This role will lead the development and execution...Show more

Last updated: 10 days ago • Promoted

Solution Architect - Managed Services for Enterprise Cloud

Rogers Communications • Ahuntsic North, ca

Full-time

A leading telecommunications company is hiring a Solution Architect for Managed Services in Ottawa.The role requires designing complex solutions for large organizations, collaborating with clients,...Show more

Last updated: 21 days ago • Promoted

Senior Solutions Architect — Cloud, APIs & Enterprise Systems

Kitco Metals Inc. • Montreal

Full-time

A leading metals company in Montreal is seeking a highly skilled Solution Architect.The ideal candidate will design and implement complex software systems in alignment with business goals, lead tec...Show more

Last updated: 13 days ago • Promoted

Solution Architect, Manufacturing & Engineering

BRP • Montreal

Full-time

We are looking for a Solution architect (SA) who will report to the Team Lead of Solution Architecture.The SA is responsible for designing, aligning, and governing end-to-end technology solutions s...Show more

Last updated: 29 days ago • Promoted

Data Solutions Architect - Belron Canada

Lebeau Vitres d'autos • Montreal

Full-time

We welcome applications from everyone, and are firmly committed to diversity, equity and inclusion in the workplace, and take pride in ensuring every member of our team feels empowered.As a • •Data ...Show more

Last updated: 13 days ago • Promoted

Power Platform Solution Architect

VBeyond Corporation • Ahuntsic North, ca

Full-time

Be among the first 25 applicants.We are seeking an experienced Power Platform Solution Architect to design and build a Power Platform Center of Excellence (CoE) from the ground up.This role will de...Show more

Last updated: 26 days ago • Promoted

Senior AI-Driven Cloud & API Solutions Architect

Banque Nationale du Canada • Montreal (administrative region), QC, Canada

Remote

Full-time

A leading Canadian bank is seeking a Solutions Architect to join their Technology and Operations team.This role involves designing and integrating innovative solutions, with a focus on cloud servic...Show more

Last updated: 26 days ago • Promoted

Senior Solution Architect - Eightfold

nformal • Montreal

Full-time

AI technology to our customers using our philosophy : a friendly, simple, honest way of working that gets to the point and produces results super fast. Drive requirement-gatheringsessions focused on ...Show more

Last updated: 13 days ago • Promoted

Solution Architect

PrecisionERP / PrecisionIT • Montreal

Full-time

The work can be remote from other parts of Canada but the consultant must be.The term would be until the end of the year. Act as the lead Solution Architect.Work with Solution Architects from variou...Show more

Last updated: 13 days ago • Promoted