Senior Analyst, SQL Sybase Database Support - Infrastructure Service Delivery
- Permanent, Full time
- TD Securities
- 20 Nov 17 2017-11-20
TD Securities is securities and investment banking arm of the Toronto Dominion Bank. We are one of Canada’s leading providers of advisory and capital market services and the premier provider of liquidity to corporations, governments and institutions. In the world’s key financial centres, we partner with our clients to deliver innovative financial solutions that help them achieve their strategic and financial goals.
Global Supporting Role of a client facing Rates & Credit electronic trading business with dealer-to-client and dealer to dealer electronic connectivity, predominantly using ION Trading technology (MarketView) but also extends to upstream & downstream processes using both proprietary & other vendor solutions. In particular the role will involve heavy interaction with ION PXE and Bloomberg TOMS for trade, position, and P&L management.
Financial products include Australian government bonds, Supras, Sovereign, Agency, Corporate Bonds, and potentially interest rate swaps.
It is intended the candidate will be part of a global support team, and will take part in support and on call type 24x7x365 activities. This will also involve active participation in project work and its associated deliverables.
The role is within TD’s – Infrastructure Service Delivery team.
Supporting the application infrastructure that underpins the Front Office Trading and risk management platforms hosted on Windows Server 2008 R2.
Support of the Sybase 15 database underpinning the production platform hosted on Red Hat Enterprise Linux Server 6.4.
Build/Support of Microsoft SQL Server 2008, 2012, and 2016
SQL AAG, Clustering and other High Availability Implementations
Documenting Support Procedures – Ownership of the Operating Support Document.
Supporting the production ION platform and users.
Executing releases of new functionality or patches.
Supporting the production Fixed Income trade flow from execution on market to downstream systems, including TOMS, and back office systems (Calypso).
Liaising with infrastructure teams to ensure that application infrastructure is appropriately configured.
Liaising with CTB team to understand the schedule of releases, ensuring that all the appropriate sign-off has been obtained.
Automation of common support tasks using scripts
Application capacity monitoring and management
Systems configuration: Follow set procedures to configure supported applications according to approved functional requirements. These requirements may form part of the project implementation, or may be part of production support.
Management of all production support incidents in chosen issue/incident tracking software.
Maintenance of PRD & DR environment: Be responsible for the working state of PRD & DR environments, ensuring they are fit for use.
The role requires working shifts and/and potentially being on-call out of normal working hours.
- Relevant experience in SQL Server 2008, 2012, 2016 (Windows) and Sybase (Linux)
- Extensive experience supporting a live FI Trading environment with live market connectivity for Rates, Credit or Swaps desk with access to trading venues such as Bloomberg & TradeWeb
- Strong experience providing technical support for Fixed Income Desks within an Investment Bank.
- Strong experience working with both project team & users.
- General understanding of financial markets and products, in particular Fixed Income & Rates.
- Technical knowledge of ION components
- Strong knowledge of working on Windows and Linux Platforms.
- Knowledge of SQL (PL/SQL and T-SQL), Excel, and VBA
- Intermediate knowledge of Oracle, SQL Server, Sybase & Windows OS.