Senior Backend Engineer (PostgreSQL Optimization)

Effodio

Senior Backend Engineer (PostgreSQL Optimization)

Full-Time | Remote

Candidates should take the time to read all the elements of this job advert carefully Please make your application promptly.

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. xhyhwjd AI supports but never replaces human decision-making, and all hiring decisions are made by people.