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 setting-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 ma

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