We are seeking an experienced Lead Engineer - Databases with deep expertise in Elasticsearch, Clickhouse, and other modern data systems. You will lead the design, development, and optimization of scalable, high-throughput database solutions that power key products and internal systems. This role emphasizes performance tuning, efficient data modeling, and the deployment of cloud-native database architectures that can handle both real-time and batch processing at scale.
Responsibilities :
- Design and optimize the usage of Elasticsearch (e. g., Amazon OpenSearch) and Clickhouse for operational and analytical workloads.
- Develop efficient, scalable data models for document, search, and columnar storage patterns.
- Continuously monitor and improve query performance, indexing strategies, and cost-effectiveness of managed services.
- Collaborate closely with engineering, data, and DevOps teams to integrate database best practices into applications and pipelines.
- Ensure high availability and performance of structured, semi-structured, and unstructured data workloads.
- Define and enforce best practices for schema governance, access control, and data lifecycle management.
- Evaluate and benchmark new managed database services to support evolving product needs.
- Automate performance monitoring and alerting using tools such as Datadog, CloudWatch, or :
- 5+ years of experience working with cloud-managed database platforms.
- Deep expertise in Elasticsearch / OpenSearch (indexing, search relevance, aggregation) and Clickhouse (columnar storage, high-throughput queries).
- Strong experience with SQL and NoSQL systems in production environments at scale.
- Proven ability to optimize query performance and storage in high-scale environments.
- Experience integrating databases with application stacks and streaming pipelines (e. g., Kafka).
- Proficiency in at least two programming languages (e. g., NodeJS, Go, Rust) for automation and tooling.
- Understanding of cloud-native security, RBAC, and compliance requirements.
- Experience with database observability, monitoring, and alerting systems.
(ref : hirist.tech)