Senior Engineer, Database Engineering and Administration
Location | Anywhere, Fully remote |
Date Posted | September 10, 2024 |
Category |
Science / Tech / Engineering
|
Job Type |
Full-time
|
State | Telecommute |
Description
Why Springbrook:
Springbrook Software is the premier provider of cloud-based ERP and payments solutions tailored for local government entities and special districts. For over three decades, we have been pioneers in setting operational standards for small to medium-sized municipalities and utility districts, focusing on efficiency, economy, and security. Our solutions are trusted by over 3,000 cities, towns, and districts across the nation, enhancing financial management, payroll, and utility billing processes.
At Springbrook, we cultivate a work environment that values performance, productivity, and teamwork. Our team members are empowered to innovate and excel alongside colleagues who share a passion for transforming the public sector through cutting-edge technology. We prioritize fun, engagement, and a balanced work-life dynamic, offering competitive salaries and superior benefits.
Join us if you're inspired to contribute to a new era of transparent, efficient, and innovative governance. We're eager to welcome forward-thinking individuals ready to make a significant impact.
Where You Fit:
Springbrook is looking for a Senior Engineer, Database Engineering and Administration to join its Cloud Operations and Site Reliability Engineering team. This is a high engagement position that will act as a liaison between the development teams and infrastructure team to deliver high performance, highly available and extensible data solutions. Responsible for technical leadership with respect to database design, physical modeling, index optimization, data security, data backup and recovery, and data transformation. You will continually assess, improve, and optimize our current database environments.
This role has both operational and engineering research responsibilities. You will be responsible for researching and recommending technology direction and solutions, while also mentoring and assisting the SRE team with operational monitoring and management of the data services. Your role will be to develop and improve existing database instances, replication, monitoring, alerting tools, infrastructure, and extend and automate our service model.
Responsibilities:
- Design, implement and manage/optimize highly available transactional databases for multi-tenant SaaS application platforms.
- Design and review for security at the data and infrastructure levels
- Design, implement and manage database backup/recover and BCP/DR processes
- Design, implement and test DDL, DML and queries for multiple database platforms
- Implement monitoring for database health, availability and performance, with tuning as needed
- Ability to be a leader/mentor to the other engineers
- Prioritize and manage work, adhering to critical project timelines in a fast-paced environment
- Self-starter who can collaborate with others in a cross-functional team or work independently as needed
- Participate in an on-call rotation for issues that occur after business hours
- Participate in incident response teams for service interruptions or security incidents
- Maintain general awareness of Springbrook security and privacy policies
- Report any security incident or suspected security incident to the Springbrook Incident Response Team
Required Qualifications:
- Bachelor's degree in computer science/information systems or a related field; or an additional 2 years of database engineer experience
- 8+ years as a Database Engineer
- Experience provisioning MySQL instances, clustered and non-clustered configurations
- Strong proficiency in MySQL database management, MySQL replication configuration, and MySQL underlying storage engines
- Knowledge of de-facto standards and best practices in MySQL
- Proficiency in writing and optimizing SQL statements
- Knowledge of limitations of MySQL and their workarounds in contrast to other popular relational databases
- Understand service-oriented architectures
- Designing and tuning high-performance transactional databases for multi-tenant SaaS applications
- Familiarity with monitoring tools and techniques for proactive performance management
- Expertise in integrating best practices for data reliability, fault tolerance, and integrity
- Attention to detail, meticulous documentation, and repeatable process design
- Excellent verbal and written communication skills
- Experience developing application database solutions with a medium-to-large scope and complexity
- Strong analytical and problem-solving skills
- Experience with various database systems (MySQL, Microsoft SQL Server, Azure SQL, Oracle)
Preferred Qualifications:
- MS computer science/information systems or a related field
- Utilize automation tools to build, maintain and manage infrastructure (Azure DevOps, Terraform, PowerShell)
- Understanding of code versioning tools (Git)
- Experience with agile development methodologies
- Experience implementing complex service solutions following the latest architecture patterns
- Experience with Azure security and compliance capabilities
Applicants must have the unrestricted ability to work in the United States (sponsorship will not be offered)
Springbrook Software is an Equal Opportunity Employer. Springbrook does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law. All employment is decided on the basis of qualifications, merit, and business need.
For more information, or to apply now, you must go to the website below. Please DO NOT email your resume to us as we only accept applications through our website.
https://springbrooksoftware.isolvedhire.com/jobs/1298795-119719.html