Postgresql Administrator - MongoDB

LTM; Hyderabad, Bengaluru; Hybrid; INR 1,275,000 - 1,725,000; Full time

Job summary

LTM is seeking a Postgres and MongoDB Database Administrator to join our Hyderabad/Bangalore team. The role focuses on maintaining PostgreSQL and MongoDB environments, including installation, configuration, backup and recovery, and performance tuning.

The candidate will work with on-premises and cloud deployments (Azure/AWS), handling capacity planning, monitoring, automation, and migrations across environments. Strong scripting and SQL skills are essential for success.

Qualifications

• Minimum 3 years of PostgreSQL administration on-premises and cloud.
• Experience with PostgreSQL 10+ and performance tuning.
• Proficient in Linux/Unix shell scripting and SQL.
• Hands-on with MongoDB installation, configuration, and replication.
• Experience with cloud platforms Azure/AWS.
• Strong knowledge of IaaS/PaaS cloud DB environments.
• Ability to monitor, backup, and recover databases.
• Ability to migrate databases across environments.

Responsibilities

• Provide technical and operational support for PostgreSQL database servers.
• Install, troubleshoot, monitor, and tune PostgreSQL performance.
• Maintain backups and recovery procedures; ensure data integrity.
• Deploy PostgreSQL databases on cloud platforms such as Azure and AWS.
• Work with shell scripting, Python, or Perl for automation.
• Ensure database capacity planning and proactive issue remediation.
• Participate in creating development, staging, and production instances.

Skills

PostgreSQL

MongoDB

Cloud

Shell scripting

Python

Performance tuning

Backup & Recovery

NoSQL

Replication

Tools

pgAdmin

pgAudit

pgBadger

pgPool

psql

MongoDB Atlas

Job description

Role : Postgres and MongoDB Admin

Location Hyderabad /Bangalore

Max Budget : 15 LPA

JD

Postgres MongoDB JD for P3 level

Job Responsibilities

PostgreSQL Database Administrator will be providing technical and operational support for activities of Database Servers including installation troubleshooting performance monitoring tuning and optimizing

Minimum Three 3 years of experience with PostgreSQL version 10 up till latest version hosted on Onpremises and Cloud Platform

Install monitor and maintain PostgreSQL implement monitoring and ing implement backup and recovery processes provide system and SQL performance tuning

Min two 2 years of experience as a PostgreSQL database administrator deploying PostgreSQL databases on Cloud platforms such as Azure Cloud Environment AWS

Strong Knowledge in IaaS PaaS cloud database environment and configuration

Programming languages such as UNIX shell scripting PLpgSQL Python or Perl experience

Two 2 years of experience with PostgreSQL native tools like pgAdmin pgAudit pgBadger pgPool pSQL

Estimate PostgreSQL database capacities develop methods for monitoring database capacity and usage

Must have experience in PostgreSQL database architecture logical and physical design automation documentation installs shell scripting PL SQL programming catalog navigation query tuning system tuning resource contention analysis backup and recovery standby replication etc

Strong understanding of command line and server administration

Participate in the creation of development staging and production database instances and the migration from one environment to another

Hands on experience in regular maintenance on databases eg Vacuum Reindexing Archiving

Handson knowledge in proactive remediation of database operational problems

Ability to proactively identify troubleshoot and resolve live database systems issues

MongoDB Skills

Extensive experience with MongoDB installation configuration and management

Proficiency in MongoDB query language and performance optimization

Experience with backup restore and disaster recovery procedures

Ability to monitor database performance and troubleshoot issues

Familiarity with NoSQL database principles and architecture

Knowledge of data modelling and schema design for MongoDB

Experience with replica sets sharding and scaling MongoDB clusters

Proficiency in scripting languages such as Python Bash or similar

Understanding of cloudbased MongoDB services eg MongoDB Atlas

Desirable Secondary Skills

Experience with other NoSQL databases like Cassandra Couchbase etc

Familiarity with database migration tools and ETL processes

Understanding of DevOps practices and tools eg Docker Kubernetes

Knowledge of SQL databases such as MySQL Oracle SQL etc

Experience with data warehousing and big data technologies

Experience with EDB Postgres PgEdge PgVector etc

Soft Skills

Strong analytical and problemsolving skills

Excellent communication and collaboration abilities

Attention to detail and a proactive approach

Ability to work independently and in a team environment

Effective time management and organizational skills

Adaptability and willingness to learn new technologies