Lead Database Architect

About the Company

Cwoods India is an ambitious startup developing a next-generation platform built for scale, strong availability, and real-time responsiveness. The product has been under development for more than six years, and the company is now seeking a hands-on Database Architect to shape the direction of its distributed data platform. This role offers the chance to influence database strategy directly while building systems that are efficient as well as high performing.

Role Overview

You will lead the design and ongoing evolution of a distributed database environment centered on Apache Cassandra and PostgreSQL. The position focuses on creating robust, scalable data systems that support demanding workloads and long-term platform growth.

Responsibilities

• Develop and refine the company’s distributed database architecture using Apache Cassandra and PostgreSQL as the primary data stores.
• Create data models that are tailored for distributed workloads requiring high throughput and very low latency.
• Own the SQL and NoSQL database design approach for relational data, including indexing, migration planning, query efficiency, and operational stability.
• Build database infrastructure that is resilient, scalable, and capable of maintaining high availability.
• Set and enforce Cassandra practices around partitioning, replication, consistency, compaction, tombstone handling, and performance improvement.
• Set and enforce PostgreSQL practices covering schema design, indexing, query tuning, transactional behavior, replication, backup and recovery, and migrations.
• Work in close partnership with backend engineering, DevOps, security, and product stakeholders.
• Define standards for monitoring, backups, disaster recovery, data movement, and day-to-day database operations.
• Assess emerging technologies and advise on major database choices as the platform expands.

Requirements

• At least 5 years of experience building and running production database systems at large scale.
• Strong hands-on expertise with Cassandra and PostgreSQL in live production environments.
• Deep PostgreSQL knowledge for transactional and relational use cases, including schema design, indexing, query tuning, migrations, replication, backup/restore, and performance optimization.
• Solid understanding of distributed systems concepts such as replication, consistency, fault tolerance, and high availability.
• Practical experience with Cassandra modeling for both read-intensive and write-intensive workloads.
• Experience designing polyglot persistence architectures where Cassandra manages distributed high-volume data and PostgreSQL handles relational or transactional data.
• Working knowledge of Kubernetes, Docker, and cloud platforms.
• Familiarity with observability and monitoring tools such as Prometheus and Grafana.
• Strong scripting or development ability in SQL, CQL, Node.js/TypeScript, Python, Bash, or similar tools.
• Excellent communication skills and the ability to mentor engineering teams.
• Exposure to Kafka or event-driven architectures is a plus.

Eligibility

Applicants from any graduate background may apply.

Compensation

The role offers a stipend/salary range of INR 50,000 to INR 100,000 per month.

Location

Jaipur, India.