Senior Database Administrator

Summary

Join Housecall Pro as a Senior Database Administrator and become part of a technical team responsible for architecting, building, maintaining, scaling, monitoring, and securing the company's cloud infrastructure. This remote position offers a flexible and autonomous work environment, empowering you to contribute creatively and take ownership of your work. You will collaborate with the DevOps department and engineering team to enhance the performance, resilience, and reliability of database systems. Your efforts will directly support the company's mission of helping home service professionals thrive. The role involves a mix of schema design, reliability engineering, query optimization, and operational tasks. You will also mentor and guide other team members.

Requirements

• 5+ years of MySQL (8.0) and 3+ years of PostgreSQL administration and scaling experience
• Strong experience with traditional OLAP systems, ETL and associated Data Engineering and Data Warehouse practices
• Strong expertise in managing growing datasets using techniques like Partitioning, Sharding, Caching, Archiving, and Clustering
• Proficiency in performance profiling tools (Percona Toolkit, pgBadger, pg_stat_statements) and backup, restore, replication, and disaster recovery patterns
• Familiarity with at least one NoSQL implementation (e.g. Redis)
• Demonstrated experience with infrastructure as code tools (Terragrunt, Terraform, CloudFormation)
• Understanding of distributed systems and tradeoffs between consistency, availability, and partition tolerance
• Demonstrate a strong passion for using AI technologies to enhance productivity, quality, and innovation
• Curiosity and drive to stay ahead of emerging AI/ML technologies and their practical applications

Responsibilities

• Enjoy a mixture of schema design, reliability engineering, query and performance tuning, and operations work
• Build infrastructure in a public cloud using Infrastructure as Code techniques
• Collaborate with release engineering and delivery teams to optimize schema and data migrations, as part of our Agile development process
• Build, maintain, and monitor data persistence systems (ACID-compliant OLTP, OLAP, Search and KV/NoSQL) in our cloud environments with an eye to both flexibility and long-term viability
• Provide technical assistance, architectural insights, and individual contributor work across engineering
• Mentor, pair, and imbue delivery teams with techniques and data access patterns to improve our applications’ interface with our data tier
• Work directly with feature teams to optimize the development experience

Preferred Qualifications

• Experience with Redshift, or Snowflake administration
• Experience with Amazon Aurora and data replication to development environments
• Experience with Elasticsearch/Opensearch in a cloud environment
• High-level written and verbal communication skills with the ability to work with team members from across the globe
• Reading and reasoning about code you are not familiar with
• Discussing tradeoffs between B-tree and bitmap indexes is second-nature
• Understanding (and helping others understand) Cardinality, Data types, Transactions and Constraints in database design
• Experience in an Agile environment, thrive on iteration, and make opportunities to bring value sooner rather than later

Benefits

• Remote environment totally built to make you feel that we are all together in one space without leaving your home office!
• Self Managed PTO - Beach? Mountains? Camping? Discovering new experiences? You are free to take time out as you need!
• Flexible 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!
• Newest MacBook (or PC if you prefer!) + Setup Fee ($500 ) - What is an engineer without the right tools right? Here in HCP, you can choose your computer and set up your home office!
• Work in your own time zone - Because we don’t think that you should miss those memorable moments with your friends and family!
• Our range of compensation starts at: 7000 USD dollars