Senior PostgreSQL Administrator
Remote
Data & Engineering – Engineering /
Permanent Full Time /
Remote
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 4 million users who trust us with more than $70 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.
Data Foundation Team
The Data Foundation team is part of Data Platform Engineering org in Wealthsimple. The team consists of talented software developers and database admins/developers and is divided into three sub-teams:
1) Data Stores Team:
With the mandate of strengthening our data infrastructure through stewardship of all our storage systems, including: Oracle EBS, Aurora Postgres RDS, DynamoDB and Redis. The team set and standardize best practices, administer and build tools to improve the reliability, scalability and usability of these systems.
2) Data Integrations Team:
With the mandate of enabling the organization to make better data-driven decisions by improving data accessibility through data replication, integrations, tooling and providing real time data access.
3) Data Streaming Team:
Provides the platform, standards and tools to leverage streaming technologies (Kafka, Flink, Temporal) the Wealthsimple way: reliable, secure and scalable.
We're seeking an experienced Senior PostgreSQL Administrator to join our Data Stores team. In this role, you'll be responsible for designing, implementing, and maintaining our PostgreSQL database environments that power critical financial operations and client data. You'll work closely with engineering and product teams to optimize database performance, ensure data integrity, and implement scalable solutions as we continue to grow. This role requires both deep technical expertise in PostgreSQL and hands-on development experience to automate and improve our database infrastructure.
In this role, you'll have the opportunity to:
- Design, implement, and maintain PostgreSQL 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
- 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
Skills we are looking for:
- 5+ years of hands-on PostgreSQL administration experience in production environments
- Proficient in Python scripting for database automation and management tasks
- Strong understanding of PostgreSQL internals, optimization, and performance tuning
- Experience with high-availability PostgreSQL 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 PostgreSQL extensions and their applications
- Knowledge of cloud-based PostgreSQL implementations (AWS Aurora RDS)
- Familiarity with Terraform and GitHub
- Experience with infrastructure-as-code and database change management tools
- Strong problem-solving skills and attention to detail
Nice-to-have's:
- Experience with financial technology systems and related compliance requirements
- Experience with container orchestration platforms like Kubernetes
- Knowledge of additional databases beyond PostgreSQL (Redis, Redshift, etc.)
- Contributions to open-source database projects or tools
- Familiarity with data observability and visualization tools (Preset, Datadog, etc.)
- AWS/PostgreSQL certifications
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
🛫 90 days away program: Employees can work internationally in eligible countries for up to 90 days per calendar year
🌎 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!
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 create even greater value. We're looking for people who are not just comfortable with change but energized by it. Our commitment is to build a company that evolves at the pace of the world around us, and we want you to help lead that future.
DEI Statement
At Wealthsimple, we are building products for a diverse world and we need a diverse team to do that successfully. We strongly encourage applications from everyone regardless of race, religion, colour, national origin, gender, sexual orientation, age, marital status, or disability status.
Accessibility Statement
Wealthsimple provides an accessible candidate experience. If you need any accommodations or adjustments throughout the interview process and beyond, please let us know, and we will work with you to provide the necessary support and make reasonable accommodations to facilitate your participation. We are continuously working to improve our accessibility practices and welcome any feedback or suggestions on how we can better accommodate candidates with accessibility needs.
