Role: Postgress DBA

Location: Pune

Experience: 5-10 Years




Desired Competencies (Technical/Behavioral Competenc

y)Must-Ha


ve
Cassandra / ScyllaDB Administrat

ion· Install, configure, upgrade, and maintain Apache Cassandra / DataStax or ScyllaDB cluste

rs.· Manage multi-datacenter, multi-node deploymen

ts.· Configure replication, consistency levels, snitches, compaction strategies, and repair settin

gs.· Perform routine cluster health checks and maintenance tasks (repair, cleanup, decommission, rebuil

d).Performance & Optimizat

ion· Monitor cluster performance using tools like nodetool, Grafana, Prometheus, DSE OpsCenter, Scylla Monitoring Sta

ck.· Troubleshoot latency issues: GC tuning, compaction tuning, hot partitions, tombstone analys

is.· Optimize schemas, queries, and data models for distributed syste

ms.Operations & Supp

ort· Manage backup and restore processes using tools such as Medusa, Snapshots, Scylla Manag

er.· Handle incident management and production troubleshooti

ng.· Implement automation for routine tasks (Shell/Python is fine—not heavy programmin

g).· Participate in on-call rotation for production suppo

rt.Security & Complia

nce· Implement authentication, authorization (role-based access), and audit contro

ls.· Apply OS-level hardening and understand network/security requirements for distributed syste

ms.

---Required Ski

llsTechnical Ski

lls· Minimum 4+ years hands-on experience in Apache Cassandra, DataStax, or Scylla

DB.· Strong understanding

of:o Gossip Proto

colo Hinting & Read/Write P

atho Consistency Lev

elso Compaction (SizeTiered, Leveled, TimeWind

ow)o SSTables, Memtables, Commit L

ogso Repair processes & Anti-entr

opy· Experience

in:o Linux administrat

iono System metrics (CPU, memory, I/O, netwo

rk)o Observability tools (Prometheus/Grafa

na)o Backup/restore framewo

rksSoft Ski

lls· Strong analytical and troubleshooting skil

ls.· Ability to collaborate with cross-functional teams (SRE, App Teams, Cloud Team

s).· Clear written and verbal communication skil

ls.

---Nice to Have (Option

al)· Experience with ScyllaDB Manager, Scylla Monitoring Sta

ck.· Exposure to AWS / GCP / Azure deployments for Cassandra/Scyl

la.· Experience with Kafka, Redis, or other distributed syste

ms.· Exposure to automation tools: Ansible, Terraform, Jenki

ns.Multi-Database Expertise (Cassandra + PostgreSQL + SQL Serv

er)· Ability to manage and optimize distributed NoSQL systems along with traditional RDB

MS.· Skilled in performance tuning, replication architecture, HA/DR design across all platfor

ms.· Strong SQL optimization skills across PostgreSQL & SQL Serv

er.· Experience with cross-platform migrations, data modeling, and schema desi

gn.· Familiar with automation, observability, and cloud deployments across all database engin


es.
Similar jobs

More from Tata Consultancy Services
Tata Consultancy Services 13 hours ago
Tata Consultancy Services 2 days ago
Tata Consultancy Services 3 days ago

Postgress SQL Database Administrator

Apply Now
Back to search page