Continuously review and fine-tune critical PostgreSQL configuration parameters (e.g., shared_buffers, work_mem, autovacuum settings) 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 (e.g., streaming replication, logical 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 (Terabyte-level or high-transaction volume) PostgreSQL databases in a live, 24/7 production environment
Experience with observability tools like DataDog, NewRelic, etc. (any tooling is fine)
Deep experience of tuning critical performance parameters

Benefits

100% remote work environment - since our founding in 2015
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

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills

PostgreSQLdatabase partitioningshardingreplicationfailover mechanismsbackup strategiesperformance tuningindexing strategiesconfiguration managementresource forecasting

Soft skills

technical guidancecollaboration