Senior Technology Architect – Database & Middleware Infrastructure

• Lead database infrastructure architecture, scaling, capacity planning, implementation, administration, and ongoing operational support.
  
• Provide extensive Oracle Database administration and architecture support, including Oracle 11gR2, 12cR2, and 19c or newer.
  
• Administer, configure, migrate, upgrade, and support Oracle databases across development, test, UAT, pre-production, production, training, and other environments.
  
• Design, implement, and maintain Oracle Real Application Clusters (RAC), Data Guard, database clustering, and Flashback technologies.
  
• Perform database monitoring, performance analysis, SQL tuning, troubleshooting, and optimization to ensure reliable and responsive applications.
  
• Lead Oracle database upgrade and migration initiatives, including planning, implementation, testing, validation, and deployment.
  
• Support Microsoft SQL Server 2016 or newer, including database administration, migration, performance tuning, and SQL Server Reporting Services (SSRS) implementation.
  
• Provide DB2 9.7 database administration, backup, recovery, and operational support.
  
• Develop, manage, and test database backup, recovery, restoration, archiving, and disaster recovery procedures.
  
• Perform database export and import, maintenance, cloning, installation, configuration, and lifecycle management activities.
  
• Monitor storage utilization, database health, server capacity, and performance metrics; proactively identify and resolve infrastructure bottlenecks.
  
• Establish and maintain database security controls, user access permissions, privileges, and access monitoring.
  
• Maintain data standards and metadata, including data dictionaries, database definitions, operating procedures, and compliance with applicable data protection requirements.
  
• Ensure database storage, backup, recovery, and archiving processes operate effectively and reliably.
  

• Design, implement, configure, upgrade, clone, and support IBM TRIRIGA 3.7.x/10.7.x, IBM WebSphere Application Server, and IBM HTTP Server (IHS).
  
• Provide hands-on IBM TRIRIGA application installation, configuration, upgrade, cloning, deployment, troubleshooting, and operational support.
  
• Support middleware development and operations for enterprise solutions using IBM IHS, WebSphere, and TRIRIGA.
  
• Install, configure, upgrade, migrate, clone, administer, and support Oracle Data Integrator (ODI) 12.x.
  
• Support Oracle Business Intelligence Enterprise Edition (OBIEE) and Oracle-based data warehouse solutions.
  
• Design and implement enterprise middleware, application integration, and data integration architectures.
  
• Support large-scale middleware environments, including troubleshooting, incident resolution, release management, and application code promotion across multiple environments.
  
• Lead infrastructure-related patching, software deployments, server upgrades, and application infrastructure modernization activities.
  
• Design and support Single Sign-On (SSO) solutions, including architecture and integration with Ontario Public Service (OPS) Go-Secure technology.
  
• Contribute to Identity and Access Management (IAM) modernization initiatives, including solutions utilizing Microsoft Entra ID or Oracle IAM.
  
• Support enterprise web-enabled antivirus file-upload scanning solutions, including architecture, configuration, integration, and operational troubleshooting.
  

• Lead infrastructure planning, server capacity assessments, sizing, scaling, upgrades, patching, deployment, and lifecycle management.
  
• Demonstrate extensive administration experience across UNIX environments, including Solaris, Linux/Red Hat, and AIX, as well as Microsoft Windows Server.
  
• Lead planning and execution of server operating system upgrades across Windows, Solaris, and Linux environments.
  
• Design and implement hardware and system software infrastructure architectures that support enterprise applications, middleware, and database platforms.
  
• Perform server, operating system, database, and storage performance monitoring and tuning.
  
• Support server commissioning, infrastructure sizing, environment configuration, system migrations, and software installations.
  
• Develop and maintain infrastructure solutions that meet availability, performance, security, scalability, and operational requirements.
  
• Support Hadoop installation and configuration on Red Hat Linux, including infrastructure design, hardware and software sizing, server commissioning, and implementation analysis.
  
• Support large-scale business intelligence and analytics platforms, including environments with data volumes exceeding 20 TB.
  
• Provide infrastructure sustainment and operational support for existing applications and platforms managed by the Community Services Cluster.
  

• Design and architect enterprise system and data integration solutions across database, middleware, reporting, and analytics platforms.
  
