Postgresql Database Administrator

Aforeserve; Mumbai; On-site; INR 900,000 - 1,200,000; Full time

Job summary

Aforeserve is seeking a skilled database professional to design, implement, and maintain robust PostgreSQL databases in Mumbai. You will drive performance tuning, ensure data integrity and security, and collaborate with development and operations teams to automate tasks and streamline processes.

Responsibilities include backups, DR planning, upgrades, and documentation to support reliable data services across applications in a fast-paced environment.

Qualifications

• Experience with database technologies, designing data architecture, and enforcing database rules.
• Experience maintaining PostgreSQL databases.
• Knowledge of data integrity, security, and disaster recovery.
• Ability to automate database tasks and scripts.
• Experience collaborating with development and operations teams.

Responsibilities

• Design and implement database systems.
• Monitor and optimize database performance.
• Develop and implement backup and recovery processes.
• Plan and execute disaster recovery strategies.
• Automate database tasks and processes.
• Maintain database documentation and standards.
• Implement database upgrades and patches.
• Monitor database health and performance metrics.
• Ensure compliance with data protection regulations.
• Provide support for database-related issues.

Skills

Database design

Performance tuning

Data security

Automation

SQL scripting

Tools

PostgreSQL

psql

pgBackRest

Job description

Experience with database technologies, designing data architecture, and monitoring and enforcing database rules

Manage and maintain PostgreSQL databases.

Ensure database performance, integrity, and security.

Design and implement database systems.

Monitor and optimize database performance.

Ensure data integrity and security.

Develop and implement backup and recovery processes.

Plan and execute disaster recovery strategies.

Collaborate with development and operations teams.

Automate database tasks and processes.

Perform database tuning and optimization.

Troubleshoot database issues and provide solutions.

Maintain database documentation and standards.

Implement database upgrades and patches.

Monitor database health and performance metrics.

Ensure compliance with data protection regulations.

Provide support for database-related issues.

Develop and maintain database scripts and tools.

Conduct database capacity planning.

Stay updated with the latest database technologies and trends.