Senior Database Reliability Engineer - ORS Partners
Malvern, PA 19355
About the Job
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.
- 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 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.