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.
