Staff Database Engineer

TO BE CONSIDERED FOR THIS ROLE, PLEASE SUBMIT AN UPDATED RESUME TRANSLATED TO ENGLISHWhy Housecall Pro?Help us build solutions that build better lives.At Housecall Pro, we show up to work every day to make a difference for real people: the home service professionals that support America's 100 million homes.We're all about the Pro, and dedicate our days to helping them streamline operations, scale their businesses, and—ultimately—save time so they can be with their families and live well.We care deeply about our customers and foster a culture where our company, employees, and Pros grow and succeed together.Leadership is as focused on growing team members' careers as they expect their teams to be on creating solutions for Pros.WHAT'S IN IT FOR YOU?Remote environment: totally built to make you feel that we are all together in one space without leaving your home officeSelf Managed PTO: Beach?Mountains?Camping?Discovering new experiences?You are free to take time out as you needFlexible work hours: We believe that you can reach your professional and personal goals working with us and encourage you to have a work life balance A culture built on innovation that values big ideas: We are always open to new ideas that will improve the life of our Pros MacBook (or PC if you prefer) + Setup Fee ($500): What is remote work without the right tools?Here at HCP, you can choose your computer and set up your home officeWe know what you are thinking...WHAT IS THE ROLE AND WHAT WOULD YOU BE DOING?As a Staff Database Engineer II within our Site Reliability team you will lead driving performance and reliability improvements of our company's databases and usage patterns.You focus on building and maintaining secure, scalable data systems while supporting high availability and integrity across environments.You work closely with engineers to optimize schema design, monitor system performance, and resolve production issues with a focus on long-term maintainability.Beyond database expertise, you influence system design, continuous delivery practices, and scalable cloud architecture.You proactively identify and resolve production issues, focusing on long-term maintainability.You join developer calls, provide architectural guidance, and coach best practices with empathy and clarity.You navigate infrastructure trade-offs with ease and contribute to strategic initiatives related to security, compliance, and business continuity.Our team is passionate, empathetic, hard working, and above all else focused on improving the lives of our service professionals (our Pros).Our success is their success.In your day to day, you will: Enjoy a mixture of schema design, reliability engineering, query and performance automation, security, and operations workHelp develop and implement database scaling strategies like sharding, replication, and data partitioning for high-growth applications.Optimize MySQL and PostgreSQL databases for performance, stability, and security.Design, build, and maintain database schemas and storage systems that support scalable application growthCollaborate with engineering teams to support data migrations, application integrations, and optimized queriesMonitor and troubleshoot production applications and databases, ensuring high availability and performanceCollaborate cross-functionally to lead initiatives such as disaster recovery, ETL, data classification, software upgrades, and complianceEstablish and promote database best practices in high availability, observability, and system designStay current with industry trends and best practices in database management.Track database incidents and design root cause fixes and preventative measuresParticipate in design reviews and provide database expertise for system enhancementsWe think this role is for you if have...5+ years of hands-on experience designing, implementing, and managing relational databases in enterprise or government environments3+ years of experience in DevOps, Software Engineering, Site Reliability Engineering or related rolesExpert knowledge of database architecture, data modeling, indexing, and query optimizationExperience with database security and compliance controls-Highly skilled in replication, partitioning, and performance tuningAbility to lead architecture reviews, data governance discussions, and integration with other platformsStrong skills in data cleaning, refinement, and preparation for analysis and modelingExperience with datastore backup and recovery solutions, high availability, sharding, and replicationStrong problem-solving skills and the ability to innovate and implement creative solutionsFamiliarity with infrastructure-as-code tools (i.e. Terraform, CloudFormation, Pulumi)Excellent communication skills to collaborate effectively with cross-functional teamsAttention to detail and a commitment to producing high-quality resultsWhat will help you succeed???Strong systems thinking and ability to balance long-term objectives with immediate prioritiesComfort with discussing tradeoffs between B-tree and bitmap indexesUnderstanding (and helping others understand) Cardinality, Data types, Transactions and Constraints in database designExceptional problem-solving skills and attention to detailAbility to influence and align cross-functional stakeholders with varying technical depthComfort working in a fast-paced environment with evolving infrastructurePassion for clean, maintainable, and efficient systems design Let's talk numbers Our compensation range for this role begins at **** USD dollars.Housecall Pro is a fintech company founded in ****.We built a SaaS platform that helps Home Service Professionals operate their businesses.We created the application for plumbers, electricians, and other Pros in the home improvement/trades industries.Housecall Pro is a simple, cloud-based field service management software platform aimed at helping companies keep track of jobs, monitor technician activity, and produce invoices easily.Our core product helps our clients with scheduling, dispatching, job management, invoicing, payment processing, marketing, and more.They used to struggle with the ton of paperwork after their hours.Now they can save time, and manage their business in one app.We support more than 27,000 businesses and have over 1,300 ambitious, mission-driven employees in San Diego, Denver, and all over the world (including 200+ talented and innovative Engineers).#LI-Remote