Senior Database Administrator (Oracle Application DBA / Cloud)

Astra-North Infoteck Inc.; Toronto; Hybrid; CAD 110,000 - 120,000; Full time

Job summary

Astra North Infoteck Inc. in Toronto is seeking a Database Engineer to manage, support, and modernize our server-based database infrastructure.

You will champion a "Database as Code" philosophy, leveraging automation and programmatic systems management to ensure currency, patching, and upgrades across our relational DBMS. You will combine deep technical expertise with analytical problem-solving to support mission-critical, high-volume environments.

Qualifications

• Minimum of 5 years of hands-on database management and administration experience.
• Deep technical expertise in SQL Server, with Oracle and PostgreSQL knowledge.
• Experience supporting real-time, large-scale, multi‑TB databases.
• Strong HA/DR design experience including Oracle RAC.
• Programmatic mindset with scripting to automate deployments and a 'DB as Code' approach.
• Knowledge of Windows, Linux, virtualization, and cloud technologies.
• Excellent analytical, problem-solving and communication skills.

Responsibilities

• System Availability & Issue Resolution: resolve complex database issues and coordinate with vendors during critical events.
• Infrastructure Optimization: install and configure database software and hardware for stable, modern systems.
• Performance Tuning & Monitoring: design automated monitoring and tune database configurations and queries.
• Disaster Recovery & Data Protection: oversee backups, test restores, and participate in DR exercises.
• Strategic Standards & Collaboration: enforce standards and collaborate with development teams and vendors.
• Operational & Project Support: provide Level 2 support and participate in a 24/7 on-call rotation.

Skills

SQL Server

Oracle

PostgreSQL

Scripting

Tools

PowerShell

Python

Perl

Linux

Windows

Job description

Database Engineer

We are seeking a Database Engineer to manage, support, and modernize our server-computing database infrastructure. In this role, you will champion a "Database as Code" philosophy, leveraging automation and programmatic systems management to ensure software currency, seamless patching, and optimal upgrades across our relational database management systems.

As a key technical resource, you will combine deep technical expertise with strong analytical problem-solving skills to support our mission-critical, high-volume database environments.

Reports to: Senior Manager, Clearing Technology Services

Job Location: Hybrid (2-3 days in office) - based in Toronto, ON.

Key Accountabilities

System Availability & Issue Resolution: Serve as the SQL Server Subject Matter Expert (SME) to resolve complex database issues. Lead short- and long-term root cause analysis, collaborate across engineering teams, and coordinate with external vendors during critical system events.

Infrastructure Optimization: Identify, install, and configure database software and hardware requirements to build highly stable, modern, and high-performing database systems.

Performance Tuning & Monitoring: Lead efforts to design and improve automated monitoring for database health and availability. Analyze performance metrics to recommend and execute tuning strategies across database configurations, storage, and application SQL queries.

Disaster Recovery & Data Protection: Oversee routine backup audits, conduct regular test restores to validate data integrity, and actively participate in scheduled Disaster Recovery exercises.

Strategic Standards & Collaboration: Enforce database engineering standards and partner with Development Squads and software vendors to design, review, and deploy database schema changes.

Operational & Project Support: Deliver Level 2 escalation support for day-to-day operations and project execution, participating in a 24/7 on-call rotation to support our continuous operations.

Must Have(s)

Professional Experience: Minimum of 5 years of hands-on database management and administration experience.

Database Expertise: Deep technical expertise in SQL Server, with additional working knowledge of Oracle and Postgres.

Scale & Volume: Proven experience supporting real-time applications and large-scale, multi-terabyte (TB) databases.

High Availability & DR: Strong hands-on experience with database data protection, Disaster Recovery design, high-availability setups, and Oracle RAC administration.

Automation & Scripting: Strong programmatic mindset with excellent scripting skills (e.g., Powershell, Python, Perl) to automate deployments and support a "DB as Code" infrastructure model.

Infrastructure & Cloud: Practical knowledge of Windows, Linux, Virtualization, and Cloud technologies.

Soft Skills: Exceptional analytical, problem-solving, and communication skills, with a collaborative team spirit and a big-picture delivery mindset.

Nice to Have(s)

Prior experience in the Financial Capital Markets industry.

Experience executing complex data migrations between differing platforms or dissimilar environments.

Salary Range

Salary Range: $110K/year - $120K/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.

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.