Staff Software Engineer (Online Storage)

Job Description

Affirm is seeking a Staff Software Engineer to join their Online Storage team. This role is crucial for scaling Affirm's products by building world-class systems that support the company's mission of providing honest financial products. The engineer will collaborate with product, infrastructure, and SRE teams to improve the database architecture, focusing on scalability, reliability, performance, and cost efficiency.Responsibilities:

• Shape the technical direction and strategy for database architecture.
• Work with engineers managing distributed database technologies like AWS Aurora MySQL and DynamoDB.
• Design and build durable and consistent database-as-a-service architecture.
• Design solutions for challenges like multi-region deployments and active resharding.
• Translate business requirements into robust database solutions.
• Suggest query optimizations and effective schemas.
• Develop and enforce best practices in database design and management.
• Stay updated with industry trends in transactional databases.
• Participate in on-call rotations and collaborate with SRE to resolve production issues.
• Mentor engineers and define roadmap aligned with stakeholder needs.

Requirements:

• Bachelor's or Master's degree in Computer Science with 7+ years of software engineering experience.
• In-depth experience with large-scale database deployments in production.
• Expertise in distributed databases and technologies like MySQL InnoDB, Postgres, Spanner, Vitess, TiDB, CockroachDB.
• Solid understanding of distributed database architecture, data modeling, and performance tuning.
• Expertise in SQL tuning and performance optimization techniques.
• Expertise in Database/Table and backup-recovery management.
• Expertise in database benchmarking, load testing, and capacity planning.
• Familiarity with connection poolers and proxies like ProxySQL, RDS Proxy, Pg Bouncer.
• Proficiency in Python or Kotlin.
• Experience with AWS and Kubernetes.
• Experience building software with IaC frameworks like Terraform or Crossplane.
• Exceptional communication skills.
• Expertise to create and triage database alerts and issues.

What Affirm Offers:

• Opportunity to work on scaling and availability challenges of infrastructural components.
• Exposure to a wide array of technologies to solve real-world problems.
• Competitive benefits, including fully subsidized healthcare, flexible spending wallets, and generous time off.