Affirm is looking to scale its products to 10x and beyond through building world-class systems that enable honest financial products which improve lives.
Requirements
- 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, Vitess, TiDB, CockroachDB etc
- Solid understanding of distributed database architecture, data modeling, and performance tuning.
- Expertise in Database/Table and backup-recovery management.
- Expertise in SQL tuning and performance optimization techniques.
- Expertise in database benchmarking, load testings, and capacity planning.
- Familiarity with connection poolers and proxies such as ProxySQL, RDS Proxy, Pg Bouncer, etc.
Responsibilities
- Leading projects towards improving database architecture, focusing on scalability, reliability, performance, and cost efficiency.
- Working with engineers managing Affirm’s distributed database technologies, particularly AWS Aurora MySQL, Distributed SQL, and eventually expanding to DynamoDB and Caching.
- Design, build and highly durable and strongly consistent database as service architecture.
- Design and build solutions at scale for challenges such as multi-region, active resharding and globally available services.
- Work closely with product teams to understand business requirements and translate them into robust database solutions.
- Assist partners achieve better query performance by suggesting better query optimizations and effective schemas.
- Develop and enforce best practices in database design and management, ensuring data integrity, security, and optimal performance.
Other
- Bachelors or Masters degree in Computer Science with 5+ years of experience as a software engineer with leadership exposure and experience mentoring junior engineers.
- Exceptional communication skills with the ability to engage effectively with both technical and non-technical stakeholders.
- Participating in an on-call rotation and collaborating with other teams, such as SRE, to solve production issues.
- Leading and mentoring engineers to define and execute on roadmap aligned with stakeholder needs
