SlipstreamJobs tracks this role from the company's public career site. Apply directly on the employer's site.
Canopy is a fast-growing SaaS company building practice management software for accounting firms. We're seeking a Senior Database Engineer to own and optimize our fleet of 100+ PostgreSQL databases, ensuring optimal performance, security, and reliability across our platform.
You'll be central to backend engineering efforts, working alongside developers, product managers, and QA engineers to shape data models and keep our platform fast and reliable. Your responsibilities include:
• Oversee maintenance of 100+ managed databases to ensure optimal performance, security, and reliability
• Monitor database health, identify bottlenecks, and recommend actionable solutions
• Own database cost and capacity planning—right-sizing instances, forecasting spend, and making investment decisions
• Use historical performance and growth trends to plan for busy seasons, scaling up before load arrives and scaling back when unnecessary
• Refine and refactor database structures to align with best practices and enhance data access for backend developers
• Own index and query health across the fleet: plan analysis, slow query review, index coverage and bloat, autovacuum tuning, and connection pooling
• Advise on and implement modern database best practices to elevate platform reliability and efficiency
• Collaborate with teams to write and optimize complex database queries and migrations
• Serve as the database reviewer on squad design docs—every new feature's data model, schema changes, and query patterns get your sign-off alongside the tech lead
• Spearhead initiatives to minimize downtime during database maintenance
• Provide mentoring and training to team members on database insights and optimizations
• Develop and communicate SQL best practices to engineering teams
Canopy emphasizes delighting customers, spotting and solving problems, and being good people along the way. Our DevOps tooling and microservices architecture enable teams to ship to production hundreds of times a month—your job is to ensure the database layer keeps up.
REQUIREMENTS:
• Minimum 5 years of experience as a Database Engineer with a track record of managing and optimizing databases
• 5+ years of experience writing SQL and working with relational database systems, specifically PostgreSQL
• Acute ability to diagnose database performance issues and provide solutions
• Proven experience implementing database best practices and ensuring minimal downtime
• Experience with managed cloud database infrastructure (RDS preferred)
• Excellent communication skills, fostering collaboration and understanding across teams
• Relentless passion for ensuring data integrity and accessibility, combined with drive to build innovative, scalable solutions
BONUS SKILLS:
• Experience with warehousing techniques for analytics and reporting
• Proficiency with Python and/or Java/Kotlin
