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 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.
Desirable Skills
Experience in developing enterprise architecture deliverables (e.g. models) based on Ontario Government Enterprise Architecture processes and practice
Knowledge and understanding of Enterprise Content Management (Open Text ECM applications)
Knowledge and understanding of Information Management principles, concepts, policies and practices
The 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, WebSphere and TRIRIGA
- Provide Oracle database and infrastructure support for Report and Validation (RV) data warehouse system
- Provide Oracle database and Oracle Data Integrator (ODI) support to various data warehouse system
- Solution design and architect for system and data integration
- Lead the planning of DDSB Server OS upgrade for Windows, Solaris and Linux servers
- Lead 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 and ITS release management activities
- Perform capacity planning, database monitoring and performance tuning to all Oracle SQL Server databases
- Provide support and solution design for Hadoop implementation
- Provide daily DBA support for all databases running in Oracle 19c on various development, test, pre-production and production environments
- Perform 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 Services
- Support web-enable antivirus file upload scanning server
Other Experience and Skills:
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
Responsibilities include, but are 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 conceptual design for a planned database with outlines
- Consider 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 model
- Further refine physical design to meet system storage requirements
- Installing 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 back-up and recovery plans
- Ensure that storage, archiving, back-up, and recovery procedures are function correctly 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 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, WebSphere and I.H.S installation, configuration and cloning
- Demonstrated working experience with IBM TRIRIGA Application Upgrade
- Demonstrated working experience with Oracle Data Integrator 12.x installation, upgrade, migration, cloning and administration
- Demonstrated working experience with Hadoop Installation and configuration on Linux RedHat
- 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 architect for system and data integration
- Establishing the needs of users and monitoring user access and security
- Monitoring performance and managing parameters to provide fast query responses to front- end users
- Installing and testing new versions of the RDBMS
- Maintaining data standards, including adherence to the Data Protection Act
- Writing database documentation, including data standards, procedures and definitions for the data dictionary (metadata)
- Controlling access permissions and privileges
- Developing, managing and testing back-up and recovery plans
- Ensuring that storage, archiving, back-up and recovery procedures are functioning correctly Experience with Database and Server Capacity planning
- 10 years of experience with Oracle Database and technology, including Oracle Real Application Cluster (RAC)
- Several years UNIX (Solaris) and Window Server experience
- Demonstrated working experience with troubleshooting, problem solving and performance tuning
- Solid experience in hardware and system software infrastructure architecture design
- In-depth knowledge of Oracle Database, clustering, flashback and Dataguard technologies
- 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; participate in release management activities
- Demonstrate ability to work with ambiguous and conflicting requirements and finding pragmatic solution which can be acceptable to all stakeholders
- Capturing minutes of meetings and following up the action items
SkillsExperience and Skill Set Requirements
Database Skills 50%
- Demonstrated 10 years of experience with leading infrastructure scaling and planning initiatives
- Demonstrated 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 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 of Oracle Database, clustering, flashback and Dataguard technologies
- Demonstrated experience of database performance monitoring and tuning
- Demonstrated experience establishing the needs of users and monitoring user access and security
- Demonstrated 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 privileges
- Demonstrated experience developing, managing and testing back-up and recovery plan
- Demonstrated experience with 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, back-up 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 Upgrade
- Demonstrated experience with Oracle Data Integrator 12.x installation, upgrade, migration, cloning and administration
- Demonstrated experience with Unix (Linux, Solaris, Aix) OS administration
- Demonstrated experience with Single Sign-On solution and architecture
- Demonstrated 10+ years UNIX (Solaris) and Window 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; participate in release management activities
- Demonstrate ability to work with ambiguous and conflicting requirements and finding pragmatic solution which can be acceptable to all stakeholders
- Capturing minutes of meetings and following up the action items
Public Sector Experience - 5%
- Previous public sector experience in an organization of equivalent size and complexity to the Public Sector
MUST HAVES:
- Demonstrated 10 years of experience with leading infrastructure scaling and planning initiatives
Demonstrated experience with Database and Server Capacity planning
- Demonstrated experience with IBM TRIRIGA 3.7.x/10.7.x, WebSphere and I.H.S installation, configuration and cloning
Originally posted on