Database Expert TimescaleDB

Company Description

We are a fast-growing company building advanced analytics platforms and dashboards for traders, builders, analysts, quants and researchers. Our mission is to make complex data accessible through clean, intuitive, and high-performance interfaces. We combine technical expertise with beautiful design to empower decision-making at scale.

Role Description

We are looking for a Database Expert specializing in TimescaleDB and PostgreSQL optimization . You will be responsible for architecting, maintaining, and optimizing large-scale time-series databases that power our analytics pipelines.

Your day-to-day will include designing efficient schemas, improving query performance, implementing continuous aggregates and materialized views, and ensuring our systems are fast, scalable, and reliable. You will collaborate closely with the data engineering and backend teams to ensure smooth data flow from ingestion to analytics.

Key Responsibilities

• Design and maintain high-performance TimescaleDB schemas optimized for time-series workloads.
• Implement materialized views , continuous aggregates , and UML-driven database design .
• Conduct normalization , indexing , and compression to optimize storage and performance.
• Profile and optimize slow queries, background jobs, and large joins.
• Ensure database integrity, consistency, and security across environments.
• Collaborate with developers to integrate database logic into backend services.
• Develop and maintain database documentation, UML diagrams, and performance monitoring dashboards.

Qualifications