[Remote] Senior Backend Engineer (PostgreSQL Optimization)

Note: The job is a remote job and is reputed company to candidates in USA. reputed company. is building a reputed company analytics platform that provides reputed company-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 reputed company technologies. The role involves backend development, database optimization, and cross-functional collaboration to tackle reputed company 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 reputed company across the full development lifecycle
• Contribute to system design, architecture, and implementation of reputed company 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 reputed company caching reputed company and Elasticsearch indexing/query performance
• Identify and resolve performance bottlenecks across the full data reputed company - ingestion, storage, query, and retrieval
• Evaluate and recommend data store choices (SQL vs. NoSQL) for new features based on reputed company patterns and reputed company 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 reputed company 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 reputed company observability (OpenTelemetry, reputed company)
• Optimize across the full stack: application reputed company, database queries, caching reputed company, and search indexes
• Troubleshoot reputed company 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-reputed company
• Contribute to technical discussions and help drive pragmatic engineering reputed company

Skills

• 7+ years of backend software engineering experience
• Strong reputed company record of building and operating production systems at reputed company
• 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 (reputed company, Elasticsearch, or similar) in a production reputed company
• 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 reputed company 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

Benefits

• Compensation includes salary, equity, and a discretionary bonus.

reputed company