Staff Software Engineer, Backend (Online Storage)

Affirm provides clear, predictable ways for people to pay over time without hidden fees or surprises. The Staff Software Engineer will set the technical strategy for the Online Storage team and design, build, operate, and improve scalable database infrastructure, including control planes, self-service capabilities, migrations, disaster recovery, and performance tuning.

Responsibilities:

• You will be responsible for setting technical strategy for your team on a year-long time scale, and help your team tie it together with critical, business-impacting projects
• You will work closely with and contribute to other teams - including product, infrastructure, and site reliability engineering (SRE)
• You will design and build components of a scalable datastore platform, contributing to the overall Affirm's goals, and leveraging experience in creating multi-region, horizontally scalable, globally available, and high-performance datastore solutions
• You will develop control planes for management, self service of hundreds of databases at scale automating schema/data migrations, disaster recovery, sharding and performance tuning
• You will collaborate across teams in the product development lifecycle, focusing on database solutions, by collaborating with product management, design & analytics to ensure technical sustainability, risks and trade-offs are well understood and managed
• You will act as a force-multiplier for your team through your definition and advocacy of technical solutions and operational processes
• You take ownership of your team’s operations and availability by ensuring you have the right monitoring, triage rotations, playbooks, policies, testing and alerting in place to support “keep the lights on” & on-call efforts
• You will foster a culture of quality and ownership on your team by setting code review and design standards for your team, and advocating for them beyond your team through your writing and tech talks
• You will help develop talent on your team by providing feedback and guidance, and leading by example

Requirements:

• You have 8+ years of experience designing, developing and launching backend systems at scale using languages like Python or Kotlin
• You have an extensive track record of developing highly available distributed systems using technologies like AWS, MySQL, Spark and Kubernetes
• You have 5+ years of hands-on Database Expertise, leveraging your deep knowledge of Relational and/or Distributed SQL such as MySQL, PostgreSQL, TiDB/Vitess  to optimize database performance, ensuring data integrity, and implementing efficient data access patterns
• Should possess deep understanding of Database fundamentals including schema design, query optimization, scaling, partitioning, sharding and performance tuning in multiple functional environments
• Strong background and expertise in building and operating databases in cloud environments
• Expertise in database benchmarking, load testing, and capacity planning
• Familiarity with connection poolers and proxies such as ProxySQL, RDS Proxy, Pg Bouncer, etc
• You have experience delivering major features, system components or deprecating existing functionality in a system through the definition of a technical and execution plan
• You write high quality code that is easily understood and used by others
• You thrive in ambiguity, and are comfortable moving from low level language idioms all the way to the architecture of large systems to understand how they work
• Your growth and impact trajectory demonstrates that you have mastered gathering and iterating on feedback from your engineering and cross-functional peers
• You have strong verbal and written communication skills that support effective collaboration with our global engineering team
• This position requires either equivalent practical experience or a Bachelor's degree in a related field