PostgreSQL Database Administrator (L2)

algoleap; Mumbai City; On-site; INR 800,000 - 1,200,000; Full time

Job summary

A leading company in software development is seeking a PostgreSQL Database Administrator (L2) to manage and support PostgreSQL databases. The ideal candidate will have extensive experience in database troubleshooting, cluster setup, and migration. This role requires a full-time commitment with 24x7 onsite support in Mumbai. Join a dynamic team focused on optimizing database performance and ensuring security.

Qualifications

• 4-6 years relevant experience required.
• Relevant certifications preferred.

Responsibilities

• Manage and maintain PostgreSQL databases.
• Ensure performance, integrity, and security.
• Design and implement database systems.

Skills

Database troubleshooting

DB cluster setup

Foreign data wrappers

Database migration

Replication

Maintenance jobs

User management

Performance tuning

Education

B.E./Diploma/BSc/BTech

B.Sc. - IT

BCA or MCA

Job description

Join to apply for the PostgreSQL Database Administrator (L2) role at algoleap

Location

Mumbai, Fort

Domain

PostgreSQL Database

Level

L2

Experience

4-6 Years relevant experience

Job Type

Onsite

Shift

24 X 7 onsite support

Qualifications

• B.E./Diploma/BSc/BTech (No education gap, Full time)
• Specializations in Computer Science, IT, Electronics & Telecommunication; Civil and Mechanical not preferred
• B.Sc. - IT
• BCA or MCA (Full time from reputed university)
• No educational gaps; passing years to be specified

Certifications

Relevant certifications preferred

Key Requirements

Experience in PostgreSQL database troubleshooting, cluster setup, and working with database migration is mandatory.

Role Purpose

Seeking an experienced PostgreSQL Database Administrator with skills in managing, supporting, and setting up PostgreSQL databases, including PCS cluster setup, migration, provisioning, replication, hardening, and patching.

Responsibilities

• Manage and maintain PostgreSQL databases
• Ensure performance, integrity, and security
• Design and implement database systems
• Monitor and optimize performance
• Develop backup and recovery strategies
• Collaborate with development and operations teams
• Automate tasks and perform tuning
• Troubleshoot issues and maintain documentation
• Implement upgrades, patches, and migration
• Monitor health and ensure compliance
• Support database-related issues and develop scripts
• Capacity planning and staying updated with trends

Technical Skills

• Database troubleshooting, hardening, patching (Must)
• DB cluster setup (Must)
• Foreign data wrappers (Must)
• Database migration (Must)
• Replication (Good to have)
• Maintenance jobs (Must)
• User management (Must)
• Performance tuning (Must)

Additional Details

• Seniority level: Mid-Senior level
• Employment type: Full-time
• Job function: Information Technology
• Industry: Software Development