Senior Database Administrator (Chennai)

Senior Database Administrator (Chennai)

17 Nov
|
Worktual Innovations
|
Chennai

17 Nov

Worktual Innovations

Chennai

Experience: 10 + years

Work Location: Chennai [ work from office]

Interview: In Person @ Chennai Office

Notice Period: Immediate to 15 days

ONLY CHENNAI CANDIDATES NEED TO APPLY

Role Overview

Worktable is seeking a seasoned Senior Database Administrator with 10+ years of experience to own the reliability, performance, scalability, and security of our core transactional and analytical data infrastructure. You will oversee mission-critical PostgreSQL and ClickHouse environments, real-time CDC/streaming pipelines (Kafka & Debezium), Kubernetes-hosted data workloads, and contemporary Lakehouse storage (Delta Lake) supporting downstream data products.

Key Responsibilities

1. Core Database Administration & Performance Tuning

- PostgreSQL & ClickHouse Operations: Architect, administer, and optimize high-availability PostgreSQL and ClickHouse clusters across production and non-production environments.
- Memory & Resource Optimization: Tune database memory allocations (e.g., shared_buffers, work_mem, connection pooling via PgBouncer, ClickHouse memory limits/caches), query execution plans, indexing strategies, and table partitioning.
- High Availability & Replication: Design, configure, and maintain robust replication topologies (streaming replication, logical replication, WAL shipping, automated failover, and read replicas) to guarantee strict RPO/RTO targets.

2. Storage, Capacity & Backup Management

- Space & Storage Control: Proactively monitor disk utilization, table bloat (VACUUM/autovacuum tuning, compaction), tablespaces, and Persistent Volume Claims (PVCs). Implement archival and data retention policies to control storage growth.
- Backup & Disaster Recovery:



Own end-to-end backup strategies (pg_basebackup, pg_dump, PITR, ClickHouse backups to object storage) and conduct regular, automated restore drills to validate disaster recovery readiness.

3. Streaming, CDC & Lakehouse Data Platforms

- Kafka & Debezium Setup: Deploy, configure, and manage Apache Kafka clusters and Debezium Change Data Capture (CDC) connectors to stream real-time transactional data with minimal replication lag.
- Delta Lake & Data Products: Manage and optimize Delta Lake storage layers (compaction, Z-ordering, vacuuming, schema evolution) and collaborate with Data Engineering teams to ensure reliable, performant data products.

4. Infrastructure, Kubernetes & Automation

- Kubernetes Data Workloads: Deploy and manage stateful database and streaming components on Kubernetes using operators (e.g., CloudNativePG, Patroni, Strimzi), Helm charts, and StorageClasses.
- Automation & CI/CD Deployments: Eliminate manual toil by building Infrastructure-as-Code (Terraform/Ansible) and CI/CD pipelines for database provisioning, schema migrations (Flyway/Liquibase), patching, and zero-downtime upgrades.

5. Observability, Security & Access Governance

- Server Health & Proactive Monitoring: Build comprehensive observability dashboards and alerting covering server health, CPU/IOPS,



replication lag, Kafka consumer lag, and slow queries.
- Access Management & Compliance: Own user account provisioning, Role-Based Access Control (RBAC), secrets management (Vault), encryption at rest/in transit, and regular security/access audits.

Required Qualifications & Technical Skills

- Experience: 10+ years of hands-on experience as a Production DBA or Data Platform Engineer managing large-scale, mission-critical data systems.
- Relational & OLAP Databases: Deep expertise in PostgreSQL internals, replication, memory tuning, and backup/recovery; strong hands-on administration of ClickHouse.
- Streaming & CDC: Proven experience setting up, scaling, and troubleshooting Apache Kafka and Debezium connectors in production.
- Lakehouse & Data Products: Solid working knowledge of Delta Lake architecture, object storage management, and supporting analytical data pipelines.
- Containers & Cloud: Strong experience running stateful workloads on Kubernetes (storage classes, PVCs, operators, Helm) alongside Linux server administration.
- Automation & Scripting: Proficiency in scripting (Bash, Python) and automation/deployment tooling (Terraform, Ansible, Helm, Liquibase/Flyway).
- Security & Monitoring: Hands-on experience with database access management, RBAC, and monitoring stacks (Prometheus, Grafana, or equivalent).

Preferred Qualifications

- Experience with cloud-native storage systems (Oracle Cloud or AWS S3/EBS, GCP GCS/PD, or Azure) and cost-to-performance optimization.
- Prior experience mentoring junior DBAs/engineers and establishing operational runbooks and SLOs

📌 Senior Database Administrator (Chennai)
🏢 Worktual Innovations
📍 Chennai

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: senior database administrator (chennai) / chennai

Subscribe to this job alert:

Get the latest job offers by email for: senior database administrator (chennai) / chennai