Senior Database Engineer

MagicSchool AI

76d

About The Position

MagicSchool is the premier generative AI platform for teachers. We're just over 2 years old, and more than 6 million teachers from all over the world have joined our platform. Join a top team at a fast growing company that is working towards real social impact. Make an account and try us out at our website and connect with our passionate community on our Wall of Love.

Requirements

• 5+ years of hands-on experience operating PostgreSQL in production environments
• 3+ years of hands-on experience asynchronously collaborating with development teams, either in application development or infrastructure as code.
• Strong SQL skills including complex queries, performance tuning, and data modeling
• Experience with database migrations, schema evolution, and zero-downtime deployment strategies
• Proficiency with database monitoring, performance analysis, and troubleshooting
• Understanding of database internals: indexing strategies, query planning, and execution optimization
• Experience working closely with application developers and understanding application data access patterns
• Strong communication and collaboration skills
• Comfort working in a fast paced growth-staged company

Nice To Haves

• Backend or full-stack engineering experience in a Typescript or Next.js environment
• Python application, data pipeline, or data warehouse engineering
• Experienced with infrastructure-as-code / devops practices and environments.
• Experience with non-relational database usage in a production environment
• Familiarity with the Supabase platform

Responsibilities

• Application Database Design
• Partner with application development teams to design optimal Postgres data models that support new features and scale with business growth
• Review and optimize Postgres data structures and query patterns to ensure efficient performance
• Collaborate on API design decisions that impact database structure and query efficiency
• Database Operations
• Analyze database query load to find opportunities for efficiency gains, and implementing them practively
• Implement and maintain database observability and monitoring systems
• Manage database upgrades, backup strategies, and read replica configurations
• Troubleshoot and resolve production database incidents as part of support rotation
• Maintain and enhance adherence to devops principles in database operations.
• Data Integrity & User Privacy
• Plan, review and execute application data migrations, collaborating with product development teams to coordinate releases
• Implement and execute efficient large scale data migrations
• Design and implement data security / privacy tooling
• Data Platform
• Collaborate with development and platform team to architect large scale new data persistence systems and migrate production traffic to them
• Develop and promote standards and best practices of database design and development

Benefits

• Work on cutting-edge AI technology that directly impacts educators and students.
• Join a mission-driven team passionate about making education more efficient and equitable.
• Flexibility of working from home, while fostering a unique culture built on relationships, trust, communication, and collaboration with our team - no matter where they live.
• Unlimited time off to empower our employees to manage their work-life balance.
• Choice of employer-paid health insurance plans including dental and vision at very low premiums.
• Every employee is offered generous stock options, vested over 4 years.
• 401k match & monthly wellness stipend

What This Job Offers

• Number of Employees: 101-250 employees