Senior Database Administrator (MongoDB & PostgreSQL)

Global Software Solutions Group; Bengaluru; On-site; INR 3,000,000 - 5,400,000; Full time

Job summary

Global Software Solutions Group in Bengaluru seeks a Senior Database Administrator with deep, hands-on expertise in MongoDB and PostgreSQL. You will own reliability, performance, security, and scalability across production environments, taking responsibility for architecture decisions, high availability, and disaster recovery readiness.

This dual-platform role requires mastery of both NoSQL and relational ecosystems, driving patching, upgrades, backups, and tuning, while partnering with Agile

Qualifications

• 7+ years in database administration with hands-on production experience across MongoDB and PostgreSQL.
• Proven HA/DR design and major version upgrade experience.
• Solid knowledge of Unix/Linux, SQL/PL/pgSQL, scripting, and automation tooling.
• Relevant certifications are a plus.

Responsibilities

• Administer, monitor, and maintain MongoDB and PostgreSQL environments across development, staging, and production.
• Design replica sets, sharded clusters, and clustering solutions for high availability.
• Own backup/restore strategy including PITR and validate recovery procedures.
• Plan/publish patching and upgrades with minimal downtime and rollback plans.
• Tune performance, diagnose replication lag, and resolve index inefficiencies.
• Manage monitoring, security hardening, and compliance aligned with policy.

Skills

MongoDB

PostgreSQL

Unix/Linux

High availability

Backup & DR design

Performance tuning

Tools

MongoDB Ops Manager

Ansible

Terraform

Jenkins

PgBackRest

Job description

Role Summary

We are seeking a highly experienced Senior Database Administrator with deep, hands on expertise across both MongoDB and PostgreSQL platforms. The successful candidate will own database reliability, performance, security, and scalability across mission critical production environments, taking full responsibility for administration, architecture decisions, high availability design, and disaster recovery readiness. This is a dual platform role requiring genuine depth in both NoSQL and relational database ecosystems, not surface level familiarity in one propped up by the other.

Role Summary

We are seeking a highly experienced Senior Database Administrator with deep, hands on expertise across both MongoDB and PostgreSQL platforms. The successful candidate will own database reliability, performance, security, and scalability across mission critical production environments, taking full responsibility for administration, architecture decisions, high availability design, and disaster recovery readiness. This is a dual platform role requiring genuine depth in both NoSQL and relational database ecosystems, not surface level familiarity in one propped up by the other.

Key Responsibilities

MongoDB

• Administer, monitor, and maintain MongoDB environments across development, staging, and production
• Design and manage replica sets and sharded cluster topologies for high availability and horizontal scalability
• Own backup and restore strategy, including point in time recovery, and validate recovery procedures regularly
• Plan and execute database patching and version upgrades with minimal downtime
• Administer and operate MongoDB Ops Manager for fleet monitoring, automation, and backup orchestration
• Diagnose and resolve replication lag, shard balancing issues, and index inefficiencies
• Own internals level troubleshooting including WiredTiger storage engine behaviour, oplog sizing, and write concern tuning

PostgreSQL

• Administer PostgreSQL instances across the full lifecycle, from provisioning to decommissioning
• Design and implement high availability and clustering solutions (e.g. streaming replication, Patroni, Pgpool, or equivalent)
• Configure and manage monitoring tooling to proactively identify performance degradation and capacity risks
• Own backup and restore strategy including physical and logical backups, WAL archiving, and point in time recovery
• Execute patching and major/minor version upgrades with a tested rollback plan
• Write and optimize SQL and PL/pgSQL for performance tuning, troubleshooting, and support of application teams

Cross Platform Responsibilities

• Own database patching and upgrade governance across both platforms, including testing, rollback planning, and change management alignment
• Implement and maintain database auditing, logging, and security hardening practices in line with compliance requirements
• Lead performance tuning and diagnostics work, including query optimization, index strategy, resource contention analysis, and capacity planning
• Plan and execute database migrations (version upgrades, platform migrations, cloud/on prem transitions) with minimal business disruption
• Maintain infrastructure as code and automation for database provisioning and configuration using tools such as Ansible, Jenkins, or Terraform
• Write and maintain operational scripts and tooling in Bash and/or Python to reduce manual effort and improve reliability
• Operate within Agile delivery practices, participating in sprint planning, incident retrospectives, and cross functional ceremonies
• Administer databases on Unix/Linux operating systems, including OS level performance and resource troubleshooting relevant to database workloads

Requirements

7+ years in database administration, including 4+ years of hands on production experience across both MongoDB and PostgreSQL. Excellent knowledge of MongoDB and PostgreSQL architecture, internals, HA, and backup/restore. Good knowledge of SQL/PL/pgSQL, Unix/Linux, Agile practices, automation tooling, and scripting. Track record of leading HA/DR design and major version upgrades independently, not just executing existing runbooks.

Relevant certifications (MongoDB DBA Associate/Professional, PostgreSQL/EDB/PGCA, or cloud database certifications) are a plus.