Database Administrator

New Classrooms is a nonprofit organization that leverages classroom design, teacher talent, and technology to enable personalized learning for more than 13,000 students in 38 pioneering schools.

We need a person who loves every aspect of how data contributes to an application because it is crucial to ours. This person will be responsible for improving our data model, ensuring that database access is efficient, directing data backup/restore, failover, and disaster recovery. The DBA will champion the data portion of our architecture and keep data flowing effectively between systems. We are a startup which means everyone wears many hats. We need classic DBA capabilities as well as more strategic thinking.

**Junior:** * 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 **Senior:** 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

**What We Are Looking For** * 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 **Technical Skills** **Junior:** * 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 **Infrastructure** * 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) **Senior:** 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 **Infrastructure** * 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.