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.