Junior DBA - Platform Services

GuruLink; Montreal; On-site; CAD 80,000 - 110,000; Full time

Job summary

A global investment management firm seeks a Platform Applications Specialist Database to join their systems team in Montreal. The role focuses on delivering scalable infrastructure for trading and research, requiring expertise in PostgreSQL and database administration. Ideal candidates will have experience with high availability and disaster recovery solutions, and be comfortable in a collaborative environment. A degree in Engineering or Computer Science is a must, along with solid Linux and Python skills.

Qualifications

• 2+ years of database administration experience required, particularly with PostgreSQL, Clickhouse, or FoundationDb.
• Experience with Linux systems administration and Python.
• A degree in Engineering or Computer Science is mandatory.

Responsibilities

• Design, deploy, and support cross-platform database solutions.
• Monitor and improve alert systems and configurations.
• Collaborate with internal teams on database infrastructure.

Skills

Database Administration

PostgreSQL

Linux Systems Administration

Python

High Availability Solutions

Backup and Disaster Recovery

Education

Degree in Engineering

Degree in Computer Science

Tools

Terraform

Ansible

Kubernetes

Job description

Location: Montreal, Quebec

Our client is a global investment management firm. As a technology and data-driven firm, they design and build their own cutting-edge systems, from high performance trading platforms to large scale data analysis and compute farms.

Platform Applications Specialists Database role will be part of a global systems team responsible to deliver highly available, high-performance, and scalable infrastructure to support trading and research using the DevOps methodology.

As part of this role will be focused on working collaboratively with internal development, investment, and infrastructure teams to design, deploy and support cross-platform databases solution such PostgreSQL, Redis, Clickhouse and Microsoft SQL.

Your day to day could consist of installation and configuration, monitoring and alerting improvements and configurations, automation and tool development, and

PLEASE NOTE - 4 days in office is required

Must Have Skills:

•2+ years database administration experience required (At least one of: PostgreSQL, Clickhouse, FoundationDb).
•Experience with high availability, backup, and disaster recovery solutions.
•Knowledge of indexes, triggers, stored procedure development and optimization.
•Experience with Linux systems administration.
•Experience with Python
•Basic understanding of source control concepts, best practices, and the software development lifecycle.
•Full project life cycle ownership: project delivery from initiation to full implementation and deployment.
•Degree in Engineering, Computer Science, or related experience.

Nice to Have Skills:

•Experience with other database platforms ClickHouse, FoundationDb, MSSQL, MongoDb, Redis, Neo4j.
•Experience with configuration management tools i.e. Chef, Terraform, Ansible.
•Experience with an observability & monitoring stack such as Prometheus exporters, LogStash, Elasticsearch, Prometheus, Thanos, Grafana, and AlertManager.
•Experience with CI / CD pipelines.
•Experience working with various cloud providers (AWS and GCP).
•Experience with virtualization technologies such as VMware and containers (standalone and Kubernetes).
•Experience with Windows systems administration.