Database Data Engineer

MavensTCL

Job Location:

Garhwa - India

Monthly Salary: Not Disclosed

Posted on: 10 hours ago

Vacancies: 1 Vacancy

Job Summary

Job Summary

You will design and optimize the database architecture supporting marketplace modules. Youll manage PostgreSQL (including TimescaleDB for time-series data) Elasticsearch for search Redis for caching and build ETL pipelines for analytics and reporting dashboards.

Key Responsibilities / Duties

Database Design and amp; Management

Design PostgreSQL schemas for 40 tables across 6 domains

Implement partitioning strategies for large tables (transactions listings)

Configure TimescaleDB hypertables for time-series data

Write and optimize complex SQL queries

Manage database migrations (Alembic/golang-migrate)

Search and amp; Analytics

Design Elasticsearch indices for multi-module search

Implement faceted search with aggregations

Build real-time analytics pipelines using Kafka ClickHouse

Create reporting tables for dashboards (Entity Admin Finance Manager)

Performance

Implement query optimization and indexing strategies

Configure read replicas for analytics workloads

Set up connection pooling (PgBouncer)

Monitor database performance (slow query logs pgstatstatements)

Data Governance

Implement data retention policies

Manage backup and recovery procedures

Ensure GDPR/CCPA compliance for data deletion

Implement data anonymization for M7 (Enterprise Data)

Required Skills and amp; Qualifications

Must-Have (4 years overall)

SkillProficiencyNotes

PostgreSQL4 yearsPerformance tuning partitioning replication

SQL4 yearsComplex joins window functions CTEs

Elasticsearch2 yearsIndex design aggregations query DSL

Redis2 yearsCaching rate limiting

Python2 yearsETL scripts

Database Migrations2 yearsAlembic or golang-migrate

Preferred / Good-to-Have Skills

SkillWhy It Matters

TimescaleDBTime-series (price history utilization metrics)

ClickHouseReal-time analytics

KafkaEvent streaming

Airflow / dbtETL orchestration

Metabase / SupersetDashboarding

pgvectorVector search for AI features

Key Tables / Data Models

Transactions: and nbsp;tables transactions escrowholds Row growth estimate 10M/year

Listings: and nbsp;tables listings listingversions Row growth estimate 5M/year

Price History: and nbsp;tables pricehistory (TimescaleDB) Row growth estimate 100M/year

AI Conversations: and nbsp;tables aiconversations Row growth estimate 50M/year

Interview Process

Round 1 PostgreSQL SQL optimization: and nbsp;60 minutes

Round 2 Elasticsearch Search design: and nbsp;60 minutes

Round 3 Data pipelines ETL: and nbsp;45 minutes

Round 4 Hiring Manager: and nbsp;45 minutes

Job SummaryYou will design and optimize the database architecture supporting marketplace modules. Youll manage PostgreSQL (including TimescaleDB for time-series data) Elasticsearch for search Redis for caching and build ETL pipelines for analytics and reporting dashboards.Key Responsibilities / Duti...