Senior Technology Architect – Oracle Database & Middleware

ThoughtStorm Inc.; Toronto; Hybrid; CAD 120,000 - 150,000; Full time

Job summary

ThoughtStorm Inc. is seeking a Senior Technology Architect in Toronto, hybrid (3 days onsite, 2 remote). The role focuses on enterprise database administration, middleware architecture, and infrastructure management.

You will design and implement complex DB and middleware solutions for large-scale data warehouses, while coordinating with stakeholders and driving release governance. The ideal candidate has 10+ years of Oracle experience, strong IBM middleware expertise, ODI proficiency, and

Qualifications

• 10+ years of Oracle database experience including RAC, Data Guard, Flashback, migrations and performance tuning.
• Hands-on IBM TRIRIGA 3.7.x/10.7.x, WebSphere, IBM HTTP Server setup, config, cloning and upgrades.
• ODI 12.x installation, administration, upgrades, migrations and cloning.
• SQL Server 2016+ and SSRS implementation experience.
• Infrastructure and OS expertise across Windows Server, Linux, Solaris, Unix.
• Database operations including backup/recovery, security, clustering, monitoring, and tuning.
• Solution architecture for enterprise DB and middleware, large-scale data warehouses.
• Experience with Hadoop installation/configuration, SSO, IAM modernization, and infra support.
• Documentation and delivery—architectures, build books, release management, stakeholder collaboration.

Responsibilities

• Design enterprise-level database and middleware solutions and data warehouse architectures.
• Lead system integrations and large-scale data migration initiatives.
• Collaborate with multiple technical and business stakeholders to deliver architectural artifacts.
• Support release management and provide technical governance across environments.

Skills

Senior-level experience

Enterprise architecture

Stakeholder collaboration

Tools

IBM TRIRIGA

WebSphere

IBM HTTP Server

ODI

SQL Server/SSRS

Windows Server

Linux/Solaris/Unix

Hadoop

Job description

Location: Toronto, ON (Hybrid – 3 days onsite, 2 days remote, as specified in the assignment details)

We are looking for a Senior Technology Architect with extensive experience in enterprise database administration, middleware architecture, and infrastructure management.

• Oracle Database: 10+ years of experience with Oracle 11g, 12c, 19c, Oracle RAC, Data Guard, Flashback, database migration, and performance tuning.
• IBM Middleware: Strong hands-on experience with IBM TRIRIGA 3.7.x/10.7.x, WebSphere, and IBM HTTP Server (IHS), including installation, configuration, cloning, and upgrades.
• Oracle Data Integrator (ODI): Expertise in ODI 12.x installation, administration, upgrades, migrations, and cloning.
• SQL Server & Reporting: Experience with SQL Server 2016+ and SQL Server Reporting Services (SSRS) implementation.
• Infrastructure & OS: Strong experience with Windows Server, Linux, Solaris, Unix administration, infrastructure architecture, capacity planning, patching, and deployments.
• Database Operations: Expertise in database backup and recovery, security, access management, clustering, monitoring, troubleshooting, and performance optimization.
• Solution Architecture: Proven experience designing enterprise-level database and middleware solutions, system integrations, and large-scale data warehouse environments.
• Additional Skills: Experience with Hadoop installation and configuration, Single Sign-On (SSO), IAM modernization, and enterprise infrastructure support.
• Documentation & Delivery: Ability to prepare technical architecture documents, build books, support release management, and collaborate with multiple technical and business stakeholders.

Public-sector experience and the ability to support complex enterprise environments are highly desirable.