Senior Technical Architecture Specialist

We are seeking a highly accomplished and multi-faceted Senior Technical Architecture Specialist for an enterprise-level contract opportunity based in Toronto. In this role, you will take on a premier technical capacity across database engineering, solution architecture, and data operations streams, specializing in the design, implementation, and execution of large-scale infrastructure migrations and data management solutions.

As a principal technical authority, you will bridge the gap between complex physical database environments, enterprise data pipelines, and cloud-native applications. Operating within a hybrid model, you will provide critical hands-on leadership across core relational engines, design end-to-end data integration pathways, and embed strict cybersecurity and compliance frameworks into both on-premise and cloud ecosystems. This role is designed for a well-rounded expert who can navigate complex technical transformations and drive strategic, future-state system modernizations.

Location: Toronto, ON

Assignment Type: Hybrid (3 days a week in-office, subject to business discretion)

Contract Duration: 6 months (with a 6-month optional extension)

Advantages
Full-Stack Data Scope: Combine senior-tier database administration (DBA) infrastructure control with advanced data modeling and data pipeline engineering.

Multi-Cloud Stack: Deepen your technical footprint working across enterprise on-premise platforms and market-leading cloud environments like AWS and Azure.

High-Visibility Migrations: Drive the end-to-end architectural strategy for major data center database moves and comprehensive system version modernizations.

Modern DevOps Culture: Create, modify, and optimize business-critical pipelines utilizing active CI/CD automation tools and modern Agile delivery models.

Responsibilities
Database Infrastructure Migration: Provide senior-level database administration expertise to support the secure, seamless migration of database engines and dependent application frameworks from legacy hosts to a new data center.

Data Integration & Mapping: Develop scalable technical solutions to connect and integrate data structures across internal platforms and third-party systems, executing detailed data mapping for transactional and analytical applications.

Data Pipeline Engineering: Design, construct, and maintain robust ETL/ELT pipelines and data integration flows utilizing both on-premise relational systems and cloud-hosted data tools.

Schema & Code Optimization: Create, update, and fine-tune complex database schemas, authoring high-performance stored procedures, functions, packages, and database triggers.

Architectural Blueprinting: Construct clear conceptual, logical, and physical data models while defining target-state solution architectures based on functional and corporate technology strategies.

Upgrades & Recommendations: Formulate data-driven recommendations for system modernizations, leading technical workstreams for system software upgrades, security refactoring, and data version changes.

Framework Compliance Guarding: Ensure all developed technical artifacts, data synchronization workflows, and security models meet strict technical, operational, privacy, and regulatory standards.

Cross-Functional Collaboration: Partner closely with internal database administrators and multi-disciplinary IT squads to align infrastructure changes with application dependencies.

Metrics tracking & Risk Management: Monitor, track, and report on work milestones, pipeline performance metrics, deployment schedules, and systemic infrastructure risks.

Mentorship & Knowledge Transfer: Provide active mentorship, structural documentation, on-the-job assistance, and dedicated knowledge-transfer sessions to team members to ensure long-term operational continuity.

Qualifications
Core Technical & Architectural Requirements
Solutions Architecture Tenure: 10+ years of progressive experience defining solution architectures, building technical environments, transforming legacy architectures, and designing relational and non-relational data models.

Database Infrastructure Mastery: 5+ years of dedicated experience operating in a DBA role, demonstrating expertise in managing database infrastructure, executing migration strategies, handling replication, and managing non-production environments using security and privacy tools.

Multi-Engine Programming Fluency: Extensive hands-on experience working with Oracle and PostgreSQL databases, writing advanced PL/SQL and PL/pgSQL, executing Linux shell scripting, and programming in Java and Python (prior exposure to Oracle Forms and Reports is considered an asset).

Data Management & Analytics Pipeline Depth: Strong background in data integration frameworks, including ETL/ELT pipelines, data warehouses, data lakes, data mesh architectures, and data visualization tools like Tableau.

Modern Development Methodologies: Practical experience executing software delivery within Agile frameworks, utilizing DevOps CI/CD practices and repository tools such as Jenkins and Git.

Compliance & Governance Capabilities
Cybersecurity & Regulatory Expertise: 5+ years of experience aligning database platforms with cybersecurity guidelines, data classification rules, privacy mandates, and strict compliance frameworks.

Systems Analysis & Documentation: Proven ability to synthesize business inputs into system analysis reports, detailed technical specifications, data protection strategies, and structural business rules.

Education: Bachelor of Science in Computer Science, Engineering, or a related quantitative discipline, or equivalent technical experience.

Leadership & Interpersonal Strength
Consultative Articulation: Outstanding communication, presentation, and facilitation skills, with an ability to present abstract technical choices clearly to diverse audiences.

Problem Solving & Collaboration: Superior analytical troubleshooting capabilities and critical thinking, with a proven history of collaborating across multi-tenant development clusters.

Leadership & Organization: Highly motivated team player with strong leadership, time-management, and multi-tasking abilities who can meet fixed deadlines in high-stakes environments.

Summary
If you're interested in the "Senior Technical Architecture Specialist" role based in Toronto, we encourage you to apply online at www.randstad.ca. Only qualified candidates will be contacted for the next steps. We look forward to hearing from you!

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.