Database Administrator

Job Description

MongoDB & PostgreSQL Database Administrator (EC2 Clustered Environment)

Experience

510+ 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 snapshotbased 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

Interested candidates can share their resume at gunjan@appsquadz.com or 9711970959