Specialist, Site Reliability Engineering - Platform and Data

HRB; Toronto; On-site; CAD 80,000 - 110,000; Full time

Job summary

A leading company in the finance sector is seeking a Specialist in Site Reliability Engineering to support critical application systems and databases for their Capital Markets and Investments Operations. The successful candidate will be responsible for database administration, automation, and managing workflows, working closely with technical and business teams in a dynamic environment. This position requires strong problem-solving skills and expertise in database technologies, especially SQL Server and Oracle.

Qualifications

• 3+ years of experience in database administration, scripting, and business systems maintenance.
• Solid grasp of database technologies like SQL Server and Oracle.
• Experience with investment applications is a plus.

Responsibilities

• Perform database administration duties across servers dedicated to investment systems.
• Analyze existing solutions to identify opportunities for improvement.
• Manage and support the overnight investment process and automate workflows.

Skills

Database Administration

Scripting

Problem-Solving

Communication

Multitasking

Education

University or College Degree in Computer Science, Information Technology, Engineering, or Mathematics

Tools

SQL Server

Oracle

Azure

Snowflake

PowerShell

Python

Java

Power BI

Job description

Specialist, Site Reliability Engineering - Platform and Data

Job Description
Reporting to the Manager, Site Reliability Engineering – Platforms and Data, the Specialist, SRE is responsible for supporting application systems, databases, automated workflow processes, and integrations used in our Capital Markets and Investments Operations & Applications. As part of the technical team, this role will participate in business initiatives and projects related to core investment application upgrades, database administration, and integration activities, as well as supporting automated workflows as part of the overnight processing. Excellent client service, interaction, and communication skills, along with the ability to perform in a high-paced, deadline-driven environment, are necessary.

• Perform database administration duties across database servers dedicated to investment systems (including MS SQL Server, Azure SQL Server, and Oracle instances).
• Install and configure various investment systems (Calypso, Eagle Pace, CRD, Frontier), as well as provide direct support, monitoring, and troubleshooting.
• Develop scripts and automations for data retrieval from third-party vendors and integration between systems.
• Analyze existing programmatic solutions and workflows to identify opportunities for automation, improvement, and optimization.
• Maintain and administer application and architecture security standards for investment applications.
• Manage and support the overnight investment process, including all data flow solutions and enterprise scheduling.
• Manage all problem and enterprise change management processes, representing investment requirements and maintaining the change management system in a timely manner.
• Work cross-functionally with both technical and business teams to facilitate the roll-out and ongoing support of major infrastructure and solution enhancements for investment users.
• Ability to multitask and manage projects with aggressive timelines.
• Demonstrate high personal and ethical standards with the ability to collaborate across the organization.
• Develop and maintain strong relationships with clients and external vendors, with a specific focus on managing OMERS Capital Markets production environment.
• Build and maintain documentation for all supported technology platforms and applications.
• Continuously broaden knowledge, learn new things, and adapt to a multifaceted and evolving technical and business investment environment.

PLEASE NOTE:This role may require some work to be performed outside regular business hours, including evenings, nights, and weekends for troubleshooting and implementation purposes.

To succeed in this role:

• A university or college degree in Computer Science, Information Technology, Engineering, or Mathematics is a plus, but other programs will be considered.
• 3+ years of relevant experience in a position related to database administration, scripting, and maintaining business systems, preferably in the investment industry.
• Solid grasp of database technologies with an emphasis on SQL Server and Oracle. DBA knowledge of SQL Server or Oracle, or both, is a strong plus.
• Experiences with leading investment applications such as Eagle, Calypso, Charles River, Frontier, and SimCorp are nice to have.
• Experience with the Azure cloud platform and/or Snowflake is nice to have.
• Familiarity with investment industry terminology.
• Knowledge of programming principles and comfort with using common development platforms and languages (PowerShell, Python, VB, Java).
• Familiarity with modern cloud-based technologies such as Microsoft Workplace, analytical tools, and platforms (Power Apps, Power Automate, Power BI, Azure, etc.).
• Strong knowledge of Windows and Microsoft Office products.
• Analytical and problem-solving skills to resolve technical issues and recommend solutions.
• Excellent team player with interpersonal and communication (oral and written) skills to support users of varying levels of technology expertise.
• Organizational skills to prioritize work and track the status of multiple activities.