Senior Software Developer, Database Infrastructure

Posted 4 months ago

Apply Now

Resume Score

Check how well your resume matches this job before you apply.

Sign in to check score

About the role

  • Senior Software Developer responsible for database infrastructure and analytics at Wealthsimple. Optimizing performance of data warehouses and collaborating with cross-functional teams.

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
  • Develop applications to orchestrate and automate the management, monitoring, and maintenance of fleets of production databases
  • Collaborate with engineering teams to optimize database schemas and queries
  • Provide guidance on database best practices and participate in code reviews
  • Create and maintain comprehensive documentation for database architecture and procedures
  • Participate in on-call rotation for database-related issues

Requirements

  • 6+ years of hands-on administration experience in production environments for at least two of: Redshift, Snowflake, PostgreSQL.
  • Strong experience in Python development
  • 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.

Benefits

  • Top-tier health benefits and life insurance
  • Long-term group savings with employer match using our Wealthsimple for Business platform
  • 20 vacation days + 4 wellness days per year, and unlimited sick and mental health days
  • 90 days away program: Employees can work outside of Canada for up to 90 days per calendar year
  • A wide variety of peer and company-led Employee Resources Groups (e.g., Rainbow, Women of Wealthsimple, Black @ WS)

Job type

Full Time

Experience level

Senior

Salary

CA$151,200 - CA$189,000 per year

Degree requirement

Bachelor's Degree

Tech skills

Amazon RedshiftPostgresPythonTerraform

Location requirements

RemoteCanada

Report this job

Found something wrong with the page? Please let us know by submitting a report below.