Senior Database Administrator (PostgreSQL and MongoDB)

FCS Software Solutions; Gurugram District; On-site; INR 2,500,000 - 4,000,000; Full time

Job summary

FCS Software Solutions in Gurugram, Haryana seeks a Senior Database Administrator with deep PostgreSQL and MongoDB expertise. You will own database administration, performance tuning, and DR across our infrastructure, stepping in to diagnose complex issues and ensure data stability and security.

Responsibilities include provisioning across environments, tuning, replication, backups, and incident response. Strong Linux skills and cloud IaaC experience are essential; 8+ years in production DBAs is

Qualifications

• 8+ years of hands-on DBA experience in production environments.
• Deep PostgreSQL (10+) and MongoDB (5+) expertise with HA, backups, replication.
• Strong SQL and MongoDB aggregation skills.
• Proficiency in Linux/Unix and shell scripting.
• Experience with cloud DB services and IaC tools.

Responsibilities

• Provision and manage PostgreSQL and MongoDB across dev, staging, prod.
• Tune performance, analyze slow queries, optimize indices.
• Design and operate replication, HA, and DR strategies.
• Implement and verify backup, PITR, and restore processes.
• Monitor, alert, and incident manage database infrastructure.
• Collaborate with devs on schema changes and data modeling.

Skills

PostgreSQL

MongoDB

SQL queries

Linux/Unix

Shell scripting

Education

Bachelor's degree in CS or related

Tools

pgAdmin

Datadog

Prometheus

Grafana

Docker

Job description

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
• Strong 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)