[Remote] Sr. Software Engineer, Backend (SQL Server Focus) at BambooHR

Utah, United States

BambooHR Logo
Not SpecifiedCompensation
Senior (5 to 8 years)Experience Level
Full TimeJob Type
UnknownVisa
SoftwareIndustries

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
  • Familiarity with integrating AI-assisted development workflows, including prompt engineering to enhance efficiency
  • Bachelor’s degree in Computer Science or related field

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
  • Integrate AI tools such as GitHub Copilot, Windsurf, and ChatGPT into your daily workflow to brainstorm, plan, and refine solutions
  • Conduct query reviews and trainings

Skills

Key technologies and capabilities for this role

SQL ServerBackend DevelopmentDatabase DesignStored ProceduresQuery OptimizationRESTful APIsData IntegrityData SecurityProblem-SolvingTeam Collaboration

Questions & Answers

Common questions about this position

Is this position remote?

Yes, this is a remote position available in the state listed on this job.

What are the key required skills for this role?

The role requires 5+ years of backend or database-driven software development experience, strong proficiency in Microsoft SQL Server including stored procedures, query optimization, and indexing, experience with database monitoring and administration, familiarity with SQL Server transactions and Read Committed Snapshot Isolation, and service development in C#, PHP, Java, or Python.

What is the salary or compensation for this position?

This information is not specified in the job description.

What is the company culture like at BambooHR?

BambooHR fosters a warm and inclusive environment where ideas are valued, growth is supported, and AI and automation are integral to the fast-paced development culture.

What makes a candidate stand out for this role?

Candidates with familiarity in cloud database environments, replication, high-availability configurations, experience with MySQL or other RDBMS, a service-minded proactive attitude, and real-world examples of technical leadership and performance optimization will stand out.

BambooHR

Cloud-based HR software for SMBs

About BambooHR

BambooHR provides HR software solutions specifically designed for small and medium-sized businesses (SMBs). Its cloud-based platform allows organizations to manage various HR functions, including hiring, onboarding, employee data management, time tracking, and performance management. The software is user-friendly and integrates with other HR applications, enhancing its capabilities. Clients pay a subscription fee based on the number of employees and features needed, and the BambooHR Marketplace offers additional integrations with various HR apps, allowing businesses to customize their HR solutions. The goal of BambooHR is to help SMBs streamline their HR processes and manage their workforce more effectively.

Lindon, UtahHeadquarters
2008Year Founded
ACQUISITIONCompany Stage
Consulting, Enterprise SoftwareIndustries
1,001-5,000Employees

Benefits

Health Insurance
Dental Insurance
Vision Insurance
401(k) Retirement Plan
401(k) Company Match
Unlimited Paid Time Off
Paid Holidays
Flexible Work Hours
Educational Benefits
Wellness Program

Risks

Increased competition from AI-driven HR solutions threatens BambooHR's market share.
New Chief Revenue Officer may disrupt existing client relationships.
AI-powered features may raise data privacy concerns among clients.

Differentiation

BambooHR offers a comprehensive HR platform with AI-powered features for efficiency.
The platform integrates with various HR apps, enhancing its functionality and versatility.
BambooHR's subscription model allows customization based on company size and feature needs.

Upsides

Growing demand for AI-driven HR solutions boosts BambooHR's market potential.
Expansion into Canadian payroll offerings increases BambooHR's market reach.
Integration with financial tools like QuickBooks streamlines operations for clients.

Land your dream remote job 3x faster with AI