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, and complete projects within estimated timeframes and with a high degree of ownership.

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
  • Database scalability concepts
  • Continuous Improvement
• Expert grasp of query languages
• Strong analytical and problem-solving skills including robust troubleshooting skills with a focus on preventative actions.
• 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.

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.
We're a group of unique and talented individuals that love what we do. We've been lucky enough to land jobs with a rapidly growing tech company that supports an appreciative and friendly customer base. We work hard to make our customers happy, but we like to have a good time in the process. We are a company that strives to think in terms of "we" instead of "me." We believe in the philosophy of servant leadership and that it's all about putting others first. We also value the balance between family and work.
Frontline embraces diversity, equity, and inclusivity. We are intentionally building a workplace that respects, supports, and values the identities of all our employees. We believe this to be foundational in developing a strong community in our company. Frontline Education is an equal opportunity employer and we do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.