Senior Software Developer, Database Infrastructure
About The Position
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. Be a part of our Canadian success story and help shape the financial future of millions. Read our Culture Manual and learn more about how we work. 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.
Requirements
- 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
Nice To Haves
- 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.)
Responsibilities
- 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
- 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
Benefits
- 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)
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
No Education Listed
