We're sorry, but this job has been placed on hold. See other open jobs at Schoology

Senior Database Engineer

New York, NY | Engineering

Job Description

Schoology is one of the fastest growing education technology startups, with nearly 1 million users across the world. To support our rapid growth we are expanding our team. We are looking for someone to own the stack, leading the charge in our infrastructure opersations. 

About Schoology:

Schoology is a learning platform and network that connects student, parents, and educators to each other, and to their academic life. From the basics of online homework and grading to completely virtual and self-paced courses. From private groups to public, cross-school professional learning networks. Schoology is about learning. Together.

Responsibilities:

  • Work directly with the CTO and DevOps team
  • Own and manage the entire database stack (producting, testing, development)
  • Deploy, configure, and monitor numerous MySQL, Redis, Memcache instances
  • Administer and support a stable, reliable, and recoverable database platform
  • Design the next generation of database infrastructure to meet the growing needs of our traffic
  • Work closely with developers in supporting new features and services
  • Plan for database capacity limits and anticipate future database infrastructure needs
  • Solve database performance bottlenecks - and work closely with the application team to catch issues before they hit production
  • Troubleshoot database-related problems, including replication, bloat, and vacuums
  • Improve database backup, schema migration, data migration, and security processes
  • Automate routine tasks with your own scripts and open-source tools
  • Write documentation and collaborate with technical peers online

Experience:

  • BA/BS Computer Science or equivalent experience
  • 2-5 years MySQL database administration experience (sharding, replication, high-availability)
  • At least 4 years of experience with Linux as a power user or administrator
  • Experience with database replication and scaling issues is a huge plus
  • Solid knowledge of SQL, relational database concepts, and web technology
  • Expert in reviewing and tuning queries
  • Expert in backup and restore procedures
  • Experience with eventual consistency and NOSQL
  • Strong coding skills in at least one of Perl, Python, Ruby, PHP or Java
  • Knowledge of best practices related to security, performance, and disaster recovery
  • Understanding of both MyISAM and InnoDB storage engines; Deep understanding of InnoDB internals and performance quirks is a big plus
  • Knowledge of system tools such as netstat, Isof, iostat, vmstat, and others, and the ability to deploy that knowledge in production-critical investigations

Skills:

  • Comfortable with solving SQL performance issues - identifying slow queries and possible solutions
  • Interest in learning and taking on increasingly complex tasks
  • Strong organizational skills and detail-oriented work ethic
  • Scripting and coding (bash, python, c)
  • Strong verbal and communication skills
  • Knowledge of replication, tuning, and monitoring

Perks:

  • Competitive salaries
  • Full benefits
  • Generous stock options
  • Weekly FreshDirect grocery delivery & weekly catered lunch
  • Monthly office happy hour/party
  • Lounge with pool table
  • Classic Pac-Man/Galaga arcade machine
  • Coke machine stocked with free drinks
  • Full kitchen

 

Position Filled
Not the right job?
Describe your perfect job
Join our Talent Network »