Postgress SQL Database Administrator

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 finenot 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