Jobs

Interviews
Job Alerts
Tools

Upskill and Grow with AI

Mock Interview Practice interviews in realistic simulations

Coding Practice Improve your coding skills with challenges

Certification Earn certifications to validate your skills

AI Learning Get trained with AI expert sessions

Career Path AI insights for smarter career decisions

AI Job Match Score AI-Powered Job Match Against Your Resume and Optimize Your Resume

Career Tools and Resources

Resume Builder Build Professional Resume with Ease

ATS Friendliness Check Check Resume Friendliness for Applicant Tracking Systems

Auto Apply Apply to hundreds of jobs on any platform effortlessly

Co-Pilot (Chrome Extension) Your AI Assistant for Seamless Browsing Efficiency

Interview Questions Streamline interviews with ready-to-use questions

Salaries Discover market-driven salary insights across skillsets and geographies

Companies Explore leading companies actively hiring talent
For Employers

Database Architect

Unlink Technologies Private limited

6 years

25 - 35 Lacs

noida uttar pradesh india

Posted:3 days ago| Platform:

Apply

Skills Required

database data kafka saas automation reconciliation stack olap ai design analytics indexing normalization retention analyze query tuning model layers airflow metrics security encryption masking tokenization iam audit retrieval ml postgresql planning replication python tooling sqlalchemy orchestration aws gcp management engineering communication payments terraform docker java apache learning

Work Mode

Remote

Job Type

Full Time

Job Description

Title: Data Platform / Database Architect (Postgres + Kafka) — AI‑Ready Data InfrastructureLocation: Noida (Hybrid). Remote within IST±3 considered for exceptional candidates.Employment: Full‑time

About Us

We are building a high‑throughput, audit‑friendly data platform that powers a SaaS for financial data automation and reconciliation. The stack blends OLTP (Postgres), streaming (Kafka/Debezium), and OLAP (ClickHouse/Snowflake/BigQuery), with hooks for AI use‑cases (vector search, feature store, RAG).Role SummaryOwn the end‑to‑end design and performance of our data platform—from multi‑tenant Postgres schemas to CDC pipelines and analytics stores—while laying the groundwork for AI‑powered product features.What You’ll Do

Design multi‑tenant Postgres schemas (partitioning, indexing, normalization, RLS), and define retention/archival strategies.
Make Postgres fast and reliable: EXPLAIN/ANALYZE, connection pooling, vacuum/bloat control, query/index tuning, replication.
Build event‑streaming/CDC with Kafka/Debezium (topics, partitions, schema registry), and deliver data to ClickHouse/Snowflake/BigQuery.
Model analytics layers (star/snowflake), orchestrate jobs (Airflow/Dagster), and implement dbt‑based transformations.
Establish observability and SLOs for data: query/queue metrics, tracing, alerting, capacity planning.
Implement data security: encryption, masking, tokenization of PII, IAM boundaries; contribute to PCI‑like audit posture.
Integrate AI plumbing: vector embeddings (pgvector/Milvus), basic feature‑store patterns (Feast), retrieval pipelines and metadata lineage.
Collaborate with backend/ML/product to review designs, coach engineers, write docs/runbooks, and lead migrations.

Must‑Have Qualifications

6+ years building high‑scale data platforms with deep PostgreSQL experience (partitioning, advanced indexing, query planning, replication/HA).
Hands‑on with Kafka (or equivalent) and Debezium/CDC patterns; schema registry (Avro/Protobuf) and exactly‑once/at‑least‑once tradeoffs.
One or more analytics engines at scale: ClickHouse, Snowflake, or BigQuery, plus strong SQL.
Python for data tooling (pydantic, SQLAlchemy, or similar); orchestration with Airflow or Dagster; transformations with dbt.
Solid cloud experience (AWS/GCP/Azure)—networking, security groups/IAM, secrets management, cost controls.
Pragmatic performance engineering mindset; excellent communication and documentation.

Nice‑to‑Have

Vector/semantic search (pgvector/Milvus/Pinecone), feature store (Feast), or RAG data pipelines.
Experience in fintech‑style domains (reconciliation, ledgers, payments) and SOX/PCI‑like controls.
Infra‑as‑Code (Terraform), containerized services (Docker/K8s), and observability stacks (Prometheus/Grafana/OpenTelemetry).
Exposure to Go/Java for stream processors/consumers.
Lakehouse formats (Delta/Iceberg/Hudi).

Skills:- PostgreSQL, Apache Kafka, CI/CD, Apache Airflow, Slowly changing dimensions, Artificial Intelligence (AI) and Machine Learning (ML)

More Jobs at Unlink Technologies Private limited

Web Content Manager

Uttar Pradesh, India

Experience: Not specified

Salary: Not disclosed

Database Architect

Uttar Pradesh, India

7.0 - 7.0 yrs

Salary: Not disclosed

Database Architect

noida, uttar pradesh, india

6.0 - 6.0 yrs

INR 25 - 35 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

Enhance Your Python Skills

Practice Python coding challenges to boost your skills

Start Practicing Python Now

Unlink Technologies Private limited

Login to

Please Verify Your Phone or Email

Confirm Action

Database Architect