Database Developer

We are looking for a skilled Database Developer to design, develop, and optimize

database solutions across our insurance and wealth management analytics platform.

The role is primarily focused on writing complex queries, stored procedures,

functions, and supporting data pipelines across multiple database engines with a

strong emphasis on ClickHouse (OLAP analytics), PostgreSQL, and SQL Server.

Key Responsibilities

Query Development & Optimization

• Write, review, and optimize complex SQL queries across ClickHouse,

PostgreSQL, and SQL Server

• Develop and maintain stored procedures, functions, views, and triggers

• Analyze and tune slow queries using execution plans, indexing strategies, and

query profiling

• Implement efficient pagination, filtering, and aggregation patterns for large

datasets

• Write parameterized queries with proper SQL injection

prevention (escaping, parameterization)

ClickHouse Development (Primary)

• Develop and optimize analytical queries for dashboards covering Gross

Sales, AUM, Revenue, Cash Flow, Pipeline, and Client data

• Design and implement MergeTree table engines, partitioning strategies, and

materialized views

• Build time-series aggregations with MTD, QTD, YTD, and custom date

range filters

• Optimize multi-dimensional queries (tier-wise, product-wise, category-wise,

hierarchy-wise)

• Support direct SQL streaming for CSV report generation from ClickHouse

HTTP interface

PostgreSQL Development

• Write and maintain PostgreSQL

functions following schema.fn_function_name conventions

• Develop functions for hierarchy resolution, employee-partner mapping, and

master data lookups

• Optimize Npgsql/.NET integration understanding EF Core function calls

and raw ADO.NET patterns

• Manage schema design across ciprevamp and partnermaster databases

SQL Server Development

• Develop queries and procedures for task management and mid-office data

(taskmanager DB)

• Support reporting and audit data requirements from SQL Server

Data Modeling & Design

• Design normalized and denormalized schemas appropriate for OLTP vs