Senior Software Developer, Database Infrastructure

Build something people love

Wealthsimple is on a mission to help everyone achieve financial freedom by reimagining what it means to manage your money. Using smart technology, we take financial services that are often confusing and expensive and make them transparent and low-cost for everyone. We’re the largest fintech company in Canada, with 3+ million users who trust us with more than $100 billion in assets.

And we’re just getting started.

We’re looking for someone who thinks big, sweats the small stuff and keeps things simple. You’ll join a high‑bar, fast‑paced team where people are trusted to own their work, communicate openly, and ship things that improve our clients’ lives. Collaboration, humility, and an obsession over quality are how we get stuff done.

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 looking for an experienced Senior Software Developer 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.

• 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 integrity
• Implement and manage database security measures, including access controls and encryption
• Develop applications to orchestrate and automate the management, monitoring, and maintenance of fleets of production databases
• Collaborate with engineering teams to optimize database schemas and queries
• Provide guidance on database best practices and participate in code reviews
• Create and maintain comprehensive documentation for database architecture and procedures
• Participate in on‑call rotation for database‑related issues

• 6+ years of hands‑on administration experience in production environments for at least two of:
  Redshift, Snowflake, Postgre
  
  SQL.
• Strong experience in Python development
• 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 Git Hub
• 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

• 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.)

🤑 Base salary range:
For this role, candidates located in Canada can expect a base salary range of CAD $151,200 - $189,000. Actual compensation is determined based on skills, experience, and role level. Exceptional candidates may…