14 Oct
S.i. Systèmes
Toronto
Position: Int. Site Reliability Engineer to perform Oracle 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:
- 7+ yrs exp as a Site Reliability Engineer within the Capital Markets/Investment industry
- Oracle performance turning, database administration, scripting, and maintaining business systems, preferably in the investment industry.
- Strong experience in Database Administration, including Installation, Configuration, Maintenance.
- Expertise in Database Performance Tuning, including query optimization, index management, and storage management.
- Experience with database backup and recovery processes.
- Strong understanding of database security principles and best practices.
- SQL Server
- 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.
Apply