Job Description:
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.

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.

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:

• 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 Client, 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 client 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 client.
• 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.
• 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.

Experience and Skill Set Requirements:

• Database Skills 50%.
• Demonstrated 10 years of experience with leading infrastructure scaling and planning initiatives.
• 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 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%:

• Proven knowledge and experience in written and oral communication with a large number of stakeholders.

Public Sector Experience - 5%:

• Previous public sector experience in an organization of equivalent size and complexity to the Public Sector.