Affirm · Remote · New York, United States
Join Affirm as a Senior Backend Software Engineer, where you'll be part of the Data and Storage Services team responsible for the company's data infrastructure. You'll have the opportunity to architect, build, and scale relational and distributed SQL databases, directly influencing your team's roadmap and collaborating with peers. This remote-first position offers a transparent compensation structure, generous time off, health benefits, and a supportive work environment.
- You are familiar with connection poolers and proxies such as ProxySQL, RDS Proxy, Pg Bouncer, PgDog etc
- You are proficient at making significant changes in a large code base, and have developed a suite of tools and practices that enable you and your team to do so safely
- You have in-depth, hands-on experience with large-scale database deployments in a production environment
- You have a total of 5+ years of experience as a software engineer
- You understand Kubernetes networking, service discovery and TLS well enough to debug connection and failover problems between services and databases
- You have executed zero-downtime migrations and major version upgrades on production databases, and have built CLI tooling or runbooks to make those procedures repeatable
- Your experience demonstrates that you take ownership of your growth, proactively seeking feedback from your team, your manager, and your stakeholders
- You have built control-plane or automation tooling for databases, such as provisioning, failover, upgrades or schema migrations, ideally on Kubernetes
- You have experience defining a technical plan for the delivery of a significant feature or system component with an elegant, simple and extensible design. You write high quality code that is easily understood and used by others
- You have expertise in distributed databases and database technologies such as MySQL(Preferred), TiDB(Preferred), Postgres, Spanner, Vitess, CockroachDB etc
- You have strong verbal and written communication skills that support effective collaboration with our global engineering team
- You are experienced in designing, developing and launching backend systems at scale technologies like Python, Kotlin, AWS, MySQL, Terraform and Kubernetes
- This position requires either equivalent practical experience or a Bachelor’s degree in a related field
- You have expertise in database benchmarking, load testing, and capacity planning
- Solid understanding of distributed database architecture, data modeling, and performance tuning. Particularly, expertise in SQL tuning and performance optimization techniques