Sr Database Reliability Engineer

Senior Database Reliability Engineer

Remote or Hybrid to Wayne, PA; Austin, TX; Naperville; IL

 

Frontline Education is a pioneer of school administration software purpose-built for K-12 districts. We provide innovative, connected solutions for student and special programs, business operations, and human capital management with powerful data and analytics to empower educators and administrators. We earn the trust of K-12 leaders across the U.S. by serving as a consistently high-performing, forthright partner of school districts through every dimension of the company. 

Frontline has a dynamic career growth opportunity for a Senior Database Reliability Engineer (DBRE) to help develop, build and support efficient database solutions for our custom applications.  Acting as a key member of the Data Operations Team, this individual will be responsible for the successful operation and support of Frontline data environments.  The DBRE is responsible for overseeing database policies and procedures to ensure the performance, integrity and availability of databases and their accompanying software.  

  

We at Frontline are heavily dependent on Microsoft SQL Server, MongoDB, DB2, PostgreSQL and MySQL for many of our application data management responsibilities, but also have a growing collection of new and exciting database technologies for which we are responsible.  For this reason, we are looking for someone who has a successful track record for developing and maintaining relational and NoSQL database environments, but who is also open minded and ready to learn new database technologies as the need arises.  This individual will proactively identify opportunities for automation, improved efficiency, and elimination of redundant processes on all levels of operational and development-focused database work. Senior Database Reliability Engineer takes pride in their work and has a sense of ownership for the systems that they support.  We have a great work environment here at Frontline and we are looking for someone who will be a complement to our existing Database Management team.   

 

Primary Responsibilities: 

• Manage/maintain/monitor database systems. 
• Perform routine audits of systems. 
• Design and performance tune database systems. 
• Maintain and report system performance statistics. 
• Designing databases for optimal application performance. 
• Safeguarding information in databases against accidental or unauthorized damage, modification or disclosure. 
• Automate routine time-consuming operational tasks. 
• Support MS SQL Server and MySQL on premise and in the AWS cloud. 
• Support AWS PostgreSQL Aurora, DB2 in the AWS cloud. 
• Support Atlas MongoDB in AWS. 
• Support Snowflake hosted in AWS and more. 
• Supports DBMS technologies on both Microsoft and Linux operating systems. 
• Develop/Support DBMS systems for highly available applications. 
• Develop/Manage/maintain/monitor database backup and recovery strategies. 
• Experience with some of the following technologies and concepts is not required but would be a plus: Microsoft Operating systems, PostgreSQL (AWS Aurora), MongoDB (Atlas), Linux Operating systems, Active Directory, SSIS, OLTP data environments, Data Archiving, Snowflake, Wait Statistics, Solarwinds DPA/DPM, PowerShell, MySQL, DB2, Agile Methodologies, Amazon cloud database technologies, VMWare, Cloud Automation.  

Critical Performance Objectives: 

1. Within the first 6 months of hire you will be performing most routine Operational DBRE responsibilities which include  

• Ensuring all data environments conform to our RPO and RTO objectives. 
• Ensuring the high availability/reliability of all data environments. 
• Ensuring the security of all data environments. 
• Monitoring of all database environments. 
• Cross Team Collaboration. 

1. After 6 months you should feel comfortable supporting the operational needs of our data environments and participate in Frontline Database On-Call Rotation.  Added responsibilities include: 

• Incident response, root cause analysis and solution deployment. 
• Data Team process improvement. 
• Work in a Agile Scrum-Ban setting to deliver product Roadmap initiatives and Operational Requirements 

1. Long-Term objectives: 

• Build robust database documentation. 
• Provide suggestions/recommendations for design and code changes to improve application performance and end user experience. 
• Tune existing SQL procedures and DB indexes. 
• Work with development teams to design efficient data environments. 
• Plan, collaborate on, a