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 proudly includes Returnly. At Affirm, 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 differential and scalable products. We prioritize building our own technology and investing in engineering talent, as we believe these are enduring competitive advantages that are difficult to replicate. Our expertise in sourcing, aggregating, protecting, and analyzing data has been what we believe to be a core competitive advantage of our platform since our founding. We use data to inform our analysis and decision-making, including risk assessment, in a way that empowers consumers and generates value for our merchants and funding sources. Our mission is to provide trustworthy, intuitive, and cost-efficient solutions to secure, store, analyze, and transform data at exceptional scale. The Online Storage team provides a set of managed databases as a platform, used to persist data for all Affirm services. Our platform automates operations and development on services on top of storage systems like AWS Aurora (MySQL), DynamoDB, and S3. As a team, we are responsible for various data and access patterns, including but not limited to mission-critical financial transactional data, data science models, and any new persistence use case requiring us to learn and gain deep expertise in various database systems. Affirm is growing fast and we want you to enable us to scale our products to 10x and beyond through building world-class systems which enable Affirm in its mission to provide honest financial products which improve lives.We are only just getting started! Come join us as we build a beloved, lasting financial services brand predicated on honesty and trust. It's going to be an amazing ride!What you'll doAs a member of the Online Storage team, you will collaborate with other teams - including product, infrastructure, and site reliability engineering(SRE) to:Working with engineers managing Affirm's distributed database technologies, including AWS Aurora MySQL and DynamoDBLeading projects towards improving our database architecture, focusing on scalability, reliability, performance, and cost efficiencyWork closely with product teams to understand business requirements and translate them into robust database solutions.Develop and enforce best practices in database design, 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.Participating in an on-call rotation and collaborating with other teams, such as SRE, to solve production issuesWhat we look forBS degree in Computer Science with 3-5+ years of experience as a software engineer/ SRE with leadership exposure and experience mentoring junior engineersIn-depth, hands-on experience with large-scale database deployments in a production environmentExpertise in distributed databases and database technologies such as MySQL InnoDB storage (Preferred), Postgres, Spanner , CockroachDB etcExpertise in Database/Table and backup-recovery management.Expertise in SQL tuning and performance optimization techniquesExpertise in database scaling, benchmarking, load testings, and capacity planning.Familiarity with connection poolers and proxies such as ProxySQL, RDS Proxy Pg Bouncer, etcSolid understanding of distributed database architecture, data modeling, and performance tuningProficiency in Python or Kotlin or bothProficiency in Scripting and troubleshooting.Expertise to create and triage database alerts and issues, identify root causes, and implement corrective solutions.Experience with AWS and Kubernetes. Experience building software with IaC (terraform or crossplane) frameworks and toolsExceptional communication skills with the ability to engage effectively with both technical and non-technical stakeholders What you'll learnJoin us as we build a beloved, lasting financial services company predicated on honesty and trust. In this role, you'll understand the exciting challenges of helping a fast-growing company move towards a service-oriented architecture - diving into the scaling and availability challenges of infrastructural components that are the fundamental building blocks of a large scale system. You'll hone your ability to anticipate and recognize how to apply different technologies to solve a wide array of real world problems across the organization - all while building teams and working cross functionally with hardworking peers.Pay Grade- USA 30Employees new to Affirm or promoted into a new role, typically begin in the min to mid range.USA base pay range (CA, WA, NY, NJ, CT) per year: Min: $162,400Mid:$203,000Max:$243,500USA base pay range (all other U.S. states) per year: Min: $146,100Mid:$182,700Max:$219,200#LI-Remote
