PostgreSQL Administrator

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 environments.
• 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

• 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.

If you are excited to grab this opportunity please apply directly or share your CV atand