RQ11599 - Technology Architect (Oracle, with IBM TRIRIGA, WebSphere)

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.

Technology Architect/Database Administrator MUST HAVE the following skills and experience:

· Extensive working experience with solution design and architect for IBM TRIRIGA System, IBM WebSphere and I.H.S

· Over 10 years of experience with Oracle Database (11gR2, 12cR2, 19c) and 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 architect for Single Sign-On solution utilizing OPS Go- Secure technology

· Extensive working experience with solution design and architect for Oracle Data Integrator (ODI) and Oracle OBIEE

· Extensive working experience with solution design and architect for system and data integration

· Demonstrated working experience with solution design and architect for enterprise web- enable anti-virus file scanning solution

· Demonstrated working experience with solution design and architect for large scale (20TB+) Business Intelligence applications

· Demonstrated 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 Service

· Demonstrated working experience with large-sized and complex middleware operations support and technology infrastructure

· Extensive 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 technology

· In-depth knowledge of database clustering solution and data guard technologies

· In-depth knowledge of database, OS and storage performance monitoring and tuning Knowledge of data warehouse related methodologies and processes

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 in 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 is able 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 in the use of 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 for meeting deadlines

• Experience in developing enterprise architecture deliverables (e.g. models)

• Experience with IAM modernization initiatives, utilizing technologies such as Microsoft Entra ID or Oracle IAM.