Lead Database Administrator
Posted on Tuesday, November 14, 2023
At Instructure, we believe in the power of people to grow and succeed throughout their lives. We aim to amplify that power by creating intuitive products that simplify learning and personal development, facilitate meaningful relationships, and inspire people to further their education and careers. We do this by giving smart, creative, passionate people opportunities to create awesomeness. And that's where you come in!
Do you dream in SQL? When someone says CRUD, do you instantly think in terms of data manipulation? If you were given a Mongo book for your birthday, would you immediately trade it in for a book by Michael Stonebraker? If so, then we have an opportunity that you can not refuse. Come join a team that is making software to make people smarter, and who have a real chance to change the world.
This time, we are seeking a highly motivated and technically proficient individual with a background in database administration, who aspires to excel in technical-, project-, and resource management within our engineering department. In this role, you will be responsible for overseeing the planning, execution, and successful completion of engineering projects, while effectively managing resources, budgets, and teams. You will be managing 3 engineers directly.
We need someone who can
- Explain why databases are one of the most difficult layers of the stack to work with, and how to overcome their special challenges.
- Comfortably work in a SQL prompt on production systems.
- Own projects and drive them to completion
- Have the customer focus to seek out what needs doing, then collaborate to get it done
- Have the knowledge to know how to respond to database problems
- Be able to automate stuff so that there aren't database problems
- Be a point of contact for questions, both from technical engineers and less technical members of the company
- Be on top of problems before they become problems
- Be part of an on-call team
- Lead and coordinate engineering projects from initiation to closure, ensuring they meet defined objectives, timelines, and budgets by implementing project management methodologies and tools
- Allocate resources efficiently to support project requirements, including personnel, equipment, and budgetary resources, optimizing resource utilization to maximize productivity
- Provide leadership, mentorship, and guidance to engineering teams and colleagues, fostering a collaborative and high-performance culture while resolving conflicts and facilitating communication within cross-functional teams
- Leverage DBA background to understand technical aspects of projects and effectively communicate with technical teams, staying updated on relevant technologies and industry trends
- Communicate project status, risks, and milestones to stakeholders, including senior management and clients, ensuring transparency and alignment with project goals and expectations
- Implement quality assurance processes to maintain high standards of deliverables and project outcomes
Here's what you will need to know/have
- Windows Server, Linux
- Amazon Web Services
- MSSQL, or some other ACID-compliant SQL database
- pgBouncer, or some other form of database pooling
- Ansible, or some other form of config management
- Datadog, or some other form of resource monitoring and alerting
- Fleets of dozens of servers
- bash, git, Python, Powershell etc.
- Performance tuning
- No fear of learning The New Shiny, and no need to remake what isn't broken
- Demonstrated expertise as a Database Administrator
- Inner motivation to explore the role of Engineering Manager
- Project management skills
- Past leadership experience or a promising leadership aptitude, coupled with the capability to oversee and motivate teams
- Excellent communication and interpersonal skills, fluency in English
- Readiness to transition into a managerial role, showcasing traits such as responsibility, accountability, and a focus on achieving outcomes
- Adaptability to varied working hours, as collaboration with stakeholders in both Europe and the United States will be necessary
- Strong expertise in MSSQL Server, encompassing installation, configuration, tuning, query optimization, backup and recovery, as well as security best practices including user authentication and access control.
- Experience with Java, Apache Tomcat Application Server, SpringBoot Framework, Apache Struts Framework
- Continuous Integration/Continuous Deployment (CI/CD) experience, Jenkins preferred
Get in on all the awesome of Instructure
- A fun, friendly, and helpful company culture
- Competitive compensation
- Restricted Stock Unit Program
- Private Medicover healthcare + cafeteria plan/SZEP card
- Employee Stock Purchase Program
- Wellness motivation through PandaFit
- An extra week off for the whole company every year
- Employee recognition program through Motivosity
- Goal-setting, proactive reviews, and internal training
- Employee assistance program
Our product area focuses on providing a comprehensive K-12 education technology and interoperability solution for approximately 1400 school districts across the U.S. We are building a central control hub to operate and monitor these districts, ensuring accurate, complete, and up-to-date district data. Our goal is to empower districts to proactively identify and resolve data issues, offering features like automated data validation, state reporting support, time and resource savings, data ownership, funding maximization, and proactive issue detection for informed decision-making. Our Elevate Data Quality platform systemizes data quality programs, making data accuracy a year-round reality for schools.
Our tech-stack is focused on AWS EKS, MSSQL, Redis, PostgreSQL, DynamoDB, Docker, K8S, Jenkins, Terraform
We’ve always believed in hiring the most awesome people and treating them right. We know that the more diverse we are, the more diverse our ideas will be and when we openly welcome those ideas, our environment is better and our business is stronger.
All Instructure employees are required to successfully pass a background check upon being hired.