Database Administrator

Weekday 1; Chennai District; On-site; INR 1,400,000 - 2,000,000; Full time

Job summary

Weekday 1 is seeking a Database Engineer in Chennai, India, to design, scale, and automate advanced database infrastructure for cloud-native environments. The role emphasizes PostgreSQL proficiency, distributed systems expertise, and production-grade Python tooling.

The ideal candidate will navigate storage engines, replication, transactions, and concurrency while building reliable automation and operational guardrails.

Qualifications

• 3+ years of engineering experience with database systems.
• Deep PostgreSQL expertise with knowledge of MySQL/MongoDB/MariaDB.
• Strong Python, Linux, and debugging skills.

Responsibilities

• Design, operate, optimize, and scale production database systems across SQL and NoSQL environments.
• Debug and prevent complex concurrency issues, including deadlocks and long-running transactions.
• Advise application teams on safe database access patterns including idempotency and retries.
• Develop understanding of database storage and replication internals (BMVCC, WAL, checkpoints).
• Design and implement backup, restore, upgrade, migration, and disaster recovery strategies.
• Analyze query planner behavior, statistics, and performance bottlenecks.
• Build effective indexing strategies balancing write amplification and performance.
• Create automation and tooling for health checks, failover, and diagnostics.
• Automate online schema changes, safe rollout and rollback workflows.
• Develop automation for performance diagnostics and workload analysis.
• Build tooling to process millions of records efficiently.
• Guide data-modeling decisions across relational, document, and key-value databases.
• Evaluate normalization vs denormalization and data lifecycle policies.
• Establish data correctness, durability, and change management standards.
• Partner with teams on migration strategies and HA database solutions.
• Contribute to multi-region architectures and failover strategies.
• Mentor engineers in database engineering practices.

Skills

PostgreSQL

Python

Distributed systems

Transactions & MVCC

Replication

Performance optimization

Concurrency

Linux

MySQL

Tools

Kubernetes

Docker

AWS

SQL tooling

Job description

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

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

Experience: 3+ yrs

Location: Chennai, Tamil Nadu, India

Job Type: Full-time

We are looking for a strongDatabase Engineerwith 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 ofstorage 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 complexconcurrency issues, including deadlocks, lock contention, starvation, and long‑running transactions.
• Advise application teams on safe database access patterns, includingidempotency, retries, backoff strategies, and concurrency controls.
• Develop a deep understanding of database storage and replication internals, includingB‑trees, LSM structures, page layouts, WAL/redo/undo, checkpoints, compaction, MVCC, and storage engines.
• Design and implement database backup, restore, upgrade, migration, anddisaster recoverystrategies.
• 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 forreplication 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‑gradePython automation and toolingfor 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 processingmillions of records or events, with strong attention to time and space complexity.
• Guide data‑modeling decisions across relational, document, and key‑value databases.
• Evaluatenormalization 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 experiencewith strong hands‑on database engineering responsibilities.
• Deep expertise inPostgreSQLand strong understanding of at least one additional SQL or NoSQL database such asMySQL, MongoDB, or MariaDB.
• Strong foundation indistributed systems, including CAP, replication, consistency, failure handling, and consensus fundamentals.
• Deep understanding oftransactions, isolation levels, MVCC, locking, concurrency, storage engines, and database internals.
• Strong proficiency inPython, with experience building production‑grade automation, diagnostics, and operational tooling.
• Hands‑on experience operating, troubleshooting, tuning, and scalingproduction databases.
• Strong debugging and performance‑analysis skills, with the ability to reason from metrics, logs, traces, and low‑level system behavior.
• Good understanding ofLinuxand common command‑line tools.
• Ability to evaluate technical trade‑offs acrosslatency, 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 withmulti‑region databases, global tables, and cross‑region failover.
• Familiarity withAWS, production support, and on‑call environments.
• Understanding of networking concepts such asVPCs, subnets, security groups, CIDR, and peering.
• Experience withKubernetesor self‑managed database infrastructure.
• Experience building internal database platforms, self‑service tooling, policy‑as‑code, or safe migration frameworks.