Sr. Database Administrator, Data Platform

Other Jobs To Apply

No other job posts for this day.

Your career is an investment that grows over time! 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, opaque and expensive and make them transparent and low-cost for everyone. We’re the largest fintech company in Canada, with over 3+ million users who trust us with more than $100 billion in assets. Our teams ship often and make an impact with groundbreaking ideas. We're looking for talented people who keep it simple and value collaboration and humility as we continue to create inclusive and high-performing teams where people can be inspired to do their best 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 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.) Why Wealthsimple? Competitive salary with top-tier health benefits and life insurance Retirement savings matching plan using Wealthsimple for Business 20 vacation days per year and unlimited sick and mental health days Up to $1,500 per year towards wellness and professional development budgets respectively A wide variety of peer and company-led Employee Resource Groups (ie. Rainbow, Women of Wealthsimple, Black @ WS) Company-wide wellness days off scheduled throughout the year We’re a remote-first team, with over 1,000 employees coast to coast in North America. Be a part of our Canadian success story and help shape the financial future of millions — join us! Read our Culture Manual and learn more about how we work. Technology & Innovation at Wealthsimple We believe the future belongs to those who innovate boldly. At Wealthsimple, every team member is expected to lean into new technologies, including AI, and tooling to rethink how we work, solve problems faster, and cre

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...