Wealthsimple

Sr. Database Administrator, Data Platform

Job Description

The Data Foundation team is part of Platform Engineering org in Wealthsimple. The team consists of talented software developers and database admins/developers and is divided into three sub-teams: Data Stores, Data Integrations, and Data Streaming.

We're seeking an experienced Data Engineer/Database Administrator to join our Data Stores team. In this role, you'll be responsible for architecting, maintaining, and administrating our primary analytics data warehouses on Redshift & Snowflake.  In addition, you will collaborate with key stakeholders to ensure excellence of operation for our fleet of RDS Aurora Postgres DBs.

These data stores collectively power critical financial operations and client data, and a successful candidate will work closely with our Data Science, Engineering, and Product teams to optimize database performance, ensure data integrity, and implement scalable solutions as we continue to grow. 

A successful candidate is expected to have deep technical expertise in at least one of these Database technologies and the aptitude and inclination to learn the rest.


In this role you’ll have the opportunity to:
  • Design, implement, and maintain database infrastructure across development, testing, and production environments
  • Monitor database performance and implement optimizations to improve query efficiency
  • Develop and maintain backup/recovery procedures and ensure data integrityImplement and manage database security measures, including access controls and encryption
  • Create Python scripts for database automation, monitoring, and maintenance tasks
  • Collaborate with engineering teams to optimize database schemas and queries
  • Provide guidance on database best practices and participate in code reviews
  • Plan and execute database upgrades and migrations with minimal downtime
  • Create and maintain comprehensive documentation for database architecture and procedures
  • Participate in on-call rotation for database-related issues

    • What you’ll bring:
  • 5+ years of hands-on administration experience in production environments for at least one of: Redshift, Snowflake, PostgreSQL.  
  • Proficient in Python scripting for database automation and management tasks
  • Strong understanding of database internals, optimization, and performance tuning
  • Experience with high-availability deployments and disaster recovery strategies
  • Knowledge of database security best practices and compliance requirements
  • Experience with database monitoring, alerting, and troubleshooting
  • Solid understanding of indexing strategies, query optimization, and execution plans
  • Familiarity with Terraform and GitHub
  • Experience with infrastructure-as-code and database change management tools
  • Strong problem-solving skills and attention to detail
  • Strong communication skills and the ability to work with a diverse group of stakeholders

    • Bonus skills:
  • Experience with cost optimization operations, especially within AWS
  • Experience with financial technology systems and related compliance requirements
  • Experience with container orchestration platforms like Kubernetes
  • Knowledge of additional databases beyond the ones listed above
  • Contributions to open-source database projects or tools
  • Familiarity with data observability and visualization tools (Preset, Datadog, etc.)

    • Apply Now
    Job Summary

    Staff Backend Software Engineer - Databases - Loki Ingest | EMEA | Remote

    Grafana Labs is a remote-first, open-source powerhouse. There are more than 20M users of Grafana, the open source visualization tool, around the globe, monitoring everyth

    • Head Level
    • Spain Only
    • $99383-$124442
    • 5 months ago

    Senior Database Reliability Engineer (DBRE) & Architect (worldwide remote)

    CloudLinux is transforming the Linux infrastructure market by ensuring security and stability for over 500,000 servers worldwide. Our products - CloudLinux OS, TuxCare, a

    • Senior
    • Slovakia Only
    • 2 months ago

    Database Engineer - 2 seats

    As a Database Engineer, you will be responsible for developing and optimizing complex SQL queries, stored procedures, functions, and views. You will also design, implemen

    • Philippines
    • 6 months ago

    Staff Backend Software Engineer - Databases - Loki Ingest

    Grafana Labs is a remote-first, open-source powerhouse. There are more than 20M users of Grafana, the open source visualization tool, around the globe, monitoring everyth

    • Head Level
    • Sweden Only
    • $77348-$92851
    • 5 months ago