Int. Site Reliability Engineer to perform database administration across database servers dedicated to investment systems for a financial client - JR-6544

Position: Int. Site Reliability Engineer to perform database administration across database servers dedicated to investment systems for a financial client - JR-6544

Duration: 6 months with possible extension

Location: Hybrid Toronto (3x on-site)

Job ID: JR-6544

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 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.

Must Haves:

• 3+ yrs exp as a Site Reliability Engineer within the Capital Markets/Investment industry
• database administration, scripting, and maintaining business systems, preferably in the investment industry.
• SQL Server and Oracle
• 3+ yrs exp with investment applications (Eagle, Calypso, Charles River, Frontier, and SimCorp)
• Knowledge of programming principles and comfort with using common development platforms and languages (PowerShell, Python, VB, Java).

Nice to Haves:

• Azure cloud platform
• Snowflake

Responsibilities

• 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.