Senior Software Engineer (Online Storage)

Posted 2 days agoViewed

View full description

💎 Seniority level: Senior, 5+ years

📍 Location: United States, Canada

💸 Salary: 150000.0 - 200000.0 USD per year

🔍 Industry: Financial Services

⏳ Experience: 5+ years

🪄 Skills: AWSPythonSQLKotlinKubernetesMySQLCommunication SkillsMentoringTerraformData modelingSoftware Engineering

Requirements:

5+ years of experience as a software engineer 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, Vitess, TiDB, CockroachDB etc
Solid understanding of distributed database architecture, data modeling, and performance tuning. Particularly, expertise in SQL tuning and performance optimization techniques.
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.
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.
Expertise to create and triage database alerts and issues, identify root causes, and implement corrective solutions.

Responsibilities:

Leading projects towards improving our 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.
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.
Leading and mentoring engineers to define and execute on roadmap aligned with stakeholder needs

Apply

Related Jobs

Apply

🔥 Senior Software Engineer (Online Storage)

Posted about 22 hours ago

📍 USA

🧭 Full-Time

💸 169000.0 - 240000.0 USD per year

🔍 Software Development

🏢 Company: Affirm👥 1001-5000💰 Post-IPO Equity about 4 years ago🫂 Last layoff about 2 years agoLending Financial Services Payments FinTech

🔧 Requirements

Bachelors or Masters degree in Computer Science with 5+ years of experience as a software engineer 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, Vitess, TiDB, CockroachDB etc
Solid understanding of distributed database architecture, data modeling, and performance tuning. Particularly, expertise in SQL tuning and performance optimization techniques.
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.
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.
Expertise to create and triage database alerts and issues, identify root causes, and implement corrective solutions.

💡 Responsibilities

Leading projects towards improving our 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.
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.
Leading and mentoring engineers to define and execute on roadmap aligned with stakeholder needs

AWSLeadershipProject ManagementPythonSQLKotlinKubernetesMySQLAlgorithmsAPI testingData StructuresREST APICommunication SkillsAnalytical SkillsCollaborationCI/CDProblem SolvingMentoringLinuxDevOpsTerraformData modelingScriptingSoftware Engineering

Posted about 22 hours ago

Apply