Worktual Innovations logo

Senior Database Administrator

Worktual Innovations

10 - 15 years

Chennai

Posted:2 days ago

Job Description

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

Senior Database Administrator

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

Skills Required

Senior Cloud Administration Native Postgresql Cloud Native DBMS Database administration

Learn the skills this job asks for

See your skill gap for Database Administrator →

Free courses, interview questions and practice for each skill.

Work Mode

Work from Office

Job Type

Full Time

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Worktual Innovations logo
Worktual Innovations

RecommendedJobs for You

Worktual Innovations logo

Senior Database Administrator

Worktual Innovations

Chennai

Northern Arc Capital logo

Senior Database Administrator

Northern Arc Capital

Bengaluru

Embrace Software Inc logo

Senior Database Administrator

Embrace Software Inc

India

Jonas Software logo

India

Embrace Software Inc logo

Senior Database Administrator

Embrace Software Inc

India

Sobha llc logo
K