Desired Skills and Experience

  • Provide on-call support for issues that affect schools and our ability to deliver material to them
  • Ensure the smooth operations of all database systems
  • Manage databases in the full SDLC for new and existing products
  • Optimize the overnight batch processing of daily student data
  • Provide on-call support for issues that affect schools and our ability to deliver material to them
  • Oversee and enhance ETL across various database products
  • Help refactor data models as the needs and direction of the program change
  • Reinforce reliable, standardized processes for database administration (backup, disaster recovery, index optimization, security audits, etc).
  • Enhance security protocols to keep data safe
  • All of the above in addition to:
  • Serve as a database subject matter expert and partner with developers on performance tuning and best practices
  • Develop an ETL process to feed into a new data warehouse to support operational reporting and data science endeavors
  • Aid the Data Solutions team in data discovery, identification, and warehousing
  • Assess new cloud-based data opportunities as they evolve and become available
  • Help implement a new, pervasive monitoring and alerting framework across the company’s evolving infrastructure
  • Investigate cross-cloud opportunities for redundancy and distributed performance
  • Strong desire to work in a highly collaborative, dynamic, fast-paced, startup environment
  • Adaptable to changing environment and circumstances
  • Familiarity and comfort within an agile project/dev structure
  • Interest in working closely with both technical and non-technical team members
  • Comfort working with on-site and remote resources
  • Ability to internalize business goals and use that information to establish data solutions that scale well and are robust
  • Desire to learn enough about infrastructure management to cover for the Systems Administrator when not available
  • Must have: Experience working with production environments using SQL Server
  • Knowledge of indexes, index management, server configuration tuning, patching. How statistics work, how indexes are stored. How to configure AlwaysOn availability groups.
  • Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, connectivity issues, security issues etc.
  • Experience in Performance Tuning, Query Optimization, using Performance Monitor, DMVs, and reading execution plans
  • Ability to identify and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.
  • Knowledge of SQL Server tools (SolarWinds DPA, Extended Events, RedGate Plan Explorer)
  • T-SQL development experience – ability to write and troubleshoot, and design (stored procs, functions, tables, views, triggers, indexes, constraints)
  • Other than SQL Server
  • Comfort with alternative data platforms including PostgreSQL, Azure SQL, CosmosDB, MongoDB, Azure SQL Data Warehouse
  • Understanding of ORMs and object mappers
  • Experience with git
  • Experience with Atlassian products (JIRA, Confluence, Bitbucket)
  • Comfort with Windows and one or more popular Linux distributions
  • Knowledge of PowerShell and/or bash
  • Architectural understanding of how the data layer can best factor into an overall product stack
  • Experience with data reconciliation and migration between data environments (e.g. dev, test, staging, prod, etc)
  • All of the above in addition to:
  • Must have: demonstrated experience managing production grade, cloud hosted (strong preference for Azure), SQL Server database solutions servicing thousands of concurrent users that are geographically disparate
  • Knowledge of or desire to learn CI/CD for database systems
  • Other than SQL Server
  • Experience with alternative data platforms including PostgreSQL, Azure SQL, CosmosDB, MongoDB, Azure SQL Data Warehouse
  • Ability to debug and review C# code using ORMs and object mappers (NHibernate, Entity Framework, Dapper)
  • Experience with git
  • Experience with Atlassian products (JIRA, Confluence, Bitbucket)
  • Able to work in and maintain Linux VMs for database software, including bash scripting
  • Ability to create solutions in PowerShell for database management and Windows maintenance
  • Experience implementing, designing, or maintaining n-tier applications that utilize a shared data layer in the cloud.
  • Experience with dynamic data generation for testing, data obfuscation, and security best practices for PII data.