Job Description

5-8 Years
Noida
Full time

Job Title

MongoDB & PostgreSQL Database Administrator (EC2 - Clustered Environment)

Experience

5-10+ Years

Location:

Sector 90, Noida (Onsite)

Job Summary

We are seeking a highly skilled

MongoDB & PostgreSQL Database Administrator

to manage

self-hosted, clustered databases running on AWS EC2

. The role involves end-to-end ownership of database availability, performance, security, backup, disaster recovery, and upgrades in

high-availability production environments

with minimal downtime.

Key Responsibilities

Database Administration (EC2-Based Clusters)

Install, configure, and manage

MongoDB and PostgreSQL clusters

on AWS EC2


Manage OS-level tuning, EBS storage optimization, and filesystem performance


Perform database upgrades, patching, and configuration changes with minimal downtime


Manage cluster scaling, node replacement, and rebalancing

High Availability & Replication

Manage:

MongoDB Replica Sets and Sharded Clusters

PostgreSQL Streaming / Logical Replication

Perform

manual failover and primary promotion

during outages


Maintain and execute

failover & DR runbooks

Performance Monitoring & Tuning

Monitor EC2, disk IOPS, memory, CPU, and network usage


Optimize PostgreSQL queries, indexes, VACUUM, and WAL settings


Tune MongoDB indexes, aggregation pipelines, and WiredTiger performance


Troubleshoot slow queries, deadlocks, and replication lag

Backup, Restore & Disaster Recovery

Implement backup strategies using:


pg_dump, pg_basebackup, WAL archiving


mongodump, mongorestore



Manage

EBS snapshot-based backups

and S3 archival


Define and test

RTO / RPO

Perform DR drills and document recovery procedures

Security & Compliance

Implement TLS encryption, authentication, and role-based access control


Secure EC2 instances (OS hardening, patching, security groups)


Manage secrets using AWS Secrets Manager / Vault


Support audits and security compliance requirements

Automation & DevOps Collaboration

Automate routine DBA tasks using

Shell / Python scripts

Work closely with DevOps teams on CI/CD, infrastructure changes, and releases


Support schema changes and application deployments

Incident Management

Provide

L2/L3 production support

Perform root cause analysis (RCA) and preventive improvements


Participate in on-call support and planned maintenance activities

Required Skills

Database

MongoDB

: Replica Sets, Sharding, Indexing, Aggregation

PostgreSQL

: Replication, WAL, Performance Tuning, Indexing

AWS & Infrastructure

Strong hands-on experience with

AWS EC2, EBS, VPC, IAM

Linux system administration (RHEL / Amazon Linux / Ubuntu)

Monitoring & Tools

CloudWatch, Prometheus, Grafana (or similar)


PostgreSQL tools: pg_stat_statements, pgBadger


MongoDB tools: mongostat, mongotop

Preferred / Nice to Have

Experience with

Patroni, PgPool, HAProxy

MongoDB Ops Manager experience


Handling

large databases (1TB+)

Exposure to multi-region DR setups