What are the responsibilities and job description for the Database Engineer position at Caselle?
ABOUT CASELLE
Established in 1979, Caselle has proudly embraced innovation, evolving into a software powerhouse that caters to over 1200 municipalities, counties, and diverse public sector entities across the nation.
Experience the freedom of flexible schedules, outstanding benefits, and be surrounded by a team of dedicated professionals who elevate each other. At Caselle, we don't just talk about work/life balance; we live it, ensuring that every employee thrives professionally and personally.
While we may not boast about game rooms and complimentary soda, our focus is unwaveringly on delivering outstanding results within the office and ensuring everyone heads home fulfilled at the end of the day. Our clients, more than just patrons, are partners in our journey. Loyalty is reciprocated through a dedicated mission- "Commitment to Community."
Our ethos extends beyond software solutions; it's a pledge to empower our employees, who, in turn, empower our clients and, ultimately, the entire community. Join us at Caselle, where innovation meets tradition, and our mission echoes in every keystroke-"Commitment to Community."
POSITION SUMMARY
The Database Engineer position is responsible for the overall design and implementation of databases used in Caselle software. This position will work on the development team and will help optimize the performance of our organization's databases, developing database architecture, algorithms, and storage rules.
ESSENTIAL DUTIES AND RESPONSIBILITIES
- Serve as a senior engineer in developing and deploying code with a particular focus on back-end data-related services
- Fine tune and establish best practices for various queries, indexing, partitioning, read/write efficiency, etc. Identify performance bottlenecks and implement solutions
- Participate in and guide database design and architecture in support of new product initiatives
- Develop best practices for database design and development activities
- Troubleshoot database and application issues. Perform root cause analysis on issues
- Establish deployment procedures (with the help of the infrastructure team) with best practices around migrations and rollbacks
- Ensure best practices for using AWS database infrastructure and services
- Ensure data is backed-up appropriately and can be restored timely
- Contribute to a positive culture of innovation and problem solving
Enjoy competitive salaries and outstanding benefits.