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 reliable, 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 (sharedbuffers, workmem, effectivecachesize, 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