As a Senior Database Administrator, you are a part of a technical team that architects, builds, maintains, scales, monitors, and secures the Housecall Pro cloud infrastructure. This team promotes flexibility and autonomy and empowers you with creative freedom and ownership in your work. You are a part of the DevOps department, inside the larger engineering team, collaborating to drive performance, resilience, reliability and availability in our Database systems. Your ultimate goal is to enable engineering to help good Pros become great Pros, by creating a solid, flexible, and stable foundation that enables us to ship quickly in the face of massive growth. You face challenges with systems running real users and data with imagination, tenacity, and attention to detail. You are motivated to follow your curiosity into solutions, answers, and actions. Your superpower is empowering engineers with a Data First mindset, enabling others to make great decisions governing the storage, transmission, retrieval, and analysis of our data.
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
requirements-expected :
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
offered :
Compensation: 7 000 - 8 500 USD per month (B2B)
Paid time off
Flexible work hours
Equity shares in a rapidly growing company backed by top-tier VCs
A culture built on innovation that values big ideas