Senior Software Engineer

Senior Software Engineer (Online Storage) Affirm is reinventing credit to make it more honest and friendly, giving consumers the flexibility to buy now and pay later without any hidden fees or compounding interest.Affirm believes that data is fundamental to everything we do. Our data and storage solutions empower machine learning, artificial intelligence, cloud‑based technologies, and other modern tools to create differentiated and scalable products. We prioritize building our own technology and investing in engineering talent as enduring competitive advantages that are difficult to replicate. The Online Storage team provides a set of managed databases as a platform, used to persist data for all Affirms services. The platform automates operations and development on services built on storage systems such as AWS Aurora (MySQL), DynamoDB, and S3. The team is responsible for a wide range of data and access patterns, including mission‑critical financial transactional data, data science models, and new persistence use cases, requiring deep expertise in various database systems. Our mission is to provide trustworthy, intuitive, and cost‑efficient solutions to secure, store, analyze, and transform data at exceptional scale. Affirm is growing fast and wants you to enable us to scale our products to 10× and beyond by building world‑class systems that support our mission to provide honest financial products that improve lives. Responsibilities Lead projects that improve our database architecture, focusing on scalability, reliability, performance, and cost efficiency. Work with engineers managing Affirms distributed database technologies, particularly AWS Aurora MySQL, Distributed SQL, and expanding to DynamoDB and caching. Design, build, and operate a highly durable and strongly consistent database‑as‑a‑service architecture. Implement solutions at scale for challenges such as multi‑region, active resharding, and globally available services. Collaborate with product teams to understand business requirements and translate them into robust database solutions. Assist partners to achieve better query performance by recommending optimizations and effective schemas. Develop and enforce best practices in database design and management, ensuring data integrity, security, and optimal performance. Stay abreast of industry trends and emerging technologies in transactional databases to continually enhance our systems and processes. Participate in an on‑call rotation and collaborate with other teams, such as SRE, to solve production issues. Lead and mentor engineers to define and execute the roadmap aligned with stakeholder needs. Qualifications Bachelors or Masters degree in Computer Science with 5+ years of experience as a software engineer, including leadership exposure and mentoring junior engineers. In‑depth, hands‑on experience with large‑scale database deployments in production. Expertise in distributed databases and database technologies such as MySQL InnoDB, Postgres, Spanner, Vitess, TiDB, CockroachDB, and similar systems. Solid understanding of distributed database architecture, data modeling, and performance tuning, particularly SQL tuning and 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 such as ProxySQL, RDS Proxy, Pg Bouncer, and similar. Proficiency in Python or Kotlin, or both. Experience with AWS and Kubernetes. Experience building software with IaC (Terraform or Crossplane) frameworks and tools. Exceptional communication skills with the ability to engage effectively with both technical and non‑technical stakeholders. Experience creating and triaging database alerts, identifying root causes, and implementing corrective solutions. Pay Grade Pay Grade: NEquity Grade: 6Base pay range (CAN): $150,000 – $200,000 per year Benefits Health care coverage – affirm covers all premiums for all levels of coverage for you and your dependents. Flexible Spending Wallets – generous stipends for technology, food, lifestyle needs, and family expenses. Time off – competitive vacation and holiday schedules for rest and recharge. ESPP – employee stock purchase plan allowing you to buy shares of Affirms at a discount. Accommodations & Diversity We believe it’s on us to provide an inclusive interview experience for all, including people with disabilities. We are happy to provide reasonable accommodations to candidates in need of individualized support during the hiring process.For U.S. positions that could be performed in Los Angeles or San Francisco, Pursuant to the San Francisco Fair Chance Ordinance and Los Angeles Fair Chance Initiative for Hiring Ordinance, Affirms will consider qualified applicants with arrest and conviction records. #J-18808-Ljbffr