11804

Maarut; Toronto; On-site; CAD 120,000 - 160,000; Full time

Job summary

Maarut seeks an experienced Technology Architect and Database Administrator to lead enterprise architecture initiatives across a large cross‑platform environment in Ontario. You will guide middleware, IAM modernization, data integration, and BI platform support across Windows, UNIX, and Linux, working with Oracle, SQL Server, and TRIRIGA/WebSphere.

A proven track record in enterprise data modeling, performance tuning, ITIL-aligned processes, and delivering complex solutions is required.

Qualifications

• 10+ years of Oracle Database experience (11gR2,12cR2,19c) and related technologies.
• Over 10 years of UNIX (Solaris/Linux) and Windows Server experience.
• Extensive experience with IBM TRIRIGA, WebSphere and IHS installations, configurations, and cloning.
• Strong troubleshooting and performance tuning capabilities across large-scale environments.

Responsibilities

• Lead design and architecture for system and data integration.
• Monitor performance and manage parameters to ensure fast query responses.
• Install and test new versions of RDBMS and ensure data standards compliance.
• Develop, manage, and test back-up and recovery plans for databases.
• Provide middleware development and operations support for critical solutions.
• Coordinate release management activities and change assessments.

Skills

Enterprise architecture

Oracle Database

UNIX/Linux

Windows Server

SQL Server

Oracle RAC

Data integration

Tools

Oracle Data Integrator

IBM WebSphere

TRIRIGA

ODI

Job description

• Develops, recommends, implements and manages the technicalarchitecture (hardware, software, database and communications) which will beused for all or specific applications in a large, distributed cross-platformenvironment. Responsibilities also include the identification of relevantinformation and the determination of the environment, which will be used fordevelopment.
  

General Skills:

• Leadership experience in the development and implementationof technical architectures at the specified experience level
  
• Extensive experience with at least three differentplatforms, operating systems, environments, database technologies, andcommunications protocols
  
• Experience with middleware and gateways
  
• Knowledge of performance considerations in differentenvironments
  
• Experience in structured methodologies for the design,development and implementation of applications
  
• Extensive experience in systems analysis and design in largesystems environments
  
• Knowledge and experience designing processes around ITIL andis able to guide others using this methodology
  
• Experience translating business requirements into reportingneeds
  
• Experience preparing conceptual, logical and/or physicalprocesses and data models
  
• Experience developing, recommending, implementing andmanaging 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-makingskills; verbal and written communication skills; interpersonal and negotiationskills
  
• A team player with a track record for meeting deadlines
  
• Experience in developing enterprise architecturedeliverables (e.g. models)
  
• Experience with IAM modernization initiatives, utilizingtechnologies such as Microsoft Entra ID or Oracle IAM.
  
• Experience in developing enterprise architecturedeliverables (e.g. models) based on Ontario Government Enterprise Architectureprocesses and practice
  
• Knowledge and understanding of Enterprise Content Management(Open Text ECM applications)
  
• Knowledge and understanding of Information Managementprinciples, concepts, policies and practices
  

The Services and Deliverables to be provided by thecandidate will include the following:

• Provide Middleware development and operations support forECIS solution running IBM IHS, WebSphere and TRIRIGA
  
• Provide Oracle database and infrastructure support forReport 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 dataintegration
  
• Lead the planning of DDSB Server OS upgrade for Windows,Solaris and Linux servers
  
• Lead the planning and execution of Oracle upgrade andmigration 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 andperformance tuning to all Oracle SQL Server databases
  
• Provide support and solution design for Hadoopimplementation
  
• Provide daily DBA support for all databases running inOracle 19c on various development, test, pre-production and productionenvironments
  
• Perform administrative tasks including but not limited todatabase backup and recovery, databases export and import, databasemaintenance, database management, monitoring database performance and tuning,etc.
  
• Support RV SRSS implementation utilizing SQL Server 2016database and Reporting Services
  
• Support web-enable antivirus file upload scanning server
  

Other Experience and Skills:

• Technology Architect/Database Administrator must have thefollowing skills and experience:
  
• Extensive working experience with solution design andarchitect 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 Serverexperience
  
• Over 10 years of experience supporting SQL Server (SQLServer 2016)
  
• Extensive working experience with solution design andarchitect for Single Sign-On solution utilizing OPS Go- Secure technology
  
• Extensive working experience with solution design andarchitect for Oracle Data Integrator (ODI) and Oracle OBIEE
  
• Extensive working experience with solution design andarchitect for system and data integration
  
• Demonstrated working experience with solution design andarchitect for enterprise web- enable anti-virus file scanning solution
  
• Demonstrated working experience with solution design andarchitect for large scale (20TB+) Business Intelligence applications
  
• Demonstrated working experience with Hadoop softwareinstallation and configuration Infrastructure design including servercommission, sizing and analysis for hardware and software;
  
