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

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 Tech Solutions Architect

Bell • Montreal

Full-time

A leading telecommunications company is seeking a Specialist to drive the sales of technology solutions in Montreal.This role focuses on developing tailored strategies for business market customers...Show more

Last updated: 5 days ago • Promoted

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: 14 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: 14 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

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 Solutions Architect

National Bank • Montreal, Canada

Full-time

A career as a Senior Solutions Architect in the Digital Delivery and Banking Services team at National Bank is an opportunity to contribute directly to major digital transformation and hyper-automa...Show more

Last updated: 7 days ago • Promoted

Anaplan Solutions Architect

Keyrus • Montreal

Full-time

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...Show more

Last updated: 14 days ago • Promoted

Senior AI-Driven Cloud & API Solutions Architect

Banque Nationale du Canada • Montreal

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: 14 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: 4 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

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

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: 14 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: 27 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: 14 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: 14 days ago • Promoted

Senior Resident Solutions Architect

IBM • Montreal

Full-time

What You’ll Do (Responsibilities).Provide both general and specific guidance on each step of the customer cloud transformation journey as it relates to the IBM product suite.Assist customers in ali...Show more

Last updated: 3 days ago • Promoted