DBA / Data and Solution Architect

DBA / Data and Solution Architect

Contract Term : 6 months, renewable

Work Location : downtown Toronto, ON. 2 days a week onsite with some flexibilities

We are looking for a versatile data 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 :

Preferred Skills :