[Remote] Senior Backend Engineer (PostgreSQL Optimization)
Note: The job is a remote job and is open to candidates in USA. Effodio, Inc. is building a next-generation analytics platform that provides real-time insights into application and infrastructure performance. They are seeking a Senior Backend Engineer with deep experience optimizing databases for performance and scalability, particularly with PostgreSQL and related technologies. The role involves backend development, database optimization, and cross-functional collaboration to tackle complex challenges in a high-volume data environment.
Responsibilities
- Design, build, and ship backend services and features in Go with a GraphQL API layer
- Write clean, efficient, and maintainable production code across the full development lifecycle
- Contribute to system design, architecture, and implementation of scalable services across multiple coordinated services
- Analyze and optimize PostgreSQL/TimescaleDB queries using EXPLAIN ANALYZE, identifying slow paths in time-series and relational workloads
- Design and implement indexing strategies (B-tree, GIN, BRIN, partial, hypertable indexes) tailored to query patterns
- Optimize Redis caching layers and Elasticsearch indexing/query performance
- Identify and resolve performance bottlenecks across the full data path - ingestion, storage, query, and retrieval
- Evaluate and recommend data store choices (SQL vs. NoSQL) for new features based on access patterns and scale requirements
- Design schemas that support both performance and scalability across PostgreSQL, TimescaleDB, and Elasticsearch
- Implement partitioning, hypertable, and retention strategies for high-volume time-series data
- Balance tradeoffs between performance, maintainability, and data integrity across SQL and NoSQL stores
- Build and operate services deployed on Kubernetes across AWS and GCP
- Design for reliability, fault tolerance, and high availability with proper observability (OpenTelemetry, Prometheus)
- Optimize across the full stack: application code, database queries, caching layers, and search indexes
- Troubleshoot complex production issues across services, data pipelines, and data stores
- Use distributed tracing and metrics to identify and resolve latency and throughput bottlenecks
- Partner with product, data, and engineering teams to deliver high-impact solutions
- Contribute to technical discussions and help drive pragmatic engineering decisions
Skills
- 7+ years of backend software engineering experience
- Strong track record of building and operating production systems at scale
- Hands-on experience optimizing PostgreSQL (and ideally TimescaleDB or similar time-series extensions) in production
- Strong understanding of query performance, indexing strategies, and execution plans
- Experience with at least one NoSQL data store (Redis, Elasticsearch, or similar) in a production capacity
- Experience working with large datasets and high-throughput data ingestion pipelines
- Proficiency in Go is highly desired; we'll invest in training the right engineer
- Experience with cloud platforms (AWS and/or GCP)
- Familiarity with Kubernetes and containerized systems
- Applicants must have legal authorization to work in the United States
- Experience with GraphQL APIs
- Experience with OpenTelemetry
- Experience with Kafka
- Experience with time-series databases
Company Overview