Senior Software Engineer
Online Storage SRE
Posted on 3/22/2024
Affirm

1,001-5,000 employees

Point of sale installment loans for consumers
Company Overview
Affirm seeks to deliver honest financial products—to improve lives. The company operates a buy-now-pay-later platform for consumers at the point of sale.
Financial Services
Consumer Goods
Data & Analytics

Company Stage

N/A

Total Funding

$2.9B

Founded

2012

Headquarters

San Francisco, California

Growth & Insights
Headcount

6 month growth

0%

1 year growth

-2%

2 year growth

4%
Locations
Remote in USA
Experience Level
Entry
Junior
Mid
Senior
Expert
Desired Skills
Kotlin
CockroachDB
Kubernetes
Python
MySQL
SQL
Postgres
AWS
Terraform
CategoriesNew
Backend Engineering
Software Engineering
Requirements
  • BS degree in Computer Science with 3-5+ years of experience as a software engineer/ SRE with leadership exposure and experience mentoring junior engineers
  • In-depth, hands-on experience with large-scale database deployments in a production environment
  • Expertise in distributed databases and database technologies such as MySQL InnoDB storage (Preferred), Postgres, Spanner , CockroachDB etc
  • Expertise in Database/Table and backup-recovery management
  • Expertise in SQL tuning and performance optimization techniques
  • Expertise in database scaling, benchmarking, load testings, and capacity planning
  • Familiarity with connection poolers and proxies such as ProxySQL, RDS Proxy Pg Bouncer, etc
  • Solid understanding of distributed database architecture, data modeling, and performance tuning
  • Proficiency in Python or Kotlin or both
  • Proficiency 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 tools
  • Exceptional communication skills with the ability to engage effectively with both technical and non-technical stakeholders
Responsibilities
  • Working with engineers managing Affirm’s distributed database technologies, including AWS Aurora MySQL and DynamoDB
  • Leading projects towards improving our database architecture, focusing on scalability, reliability, performance, and cost efficiency
  • Work 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 issues