Lead Database Architect (Cassandra & PostgreSQL)

Cwoods India; Jaipur; On-site; INR 1,200,000 - 2,000,000; Full time

Job summary

Cwoods India is seeking an experienced database architect in Jaipur, Rajasthan, to design and evolve distributed database architectures using Apache Cassandra and PostgreSQL. The ideal candidate will have over 5 years of experience and deep expertise in these technologies, focusing on performance tuning and operational reliability.

The role involves evaluating new technologies and collaborating closely with engineering teams to establish operational standards. Strong communication skills and mentorship capability are essential for this position.

Qualifications

• 5+ years of experience in designing and operating large-scale production database systems.
• Strong understanding of distributed systems and fault tolerance.
• Experience with monitoring and observability tools.

Responsibilities

• Design and evolve our distributed database architecture with Apache Cassandra and PostgreSQL.
• Own SQL/NoSQL architecture and operational reliability.
• Collaborate with backend engineers, DevOps, and product teams.

Skills

Cassandra Expertise

PostgreSQL Expertise

Distributed Systems Knowledge

Kubernetes Knowledge

Cloud Platforms Experience

Monitoring Tools (Prometheus, Grafana)

Scripting Skills (SQL, CQL, Python)

Tools

Docker

Event-Driven Architectures (Kafka)

Job description

Roles & Responsibilities

• Design and evolve our distributed database architecture with Apache Cassandra and PostgreSQL as core data platforms.
• Define data models optimised for high-volume, low-latency, distributed workloads.
• Own SQL/NoSQL architecture for relational data, indexing strategy, migrations, query performance, and operational reliability.
• Build scalable, resilient, and highly available database infrastructure.
• Drive best practices around Cassandra partitioning, replication, consistency, compaction, tombstone management, and performance tuning.
• Drive best practices around PostgreSQL schema design, indexing, query optimisation, transactions, replication, backup/restore, and migrations.
• Collaborate closely with backend engineers, DevOps, security, and product teams.
• Establish monitoring, backup, disaster recovery, data migration, and operational standards.
• Evaluate new technologies and guide strategic database decisions as the platform scales.

What we are looking for

• 5+ years of experience of designing and operating large-scale production database systems.
• Deep expertise of Cassandra/Postgres in production environments.
• Strong PostgreSQL expertise for relational and transactional workloads, including schema design, indexing, query optimisation, migrations, replication, backup/restore, and performance tuning.
• Strong understanding of distributed systems, replication, consistency models, fault tolerance, and high availability.
• Experience with Cassandra data modelling for read-heavy and write-heavy workloads.
• Experience designing polyglot persistence systems where Cassandra handles distributed high-volume workloads and PostgreSQL handles relational or transactional data.
• Knowledge of Kubernetes, Docker, and cloud platforms.
• Experience with monitoring and observability tools such as Prometheus and Grafana.
• Strong scripting or programming skills in SQL, CQL, Node.js/TypeScript, Python, Bash, or similar.
• Excellent communication skills and the ability to mentor engineering teams.

Nice to Have

• Experience with Kafka or event-driven architectures.