Wealthsimple

Senior PostgreSQL Administrator

Remote

Not SpecifiedCompensation
Senior (5 to 8 years)Experience Level
Full TimeJob Type
UnknownVisa
Fintech, Financial ServicesIndustries

Requirements

The ideal candidate will possess over 5 years of hands-on PostgreSQL administration experience in production environments, with proficiency in Python scripting for database automation and management. A strong understanding of PostgreSQL internals, optimization techniques, and performance tuning is essential, along with experience in high-availability deployments and disaster recovery strategies. Knowledge of database security best practices, monitoring, alerting, troubleshooting, indexing strategies, query optimization, and execution plans are also required. Familiarity with PostgreSQL extensions, cloud-based PostgreSQL implementations (AWS Aurora RDS), Terraform, GitHub, infrastructure-as-code, and database change management is preferred.

Responsibilities

The Senior PostgreSQL Administrator will be responsible for designing, implementing, and maintaining PostgreSQL database infrastructure across various environments, monitoring database performance, and implementing optimizations for query efficiency. Key duties include developing and maintaining backup/recovery procedures, ensuring data integrity, implementing and managing database security measures, and creating Python scripts for automation, monitoring, and maintenance. The role also involves collaborating with engineering teams to optimize database schemas and queries, providing guidance on best practices, participating in code reviews, and planning/executing database upgrades and migrations with minimal downtime. Creating and maintaining documentation and participating in an on-call rotation for database-related issues are also core responsibilities.

Skills

PostgreSQL
Database Administration
Aurora Postgres RDS
Oracle EBS
DynamoDB
Redis
Data Infrastructure
Scalability
Reliability
Financial Operations

Wealthsimple

Digital platform for investing and financial management

About Wealthsimple

Wealthsimple provides a range of financial tools that help individuals manage their money effectively. Their services include automated investing, where users can set up investment accounts that automatically adjust based on market conditions, and commission-free stock trading, allowing users to buy and sell stocks without paying fees. They also offer cryptocurrency investments for those interested in digital currencies and a straightforward tax filing service that is designed to be quick and user-friendly. Wealthsimple stands out from its competitors by focusing on young professionals and tech-savvy individuals, providing a digital platform that is easy to navigate and understand. The company's goal is to simplify financial management, making it accessible to everyone by using technology to create a more personal and approachable experience in finance.

Toronto, CanadaHeadquarters
2014Year Founded
$826.6MTotal Funding
LATE_VCCompany Stage
Fintech, Financial ServicesIndustries
1,001-5,000Employees

Benefits

Health Insurance
Life Insurance
401(k) Company Match
401(k) Retirement Plan
Paid Vacation
Unlimited Paid Time Off
Professional Development Budget
Wellness Program
Remote Work Options
Paid Holidays

Risks

Increased competition from zero-commission brokers could erode Wealthsimple's market share.
Invite-only rollout of Wealthsimple Cash may limit user adoption and growth.
Rapid cryptocurrency adoption pressures Wealthsimple to innovate its offerings continuously.

Differentiation

Wealthsimple offers a human-centric approach to finance with user-friendly digital tools.
The company provides a seamless platform for investing, trading, saving, and tax filing.
Wealthsimple targets young, tech-savvy professionals seeking accessible financial management solutions.

Upsides

Wealthsimple's AUA reached $50 billion, indicating strong market presence and growth potential.
The rise of AI-driven advisory services can enhance Wealthsimple's personalized investment offerings.
Fractional shares' popularity aligns with Wealthsimple's target demographic, boosting user acquisition.

Land your dream remote job 3x faster with AI