Description
Job Summary
As a Staff Database Reliability Engineer at Huntress, you will be joining a high-performing team responsible for proactively building, monitoring, and implementing the databases that are a core part of the Huntress Security Platform and supporting our millions of installed endpoint agents.
Responsibilities
- Continuously review and fine-tune critical PostgreSQL configuration parameters to maximize resource utilization and match the current workload profile.
- Forecast future resource needs based on application growth and agent usage trends, and propose scaling solutions.
- Design, implement, and manage comprehensive monitoring dashboards and alerting systems to track key performance indicators (KPIs) like latency, throughput, connection count, and cache hit ratio.
- Design, implement, and maintain optimal indexing strategies to support application requirements, and systematically identify and remove redundant or underutilized indexes that degrade write performance.
- Implement and manage advanced scaling techniques such as database partitioning for large tables and, where necessary, coordinate efforts for database sharding.
- Partner with SRE team to optimize PostgreSQL deployments in Azure, ensuring efficient use of cloud-specific storage and networking.
- Provide technical guidance to application teams on their query/schema/index designs.
Requirements
- 5+ years experience with scaling, configuration, maintenance and management of PostgreSQL clusters in production environments.
- Expertise in designing, implementing, and supporting replication, failover mechanisms, and robust backup/recovery strategies.
- Deep understanding of PostgreSQL's core architecture, including the WAL, transaction management, locking mechanisms, and the role of background processes like autovacuum.
- Extensive hands-on experience managing and maintaining large-scale PostgreSQL databases in a live, 24/7 production environment.
- Experience with observability tools like DataDog, NewRelic, etc.
- Deep experience of tuning critical performance parameters.
Nice to Have
- Understanding of NoSQL data models to optimize for specific access patterns.
- Understanding of when to use an RDB and when not to.
- Experience with IaC (infrastructure as code).
Benefits
- 100% remote work environment.
- Generous paid time off policy, including vacation, sick time, and paid holidays.
- 12 weeks of paid parental leave.
- Highly competitive and comprehensive medical, dental, and vision benefits plans.
- 401(k) with a 5% contribution regardless of employee contribution.
- Life and Disability insurance plans.
- Stock options for all full-time employees.
- One-time $500 reimbursement for building/upgrading home office.
- Annual allowance for education and professional development assistance.
- $75 USD/month digital reimbursement.
- Access to the BetterUp platform for coaching, personal, and professional growth.