Database and Solution Architectfreelance.ca • Montreal, Canada

Database and Solution Architect

freelance.ca • Montreal, Canada

Il y a plus de 30 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

Database and Solution Architect • Montreal, Canada

Offres similaires

Lead Data Platform Architect

Oliver Wyman • Montreal

Temps plein

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

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

Senior Solutions Engineer : Architect Winning Tech Solutions

CyberArk • Montreal

Temps plein

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

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

Enterprise Architect / Solutions Architect - - KUMDC5690453

Compunnel Inc. • Montreal

Temps plein

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

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

Senior Software Architect - AEC Data Platform

Autodesk, Inc. • Montreal

Temps plein

Une entreprise de technologie leader à Montréal recherché un architecte logiciel expérimenté.Vous serez responsable de la conception de systèmes et services pour les capacités de données au sein de...Voir plus

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

Anaplan Solutions Architect

Keyrus • Montreal

Temps plein

Keyrus Consultants are collaborative and curious - working together to figure out the best solution for our clients.Keyrus is actively seeking candidates who are problem solvers, enjoy working on c...Voir plus

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

Solution Architect (Architecture & Engineering focus)

GRAITEC GmbH • Montreal

Temps plein

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

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

Senior Solutions Architect, Professional Services

National Society for Black Engineers • Ahuntsic North, ca

Temps plein

Join Axon and be a Force for Good.At Axon, we're on a mission to Protect Life.We're explorers, pursuing society's most critical safety and justice issues with our ecosystem of devices and cloud sof...Voir plus

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

Senior AI-Driven Cloud & API Solutions Architect

Banque Nationale du Canada • Montreal

Temps plein

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

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

Solution Architect, Product

Kinaxis • Ahuntsic North, ca

Temps plein

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

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

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

S.i. Systems • Montreal

Temps plein

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

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

Solution Architect

Coveo • Montreal

Temps plein

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

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

Solution Architect

CGI • Montréal, QC, Canada

Temps plein

Do you thrive on creating innovative solutions that help clients overcome complex technical challenges? At CGI, we are entering an exciting era and seeking forward‑thinking professionals to join us...Voir plus

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

Solutions Architect

Compunnel, Inc. • Montreal

Temps plein

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

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

Solution Architect - Managed Services for Enterprise Cloud

Rogers Communications • Ahuntsic North, ca

Temps plein

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

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

Data Solutions Architect - Belron Canada

Lebeau Vitres d'autos • Montreal

Temps plein

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

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

Power Platform Solution Architect

VBeyond Corporation • Ahuntsic North, ca

Temps plein

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

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

Senior Solution Architect - Eightfold

nformal • Montreal

Temps plein

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

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

Solution Architect

PrecisionERP / PrecisionIT • Montreal

Temps plein

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

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