Sr. Database Administrator, Data Platform
Wealthsimple
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.)
