Senior Backend Engineer (PostgreSQL Optimization)
Role summary
Effodio is seeking a Senior Backend Engineer with deep expertise in database optimization (SQL and NoSQL) to enhance their real-time analytics platform. This hands-on role involves writing Go code, designing scalable services, and tackling performance challenges in PostgreSQL, TimescaleDB, Redis, and Elasticsearch. Responsibilities include analyzing and optimizing queries, designing indexing strategies, resolving performance bottlenecks across the data path, and contributing to system architecture. Experience with cloud platforms (AWS/GCP) and Kubernetes is essential. The role focuses on backend development with a specialty in database performance and scalability.
Effodio
Senior Backend Engineer (PostgreSQL Optimization)
Full-Time | Remote
About Effodio
Founded by industry veterans from Google, Arista, and other leading tech companies, Effodio is building a next-generation analytics platform that provides real-time insights into application and infrastructure performance.
Effodio (Latin): “I dig, excavate, or mine.”
Job Summary
We are looking for someone with deep experience optimizing databases, both SQL and NoSQL, for performance and scale. Our platform ingests and analyzes high-volume time-series data. We are looking for a candidate with experience with technologies such as PostgreSQL, Timescale, Redis, and Elasticsearch. This is a hands-on backend engineering role in Go, not a DBA position. Day-to-day, you’ll be writing code and building across the platform. Your database expertise will be especially valuable as we tackle performance and scalability challenges across these data stores. Once that work is in a solid, maintainable place, you’ll contribute across other backend projects as well.
What You’ll Do
Backend Development (Primary Focus)
- 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
Database Optimization (Specialty Area)
- 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
Data Modeling & Schema Design
- 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
Distributed Systems & Cloud Architecture
- Build and operate services deployed on Kubernetes across AWS and GCP
- Design for reliability, fault tolerance, and high availability with proper observability (OpenTelemetry, Prometheus)
Performance & Scalability
- 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
Cross-Functional Collaboration
- Partner with product, data, and engineering teams to deliver high-impact solutions
- Contribute to technical discussions and help drive pragmatic engineering decisions
What You Bring
Experience
- 7+ years of backend software engineering experience
- Strong track record of building and operating production systems at scale
Database Expertise (Required)
- 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
Technical Skills
- 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
- Bonus: experience with GraphQL APIs, OpenTelemetry, Kafka, or time-series databases
Compensation
Individual compensation is determined by skills, qualifications, and experience. Compensation includes salary, equity, and a discretionary bonus.
Work Authorization
Applicants must have legal authorization to work in the United States. Effodio does not sponsor employment visas for this role.
Equal Opportunity Employer
Effodio is an Equal Opportunity Employer and does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other legally protected characteristic.
AI in Our Hiring Process
Effodio uses AI-enabled recruiting tools to improve efficiency and consistency in our hiring process. These tools may assist with resume review, scheduling, and communication. AI supports but never replaces human decision-making, and all hiring decisions are made by people.