Production Support Engineer II (SQL/Linux)
Core
Support CIBC's anti-money laundering (AML) platform built on SAS Viya 3.5, handling incident resolution, database queries, and release management for customer risk rating and regulatory reporting.
Role type
Mid-level IC production support engineer (SQL/Linux)
Builds
SAS Viya 3.5 AML platform for customer risk rating, transaction monitoring, and regulatory reporting
Domain
Banking / Financial Services / Risk Technology
Deliverable
production ML models
Required skills
SQL query writing, Linux CLI, incident management (ITIL), ETL pipeline troubleshooting, release management, disaster recovery testing
Preferred skills
Azure cloud management, SAS Viya administration, PostgreSQL database management
Technologies
SAS Viya 3.5, Linux, PostgreSQL, Microsoft Azure, SQL
Responsibilities
Investigate application issues and implement root cause solutions; write complex SQL queries and troubleshoot ETL pipelines; manage Linux VMs and PostgreSQL on Azure; oversee production changes and bug fixes; perform disaster recovery tests
Seniority
Mid-level, hands-on IC