# Database Administrator

> Weekday AI · Chennai, India · Full-time · Posted 2026-09-02

**Salary:** INR 1,400,000–2,000,000

**Workplace:** on_site

**Department:** Weekday's Client via platform

## Description

𝗧𝗵𝗶𝘀 𝗿𝗼𝗹𝗲 𝗶𝘀 𝗳𝗼𝗿 𝗼𝗻𝗲 𝗼𝗳 𝘁𝗵𝗲 𝗪𝗲𝗲𝗸𝗱𝗮𝘆'𝘀 𝗰𝗹𝗶𝗲𝗻𝘁𝘀

𝗦𝗮𝗹𝗮𝗿𝘆 𝗿𝗮𝗻𝗴𝗲: 𝗥𝘀 𝟭𝟰𝟬𝟬𝟬𝟬𝟬 - 𝗥𝘀 𝟮𝟬𝟬𝟬𝟬𝟬𝟬 (𝗶𝗲 𝗜𝗡𝗥 𝟭𝟰-𝟮𝟬 𝗟𝗣𝗔)

Experience: 3+ yrs

Location: Chennai, Tamil Nadu, India

Job Type: Full-time

We are looking for a strong **Database Engineer** with deep expertise in PostgreSQL, distributed systems, database internals, and production database operations. The role focuses on designing, scaling, automating, and optimizing database infrastructure for high-throughput, cloud-native environments.

The ideal candidate will have a strong understanding of **storage engines, replication, transactions, concurrency, reliability, performance optimization, and data consistency**, combined with strong Python skills for building production-grade automation and operational tooling.

## Requirements

### Key Responsibilities

-   Design, operate, optimize, and scale production database systems across SQL and NoSQL environments.
-   Debug and prevent complex **concurrency issues**, including deadlocks, lock contention, starvation, and long-running transactions.
-   Advise application teams on safe database access patterns, including **idempotency, retries, backoff strategies, and concurrency controls**.
-   Develop a deep understanding of database storage and replication internals, including **B-trees, LSM structures, page layouts, WAL/redo/undo, checkpoints, compaction, MVCC, and storage engines**.
-   Design and implement database backup, restore, upgrade, migration, and **disaster recovery** strategies.
-   Analyze query planner behavior, statistics, cardinality estimation, and query performance bottlenecks.
-   Develop effective indexing strategies while considering write amplification, storage, and performance trade-offs.
-   Build database reliability practices, preventative controls, and automated remediation mechanisms.
-   Implement monitoring and alerting for **replication lag, lock contention, cache health, slow queries, storage growth, and failover events**.
-   Lead database incident response, root-cause analysis, and post-incident reviews.
-   Build production-grade **Python automation and tooling** for health checks, failover validation, backup/restore verification, consistency checks, and diagnostics.
-   Automate online schema changes, safe rollout and rollback workflows, and operational guardrails.
-   Develop automation for performance diagnostics, including query-plan capture and workload analysis.
-   Build scalable tooling capable of efficiently processing **millions of records or events**, with strong attention to time and space complexity.
-   Guide data-modeling decisions across relational, document, and key-value databases.
-   Evaluate **normalization vs. denormalization, secondary indexing, partitioning, hot-spot mitigation, throughput planning, TTL, archiving, and data lifecycle policies**.
-   Establish standards for data correctness, durability, operational safety, access controls, auditing, and production change management.
-   Partner with application and infrastructure teams on database architecture, migration strategies, and operational best practices.
-   Contribute to multi-region architectures, failover strategies, and high-availability database solutions where required.
-   Mentor engineers and promote strong database engineering practices across the organization.

### What Makes You a Great Fit

-   **3+ years of relevant engineering experience** with strong hands-on database engineering responsibilities.
-   Deep expertise in **PostgreSQL** and strong understanding of at least one additional SQL or NoSQL database such as **MySQL, MongoDB, or MariaDB**.
-   Strong foundation in **distributed systems**, including CAP, replication, consistency, failure handling, and consensus fundamentals.
-   Deep understanding of **transactions, isolation levels, MVCC, locking, concurrency, storage engines, and database internals**.
-   Strong proficiency in **Python**, with experience building production-grade automation, diagnostics, and operational tooling.
-   Hands-on experience operating, troubleshooting, tuning, and scaling **production databases**.
-   Strong debugging and performance-analysis skills, with the ability to reason from metrics, logs, traces, and low-level system behavior.
-   Good understanding of **Linux** and common command-line tools.
-   Ability to evaluate technical trade-offs across **latency, consistency, durability, throughput, cost, and performance**.
-   Strong first-principles approach to understanding database behavior under high load and failure conditions.
-   Experience designing reliable automation, safe database migrations, and operational guardrails.
-   Strong communication and collaboration skills, with the ability to influence application and infrastructure teams.
-   Demonstrated ownership, technical judgment, and ability to mentor other engineers.

**Nice to Have:**

-   Experience with **multi-region databases, global tables, and cross-region failover**.
-   Familiarity with **AWS**, production support, and on-call environments.
-   Understanding of networking concepts such as **VPCs, subnets, security groups, CIDR, and peering**.
-   Experience with **Kubernetes** or self-managed database infrastructure.
-   Experience building internal database platforms, self-service tooling, policy-as-code, or safe migration frameworks.

## Apply

[Apply at Weekday AI](https://apply.workable.com/weekday-1/j/EEE2B736C5/apply)

---
Powered by [Workable](https://www.workable.com)