Database Operations Engineer
Who We Are
Addepar’s purpose is to maximize the positive impact of the world’s capital. More than 700 of the world’s leading financial services firms trust Addepar to unlock the power and possibility of informed, data driven investing and advice. These family offices, wealth managers, banks and institutions use Addepar’s purpose-built SaaS platform and associated Marketplace to deliver exceptional value to their clients in a modern, scalable and secure way.
Our clients use Addepar to manage and advise on more than $3.5 trillion in assets, and we’ve been adding more than $15 billion per week for many consecutive quarters, making us one of the fastest growing companies in fintech. Our board and investors are some of the best in the business: D1 Capital, WestCap, 8VC and Valor Equity Partners have led our last few rounds.
We’re now expanding Addepar’s business around the globe, with clients in more than 25 countries. We’re constantly doubling down on tech- and data-fueled innovation, and our product and platform roadmap is more ambitious today than ever. We place our clients at the center of everything we do, and see a virtually unlimited set of opportunities to expand our client footprint and deepen the value we can unlock by building together.
Addepar is a Forbes Fintech 50 company and an honored member of the CB Insights Fintech 250. Addepar embraces a global flexible workforce model with offices in Silicon Valley, New York City, Salt Lake City and Edinburgh, Scotland.
*Marketplace and brokerage services provided by Acervus Securities, Inc., an SEC registered broker‑dealer and member FINRA / SIPC.
The Role
We are currently seeking a Database Engineer to join our Site Reliability Engineering team!
As Addepar's SRE Database Administrator, you'll be responsible for ensuring the availability and reliability of Addepar's core production databases. You'll play a leading role in implementing and maintaining best practices for database administration. Addepar moves quickly, so it's vital that you ensure our databases are running at optimum speed and efficiency. This position involves critical duties and responsibilities that must continue to be performed during crises and contingency operations, which may necessitate extended hours of work. In this position, your responsibility will include system design, configuration, deployment, and operations of Database operations and Database observability systems and tools. These systems include monitoring services and infrastructure, log collection and analytics, and Database Performance Monitoring (DPM). Together these systems and tools serve as a critical part of Addepar’s Cloud infrastructure services. The ideal candidate will need to have a strong cloud platform, AWS Database Services, MySQL, PostgreSQL, Linux systems, and DBAOps experience, and demonstrate experience with database architecture and production workloads at scale.
What You’ll Do
- Assume administrative and operational ownership of Addepar's self-managed and AWS-based Database services, including MySQL and PostgreSQL.
- Create, operate and deliver KPI-focused database monitoring solutions and reports using enterprise-grade Database observability methodologies and risk management processes.
- On-board Addepar Databases and critical applications to Enterprise Observability tools and services across Addepar to enable monitoring and alerting with best practices and standard Database Performance Monitoring (DPM) tools
- Troubleshoot and resolve database performance-related issues
- Establish customized monitoring dashboards, thresholds, alerting to enable Addepar application and support teams fully
- Establish, document, and maintain Database observability program including monitoring tools, support run books, and documentation to ensure proper monitoring in production is continuous
- Serve as a subject matter expert on Database Performance Monitoring (DPM), logging, and other observability & visualization tools
- Performance expert consultation and training services to our application development and platform support partners
- Support the high availability and disaster recovery options of Addepars Database instances - AlwaysOn Availability and Database Replication are in place and active
- Develop automated scripts for maintenance tasks
- Build, own, update and maintain all Database topology and architecture diagrams and documentation.
- Maintain, develop and report on metrics relative to Critical Incident Response Team activities for monthly business and flash reporting for senior leadership and internal business units
- Work with a team of experienced engineers to test your ideas and understand the system, and mentor junior team members
- Build and maintain successful relationships with existing and prospective members, ensuring end-to-end observability of Addepars platform
- Excellent problem solving and critical thinking skills, and ability to function and communicate under pressure
- Participate and lead efforts involving incident response and root cause analysis for Site Reliability Engineering
- Being on-call and available for rotational shift support for production issues
- Demonstrate outstanding communication, flexibility, teamwork, and leadership
- Participate, present, and speak to KPI's metrics and uptime performance data in management and executive-level debriefs.
What You’ll Do
- 10+ years of experience in Database engineering or Database Administration.
- Developing pipelines using CICD tools: Github Actions and/or Jenkins is a plus.
- Linux/*NIX administration.
- Public cloud providers: AWS, Azure.
- Programming experience in Java, C++, Python, Go, or Deep experience managing large-scale software and distributed systems and environments.
- An understanding of and experience with web application development.
- A solid foundation in computer science, with competencies in data structures, algorithms, and software design practices.
- Understand database design, caching, scalability, and network fundamentals.
- 5+ years of experience with Docker, Kubernetes, Sensu, Prometheus, or other CNCF software is a big plus.
- An understanding of and experience with incident alerting platforms, Pagerduty
- Technical documentation skills, produced in a step-by-step manner, regarding every task.
- BS, or MS degree in Computer Science or related technical field or equivalent industry experience.
- An understanding of and experience in Product/Project management and issue tracking systems (Jira, Smartsheets, Aha a plus)
- Demonstrated ability in leadership, facilitation, collaboration, and negotiation.
- Demonstrated ability to operate in a highly matrix environment and align to common vision, objectives, and outcomes.
- Ability to translate complicated technical concerns to non-technical individuals.
- Highly skilled at database design, installations, conversions responsible for database backup and recovery procedures, access security and database integrity, data storage design, and data storage management.
- Experienced in Database Performance, Maintenance (DPM), and Development to perform the following: Database management including backups, recovery, and maintenance; Database Disaster Recovery planning, testing, execution and documentation; Database Security policies, access control, and security settings; Database management for export, import, and mass data loads; Analyzes and generation of all tables and index statistics; Database monitoring and resolving bottlenecks and data lock issues, resolve issues on time; Check all statistics related to memory, locks, I/O, database response time, wait for events, top sessions, and background processes; On-Line Transaction Processing (OLTP) to capture, validate and store large amounts of transactions; Database guidance to engineers and participate in peer reviewing pull requests related to SQL code.
- AWS Certified Database - specialty
- AWS Certified Solutions Architect / Professional is a plus
Our Values
- Act Like an Owner - Think and operate with intention, purpose and care. Own outcomes.
- Build Together - Collaborate to unlock the best solutions. Deliver lasting value.
- Champion Our Clients - Exceed client expectations. Our clients’ success is our success.
- Drive Innovation - Be bold and unconstrained in problem solving. Transform the industry.
- Embrace Learning - Engage our community to broaden our perspective. Bring a growth mindset.
In addition to our core values, Addepar is proud to be an equal opportunity employer. We seek to bring together diverse ideas, experiences, skill sets, perspectives, backgrounds and identities to drive innovative solutions. We commit to promoting a welcoming environment where inclusion and belonging are held as a shared responsibility.
To ensure the health and safety of all Addepeeps and our prospective candidates, we have instituted a virtual interview and onboarding experience.
Unfortunately, at this time we cannot accept Colorado applicants.