Staff Site Reliability Engineer, Database

<div class="content-intro"><p><strong>Who We Are:</strong></p> <p>Alpaca is a US-headquartered self-clearing broker-dealer and brokerage infrastructure for stocks, ETFs, options, crypto, fixed income, 24/5 trading, and more. Our&nbsp;<a href="https://alpaca.markets/blog/alpaca-raises-150-million-at-a-1-15b-valuation-to-build-the-global-standard-for-brokerage-infrastructure/">recent Series D funding round</a> brought our total investment to over $320 million, fueling our ambitious vision.</p> <p>Amongst our subsidiaries, Alpaca is a licensed financial services company, serving hundreds of financial institutions across 40 countries with our institutional-grade APIs. This includes broker-dealers, investment advisors, wealth managers, hedge funds, and crypto exchanges, totalling over 9 million brokerage accounts.</p> <p>Our global team is a diverse group of experienced engineers, traders, and brokerage professionals who are working to achieve our mission of&nbsp;<strong>opening financial services to everyone on the planet</strong>. We're deeply committed to open-source contributions and fostering a vibrant community, continuously enhancing our award-winning, developer-friendly API and the robust infrastructure behind it.</p> <p>Alpaca is proudly backed by top-tier global investors, including Portage Ventures, Spark Capital, Tribe Capital, Social Leverage, Horizons Ventures, Unbound, SBI Group, Derayah Financial, Elefund, and Y Combinator.</p> <p>&nbsp;</p> <p><strong>Our Team Members:</strong></p> <p>We're a dynamic team of 230+ globally distributed members who thrive working from our favorite places around the world, with teammates spanning the USA, Canada, Japan, Hungary, Nigeria, Brazil, the UK, and beyond!<br><br>We're searching for passionate individuals eager to contribute to Alpaca's rapid growth. If you align with our core values—Stay Curious, Have Empathy, and Be Accountable—and are ready to make a significant impact, we encourage you to apply.</p></div><h2><span style="font-size: 10pt;">Your Role:</span></h2> <p><span style="font-size: 10pt;">As a Site Reliability Engineer (SRE) at Alpaca, you will ensure the reliability, scalability, and performance of our systems and services. You will work closely with development, operations and devops teams to build and maintain robust applications, ensuring they run smoothly and efficiently. This role requires a blend of software engineering and operations skills, with a strong ability to troubleshoot technical issues and resolve problems before they impact our users.</span></p> <p>&nbsp;</p> <h2><span style="font-size: 10pt;">Things You Get To Do:</span></h2> <ul> <li style="font-size: 10pt;"><span style="font-size: 10pt;">Triage difficult technical problems and implement solutions</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;">Improve our observability stack (monitoring, logging, profiling)</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;">Incident Management: Respond to and resolve incidents in a timely manner, conducting post-incident reviews to identify and implement improvements.</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;">Collaboration: Work closely with development teams to ensure new features and services are designed with reliability and scalability in mind.</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;">Capacity Planning: Monitor system capacity and performance, making recommendations and implementing changes to handle future growth.</span></li> </ul> <h2><span style="font-size: 10pt;">Who you are (must-haves):</span></h2> <ul> <li style="font-size: 10pt;"><span style="font-size: 10pt;">5+ years of experience in Site Reliability Engineering, Performance Engineering, or similar roles.</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;">5+ years of experience with multi-terabyte scale PostgreSQL clusters.</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;">Proven track record of managing and maintaining large-scale, high-availability, and high-performance PostgreSQL database.</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;">Experience designing and implementing SLIs, SLOs, and SLAs for internal systems and databases.</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;">Experience with troubleshooting PostgreSQL performance problems and slow queries.</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;">Extensive experience with efficient schema design and efficient query design.</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;">Experience migrating multi-terabyte tables into more efficient schemas.</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;">Proficient with Go.</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;">Proficient with Prometheus.</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;">Proficient with Linux.</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;">Knowledgeable in trading/fintech domains.</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;">Experience with low-latency systems.</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;">Experience with distributed tracing.</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;">Experience scaling PostgreSQL clusters rapidly.</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;">Experience with pgx, gorm, or sqlc.</span></li> </ul><div class="content-conclusion"><h3><strong>How We Take Care of You:</strong></h3> <ul> <li style="font-weight: 400; text-align: justify;"><span style="font-weight: 400;">Competitive Salary &amp; Stock Options</span></li> <li style="text-align: justify;">Health Benefits</li> <li style="font-weight: 400; text-align: justify;"><span style="font-weight: 400;">New Hire Home-Office Setup: One-time USD $500</span></li> <li style="font-weight: 400; text-align: justify;"><span style="font-weight: 400;">Monthly Stipend: USD $150 per month via a Brex Card</span></li> </ul> <p><em><span style="font-weight: 400;">Alpaca is proud to be an equal opportunity workplace dedicated to pursuing and hiring a diverse workforce.<br></span></em></p> <p><span style="font-size: 8pt;"><a href="https://files.alpaca.markets/disclosures/AlpacaRecruitmentPrivacyPolicy.pdf"><em><span style="font-weight: 400;">Recruitment Privacy Policy</span></em></a></span></p></div>