• Provide Oracle database and infrastructure support for the Report and Validation (RV) data warehouse system.
  
• Support Oracle Data Integrator and related technologies across multiple data warehouse environments.
  
• Support the implementation and maintenance of RV SRSS using SQL Server 2016 and SQL Server Reporting Services.
  
• Contribute to Hadoop implementation and enterprise analytics infrastructure initiatives.
  
• Translate business and user requirements into technical architecture, data models, reporting needs, and implementation specifications.
  
• Develop conceptual, logical, and physical data models and support data warehouse methodologies and processes.
  
• Establish technical solutions that improve data accessibility, reporting performance, system integration, and operational reliability.
  

• Develop, recommend, implement, and manage technical architectures for large, distributed, cross-platform enterprise environments.
  
• Lead solution design and architecture activities covering hardware, software, databases, middleware, communications, integration, and security.
  
• Develop enterprise architecture deliverables, technical models, infrastructure build books, technical architecture documents, operation manuals, and programming specifications.
  
• Participate in architecture reviews, technical planning, solution assessments, change request evaluations, and implementation planning.
  
• Complete required Design Workbooks, Work Implementation Assessments (WIA), and other technical governance documentation.
  
• Support release management activities across the Community Services Cluster and Information Technology Services (ITS).
  
• Apply structured methodologies for systems analysis, design, development, testing, implementation, and maintenance.
  
• Apply ITIL principles to incident management, change management, release management, problem management, and service operations.
  
• Use relevant architecture, CASE, database management, and project management tools to support technical delivery.
  
• Maintain awareness of emerging technologies, architecture standards, infrastructure trends, and technology modernization practices.
  
• Where applicable, align enterprise architecture deliverables with Ontario Government Enterprise Architecture processes and practices.
  
• Apply information management principles, policies, standards, and practices, including relevant knowledge of OpenText Enterprise Content Management (ECM) where applicable.
  

• Diagnose and resolve complex database, middleware, operating system, infrastructure, application, and integration issues.
  
• Provide timely technical assistance for implementation, conversion, migration, deployment, and production support activities.
  
• Monitor application and database performance, security, availability, and operational health.
  
• Support secure database administration, access control, backup and recovery, data protection, and infrastructure management.
  
• Manage technical incidents, investigate root causes, implement corrective actions, and recommend preventative measures.
  
• Support decommissioning and installation of applications and customization of existing applications where required.
  
• Provide operational support for urgent priorities, changing business needs, time-sensitive upgrades, and sustainment activities across CSC platforms.
  
• Ensure infrastructure and database changes follow approved change management and release management processes.
  

• Establish and clarify user needs and translate business requirements into practical technical solutions.
  
• Lead infrastructure and architecture activities while coordinating with project managers, database administrators, developers, application teams, operations personnel, and other stakeholders.
  
• Communicate complex technical issues, architecture decisions, risks, and recommendations clearly to technical and non-technical audiences.
  
• Manage ambiguous or conflicting requirements and develop pragmatic solutions acceptable to stakeholders.
  
• Participate in planning meetings, document meeting minutes, track action items, and follow up on outstanding deliverables.
  
• Demonstrate strong analytical, problem-solving, decision-making, interpersonal, negotiation, and written and verbal communication skills.
  
• Work collaboratively across multiple initiatives while meeting deadlines and supporting time-sensitive operational requirements.
  

Requirements

1. At least 10 years of experience leading infrastructure scaling, capacity planning, and infrastructure planning initiatives.
   
2. At least 10 years of experience with Oracle Database technologies, including Oracle Real Application Clusters (RAC).
   
3. Demonstrated experience administering, migrating, upgrading, and supporting Oracle Database 19c or newer.
   
4. Demonstrated experience with Microsoft SQL Server 2016 or newer and SQL Server Reporting Services (SSRS) implementation.
   
5. Demonstrated experience with DB2 9.7 database administration, backup, and recovery.
   
6. Experience installing, configuring, upgrading, and testing new versions of relational database management systems (RDBMS).
   
7. Demonstrated experience with database and server capacity planning.
   
8. In-depth knowledge and practical experience with Oracle clustering, Flashback, and Data Guard technologies.
   
