Edtech.com's Summary

MagicSchool is hiring a Senior Database Engineer. This role involves designing optimal PostgreSQL data models, optimizing database performance, managing database operations including upgrades and monitoring, and ensuring data integrity and user privacy through secure data migrations and tooling. The engineer will collaborate closely with development and platform teams to architect large-scale data persistence systems and maintain best practices in database design.

Highlights

Design and optimize PostgreSQL data models and query patterns.
Manage database operations such as upgrades, backups, monitoring, and incident resolution.
Plan and execute large-scale data migrations while ensuring data security and privacy.
Collaborate with API and platform teams to support efficient database structure and new system architecture.
Require 5+ years hands-on experience with PostgreSQL in production environments and 3+ years collaborating asynchronously with development teams.
Strong expertise in SQL, database migrations, zero-downtime deployment, and performance tuning.
Valued experience includes backend/full-stack development (TypeScript/Next.js), Python data engineering, infrastructure-as-code, and non-relational databases.
Company offers employer-paid health insurance options, generous stock options vested over 4 years, 401k match, and monthly wellness stipend.
Team works on generative AI technology impacting over 6 million educators globally with a mission-driven culture focused on innovation, responsibility, and diversity.
Strong communication skills and ability to thrive in a growth-stage company environment are essential.

Senior Database Engineer Full Description

WHO WE ARE: 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.

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

Qualifications

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

Additional Valued / Nice to Have Experience:

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

Why Join Us?

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. We work hard for our teachers and users, and encourage our employees to rest and take the time they need.
Choice of employer-paid health insurance plans so that you can take care of yourself and your family. Dental and vision are also offered at very low premiums.
Every employee is offered generous stock options, vested over 4 years.
Plus a 401k match & monthly wellness stipend

Our Values:

Educators are Magic: Educators are the most important ingredient in the educational process - they are the magic, not the AI. Trust them, empower them, and put them at the center of leading change in service of students and families.
Joy and Magic: Bring joy and magic into every learning experience - push the boundaries of what’s possible with AI.
Community: Foster community that supports one another during a time of rapid technological change. Listen to them and serve their needs.
Innovation: The education system is outdated and in need of innovation and change - AI is an opportunity to bring equity, access, and serve the individual needs of students better than we ever have before.
Responsibility: Put responsibility and safety at the forefront of the technological change that AI is bringing to education.
Diversity: Diversity of thought, perspectives, and backgrounds helps us serve the wide audience of educators and students around the world.
Excellence: Educators and students deserve the best - and we strive for the highest quality in everything we do.

Original Job Description

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

Qualifications

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

Additional Valued / Nice to Have Experience:

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

Why Join Us?

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. We work hard for our teachers and users, and encourage our employees to rest and take the time they need.
Choice of employer-paid health insurance plans so that you can take care of yourself and your family. Dental and vision are also offered at very low premiums.
Every employee is offered generous stock options, vested over 4 years.
Plus a 401k match & monthly wellness stipend

Our Values:

Educators are Magic: Educators are the most important ingredient in the educational process - they are the magic, not the AI. Trust them, empower them, and put them at the center of leading change in service of students and families.
Joy and Magic: Bring joy and magic into every learning experience - push the boundaries of what’s possible with AI.
Community: Foster community that supports one another during a time of rapid technological change. Listen to them and serve their needs.
Innovation: The education system is outdated and in need of innovation and change - AI is an opportunity to bring equity, access, and serve the individual needs of students better than we ever have before.
Responsibility: Put responsibility and safety at the forefront of the technological change that AI is bringing to education.
Diversity: Diversity of thought, perspectives, and backgrounds helps us serve the wide audience of educators and students around the world.
Excellence: Educators and students deserve the best - and we strive for the highest quality in everything we do.

Let me find your next job.

Thanks - you're signed up.

Senior Database Engineer

Edtech.com's Summary

Senior Database Engineer Full Description

Student Learning Technology Assistant

IT Governance & Planning Mgr

Business Systems Analyst, Customer Operations

Senior SRE - Distributed Systems & Cloud Infrastructure

Data Quality & Verification Specialist