Senior Database Administrator

Worktual Innovations

Chennai

Vor Ort

INR 2.500.000 - 5.000.000

Vollzeit

Vor 6 Tagen
Sei unter den ersten Bewerbenden

Erhalte eine Antwort von diesem Arbeitgeber

Dein Lebenslauf und dein Anschreiben, genau auf das zugeschnitten, was gesucht wird.

Schaffe es an den ATS-Filtern vorbei

Zusammenfassung

Worktable is seeking a seasoned Senior Database Administrator to own the reliability, performance, and security of core data infrastructure in Chennai. You will oversee PostgreSQL and ClickHouse environments, real-time CDC pipelines with Kafka and Debezium, and Kubernetes-hosted data workloads supporting Delta Lake-based lakehouse storage.

You will design HA/replication, optimize memory and queries, and lead backup/DR, with strong emphasis on security, RBAC, and observability.

Qualifikationen

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

Aufgaben

  • Architect, administer, and optimize high-availability PostgreSQL and ClickHouse clusters.
  • Tune memory allocations, query plans, indexing, and partitioning for performance.
  • Design and maintain robust replication topologies with DR objectives.
  • Own end-to-end backup strategies and disaster recovery drills.
  • Deploy and manage Kafka clusters and Debezium CDC connectors for real-time data streaming.
  • Manage Delta Lake storage layers and collaborate with data engineers on data products.
  • Operate on Kubernetes-based stateful workloads and implement IaC and CI/CD for DB provisioning and migrations.
  • Ensure security, access governance, and monitoring of data platforms and pipelines.

Kenntnisse

PostgreSQL
ClickHouse
Kafka
Debezium
Kubernetes
Delta Lake
Terraform
Ansible
CI/CD
RBAC
Monitoring

Tools

pg_basebackup
pg_dump
PITR
PgBouncer
Liquibase
Flyway
Kubernetes Operators
Helm

Jobbeschreibung

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 modern 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
Hol dir deinen kostenlosen, vertraulichen Lebenslauf-Check.

oder ziehe deine Datei hierhin.

Similar jobs

Ähnliche Jobs, die dir auch gefallen könnten

Database Administrator - Bengaluru Only (m/f/d)
Database Administrator - Bengaluru Only (m/f/d)

Cuculus • Bengaluru

Vor Ort
INR 1.500.000 - 2.100.000
Lead - Database Administrator: 797
Lead - Database Administrator: 797

Netcore • Mumbai

Vor Ort
INR 1.500.000 - 2.500.000
Lead – Database Administrator (DBA)
Lead – Database Administrator (DBA)

Delta6Labs FinTech Pvt Ltd • Indien

Vor Ort
INR 4.000.000 - 7.000.000
Senior Database Administrator
Senior Database Administrator

i2b Technologies Pvt Ltd • Hyderabad

Vor Ort
INR 1.000.000 - 3.000.000
Database Administrator
Database Administrator

Weekday AI • Chennai

Vor Ort
INR 1.400.000 - 2.000.000
ClickHouse Database Administrator (DBA)
ClickHouse Database Administrator (DBA)

VMC Soft Technologies • Chennai District

Vor Ort
INR 1.200.000 - 2.000.000
Database Developer Lead MYSQL and PostgreSQL
Database Developer Lead MYSQL and PostgreSQL

Worktual Innovations • Chennai

Vor Ort
INR 1.500.000 - 2.400.000
Senior DBA Infrastructure India
Senior DBA Infrastructure India

Stitch • Chennai

Vor Ort
INR 400.000 - 700.000
Database Administrator
Database Administrator

Minfy Technologies • Hyderabad

Vor Ort
INR 1.500.000 - 2.400.000
Senior Project Consultant - Technology Strategy & Transformation
Senior Project Consultant - Technology Strategy & Transformation

EY • New Delhi

Vor Ort
INR 4.000.000 - 7.000.000