Database and Solution Architectfreelance.ca • Montreal, Canada

Database and Solution Architect

freelance.ca • Montreal, Canada

8 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

Solution Architect • Montreal, Canada

Similar jobs

Architecte de solutions Azure / Azure Solution Architect

KPI Digital • Montreal, QC, Canada

Full-time +1

Chez KPI, vous aurez la chance de btir une carrire aussi unique que vous, avec le soutien, la culture inclusive et la technologie qui vous permettront de devenir la meilleure version de vous-mme.Et...Show more

Last updated: 30+ days ago • Promoted

Enterprise Solution Architect – ITSM

NTT DATA North America • Ahuntsic North, ca

Full-time

Enterprise Solution Architect – ITSM.Location : Gatineau, Quebec, Canada.Employer : NTT DATA North America.The IT Service Management (ITSM) Refactoring Project is designed to eliminate technical debt...Show more

Last updated: 24 days ago • Promoted

Solution Architect

Air Canada • Dorval

Full-time

Being part of Air Canada is to become part of an iconic Canadian symbol, recently ranked the best Airline in North America. Let your career take flight by joining our diverse and vibrant team at the...Show more

Last updated: 4 days ago • Promoted

SAP Solution Architect – S / 4HANA Migration - montréal

Avance Consulting • montréal, qc, ca

Full-time

Job Title : SAP Solution Architect – S / 4HANA Migration.Location : Montreal, Quebec ( Onsite ).Lead Brownfield Conversion Projects : . Define conversion strategy, roadmap, and timelines.Assess existing...Show more

Last updated: 27 days ago • Promoted

Solution Architect

Cofina • Montreal

Full-time +1

Our client offers a great range of employee benefits.The work mode is hybrid, with two days per week in the office.Do you want to grow within a family-oriented company where it’s great to work? The...Show more

Last updated: 15 days ago • Promoted

Solution Architect

Targeted Talent • Montreal, QC, Canada

Permanent

We are looking for an experienced.Our client is a fintech company based out of Vancouver.You'll have the opportunity to work on an amazing platform that combines Data Analytics, and complex int...Show more

Last updated: 30+ days ago • Promoted

Senior Digital Solution Architect - Cloud & API

Intact Financial Corporation • Montreal

Full-time

A leading insurance company based in Montreal is seeking a Senior Solution Architect - Digital to define and implement architectural solutions. The role involves collaborating across various teams, ...Show more

Last updated: 8 days ago • Promoted

SAP Solution Architect – S / 4HANA Migration - laval

Avance Consulting • laval, qc, ca

Full-time

Last updated: 27 days ago • Promoted

Solution Architect

Rogers Communications, Inc. • Ahuntsic North, ca

Full-time +1

Solution Architect Our company was built on the dream of a pioneering entrepreneur, and that spirit continues to empower our work with businesses across Canada today. The Rogers Business team helps ...Show more

Last updated: 5 days ago • Promoted

Solution Architect

Rogers Communications • Montreal

Full-time +1

Be among the first 25 applicants.Our company was built on the dream of a pioneering entrepreneur, and that spirit continues to empower our work with businesses across Canada today.The Rogers Busine...Show more

Last updated: 2 hours ago • Promoted • New!

Solution Architect

Tech Insights • Ahuntsic North, ca

Permanent

OUR STORY TechInsights is the information Platform for the semiconductor industry.Regarded as the most trusted source of actionable, in-depth intelligence related to semiconductor innovation and su...Show more

Last updated: 30+ days ago • Promoted

Senior Digital Solution Architect — Cloud & API

Intact • Montreal

Full-time

A leading insurance provider in Montreal is seeking a Senior Solution Architect – Digital to join their team.In this role, you will manage and develop architecture for various projects, define solu...Show more

Last updated: 13 days ago • Promoted

Solution Architect / Architecte de Solutions

Kitco Metals Inc. • Montreal

Full-time

Solution Architect / Architecte de Solutions.Be among the first 25 applicants.Solution Architect / Architecte de Solutions. We are looking for a highly skilled Solution Architect to design and implement...Show more

Last updated: 15 days ago • Promoted

DBA / Data and Solution Architect

freelance.ca • Montreal, Canada

Full-time

DBA / Data and Solution Architect.Contract Term : 6 months, renewable.Work Location : downtown Toronto, ON.We are looking for a versatile data and solution architecture professional with expertise ac...Show more

Last updated: 28 days ago • Promoted

Senior Solutions Architect : Data & Cloud (Hybrid, Montreal)

Alteo Inc. • Montreal

Full-time +1

A technology consulting firm is seeking a Solutions Architect for a permanent position in Montreal.The role focuses on analyzing business needs, creating scenarios, and leading solution development...Show more

Last updated: 6 days ago • Promoted

Solutions Architect [#4891]

Alteo • Montreal, QC, Canada

Permanent

Alteo is looking for a Solutions Architect for a permanent position based in Montreal.Hybrid : 6 days in the office per month • • •. Your responsibility will be to analyze business needs, create scenar...Show more

Last updated: 7 days ago • Promoted

Solution Architect

BRP • Montreal

Full-time

Be among the first 25 applicants.We are looking for a Solution Architect (SA) who will report to the manager of solution architecture. The SA will primarily be defining the solution architecture on ...Show more

Last updated: 30+ days ago • Promoted

Platform Solutions Architect — Data & Core Tools (Ottawa)

Tech Insights • Ahuntsic North, ca

Full-time

A technology company in Ottawa is seeking a Solution Architect to define and improve its Platform's architecture.The role involves collaboration across departments to optimize internal tools and ma...Show more

Last updated: 30+ days ago • Promoted