[Remote] Sr. Database Administrator, Data Platform

Note: The job is a remote job and is open to candidates in USA. Wealthsimple is on a mission to help everyone achieve financial freedom by reimagining what it means to manage your money. In this role, you'll be responsible for architecting, maintaining, and administrating our primary analytics data warehouses on Redshift & Snowflake, and collaborating with key stakeholders to ensure excellence of operation for our fleet of RDS Aurora Postgres DBs. 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 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 • 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 • 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.) Benefits • 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 Company Overview • Wealthsimple is a fintech company that offers digital financial services to help investors grow and manage their money. It was founded in 2014, and is headquartered in Toronto, Ontario, CAN, with a workforce of 1001-5000 employees. Its website is Apply tot his job