Postgress SQL Database Administrator

Job description

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.