Senior Database Engineer

Job Overview:

The Database Engineering Team at ExploreK12 is looking for a Senior Database Engineer to be responsible for providing database support and strategy for our database ecosystem. Database administration includes production support, upgrades, performance tuning, disaster recovery as well as helping set and enforce database level controls and standards for the applications team.

This is an individual contributor role with significant technical influence, you'll set database standards and best practices that application engineering teams follow, without direct reports. This role reports to the Systems Manager and will often collaborate with the engineering teams offering guidance.

Job Responsibilities:

• Replication configuration and management
• SQL query plan analysis and optimization
• Backup and restoration management
• Application query optimization
• Enhances the effectiveness of database tools and services
• Enhances the scalability and performance of existing database structures
• Work with system engineers to maintain and monitor backup processes and test restorations including disaster recovery
• Work with the infrastructure and other internal teams (e.g. developers and product managers) to identify system requirements
• Monitor system performance and alerts to identify current and future problems
• Ethical handling of private data
• Minimize database downtime and maximize database reliability
• Predict capacity requirements
• Help review requirements, specifications and technical design documents to provide timely and meaningful feedback
• Keeps up to date with technological developments

Job Requirements:

• 5+ years of experience with engineering and/or administering databases
• Hands on, professional experience building and operating performance critical applications and databases, with significant experience in both MySQL/Linux and SQL Server/Windows environments
• Strong knowledge of relational databases including normalization, indexing and SQL
• Knowledge of data security and integrity
• Knowledge of a high-volume SaaS database environment
• Exceptional communications skills (verbal, written, illustrative/diagrammatic)
• Ability to build strong relationships

Preferred Qualifications:

• Experience with student-data privacy frameworks (e.g. FERPA) strongly preferred given the nature of our platform
• Knowledge of PHP or other scripting languages
• Experience with NoSQL databases
• Experience working in an Agile/Scrum development process
• Recent experience with iPaaS and/or canonical data models