13 days ago
Base Salary
$215k - $245k/yr
Responsibilities
- Tune PostgreSQL configuration parameters, including shared_buffers, work_mem, and autovacuum settings, to optimize resource utilization.
- Forecast database resource needs based on application growth and endpoint-agent usage trends and propose scaling solutions.
- Design, implement, and maintain database monitoring dashboards and alerting for latency, throughput, connection count, cache hit ratio, and other KPIs.
- Design and maintain indexing strategies and identify redundant or underutilized indexes that reduce write performance.
- Implement database partitioning and coordinate database sharding when necessary.
- Partner with the SRE team to optimize PostgreSQL deployments in Azure, including cloud-specific storage and networking.
- Provide technical guidance to application teams on query, schema, and index design.
Requirements
- 5+ years of experience scaling, configuring, maintaining, and managing PostgreSQL clusters in production environments.
- Expertise with replication, including streaming and logical replication, failover mechanisms, and backup and recovery strategies.
- Deep understanding of PostgreSQL architecture, including WAL, transaction management, locking mechanisms, and autovacuum-related background processes.
- Extensive hands-on experience managing large-scale, terabyte-level or high-transaction-volume PostgreSQL databases in live 24/7 production environments.
- Experience with observability tools such as DataDog and NewRelic.
- Deep experience tuning critical database performance parameters.
- Bonus: understanding of NoSQL data models and access patterns for MongoDB, Redis, and Cassandra.
- Bonus: understanding when to use relational databases and when not to.
- Bonus: experience with infrastructure as code.
Benefits
- 100% remote work environment.
- Generous paid time off, including vacation, sick time, and paid holidays.
- 12 weeks of paid parental leave.
- Medical, dental, and vision benefits.
- 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 or upgrading a home office.
- Annual education and professional development assistance.
- $75 USD per month digital reimbursement.
- Access to the BetterUp coaching and personal and professional growth platform.
Tech Stack
Categories
Site Reliability
About Huntress
Huntress builds a managed security platform for mid-market businesses and the MSPs that support them, offering endpoint protection, identity defense, SIEM, and security awareness training backed by a 24/7 human-led SOC. Founded in 2015 by former NSA cyber operators and headquartered in Columbia, Maryland, the company is privately held. Its platform secures more than 5 million endpoints and 14 million identities worldwide.