Senior Software Engineer, Backend (Online Storage)
Affirm · Remote Canada
Job description
About the role
Affirm's Online Storage team provides managed databases as a platform for all its services, including relational (MySQL), key-value (DynamoDB), distributed SQL (TiDB) and cache (Redis) storage. This remote role is open only to candidates living in Alberta, British Columbia, Manitoba, New Brunswick, Newfoundland and Labrador, Nova Scotia, Ontario, Prince Edward Island or Saskatchewan. The Senior Software Engineer will architect, build and scale relational and distributed SQL databases, and improve how they are built, produced and operated.
Key responsibilities
- Build and operate the control plane for large-scale distributed SQL databases such as MySQL and TiDB, automating provisioning, failover, backups and upgrades end to end.
- Design and execute reliability-focused schema and data migrations across multi-tenant clusters with zero downtime.
- Own the networking stack connecting services to storage on Kubernetes, including connection proxies such as ProxySQL, tuned for latency, resilience and failover.
- Deliver quarterly goals for the team, guide engineers through ambiguity and support delivery.
- Collaborate with product management, design and analytics on ideation, technical constraints and risk-informed decisions.
- Proactively identify and lead the resolution of project, process, technology or business issues.
- Create and monitor metrics, escalate when needed and support on-call and "keep the lights on" work.
- Set or improve code review and design standards, mentor team members and share knowledge through writing and tech talks.
Required profile
- 5+ years of experience as a software engineer, with either equivalent practical experience or a Bachelor's degree in a related field.
- Experience designing, developing and launching backend systems at scale.
- In-depth hands-on experience with large-scale database deployments in production.
- Expertise in distributed databases, SQL tuning, benchmarking, load testing and capacity planning.
- Experience building control-plane or automation tooling for databases, ideally on Kubernetes, and executing zero-downtime migrations with repeatable tooling or runbooks.
- Strong communication skills and ownership of personal growth.
Required skills
- Backend technologies: Python, Kotlin, AWS, MySQL, Terraform, Kubernetes
- Distributed databases: MySQL (preferred), TiDB (preferred), PostgreSQL, Spanner, Vitess, CockroachDB
- Connection proxies: ProxySQL, RDS Proxy, PgBouncer, PgDog
- Kubernetes networking, service discovery and TLS debugging
What we offer
- Base pay of $153,000 - $213,000 CAD per year, with equity, monthly stipends and benefits including 100% subsidized medical, dental and vision coverage.
- Flexible time off and holiday calendar.
- Employee stock purchase plan.
Questions fréquentes
Why are you reporting this job?
Explore further
Salaries, guides and searches in Canada.
Salaries by job title
Apply in 30 seconds
Enter your email to apply. An account will be created automatically.
By continuing, you accept our terms of use.
Already have an account? Login
A question about this job?
Ask it here: you will get the full job summary by e-mail, right away.
Published 7 hours ago
Expires 1 month from now
4 views · 0 interested
Boost your chances
Upload your CV — we will match you with relevant openings.
Analyzing your CV...
Affirm
Remote Canada
Related job offers
-
Staff Software Engineer (Continuous Integration)
Affirm Remote Canada -
Staff Software Engineer, Backend (Search)
Affirm Remote Canada -
Staff Software Engineer, Backend (Fraud Decisioning)
Affirm Remote Canada -
Principal Engineer, Identity & Access Management
Questrade Financial Group -
Technical Support Specialist - Telecom
servicetitan Canada Manitoba Remote