Talent.com
freelance.ca
Database and Solution Architectfreelance.ca • Toronto, Canada
Database and Solution Architect

Database and Solution Architect

freelance.ca • Toronto, Canada
30+ days ago
Job type
  • Full-time
Job description
We are looking for a versatile database and solution architecture professional with expertise across data modeling, SQL development, data architecture, database administration, and solution architecture. The ideal candidate has hands-on experience with distributed databases (CockroachDB, PostgreSQL, DB2), data lakes (Iceberg, Parquet, query engines), and microservices/Spring Boot ecosystems. You will design end-to-end data solutions, optimize performance, and ensure high availability across enterprise systems.

Key Responsibilities:
• Design scalable end-to-end solution architectures integrating databases, data lakes, and microservices.
• Build and maintain conceptual, logical, and physical data models for OLTP and OLAP workloads.
• Develop and optimize SQL queries, stored procedures, and views.
• Architect and implement distributed database and data lake solutions using Iceberg, Parquet, and query engines.
• Integrate database components with microservices and Spring Boot applications, ensuring correct transaction isolation and concurrency control.
• Perform performance tuning, indexing, partitioning, and query optimization for large-scale, distributed systems.
• Administer CockroachDB, PostgreSQL including installation, configuration, backup/recovery, and DR.

Required Skills & Experience:
• Strong experience across database development, data modeling, data architecture, DBA functions, and solution architecture.
• Strong proficiency in SQL, CockroachDB, PostgreSQL.
• Strong performance-tuning expertise for distributed and high-throughput systems.
• Understanding of microservices architecture, Java, Spring Boot, and transaction isolation levels.
• Knowledge of ETL, data warehousing, and data integration best practices.

Preferred Skills:
• Cloud experience (IBM Cloud, AWS, GCP, Azure) and OpenShift (On-prem).
• Automation/scripting (Python, Shell, ansible etc).
• Familiarity with data governance, MDM, and data quality frameworks.
Create a job alert for this search

Database and Solution Architect • Toronto, Canada

Similar jobs

Databricks Solution Architect

BDO Canada LLPToronto, ON, CA
Full-time

Databricks Solution Architect page is loaded## Databricks Solution Architectlocations: Toronto - Bay Sttime type: Temps pleinposted on: Publié aujourd'huijob requisition id: JR6061**Putting... Show more

 • Promoted

Backbase Solution Architect - Toronto, ON

Info-WaysToronto, ON, CA
Full-time

Backbase Solution Architect - Toronto, ON.Role: Backbase Solution Architect.Background Verification (BGV) will be done for selected candidates.At least 2 years of experience as a solution architect... Show more

 • Promoted

Solution Architect

CollaberaToronto, ON, CA
Full-time

Collabera is seeking a hands‑on Solution Architect with a strong focus on application architecture to support a critical migration initiative.This role will primarily focus on designing and operati... Show more

 • Promoted

Solution Architect

Aecon Group Inc.Toronto, ON, CA
Full-time

The Solution Architect will design, own, and govern end‑to‑end technology solutions that enable business outcomes across Aecon’s operations.This role is accountable for translating business needs i... Show more

 • Promoted

Lead Solution Architect Specializing in Backbase Implementations

Info-WaysToronto, ON, CA
Full-time

Drive innovative solutions as a Solution Architect with deep expertise in Backbase.Leverage your 6+ years of architectural experience to shape impactful projects in a dynamic IT environment.In this... Show more

 • Promoted

Senior Cloud & Oracle EBS Architect

Stantec Consulting International Ltd.Toronto, ON, CA
Full-time

A leading engineering consulting firm is seeking a Senior Application Architect based in Toronto.In this role, you will be responsible for designing scalable and secure applications, integrating cl... Show more

 • Promoted

Solution Architect

Aecon ConcessionsToronto, ON, CA
Full-time

Position Title: Solution Architect.Operating Sector: Information Services.Aecon’s corporate teams play a critical role in enabling the success of Aecon’s operating sectors and major infrastructure ... Show more

 • Promoted

Senior Solutions Architect, Integrations

TipaltiToronto, ON, CA
Full-time

The Senior Solution Architect within Tipalti’s Professional Services organization is responsible for driving solution excellence, establishing integration architecture standards, and ensuring succe... Show more

 • Promoted

Database Solutions Architect with Cloud and Data Expertise

KrollToronto, ON, CA
Full-time

Transform data strategy as a Database Solutions Architect.Utilize your expertise in cloud environments and advanced SQL to create high-performance database solutions that support business needs.You... Show more

 • Promoted

Cloud Solution Architect

Soar ConsultantsToronto, ON, CA
Full-time

We are looking for a skilled Solution Architect for a client in Toronto.They are looking for a Solution Architects with experience working on Cloud and Development focused projects within the Banki... Show more

 • Promoted

Senior Solution Architect

LotusFlareToronto, ON, CA
Full-time

SaaS products based in the heart of Silicon Valley.Founded by the team that helped Facebook reach over one billion users, LotusFlare was founded to make affordable mobile communications available t... Show more

 • Promoted

Lead Data Solution Architect, Wealth Technology

ManulifeToronto, ON, CA
Full-time

Join our Wealth Technology Architecture team!.We want to foster and create diverse thinking and perspectives to drive innovative solutions.We recognize that sometimes we must embrace ambiguity, cre... Show more

 • Promoted

Expert Solutions Architect in Databricks and Cloud Architecture

LumenaltaToronto, ON, CA
Full-time

Enhance cloud-native data infrastructures as a Solutions Architect.Leverage your expertise in Databricks and AWS to design scalable, high-performance data platforms in a remote role.In this senior ... Show more

 • Promoted

Solutions Architect

Insight GlobalToronto, ON, CA
Full-time

This range is provided by Insight Global.Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.Annual Bonus and Stock options.Insight Global currently... Show more

 • Promoted

Solution Architect with Expertise in Anaplan and Data Management

FuturetekToronto, ON, CA
Full-time

Join a dynamic team as a Solution Architect specializing in Anaplan solutions within a hybrid work setting.Drive business transformation by creating effective and innovative planning models.This ro... Show more

 • Promoted

Senior Solution Architect with Cloud Expertise

Inizio Partners CorpToronto, ON, CA
Full-time

Drive innovative solutions as a Senior Solution Architect.Manage architecture design processes and foster collaboration with stakeholders to meet essential business goals.In this contract position,... Show more

 • Promoted

Solution/Modernization Architect (Mainframes)

Dedicatted»Toronto, ON, CA
Full-time +1

Solution/Modernization Architect (Mainframes).We are seeking a dedicated Migration/Solution Architect (Mainframes) to join our team.In this role, you will be pivotal in designing and leading comple... Show more

 • Promoted

Principal Database Architect (DBaaS)

RumbleToronto, ON, CA
Full-time

Our mission is to restore the internet to its roots by making it free and open once again.Database as a Service (DBaaS) offering within our public cloud platform.This role will take over a product ... Show more

 • Promoted

OPEN: Senior Solution Architect & SAP Certified Solution Architect

Cpus Engineering Staffing Solutions Inc.Toronto, ON, CA
Full-time

We are currently requesting resumes for the following position.Monday, March 10, 2025 (5:00PM EST).We are seeking a highly skilled Solution Architect to join our dynamic team.The ideal candidate wi... Show more

 • Promoted

Senior Architect for Cloud and Data Solutions

Symbiotic GroupToronto, ON, CA
Full-time

Shape the future as a Senior Architect focusing on data and cloud technologies in Downtown Toronto.Your leadership will ensure the deployment of sophisticated technical architectures across diverse... Show more