Database Engineer

**About us**

Have you always wanted to put your passion for education to use on the job? Would you like to work with an incredible team making an impact on learning around the world? If you answered yes, we can't wait to meet you

And just who are we? Edpuzzle is a leading edtech company with offices in San Francisco and Barcelona and nearly 10 years of history helping teachers find and create exciting, interactive video lessons. Over 80% of U.S. schools and millions of teachers and students in 190+ countries around the world are already using Edpuzzle to make education more equitable and engaging.

**About the role**

We’re looking for our first **Database Engineer** to join our **Security & Infrastructure** in **Spain**. You’ll ensure the optimized performance and resilience of our database systems, tailoring it to the demands of our educational platforms. As a Database Engineer, you will focus on balancing efficiency, scalability, and cost, while providing the robust database solutions necessary to meet the needs of our products and users.

**What technologies will you find?**

Technically speaking, our product is written in **JavaScript and Node.js **and our infrastructure is fully hosted on **AWS** which we also use to store, encode, and stream our own pool of videos. Our data is stored on **MongoDB Atlas** and we also work with **Elasticsearch** and **Redis** for our search engine and caching. We are continuously improving our release pipeline with CI/CD and Infrastructure as Code, using technologies like **GitHub Actions, CloudFormation **and** CDK**, making sure we never compromise on code quality and reliability. For monitoring and alerting, our main tools are **Datadog **and** CloudWatch**.

**Wondering what it’s like to work at Edpuzzle?**

Picture a place where you can connect with your teammates, whether remotely or in person, whenever you need support. A place where one day you're helping shape one of the biggest edtech platforms in the world, and the next day you're doing a teambuilding activity with your coworkers. A place where everyone has been selected because they're the best at what they do, and where your manager and team trust your decisions fully. A place where you're encouraged to learn and grow because education is the cornerstone of everything we do. Check out the job details below to see if Edpuzzle could be the right fit for you

**About the job**:

- Design, implement, and manage database solutions in a cloud environment using MongoDB Atlas, Elasticsearch on AWS, and Redis on ElastiCache.
- Work closely with the Engineering teams to optimize data structures and refine queries, commands, and indexes.
- Write custom scripts for data manipulation, migrations, and complex operations, ensuring they are executed with precision and mínimal downtime.
- Proactively monitor database metrics to foresee performance bottlenecks and implement improvements.
- Engage in capacity planning and demand forecasting, anticipating performance issues.
- Drive the development of tools and procedures for database backups, recovery, and maintenance.
- Manage data security and compliance requirements, ensuring user data protection.
- Perform root cause analysis for production errors and database issues.
- Have a good understanding of the product functionalities.
- Performs other duties as assigned.

**About you**:

- More than** 4 years of experience** in database engineering or database administration for a high-traffic, web-based product.
- Bachelor's degree in Computer Science, Engineering, or a similar degree.
- In-depth knowledge of **MongoDB**, performance tuning, and replication strategies.
- In-depth knowledge of **performance tuning for NoSQL databases**, including index creation, query optimization, and understanding the performance trade-offs of database design choices.
- In-depth knowledge of database cloud environments like **MongoDB** **Atlas**.
- Familiarity with caching databases (such as **Redis**) and search engines (such as **Elasticsearch** or **Opensearch**), performance tuning, and replication strategies.
- Working experience in scripting languages such as Python or JavaScript for automating database-related operations (JavaScript preferred).
- Working experience with **Git** or equivalent version control system.
- Familiarity with **monitoring and alerting** tools like CloudWatch, Datadog, or New Relic.
- You feel comfortable communicating in **English** within an international and multicultural team.
- You are **based in Spain** and have a work permit to work in Spain.

**Bonus skills**:

- Familiarity with cloud solutions like Amazon Web Services.
- Familiarity with Infrastructure as Code tools such as AWS CloudFormation, CDK or Terraform.
- Specific training in database design, database administration, or database optimization with a specific focus on MongoDB.
- Experience in implementing and managing security measures for databases, including encryption, access control