WHO WE ARE: MagicSchool is the premier generative AI platform for teachers. Were 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 <a target="_blank" href="https://www.magicschool.ai">our website</a> and connect with our passionate community on our <a target="_blank" href="https://love.magicschool.ai/all">Wall of Love</a>.Responsibilities<ul><li>Application Database Design<ul><li>Partner with application development teams to design optimal Postgres data models that support new features and scale with business growth</li><li>Review and optimize Postgres data structures and query patterns to ensure efficient performance</li><li>Collaborate on API design decisions that impact database structure and query efficiency</li></ul></li><li>Database Operations<ul><li>Analyze database query load to find opportunities for efficiency gains, and implementing them practively</li><li>Implement and maintain database observability and monitoring systems</li><li>Manage database upgrades, backup strategies, and read replica configurations</li><li>Troubleshoot and resolve production database incidents as part of support rotation</li><li>Maintain and enhance adherence to devops principles in database operations.</li></ul></li><li>Data Integrity &amp; User Privacy<ul><li>Plan, review and execute application data migrations, collaborating with product development teams to coordinate releases</li><li>Implement and execute efficient large scale data migrations</li><li>Design and implement data security / privacy tooling</li></ul></li><li>Data Platform<ul><li>Collaborate with development and platform team to architect large scale new data persistence systems and migrate production traffic to them</li><li>Develop and promote standards and best practices of database design and development</li></ul></li></ul>Qualifications<ul><li>5+ years of hands-on experience operating PostgreSQL in production environments</li><li>3+ years of hands-on experience asynchronously collaborating with development teams, either in application development or infrastructure as code.</li><li>Strong SQL skills including complex queries, performance tuning, and data modeling</li><li>Experience with database migrations, schema evolution, and zero-downtime deployment strategies</li><li>Proficiency with database monitoring, performance analysis, and troubleshooting</li><li>Understanding of database internals: indexing strategies, query planning, and execution optimization</li><li>Experience working closely with application developers and understanding application data access patterns</li><li>Strong communication and collaboration skills</li><li>Comfort working in a fast paced growth-staged company</li></ul>Additional Valued / Nice to Have Experience:<ul><li>Backend or full-stack engineering experience in a Typescript or Next.js environment</li><li>Python application, data pipeline, or data warehouse engineering</li><li>Experienced with infrastructure-as-code / devops practices and environments.</li><li>Experience with non-relational database usage in a production environment</li><li>Familiarity with the Supabase platform</li></ul>Why Join Us?<ul><li>Work on cutting-edge AI technology that directly impacts educators and students.</li><li>Join a mission-driven team passionate about making education more efficient and equitable.</li><li>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.</li><li>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.</li><li>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.</li><li>Every employee is offered generous stock options, vested over 4 years.</li><li>Plus a 401k match &amp; monthly wellness stipend</li></ul>Our Values:<ul><li>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.</li><li>Joy and Magic: Bring joy and magic into every learning experience - push the boundaries of what’s possible with AI.</li><li>Community:  Foster community that supports one another during a time of rapid technological change. Listen to them and serve their needs.</li><li>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.</li><li>Responsibility: Put responsibility and safety at the forefront of the technological change that AI is bringing to education.</li><li>Diversity: Diversity of thought, perspectives, and backgrounds helps us serve the wide audience of educators and students around the world.</li><li>Excellence:  Educators and students deserve the best - and we strive for the highest quality in everything we do.</li></ul>

MagicSchool AI

Senior Database Engineer

MagicSchool AI

Similar Remote Jobs