Database Architect - ClickHouse/PostgreSQL

Role : Database Architect

Type : **Full-Time

Experience : 8+ Years.

About the Role :

We are seeking a seasoned Database Architect to own the end-to-end data architecture strategy for our insurance and wealth management analytics platform. This is a strategic and hands-on role where you will define database design standards, lead technology selection decisions, drive the modernization roadmap across a heterogeneous multi-database environment, and ensure the data layer scales reliably to meet business growth. The role requires deep expertise across OLAP, OLTP, NoSQL, caching, and streaming layers, combined with strong architectural judgment to make the right trade-offs between performance, maintainability, cost, and reliability.

Key Responsibilities :Architecture Strategy & Governance :

• Own the enterprise data architecture blueprint across all database systems including ClickHouse, PostgreSQL, SQL Server, MongoDB, Elasticsearch, and Redis.

• Define and enforce database design standards, naming conventions, schema governance, and data modeling guidelines across teams.

• Evaluate and recommend database technologies for new use cases such as build vs buy, OLTP vs OLAP, and relational vs document vs graph.

• Lead technology selection decisions with documented trade-off analysis including POCs, benchmarks, and cost modeling.

• Create and maintain the multi-year database modernization roadmap aligned to business and engineering strategy.

• Define data tiering strategy including hot/warm/cold storage, archival policies, and retention rules.

• Establish reference architectures and reusable patterns for data access, caching, and reporting layers.

Modernization & Version Roadmap :

• Lead the organization-wide database version upgrade roadmap prioritizing by EOL risk, business impact, and migration complexity.

• Define zero-downtime migration patterns including blue/green, logical replication, and dual-write strategies.

• Architect backward-compatible schema evolution strategies to decouple DB upgrades from app releases.

• Govern application team readiness including driver compatibility and ORM migration impact.

OLAP & Analytics Architecture (ClickHouse) :

• Own the ClickHouse data architecture including table engine selection, partitioning, sharding, and replication topology.

• Design materialized view strategies for pre-aggregated analytics.

• Define data ingestion pipelines into ClickHouse.