Middleware Administrator - Ottawa, ON, Canada - CGI Njoyn

Description

We are an organization comprised of industry thought leaders who are passionate about health data and want to make a difference in the health care field. We are an independent, not-for-profit organization and together with our partners we provide essential information on Canada's health systems, enabling decisions that lead to healthier Canadians. As a valued member of the CIHI team, you and your work will have a pivotal role in the evolution of Canada's health care systems.

CIHI is recognized as an exceptional place to work that embraces diversity, respect, integrity, collaboration and innovation. Learn about our Equity, Diversity and Inclusion Strategy and the work being done to create a more inclusive and welcoming organization by focusing on how we learn, govern and practise.

At CIHI, we recognize what matters to our employees. Some of the benefits of working at CIHI include

• Retirement Planning Program
• Generous vacation days for permanent and long-term contracts
• Work-life balance
• Learning and Professional Development Program
• Flexible benefits program from your first day on the job for permanent and long-term contracts

Why is this role important?

Under the direction of the Manager, the middleware administrator is responsible for the configuration, deployment, optimization, and upkeep of CIHI's software middleware infrastructure including Informatica and AWS data services etc. Working within the Technology Services department, this position will work with stakeholders throughout the ITS Division to design, plan, implement and support CIHI's technical architecture.

What you'll do

1. Designs, plans, implements, and maintains CIHI's technical architecture including environments for development, staging and production activities using CIHI's standard technologies (e.g. Informatica, AWS data services etc.).
2. Leads Informatica administrative activities including but not limited to: planning ETL hardware and software license activities, supporting server/application configuration, deployment and execution in Middleware environments, ensuring the resolution of ETL related technical issues in a time-sensitive/priority sensitive manner.
3. Installs and configures middleware on-prem software such as Informatica; setup and optimize AWS data services for ETL related jobs.
4. Plans and executes configuration changes, patch management and day-to-day administration/monitoring of the middleware infrastructure.
5. Supports CIHI's Information Security Management System (ISMS) through the implementation, management and/or monitoring of required Information Security controls.
6. Participates in key ISMS processes as required, including but not limited to Risk Management, Audit and Assessment, Monitoring and Reporting and Record Management.
7. Works directly with other Architecture staff to solve on-going middleware architecture and software problems, performs troubleshooting, performance, and security tuning activities of the technical environments.
8. Researches, drafts, develops, and implements policies, procedures, and best practices for application deployment, change control and strategic recommendations relating to the resolution of middleware support issues.
9. Participates on project teams to ensure application development activities adhere to proper deployment, installation, and configuration of middleware software.
10. Participates in the architectural design of systems.
11. Supervises, provides technical advice and guidance and coaching to project/program staff assigned to middleware support activities; and provides input on performance evaluations, monitors workload and allocates work as appropriate.
12. Other duties as required.

What you'll bring to the table

• Undergraduate degree in Computer Science, Mathematics, or related discipline.

• Minimum five (5) years' experience in a senior technical analytical position responsible for administration of complex Middleware Server environments.

• ITIL v3 fundamentals certification is an asset.

• Strong knowledge and experience with ETL tools, such as Informatica, AWS data services, Ab Initio or Oracle Warehouse Builder.

• Knowledge of AWS cloud, experiences with AWS services such as EMR, Glue, S3, Lake formation, IAM etc.

• Knowledge of Oracle, RedShift and MySQL RDBMS, network protocols and firewalls.

• Demonstrated expertise in Linux Shell Scripting (BASH/KSH, SED, AWK).

• Experience with system hardening and demonstrated knowledge of security best practices and techniques.

• Experience in for Data Warehouse/ETL technical design concepts, as well as a familiarity with Dimensional Modelling technique is a definite asset.

• Experience with data warehouse performance tuning of very large databases in an Oracle environment is an asset.

• Exposure or experience with CIHI data holdings or other healthcare data holdings is a definite asset

• Excellent interpersonal skills and communication skills, both written and oral with the ability to communicate effectively with users, management, and technical staff.

• Availability to meet minimum off-hours support requirements (occasional variable work hours) – patching, vulnerability mgmt.- Very occasional( twice or thrice a year)- Not on call

• Fluency in both official languages is an asset.

To find out more about this role and other exciting opportunities visit our website at and check out our 'Careers' section.

We thank all those who apply, however, only candidates selected for an interview will be contacted.

At CIHI we are committed to fostering an inclusive, barrier-free and accessible environment. Part of this commitment includes arranging accommodations to ensure an equitable opportunity to participate in the recruitment and selection process. If you require an accommodation, we will work with you to meet your needs.

Please note the CIHI Recruiting Team uses email to communicate with applicants. Please make sure your profile has an updated email address that is checked regularly, including the junk/spam mail folder, as we send time sensitive emails (i.e. testing and interview bookings).