9. Demonstrated experience with database performance monitoring, troubleshooting, SQL tuning, and performance optimization.
   
10. Experience establishing user requirements and monitoring database access, security, permissions, and privileges.
    
11. Experience maintaining data standards, metadata, database documentation, procedures, and data dictionary definitions, including adherence to applicable data protection requirements.
    
12. Demonstrated experience developing, managing, testing, and maintaining backup, recovery, restoration, storage, and archiving procedures.
    
13. Experience monitoring and managing database parameters to provide fast query responses to front-end users.
    
14. Demonstrated experience resolving complex database incidents and ensuring database integrity, availability, and reliability.
    

1. Demonstrated experience with IBM TRIRIGA 3.7.x/10.7.x, IBM WebSphere, and IBM HTTP Server (IHS) installation, configuration, and cloning.
   
2. Demonstrated experience upgrading IBM TRIRIGA applications.
   
3. Demonstrated experience with Oracle Data Integrator (ODI) 12.x installation, upgrade, migration, cloning, administration, and support.
   
4. Demonstrated UNIX and Linux operating system administration, including Linux, Solaris, and AIX.
   
5. Demonstrated experience designing, implementing, and supporting Single Sign-On (SSO) solutions and architecture, including OPS Go-Secure technology.
   
6. At least 10 years of UNIX (Solaris) and Windows Server experience.
   
7. Demonstrated experience in hardware and system software infrastructure architecture design.
   
8. Demonstrated experience architecting system integration and data integration solutions.
   
9. Demonstrated experience with Oracle OBIEE, data warehouse infrastructure, and enterprise analytics platforms.
   
10. Demonstrated experience with Hadoop installation and configuration on Red Hat Linux.
    
11. Demonstrated experience supporting enterprise web-enabled antivirus file-scanning solutions.
    
12. Experience with application and database code deployment, promotion, cloning, migration, and release management across development, test, UAT, pre-production, production, and training environments.
    
13. Experience supporting complex middleware operations, troubleshooting, infrastructure patching, and application sustainment activities.
    

1. Excellent analytical, problem-solving, and decision-making skills.
   
2. Strong written and verbal communication skills, including experience communicating with a large number of stakeholders.
   
3. Demonstrated experience participating in planning activities, assessing change requests, and supporting release management.
   
4. Ability to resolve ambiguous or conflicting requirements and recommend pragmatic technical solutions.
   
5. Experience documenting meetings, capturing minutes, tracking action items, and following up with stakeholders.
   
6. Strong interpersonal, negotiation, collaboration, and technical leadership skills.
   

1. Previous experience working in the public sector within an organization of equivalent size and complexity to the Ontario Public Service.
   
2. Familiarity with enterprise IT governance, change management, release management, security, and operational procedures in a large public-sector environment.
   

• Leadership in developing and implementing technical architectures at a senior or Level 3 experience level.
  
• Extensive experience across at least three different platforms, operating systems, environments, database technologies, and communications protocols.
  
• Experience with middleware, gateways, structured systems development methodologies, and large-scale systems analysis and design.
  
• Knowledge of performance considerations across different technology environments.
  
• Experience translating business requirements into reporting requirements and preparing conceptual, logical, and physical data models.
  
• Experience with ITIL-based processes and the ability to guide others in applying them.
  
• Experience producing enterprise architecture deliverables and technical models.
  
• Experience with IAM modernization using technologies such as Microsoft Entra ID or Oracle IAM.
  

• Experience developing enterprise architecture deliverables using Ontario Government Enterprise Architecture processes and practices.
  
• Knowledge of OpenText Enterprise Content Management (ECM) applications.
  
• Knowledge of information management principles, concepts, policies, and practices.
  

• Full-time engagement at 100% allocation.
  
• Mandatory onsite presence at 777 Bay Street, Toronto, Ontario, five days per week.
  
• Contract period from October 26, 2026, to October 5, 2027, with one possible extension term.
  
• Support across multiple environments, including development, testing, UAT, pre-production, production, and training.
  
• Participation in infrastructure upgrades, migrations, patching, deployments, release management, and operational sustainment.
  
• Ability to respond to urgent priorities and time-sensitive technical initiatives.
  
• No security clearance is specified as a requirement.