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
37Signals - 12 months ago
- save job
-
block
