Senior Database Reliability Engineer

Overview

Location Requirements: This role is Remote or Hybrid to one of our offices: Austin, Naperville or Wayne.  

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. The 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. 

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.
• Develop ways to 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.

Qualifications

• Comprehensive understanding of both software development and database administration

• Database management
• Database Performance Optimization
• Automation and Scripting
• Monitoring and Alerting
• Incident Response
• Capacity Planning
• Security compliance
• Continuous Improvement Strong grasp of SQL.
• A fast learner, detail oriented, decisive, and enjoy fast paced work environments. Self-directed and operate with urgency, focus, and discipline. 
• Communicates and influences effectively and appropriately across the organization.
• Confidently makes data driven decisions while considering upstream and downstream operational impacts.
• Strong project management skills, including the ability to think and lead complex projects simultaneously.

 Education and Experience: 

• Bachelor’s degree in a technical discipline or equivalent experience.
• At least 8+ years’ experience performing full stack database administration functions and supporting relational databases in a 24x7 production environment.
• Proven expertise managing complex data systems and working with development teams to assist in the successful delivery of application environments.
• Experience with supporting highly transactional OLTP databases. Experience with High Availability concepts.
• Experience with database scalability concepts (partitioning/sharding, replication, compression)
• Strong analytical and problem-solving skills including robust troubleshooting skills with a focus on preventative actions.
• 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, Policy Based Management, PowerShell, MySQL, DB2, Agile Methodologies, Amazon cloud database technologies, VMWare, Cloud Automation.

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 a