Sql analyst Jobs in North York, ON

Venture outside the ordinary - TMX Careers

The TMX group of companies includes leading global exchanges such as the Toronto Stock Exchange, Montreal Exchange, and numerous innovative organizations enhancing capital markets. United as a global team, we’re connecting cross-functionally, traversing industries and geographies, moving opportunity into action, advancing global economic growth, and propelling progress. Through a rich exchange of ideas, meaningful collaboration, and a nimble operating model, we're powering some of the nation's most critical systems, fueling capital formation and innovation, bringing increased opportunity to business visionaries, product ingenuity to consumers, and career exploration to our team.

Ready to be part of the action?

Global Technology Services (GTS) is one of the foundational divisions of the TMX Group, that empowers internal TMX business lines for their technology needs, operations and digital innovation. GTS as a client centric organization focuses on building technology capabilities, enabling our clients with the best technology solutions and providing effective technology financial and resource management processes. The cost effective operation is a key attribute of the GTS execution. GTS is responsible for delivery of all technology initiatives and services across TMX.

Leveraging DevOps has become necessary and key to delivering on GTS' promise to be a technology driven solutions provider that puts clients first. The DevOps Engineering team is responsible for working closely with various business units and stakeholders to solve complex problems using innovative solutions, quickly and effectively using agile, lean and DevOps methodologies, while ensuring infrastructure remains highly available, secure and optimized for speed and cost.

Repporting to DevOps Lead, Production Operations, you will join a growing practice around Agile, DevOps, Continuous Integration/Development, and Infrastructure as Code. This is a multi-discipline systems engineering position within our Level 2 Application Support team supporting the continued growth and successes within our various business lines. The main focus will being the Level 2 Support for many of the application in production and helping agile teams ability to deliver reliable and secure technology.

This role is hybrid (2 - 3 days/week in the office) - we are open to candidates being located in one of our Canadian office locations: Toronto or Montreal.

Key Accountabilities:

• Be part of a Centre of Excellence in the practice of DevOps and to help spread a culture of innovation driven by experimentation
• Off hours support, flexible working hours as required
• Identify opportunities to make systems more resilient and efficient using automation
• Interact with the Agile Development team and internal customer support teams to find resolution quickly for production incidents
• Collaborate regularly with colleagues both inside and outside the application support team
• Facilitate CI/CD in infrastructure using DevOps and Agile methodologies
• Debug systems and identify issues quickly and effectively by analyzing metrics
• Proactively identify problem areas for the team both technically and procedurally and recommend improvements
• Identify system resource bottlenecks and work with other teams to test and tune systems for optimal performance
• Deliver on various business initiatives by building and supporting innovative solutions using PaaS, IaaS, and traditional on-prem technology stacks

Must Haves:

• 1 year of hands-on experience Agile methodology
• 1 to 3 years of experience in maintaining and operating mission critical distributed systems
• Must be able to develop script/code using Python and Shell from scratch
• Knowledge of Kubernetes, Helm, go templating, ArgoCD and Rancher
• Knowledge of at least one of the Cloud Providers such as Azure, GCP or AWS
• Must be well-versed with Linux OS and Windows
• Ability to quickly identify issues and performance bottlenecks by recognizing patterns in data analytics
• Strong experience using orchestration tools such as Ansible
• Excellent communication and technical documentation skills
• An inherent desire to automate everything
• Demonstrated ability to be an active contributor in a collaborative environment and be willing to take on problem ownership within the team
• The ability to work under pressure and with tight deadlines

Nice to Haves:

• Knowledge of FIX protocol, order management system and/or market data is highly desirable
• Experience with systems benchmarking and performance testing
• Perl, JavaScript, Golang
• Familiarity with application and systems performance monitoring, data visualization and logging tools such as Splunk, ELK, Grafana, Graphite, Nagios

Salary Range: 75K/year - 95K/year CAD. Please note that the salary range included is a guideline only. The salary offered may vary based on factors, including, but not limited to, the successful candidate’s relevant knowledge, skills, and experience.

The recruiting efforts for this role are intended to fill a vacant position.

In the market for…

Excitement - Explore emerging technology and innovation, as well as ventures and digital finance that shape the future of global markets! Experience the movement of the market while grounded in the stability of close to 200 years of success.

Connection - With site hubs in some of the world’s most multicultural cities, we leverage our size and structure to create rich connections and belonging while experiencing powerful global impact through our work.

Impact - More than a platform, we use our talents to power mission-critical systems that drive global economic advancement, innovation, and growth. As well, our employee-led spreads social good via our giving strategy.

Wellness - From empathetic leadership to a culture of flexibility and balance, we believe wellness at work creates the maximum yield and a stronger “we”. Plus, with a cloud-first and hybrid workstyle, as well as generous time-off and leaves, we support a life well lived!

Growth - From a growth mindset in our work, to expansion in our business, TMX is home to action-takers energized by the achievement of ambitious growth.

Ready to enrich your career with impactful work, leaders who truly care, and the flexibility and programs to help you thrive as part of #TeamTMX ? Apply now.