BambooHR is looking to solve the problem of designing, performance, and reliability of their backend systems, with a strong emphasis on database engineering and optimization, to continue leading the way in HR software for small and medium-sized businesses.
Requirements
- 5+ years of experience in backend or database-driven software development.
- Strong proficiency in Microsoft SQL Server, including stored procedures, query optimization, and indexing strategies.
- Experience with database monitoring and administration, including performance tuning and troubleshooting.
- Familiarity with SqlServer transactions and Read Committed Snapshot Isolation
- Service development experience in a backend language such as C, PHP, Java, or Python (with a desire to work in PHP 8).
- Solid understanding of object-oriented programming and software design principles.
- Experience with version control systems like Git.
Responsibilities
- Lead SQL Server database development, including designing schemas, writing complex stored procedures, functions, and triggers.
- Optimize database queries and indexes for performance and scalability.
- Monitor database health, diagnose performance issues, and implement tuning strategies.
- Design, implement, and maintain backend services and RESTful APIs that power BambooHR’s platform.
- Collaborate with product, QA, and frontend teams to integrate your work into production systems.
- Ensure data integrity, reliability, and security across systems.
- Proactively identify and implement process and system improvements.
Other
- Bachelor’s degree in Computer Science or related field.
- Ability to pass a background and credit check.
- Must be willing to work in a remote position.
- Must have a service-minded, proactive attitude toward problem-solving.
- Must be willing to learn and adapt to new technologies, including AI tools.
