Role: Senior Database Administrator (PostgreSQL and MongoDB)

Experience Required: 8+ years

Location: Gurugram, Haryana (Gurgaon)

About the Role:

We are looking for an experienced Senior Database Administrator with deep expertise in PostgreSQL and MongoDB. The ideal candidate will take ownership of database administration, performance tuning, troubleshooting, and delivery support across our infrastructure. This role requires someone who can step in, diagnose complex issues, and ensure our databases are stable, secure, and performant.

Key Responsibilities:

Day-to-Day Administration

- Provision, configure, and manage PostgreSQL and MongoDB instances across development, staging, and production environments
- Perform routine health checks, instance monitoring, and capacity planning
- Manage user accounts, roles, permissions, and access control policies
- Handle database creation, cloning, schema migrations, and version upgrades
- Manage configuration parameters, tuning, and environment-specific optimizations
- Perform patching, minor/major version upgrades, and rollback procedures

Performance Tuning & Optimization

- Analyze slow queries, execution plans, and query patterns to identify bottlenecks
- Tune PostgreSQL settings (shared_buffers, work_mem, effective_cache_size, checkpoint, WAL, etc.)
- Optimize MongoDB queries, index usage, and write concern configurations
- Identify and resolve lock contention, deadlocks, and blocking issues
- Recommend and implement indexing strategies (B-tree, GIN, GiST, partial, composite, etc.)
- Monitor and optimize connection pooling, buffer cache, and I/O throughput

High Availability, Replication & Disaster Recovery

- Design, implement, and maintain PostgreSQL replication setups (streaming, logical, synchronous/async)
- Manage MongoDB replica sets, arbiter nodes, and failover configurations
- Design and operate MongoDB sharded clusters (config servers, mongos routers, shard allocation)
- Implement and maintain high-availability solutions (Patroni, pgpool-II, repmgr, Pacemaker/Corosync)
- Define and test RPO/RTO targets, backup strategies, and disaster recovery runbooks
- Perform point-in-time recovery (PITR), full/partial restores,



and cross-region failover drills

Backup, Restore & Data Integrity

- Design and automate backup strategies (full, incremental, WAL-based, continuous archiving)
- Manage MongoDB backups (mongodump, file system snapshots, cloud snapshots)
- Conduct regular restore drills to validate backup integrity and recovery timelines
- Monitor backup job success/failure, retention policies, and storage consumption
- Perform data integrity checks, corruption detection, and repair procedures

Security & Compliance

- Implement and enforce database security policies, authentication, and authorization
- Manage SSL/TLS encryption for data in transit and at rest
- Configure and audit role-based access control (RBAC) and least-privilege principles
- Perform security hardening, vulnerability assessments, and compliance audits
- Manage audit logging, query logging, and data access tracking
- Ensure GDPR/PCI-DSS/SOC2 compliance as applicable

Monitoring, Alerting & Incident Management

- Set up and maintain monitoring dashboards (Grafana, Datadog, Prometheus, pgMonitor, MongoDB Atlas)
- Configure alerting thresholds for CPU, memory, disk, connections, replication lag, slow queries, etc.
- Respond to production incidents, perform root-cause analysis, and document post-mortems
- Track and report on SLA/SLO metrics, uptime, and incident trends

Delivery & Engineering Support

- Collaborate with development teams on schema design reviews and data modeling
- Review and approve DDL changes, migration scripts, and deployment pipelines
- Provide query review, index recommendations, and anti-pattern guidance to developers
- Participate in sprint planning, release reviews, and capacity forecasting
- Document procedures, runbooks, and knowledge-base articles

Infrastructure & Automation

- Manage databases on bare metal, VMs, containers (Docker),



and Kubernetes (Operators)
- Automate provisioning, configuration, and routine tasks using Ansible, Terraform, or custom scripts
- Manage cloud-hosted databases (AWS RDS, Amazon DocumentDB, Azure Database for PostgreSQL, GCP Cloud SQL)
- Implement infrastructure-as-code for reproducible, version-controlled database environments
- Maintain configuration management and drift detection

Required Qualifications:

- 8+ years of hands-on experience as a Database Administrator in production environments
- Solid operational expertise with PostgreSQL (version 10+) administration, replication, tuning, HA, backups
- Strong operational expertise with MongoDB (version 5+) replica sets, sharding, tuning, backups, administration
- Proficiency in writing and analyzing complex SQL queries and MongoDB aggregation pipelines
- Deep understanding of database internals storage engines, WAL/journaling, MVCC, indexing, buffer management
- Experience with database monitoring and alerting tools (pgAdmin, pg_stat_statements, MongoDB Compass, Datadog, Prometheus, Grafana)
- Hands-on experience with backup, restore, and disaster recovery procedures
- Strong Linux/Unix administration skills and shell scripting (Bash, Python)
- Familiarity with infrastructure-as-code (Terraform, Ansible) and container orchestration (Docker, Kubernetes)
- Experience managing databases in cloud environments (AWS, Azure, GCP)
- Strong troubleshooting skills with the ability to diagnose and resolve issues under pressure
- Excellent communication skills for cross-functional collaboration and stakeholder reporting
- Experience with PostgreSQL HA tools Patroni, pgpool-II, repmgr, Barman, pgBackRest, logical replication
- MongoDB sharded cluster design, resharding, and chunk migration experience
- Experience with cloud-managed databases AWS RDS/DocumentDB, Azure Cosmos DB, Azure SQL, GCP Cloud SQL/AlloyDB
- Familiarity with database migration tools (pgLoader, mongorestore, AWS DMS)
- Experience with connection poolers (PgBouncer, mongos)
- Relevant certifications (MongoDB Certified DBA, PostgreSQL certifications, AWS/Azure database specialties)

📌 Senior Database Administrator (PostgreSQL and MongoDB) (Gurugram)
🏢 FCS Software Solutions
📍 Gurugram