Responsibilities Develops, recommends, implements and manages the technical architecture (hardware, software, database and communications) which will be used for all or specific applications in a large, distributed cross-platform environment. Responsibilities also include the identification of relevant information and the determination of the environment, which will be used for development.General Skills Leadership experience in the development and implementation of technical architectures at the specified experience levelExtensive experience with at least three different platforms, operating systems, environments, database technologies, and communications protocolsExperience with middleware and gatewaysKnowledge of performance considerations in different environmentsExperience in structured methodologies for the design, development and implementation of applicationsExtensive experience in systems analysis and design in large systems environmentsKnowledge and experience designing processes around ITIL and is able to guide others using this methodologyExperience translating business requirements into reporting needsExperience preparing conceptual, logical and/or physical processes and data modelsExperience developing, recommending, implementing and managing technical architectureExperience in the use of Computer Aided Software Engineering (CASE) tools and other software tools such as project management toolsAwareness of emerging technologies, trends and directionsExcellent analytical, problem-solving and decision-making skills; verbal and written communication skills; interpersonal and negotiation skillsA team player with a track record for meeting deadlinesExperience in developing enterprise architecture deliverables (e.G. models)Experience with IAM modernization initiatives, utilizing technologies such as Microsoft Entra ID or Oracle IAM.Desirable Skills Experience in developing enterprise architecture deliverables (e.G. models) based on Ontario Government Enterprise Architecture processes and practiceKnowledge and understanding of Enterprise Content Management (Open Text ECM applications)Knowledge and understanding of Information Management principles, concepts, policies and practicesThe Services and Deliverables to be provided by the candidate will include the following: Provide Middleware development and operations support for ECIS solution running IBM IHS, Web Sphere and TRIRIGAProvide Oracle database and infrastructure support for Report and Validation (RV) data warehouse systemProvide Oracle database and Oracle Data Integrator (ODI) support to various data warehouse systemSolution design and architect for system and data integrationLead the planning of DDSB Server OS upgrade for Windows, Solaris and Linux serversLead the planning and execution of Oracle upgrade and migration project(s)Participate in planning activities and solution design; complete all required change request assessment tasks, Design Workbook and WIA; participate in DDSB andITS release management activitiesPerform capacity planning, database monitoring and performance tuning to all Oracle SQL Server databasesProvide support and solution design for Hadoop implementationProvide daily DBA support for all databases running in Oracle 19c on various development, test, pre-production and production environmentsPerform administrative tasks including but not limited to database backup and recovery, databases export and import, database maintenance, database management, monitoring database performance and tuning, etc.Update technical documentation including: Operation Manual documents, Technical Architecture documents, etc.Support RV SRSS implementation utilizing SQL Server 2016 database and Reporting ServicesSupport web-enable antivirus file upload scanning serverOther Experience and Skills: Extensive working experience with solution design and architect for IBM TRIRIGA System, IBM Web Sphere and I. H. SOver 10 years of experience with Oracle Database (11g R2, 12c R2, 19c) and technology, including Oracle Real Application Cluster (RAC)Over 10 years of UNIX (Solaris and Linux) and Windows Server experienceOver 10 years of experience supporting SQL Server (SQL Server 2016)Extensive working experience with solution design and architect for Single Sign-On solution utilizing OPS Go- Secure technologyExtensive working experience with solution design and architect for Oracle Data Integrator (ODI) and Oracle OBIEEExtensive working experience with solution design and architect for system and data integrationDemonstrated working experience with solution design and architect for enterprise web- enable anti-virus file scanning solutionDemonstrated working experience with solution design and architect for large scale (20 TB+)



Business Intelligence applicationsDemonstrated working experience with Hadoop software installation and configuration Infrastructure design including server commission, sizing and analysis for hardware and software; Previous public sector experience in an organization of equivalent size and complexity to the Ontario Public ServiceDemonstrated working experience with large-sized and complex middleware operations support and technology infrastructureExtensive working experience in the deployment/promotion of database and application codes to target environments (dev-test, UAT, Pre-PROD, PROD, Training and other environments)Extensive working experience in the troubleshooting of issues, incidents and problem solving; In-depth knowledge of Oracle database flashback technologyIn-depth knowledge of database clustering solution and data guard technologiesIn-depth knowledge of database, OS and storage performance monitoring and tuning Knowledge of data warehouse related methodologies and processesResponsibilities include, but are limited to, the following: Establish the needs of usersMonitor user access and securityMonitor performance and manage parameters to provide front-end users with fast query responsesMap conceptual design for a planned database with outlinesConsider both back-end organization of data and front-end accessibility for end-users Refine the logical design to be able to translate into a specific data modelFurther refine physical design to meet system storage requirementsInstalling and test recent versions of the RDBMSMaintain data standards, including adherence to the Data Protection ActWrite database documentation, including data standards, procedures and definitions for the data dictionary (metadata)Control access permissions and privilegesDevelop, manage, and test back-up and recovery plansEnsure that storage, archiving, back-up and recovery procedures are function correctly Capacity planningWork closely with IT project managers, database programmers, and multimedia programmersCommunicate regularly with technical, applications and operational staff to ensure database integrity and securityDecommission and install new applicationsCustomize existing applications in order to make them fit for purpose.Required Knowledge / Skills: 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, Web Sphere and I. H. S installation, configuration and cloningDemonstrated working experience with IBM TRIRIGA Application UpgradeDemonstrated working experience with Oracle Data Integrator 12.X installation, upgrade, migration, cloning and administrationDemonstrated working experience with Hadoop Installation and configuration on Linux Red HatDemonstrated working experience with Oracle 19c database migrationDemonstrated working experience with SQL Server 2016 and SSRS implementationDemonstrated working experience with solution design and architect for system and data integrationEstablishing the needs of users and monitoring user access and securityMonitoring performance and managing parameters to provide fast query responses to front- end usersInstalling and testing new versions of the RDBMSMaintaining data standards, including adherence to the Data Protection ActWriting database documentation, including data standards, procedures and definitions for the data dictionary (metadata)Controlling access permissions and privilegesDeveloping, managing and testing back-up and recovery plansEnsuring that storage, archiving, back-up and recovery procedures are functioning correctly Experience with Database and Server Capacity planning10 years of experience with Oracle Database and technology, including Oracle Real Application Cluster (RAC)Several years UNIX (Solaris) and Window Server experienceDemonstrated working experience with troubleshooting, problem solving and performance tuningSolid experience in hardware and system software infrastructure architecture designIn-depth knowledge of Oracle Database, clustering, flashback and Dataguard technologiesKnowledge of database performance monitoring and tuningCommunication and Management Skills Excellent analytical, problem-solving,



