Database Administrator

MongoDB / Postgresql / Elastic Search (Strong experience in any 2)

Key Responsibilities

Design, install, configure, and maintain MongoDB / Postgresql / Elastic Search on-premises clusters (replica sets, sharded clusters).

Manage and optimize database performance, including query tuning, indexing strategies, and resource utilization.

Implement and maintain monitoring and alerting using Grafana, Prometheus, and MongoDB Exporter.

Configure backup and recovery mechanisms using mongodump, snapshots.

Handle replication lag, oplog sizing, and balancer optimization in sharded clusters.

Work closely with developers and DevOps teams to ensure database best practices in application design.

Perform root cause analysis for database performance and stability issues.

Implement security hardening, user management, role-based access, and TLS / SSL setup.

Contribute to capacity planning, scalability improvements, and high availability (HA) setups.

3–6 years of hands-on experience with MongoDB / Postgresql / Elastic Search (Any 2) administration (v4.x – v8.x).

Strong understanding of replication, sharding, journaling, and storage engines (WiredTiger).

Experience with Linux system administration (Ubuntu).

Proficient in monitoring MongoDB metrics via Grafana, Prometheus, MMS.

Knowledge of query profiling, explain plans, and performance analysis.

Familiarity with MongoDB backups, PITR, and disaster recovery.

Experience in scripting and automation using Bash or Python.

Good understanding of networking, security, and SSL / TLS configurations for database communication.

Experience with version upgrades, patching, and migrations Knowledge of connection pooling (PgBouncer / HAProxy) and load balancing for read replicas.

Proficiency in SQL, PL / pgSQL scripting, and Linux shell scripting.