Greetings from Maneva!

Job Description

Job Title - PostgreSQL Administrator

Location - Mumbai

Experience - 8 - 10 years

Notice - Immediate Joiner

Requirements:-
Install, configure, and maintain PostgreSQL databases across production and nonproduction settings
Perform database upgrades, patching, and version migrations with minimal downtime
Manage replication (Streaming Replication, Logical Replication), failover, and DR setups
Monitor performance, tune queries, and optimize database parameters
Handle backup, restore, PITR, and retention policies
Support incidents, RCA, and problem management activities

Automation using Ansible Ansible
Design, develop, and maintain Ansible playbooks and roles for PostgreSQL automation
Automate:
Database installation and configuration
User/role creation and privilege management
Patching and upgrades
Backup and restore validation
Replication setup and health checks
Postdeployment validation and compliance checks




Maintain inventory management for multiple environments (Prod, UAT, NonProd)
Integrate Ansible automation with CI/CD pipelines and DevOps workflows
Ensure idempotent, reusable, and secure playbooks following best practices

Security and Compliance
Implement database security controls as per SCD / audit requirements
Automate password rotation, access reviews, and role compliance
Integrate with PAM tools (e.g., ARCON, CyberArk if applicable)
Ensure encryption, logging, and audit trails are enabled and validated
Work with cloud platforms (AWS RDS, EC2, Aurora, or similar)
Support containerized or hybrid PostgreSQL deployments (if applicable)

Documentation & Reporting
Maintain SOPs, KTs, automation documentation, and runbooks
Provide regular status reports, automation coverage reports, and audit evidence
Participate in knowledge sharing and mentoring sessions

📌 Postgresql Administrator Mumbai (India)
🏢 Maneva Consulting
📍 India