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