Client: Ministry of Public and Business Service Delivery and Procurement – RQ11599
We are seeking a
Senior Technology Architect / Database Administrator with extensive experience in enterprise technology architecture, Oracle database administration, middleware operations, infrastructure planning, system integration, and business intelligence solutions. The ideal candidate will have strong hands-on expertise in Oracle Database (11gR2, 12cR2, and 19c), Oracle Real Application Cluster (RAC), IBM TRIRIGA, IBM WebSphere, IBM HTTP Server (I.H.S), Oracle Data Integrator (ODI), Oracle OBIEE, SQL Server, Hadoop, UNIX, Solaris, Linux, and Windows Server environments. The successful candidate will lead infrastructure planning, database migrations and upgrades, middleware development and operations support, performance tuning, identity and access management modernization, and enterprise system integration while ensuring security, reliability, scalability, and timely delivery of critical public-sector technology initiatives.
Role Snapshot
- Job Title: RQ11599 – Technology Architect – Senior
- Client: Ministry of Public and Business Service Delivery and Procurement
- Work Location: 777 Bay Street, Toronto, Ontario, Canada
- Work Arrangement: Onsite – 5 Days per Week
- Estimated Start Date: October 26, 2026
- Estimated End Date: October 5, 2027
- Business Days: 240.00
- Extension: Probable after the initial mandate
- Hours: 7.25 hours per day
- Security Level: No Clearance Required
Description
Responsibilities
Develops, recommends, implements, and manages the technical architecture, including hardware, software, databases, and communications, which will be used for all or specific applications in a large, distributed, cross-platform environment. Responsibilities also include identifying relevant information and determining the environment that will be used for development.
General Skills
- Leadership experience in the development and implementation of technical architectures at the specified experience level.
- Extensive experience with at least three different platforms, operating systems, environments, database technologies, and communications protocols.
- Experience with middleware and gateways.
- Knowledge of performance considerations in different environments.
- Experience with structured methodologies for the design, development, and implementation of applications.
- Extensive experience in systems analysis and design in large systems environments.
- Knowledge and experience designing processes around ITIL and the ability to guide others using this methodology.
- Experience translating business requirements into reporting needs.
- Experience preparing conceptual, logical, and/or physical processes and data models.
- Experience developing, recommending, implementing, and managing technical architecture.
- Experience using Computer Aided Software Engineering (CASE) tools and other software tools, such as project management tools.
- Awareness of emerging technologies, trends, and directions.
- Excellent analytical, problem-solving, and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills.
- A team player with a track record of meeting deadlines.
- Experience developing enterprise architecture deliverables, such as models.
- Experience with IAM modernization initiatives using technologies such as Microsoft Entra ID or Oracle IAM.
Desirable Skills
- Experience developing enterprise architecture deliverables, such as models, based on Ontario Government Enterprise Architecture processes and practices.
- Knowledge and understanding of Enterprise Content Management, including OpenText ECM applications.
- Knowledge and understanding of Information Management principles, concepts, policies, and practices.
Services and Deliverables
The services and deliverables to be provided by the candidate will include the following:
- Provide middleware development and operations support for the ECIS solution running IBM IHS, WebSphere, and TRIRIGA.
- Provide Oracle database and infrastructure support for the Report and Validation (RV) data warehouse system.
- Provide Oracle database and Oracle Data Integrator (ODI) support to various data warehouse systems.
- Perform solution design and architecture for system and data integration.
- Lead the planning of DDSB Server OS upgrades for Windows, Solaris, and Linux servers.
- Lead the planning and execution of Oracle upgrade and migration projects.
- Participate in planning activities and solution design; complete all required change request assessment tasks, Design Workbook, and WIA; and participate in DDSB and ITS release management activities.
- Perform capacity planning, database monitoring, and performance tuning for all Oracle and SQL Server databases.
- Provide support and solution design for Hadoop implementation.
- Provide daily DBA support for all databases running Oracle 19c across development, test, pre-production, and production environments.
- Perform administrative tasks, including database backup and recovery, database export and import, database maintenance, database management, database performance monitoring, and tuning.
- Update technical documentation, including Operations Manual documents and Technical Architecture documents.
- Support RV SRSS implementation using SQL Server 2016 database and Reporting Services.
- Support the web-enabled antivirus file-upload scanning server.
Other Experience And Skills
The Technology Architect / Database Administrator must have the following skills and experience:
- Extensive working experience with solution design and architecture for IBM TRIRIGA System, IBM WebSphere, and I.H.S.
- Over 10 years of experience with Oracle Database (11gR2, 12cR2, and 19c) and related technology, including Oracle Real Application Cluster (RAC).
- Over 10 years of UNIX (Solaris and Linux) and Windows Server experience.
- Over 10 years of experience supporting SQL Server (SQL Server 2016).
- Extensive working experience with solution design and architecture for Single Sign-On solutions utilizing OPS Go-Secure technology.
- Extensive working experience with solution design and architecture for Oracle Data Integrator (ODI) and Oracle OBIEE.
- Extensive working experience with solution design and architecture for system and data integration.
- Demonstrated working experience with solution design and architecture for enterprise web-enabled antivirus file-scanning solutions.
- Demonstrated working experience with solution design and architecture for large-scale (20TB+) Business Intelligence applications.
- Demonstrated working experience with Hadoop software installation and configuration, including infrastructure design, server commissioning, sizing, and hardware and software analysis.
- Previous public-sector experience in an organization of equivalent size and complexity to the Ontario Public Service.
- Demonstrated working experience with large-scale and complex middleware operations support and technology infrastructure.
- Extensive working experience deploying and promoting database and application code to target environments, including development, test, UAT, pre-production, production, training, and other environments.
- Extensive working experience troubleshooting issues and incidents and solving problems.
- In-depth knowledge of Oracle Database Flashback technology.
- In-depth knowledge of database clustering solutions and Data Guard technologies.
- In-depth knowledge of database, operating system, and storage performance monitoring and tuning.
- Knowledge of data warehouse-related methodologies and processes.
Database Administration Responsibilities
Responsibilities Include, But Are Not Limited To, The Following
- Establish the needs of users.
- Monitor user access and security.
- Monitor performance and manage parameters to provide front-end users with fast query responses.
- Map the conceptual design for a planned database with outlines.
- Consider both the back-end organization of data and front-end accessibility for end users.
- Refine the logical design so it can be translated into a specific data model.
- Further refine the physical design to meet system storage requirements.
- Install and test new versions of the Relational Database Management System (RDBMS).
- Maintain data standards, including adherence to the Data Protection Act.
- Write database documentation, including data standards, procedures, and definitions for the data dictionary (metadata).
- Control access permissions and privileges.
- Develop, manage, and test backup and recovery plans.
- Ensure storage, archiving, backup, and recovery procedures are functioning correctly.
- Perform capacity planning.
- Work closely with IT project managers, database programmers, and multimedia programmers.
- Communicate regularly with technical, applications, and operational staff to ensure database integrity and security.
- Decommission and install new applications.
- Customize existing applications to make them fit for purpose.
Required Knowledge / Skills
Key Deliverables – Senior (Level 3) Technology Architect
The Key Deliverables To Be Performed By The Senior (Level 3) Technology Architect Include, But Are Not Limited To, The Following
- Demonstrated working experience with IBM TRIRIGA 3.7.x/10.7.x, WebSphere, and I.H.S installation, configuration, and cloning.
- Demonstrated working experience with IBM TRIRIGA application upgrades.
- Demonstrated working experience with Oracle Data Integrator 12.x installation, upgrades, migration, cloning, and administration.
- Demonstrated working experience with Hadoop installation and configuration on Linux Red Hat.
- Demonstrated working experience with Oracle 19c database migration.
- Demonstrated working experience with SQL Server 2016 and SSRS implementation.
- Demonstrated working experience with solution design and architecture for system and data integration.
- Establish the needs of users and monitor user access and security.
- Monitor performance and manage parameters to provide fast query responses to front-end users.
- Install and test new versions of the RDBMS.
- Maintain data standards, including adherence to the Data Protection Act.
- Write database documentation, including data standards, procedures, and definitions for the data dictionary (metadata).
- Control access permissions and privileges.
- Develop, manage, and test backup and recovery plans.
- Ensure storage, archiving, backup, and recovery procedures are functioning correctly.
- Demonstrate experience with database and server capacity planning.
- Have 10 years of experience with Oracle Database and related technology, including Oracle Real Application Cluster (RAC).
- Have several years of UNIX (Solaris) and Windows Server experience.
- Demonstrate working experience with troubleshooting, problem-solving, and performance tuning.
- Have solid experience in hardware and system software infrastructure architecture design.
- Possess in-depth knowledge of Oracle Database, clustering, Flashback, and Data Guard technologies.
- Demonstrate knowledge of database performance monitoring and tuning.
Communication and Management Skills
- Excellent analytical, problem-solving, and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills.
- Demonstrated experience in written and oral communication with a large number of stakeholders.
- Participate in planning activities, complete all required change request assessment tasks, and participate in release management activities.
- Demonstrate the ability to work with ambiguous and conflicting requirements and find pragmatic solutions acceptable to all stakeholders.
- Capture meeting minutes and follow up on action items.
Additional Resource Responsibilities
The resource will:
- Lead infrastructure-related activities, including patching and deployments.
- Support the entire suite of applications, including infrastructure-related work such as IAM modernization and analytics platform improvements, across all projects in the Data Product Services Branch. Support, influence, and impact the use of analytics and analytics strategy across the enterprise.
- Develop technical documentation to assist with branch activities, such as build books and programming specifications.
- Resolve and troubleshoot technical problems that arise during the use and operation of software packages, including providing technical assistance with implementation, conversion, and migrations.
- Bring extensive experience in database and middleware technology and support the branch in providing optimal solution support and delivering time-sensitive initiatives.
- Maintain the infrastructure required for DPS solutions, including infrastructure capacity planning and patching.
- Support CSC release and infrastructure solution support and sustainment activities, urgent priorities, changing needs, time-sensitive infrastructure upgrades, and other sustainment activities supporting any CSC platforms overseen by the Cluster where annual work is required.
Experience And Skill Set Requirements
- Database Skills – 50%
- Demonstrated 10 years of experience leading infrastructure scaling and planning initiatives.
- Demonstrated 10 years of experience with Oracle Database and related technology, including Oracle Real Application Cluster (RAC).
- Demonstrated experience with Oracle 19c or newer database administration, migration, and support.
- Demonstrated experience with SQL Server 2016 or newer and SSRS implementation.
- Demonstrated experience with DB2 9.7 Database Administration, backup, and recovery.
- Experience installing and testing new versions of the RDBMS.
- Demonstrated experience with database and server capacity planning.
- Demonstrated experience with Oracle Database, clustering, Flashback, and Data Guard technologies.
- Demonstrated experience in database performance monitoring and tuning.
- Demonstrated experience establishing user needs and monitoring user access and security.
- Demonstrated experience maintaining data standards, including adherence to the Data Protection Act.
- Experience writing database documentation, including data standards, procedures, and definitions for the data dictionary (metadata).
- Demonstrated experience controlling access permissions and privileges.
- Demonstrated experience developing, managing, and testing backup and recovery plans.
- Demonstrated experience troubleshooting, problem-solving, and performance tuning.
- Demonstrated experience monitoring performance and managing parameters to provide fast query responses to front-end users.
- Demonstrated experience ensuring that storage, archiving, backup, and recovery procedures are functioning correctly.
- Middleware Skills – 40%
- Demonstrated experience with IBM TRIRIGA 3.7.x/10.7.x, WebSphere, and I.H.S installation, configuration, and cloning.
- Demonstrated experience with IBM TRIRIGA application upgrades.
- Demonstrated experience with Oracle Data Integrator 12.x installation, upgrades, migration, cloning, and administration.
- Demonstrated experience with UNIX (Linux, Solaris, AIX) operating system administration.
- Demonstrated experience with Single Sign-On solutions and architecture.
- Demonstrated 10+ years of UNIX (Solaris) and Windows Server experience.
- Demonstrated experience in hardware and system software infrastructure architecture design.
- Communication Skills – 5%
- Excellent analytical, problem-solving, and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills.
- Proven knowledge and experience in written and oral communication with a large number of stakeholders.
- Participate in planning activities, complete all required change request assessment tasks, and participate in release management activities.
- Demonstrate the ability to work with ambiguous and conflicting requirements and find pragmatic solutions acceptable to all stakeholders.
- Capture meeting minutes and follow up on action items.
- Public Sector Experience – 5%
- Previous public-sector experience in an organization of equivalent size and complexity to the public sector.
How to Apply
If you are interested and your profile matches the requirements, kindly send the following mandatory documents to
hrsmss@smsoftconsulting.com by
Thursday, October 29, 2026, at 10:00 AM EST.
Mandatory Documents
- Updated Resume in Word format (Mandatory)
- References (Mandatory)
- Expected Hourly Rate (Mandatory)
- Visa Status (Mandatory)
- LinkedIn ID (Mandatory)
Without the mandatory documents, we cannot submit a candidate.
WhatsApp Group
For daily job updates, you can also join our WhatsApp group using the link below:
Join our WhatsApp Group
Additional Information
- Work Arrangement: Onsite – 5 days per week.
- Email is the best way to reach us.
You have received this message either as a result of contacting our company to express interest in employment or as a result of posting your resume in a location that can be accessed by recruiters or HR specialists, which suggests an interest in being contacted about employment opportunities.