• Previous public sector experience in an organization ofequivalent size and complexity to the Ontario Public Service
  
• Demonstrated working experience with large-sized and complexmiddleware operations support and technology infrastructure
  
• Extensive working experience in the deployment/promotion ofdatabase and application codes to target environments (dev-test, UAT, Pre-PROD,PROD, Training and other environments)
  
• Extensive working experience in the troubleshooting ofissues, incidents and problem solving;
  
• In-depth knowledge of Oracle database flashback technology
  
• In-depth knowledge of database clustering solution and dataguard technologies
  
• In-depth knowledge of database, OS and storage performancemonitoring and tuning Knowledge of data warehouse related methodologies andprocesses
  

Responsibilities include, but are limited to, the following:

• Establish the needs of users
  
• Monitor user access and security
  
• Monitor performance and manage parameters to providefront-end users with fast query responses
  
• Map conceptual design for a planned database with outlines
  
• Consider both back-end organization of data and front-endaccessibility for end-users Refine the logical design to be able to translateinto a specific data model
  
• Further refine physical design to meet system storagerequirements
  
• Installing and test new versions of the RDBMS
  
• Maintain data standards, including adherence to the DataProtection 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 recoveryprocedures are function correctly Capacity planning
  
• Work closely with IT project managers, database programmers,and multimedia programmers
  
• Communicate regularly with technical, applications andoperational staff to ensure database integrity and security
  
• Decommission and install new applications
  
• Customize existing applications in order to make them fitfor 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 TRIRIGA3.7.x/10.7.x, WebSphere and I.H.S installation, configuration and cloning
  
• Demonstrated working experience with IBM TRIRIGA ApplicationUpgrade
  
• Demonstrated working experience with Oracle Data Integrator12.x installation, upgrade, migration, cloning and administration
  
• Demonstrated working experience with Hadoop Installation andconfiguration on Linux RedHat
  
• Demonstrated working experience with Oracle 19c databasemigration
  
• Demonstrated working experience with SQL Server 2016 andSSRS implementation
  
• Demonstrated working experience with solution design andarchitect for system and data integration
  
• Establishing the needs of users and monitoring user accessand security
  
• Monitoring performance and managing parameters to providefast query responses to front- end users
  
• Installing and testing new versions of the RDBMS
  
• Maintaining data standards, including adherence to the DataProtection 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 recoveryprocedures are functioning correctly Experience with Database and ServerCapacity 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 softwareinfrastructure architecture design
  
• In-depth knowledge of Oracle Database, clustering, flashbackand Dataguard technologies
  
• Knowledge of database performance monitoring and tuning
  

Communication and Management Skills:

• Excellent analytical, problem-solving, and decision-makingskills; verbal and written communication skills; interpersonal and negotiationskills
  
• Demonstrated experience in written and oral communicationwith a large number of stakeholders
  
• Participate in planning activities; complete all requiredchange request assessment tasks, participate in release management activities
  
• Demonstrate ability to work with ambiguous and conflictingrequirements and finding pragmatic solution which can be acceptable to allstakeholders
  
• Capturing minutes of meetings and following up the actionitems
  

Requirements

Experience and Skill Set Requirements:

Skill Set Requirements:

The resource will:

• Lead infrastructure related activities, including patchingand deployments
  
• Support the entire suite of applications, includinginfrastructure related work (e.g. IAM Modernization, analytics platformimprovements, etc.), across all projects in the Data Product Services Branch.Support, influence and impact the use of analytics and strategy for analyticsacross the enterprise.
  
• Develop technical documentations to assist with branchactivities, such as build books and programming specifications.
  
• Resolve and troubleshoot technical problems which ariseduring the use and operation of software packages, including technicalassistance in implementation, conversion and migrations.
  
• Have extensive experience on database and middlewaretechnology and is required to support the branch in providing optimal solutionsupport 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, andinfrastructure solutions support sustainment activities, urgent priorities,changing needs, or time-sensitive infrastructure upgrades, or other sustainmentactivities supporting any CSC platforms overseen by the Cluster where annualwork is required.
  

Database Skills:

• Demonstrated 10 years of experience with leadinginfrastructure scaling and planning initiatives
  
• Demonstrated 10 years of experience with Oracle Database andtechnology, including Oracle Real Application Cluster (RAC)
  
• Demonstrated experience with Oracle 19c (or newer) databaseadministration, migration and support
  
• Demonstrated experience with SQL Server 2016 (or newer) andSSRS implementation
  
• Demonstrated experience with DB2 9.7 DatabaseAdministration, backup and recovery Experience installing and testing newversions of the RDBMS
  
• Demonstrated experience with Database and Server Capacityplanning
  
• Demonstrated experience of Oracle Database, clustering,flashback and Dataguard technologies
  
• Demonstrated experience of