Deepamjyoti Sahoo

MongoDB Database Administrator with 2+ years of hands-on experience in managing MongoDB replica sets and sharded clusters across production and non-production environments. Experienced in database administration, backup and recovery, version upgrades, disaster recovery testing, performance tuning, index optimization, monitoring, troubleshooting, capacity planning, and high availability. Familiar with Linux, cloud environments, and database monitoring tools, with a focus on maintaining database reliability, availability, and operational support.

Associate Database Administrator - Ornext Technology Solutions - Bengaluru, KA

(2025-11)

• Administered MongoDB replica sets and sharded clusters across Production, UAT, and Dev, including config server management, election tuning, and chunk balancing to sustain HA under node failure.
• Owned backup and recovery using mongodump/mongorestore, filesystem snapshots, and oplog-based point-in-time recovery (PITR), performing hands-on PITR practicals to validate recovery point objectives (RPO) across simulated failure scenarios; automated backup and restore workflows using Python, with periodic restoration validation.
• Conducted quarterly audits of backup and recovery processes to verify SLA compliance, tracking backup success rates, restore integrity, and recovery time objectives (RTO).
• Diagnosed and resolved production issues including lock contention, slow queries and the database profiler, oplog lag on secondaries, and cluster balancing during peak load.
• Collaborated with application, infra and devops teams to troubleshoot production incidents, support release activities, and maintain database availability in 24×7 production environments.

Programmer Analyst Trainee - Cognizant Technology Solutions - Hyderabad, TG

(2024-11 - 2025-11)

• Assisted in administering MongoDB replica sets and sharded clusters under senior DBA guidance, supporting day-to-day health checks, backup validation, and replication monitoring across production environment.
• Supported query performance tuning efforts by analyzing slow queries and execution plans, contributing to index optimization work that helped reduce p95 query latency on targeted collections.
• Maintained upgrade and patching records, logging execution timelines, validation results, and rollback triggers to support audit and knowledge-transfer requirements.
• Assisted in monitoring MongoDB environments using PMM and MongoDB Atlas, investigating alerts related to replication, performance, and resource utilization, and supporting production issue resolution under supervision.

DBA Intern - DataXSchool - Bhubaneswar, OD

(2024-06 - 2024-11)

• Installed and configured MongoDB standalone and replica set environments on Linux, performing routine administrative tasks and validating replication and failover.
• Managed database users, roles, authentication, and index creation while executing backup and restore operations using mongodump and mongorestore.
• Monitored database health using PMM and MongoDB Atlas, analyzed slow queries, and performed basic performance tuning through index optimization.
• Completed a capstone project involving a 3-shard MongoDB cluster with replica sets, config servers, and mongos routers as a training capstone, applying compound and TTL indexing, RBAC security, backup/recovery, and failover testing to simulate production-grade cluster operations.

Bachelor of Technology - Chemical Engineering - Veer Surendra Sai University of Technology, Burla (2020 - 2024)