Senior PostgreSQL Administrator

Summary

Join Wealthsimple's Data Stores team as a Senior PostgreSQL Administrator and contribute to the design, implementation, and maintenance of PostgreSQL database environments supporting critical financial operations and client data. Collaborate with engineering and product teams to optimize database performance, ensure data integrity, and implement scalable solutions. This role demands deep technical expertise in PostgreSQL and hands-on development experience to automate and improve database infrastructure. You will design, implement, and maintain PostgreSQL database infrastructure; monitor database performance and implement optimizations; develop and maintain backup/recovery procedures; implement and manage database security measures; create Python scripts for automation; collaborate with engineering teams; provide guidance on best practices; plan and execute database upgrades; create and maintain documentation; and participate in on-call rotation. The position offers opportunities to work with cutting-edge technologies and contribute to a growing fintech company. Wealthsimple is committed to building an inclusive and high-performing team.

Requirements

• 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

Responsibilities

• 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

Preferred Qualifications

• 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

Benefits

• 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