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, PostgreSQL.
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 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.

Top-tier health benefits and life insurance
Long-term group savings with employer match using our Wealthsimple for Business platform
20 vacation days + 4 wellness days per year, and unlimited sick and mental health days
90 days away program: Employees can work outside of Canada for up to 90 days per calendar year
A wide variety of peer and company-led Employee Resources Groups (e.g., Rainbow, Women of Wealthsimple, Black @ WS)

Senior Software Developer, Database Infrastructure

Key skills