and decision-making skills; verbal and written communication skills; interpersonal and negotiation skillsDemonstrated experience in written and oral communication with a large number of stakeholdersParticipate in planning activities; complete all required change request assessment tasks; participate in release management activitiesDemonstrate ability to work with ambiguous and conflicting requirements and finding pragmatic solution which can be acceptable to all stakeholdersCapturing minutes of meetings and following up the action itemsExperience Requirements The resource will:Lead infrastructure related activities, including patching and deploymentsSupport the entire suite of applications, including infrastructure related work (e.G. IAM Modernization, analytics platform improvements, etc.), across all projects in the Data Product Services Branch. Support, influence and impact the use of analytics and strategy for analytics across the enterprise.Develop technical documentations to assist with branch activities, such as build books and programming specifications.Resolve and troubleshoot technical problems which arise during the use and operation of software packages, including technical assistance in implementation, conversion and migrations.Have extensive experience on database and middleware technology and is required to support the branch in providing optimal solution support and delivering on time sensitive initiatives.Maintain infrastructure required for DPS solutions, including infrastructure capacity planning and patching.The resources will also support CSC release, and infrastructure solutions support sustainment activities, urgent priorities, changing needs, or time-sensitive infrastructure upgrades, or other sustainment activities supporting any CSC platforms overseen by the Cluster where annual work is required.Evaluation Criteria: Database Skills – 50% Demonstrated 10 years of experience with leading infrastructure scaling and planning initiativesDemonstrated 10 years of experience with Oracle Database and technology, including Oracle Real Application Cluster (RAC)Demonstrated experience with Oracle 19c (or newer) database administration, migration and supportDemonstrated experience with SQL Server 2016 (or newer) and SSRS implementationDemonstrated experience with DB2 9.7 Database Administration, backup and recovery Experience installing and testing new versions of the RDBMSDemonstrated experience with Database and Server Capacity planningDemonstrated experience of Oracle Database, clustering, flashback and Dataguard technologiesDemonstrated experience of database performance monitoring and tuningDemonstrated experience establishing the needs of users and monitoring user access and securityDemonstrated experience maintaining data standards, including adherence to the Data Protection Act Writing database documentation, including data standards, procedures and definitions for the data dictionary (metadata)Demonstrated experience controlling access permissions and privilegesDemonstrated experience developing, managing and testing back-up and recovery planDemonstrated experience with troubleshooting, problem solving and performance tuningDemonstrated experience monitoring performance and managing parameters to provide fast query responses to front-end usersDemonstrated experience ensuring that storage, archiving, back-up and recovery procedures are functioning correctlyMiddleware Skills – 40% Demonstrated experience with IBM TRIRIGA 3.7.X/10.7.X, Web Sphere and I. H. S installation, configuration and cloningDemonstrated experience with IBM TRIRIGA Application UpgradeDemonstrated experience with Oracle Data Integrator 12.X installation, upgrade, migration, cloning and administrationDemonstrated experience with Oracle Data Integrator 12.X installation, upgrade, migration, cloning and administrationDemonstrated experience with Oracle Data Integrator 12.X installation, upgrade, migration, cloning and administrationDemonstrated experience with Oracle Data Integrator 12.X installation, upgrade, migration, cloning and administrationDemonstrated experience with Oracle Data Integrator 12.X installation, upgrade, migration, cloning and administrationCommunication Skills – 5% Excellent analytical, problem-solving, and decision-making skills; verbal and written communication skills; interpersonal and negotiation skillsDemonstrated knowledge and experience in written and oral communication with a large number of stakeholdersParticipate in planning activities; complete all required change request assessment tasks; participate in release management activitiesDemonstrate ability to work with ambiguous and conflicting requirements and finding pragmatic solution which can be acceptable to all stakeholdersCapturing minutes of meetings and following up the action itemsPublic Sector Experience – 5% Previous public sector experience in an organization of equivalent size and complexity to the Public SectorSupplier Comments Closing Date/Time:, 12:00 p.M.Max submission: 1 (one)5 days onsitePlease refer to job description and requirements.#J-18808-Ljbffr

📌 Technology Architect (Rq11599) Community Services Cluster (Winnipeg)
🏢 Softline Technology
📍 Winnipeg