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-inciden

📌 Database Administrator (Chennai)
🏢 Weekday AI
📍 Chennai