Sr. Database Administrator, Data Platform
Job Description
The Data Foundation team is part of Platform Engineering org in Wealthsimple. The team consists of talented software developers and database admins/developers and is divided into three sub-teams: Data Stores, Data Integrations, and Data Streaming.
We're seeking an experienced Data Engineer/Database Administrator to join our Data Stores team. In this role, you'll be responsible for architecting, maintaining, and administrating our primary analytics data warehouses on Redshift & Snowflake. In addition, you will collaborate with key stakeholders to ensure excellence of operation for our fleet of RDS Aurora Postgres DBs.
These data stores collectively power critical financial operations and client data, and a successful candidate will work closely with our Data Science, Engineering, and Product teams to optimize database performance, ensure data integrity, and implement scalable solutions as we continue to grow.
A successful candidate is expected to have deep technical expertise in at least one of these Database technologies and the aptitude and inclination to learn the rest.
In this role you’ll have the opportunity to:
Design, implement, and maintain database infrastructure across development, testing, and production environmentsMonitor database performance and implement optimizations to improve query efficiencyDevelop and maintain backup/recovery procedures and ensure data integrityImplement and manage database security measures, including access controls and encryptionCreate Python scripts for database automation, monitoring, and maintenance tasksCollaborate with engineering teams to optimize database schemas and queriesProvide guidance on database best practices and participate in code reviewsPlan and execute database upgrades and migrations with minimal downtimeCreate and maintain comprehensive documentation for database architecture and proceduresParticipate in on-call rotation for database-related issuesWhat 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 tasksStrong understanding of database internals, optimization, and performance tuningExperience with high-availability deployments and disaster recovery strategiesKnowledge of database security best practices and compliance requirementsExperience with database monitoring, alerting, and troubleshootingSolid understanding of indexing strategies, query optimization, and execution plansFamiliarity with Terraform and GitHubExperience with infrastructure-as-code and database change management toolsStrong problem-solving skills and attention to detailStrong communication skills and the ability to work with a diverse group of stakeholdersBonus skills:
Experience with cost optimization operations, especially within AWSExperience with financial technology systems and related compliance requirementsExperience with container orchestration platforms like KubernetesKnowledge of additional databases beyond the ones listed aboveContributions to open-source database projects or toolsFamiliarity with data observability and visualization tools (Preset, Datadog, etc.)