Database and Solution Architectfreelance.ca • Montreal, Canada

Database and Solution Architect

freelance.ca • Montreal, Canada

Il y a 9 jours

Type de contrat

Temps plein

Description de poste

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.

Créer une alerte emploi pour cette recherche

Solution Architect • Montreal, Canada

Offres similaires

Architecte de solutions Azure / Azure Solution Architect

KPI Digital • Montreal, QC, Canada

Temps plein +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...Voir plus

Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée

Enterprise Solution Architect – ITSM

NTT DATA North America • Ahuntsic North, ca

Temps plein

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...Voir plus

Dernière mise à jour : il y a 25 jours • Offre sponsorisée

Business Solutions Architect

Targeted Talent • Montreal, QC, Canada

Temps plein

Our client, an award-winning vehicle manufacturer utilizing deep technology and AI, is looking for a Business Solutions Architect to help support the company's growth.As the Business Solutions ...Voir plus

Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée

Solution Architect

Air Canada • Dorval

Temps plein

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...Voir plus

Dernière mise à jour : il y a 5 jours • Offre sponsorisée

Solution Architect

Cofina • Montreal

Temps plein +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...Voir plus

Dernière mise à jour : il y a 17 jours • Offre sponsorisée

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...Voir plus

Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée

Senior Digital Solution Architect - Cloud & API

Intact Financial Corporation • Montreal

Temps plein

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, ...Voir plus

Dernière mise à jour : il y a 9 jours • Offre sponsorisée

SAP Solution Architect – S / 4HANA Migration - laval

Avance Consulting • laval, qc, ca

Temps plein

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

Dernière mise à jour : il y a 28 jours • Offre sponsorisée

Solution Architect

Rogers Communications, Inc. • Ahuntsic North, ca

Temps plein +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 ...Voir plus

Dernière mise à jour : il y a 6 jours • Offre sponsorisée

Solution Architect

Rogers Communications • Montreal

Temps plein +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...Voir plus

Dernière mise à jour : il y a 1 jour • Offre sponsorisée

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...Voir plus

Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée

SAP Solution Architect – S / 4HANA Migration

Avance Consulting • Montreal, QC, Canada

Temps plein

Dernière mise à jour : il y a 8 jours • Offre sponsorisée

DBA / Data and Solution Architect

freelance.ca • Montreal, Canada

Temps plein

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...Voir plus

Dernière mise à jour : il y a 29 jours • Offre sponsorisée

Senior Digital Solution Architect — Cloud & API

Intact • Montreal, Montreal (administrative region), Canada

Temps plein

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...Voir plus

Dernière mise à jour : il y a 13 jours • Offre sponsorisée

Senior Digital Solutions Architect — Cloud & APIs

Queer Tech • Montreal, Montreal (administrative region), Canada

Télétravail

Temps plein

A technology company in Montreal seeks a Senior Solution Architect - Digital to drive solution definitions, manage architecture across projects, and collaborate with various teams.Applicants should...Voir plus

Dernière mise à jour : il y a 13 jours • Offre sponsorisée

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...Voir plus

Dernière mise à jour : il y a 9 jours • Offre sponsorisée

Solution Architect

BRP • Montreal

Temps plein

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 ...Voir plus

Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée

Platform Solutions Architect — Data & Core Tools (Ottawa)

Tech Insights • Ahuntsic North, ca

Temps plein

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...Voir plus

Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée