Postgresql Database Administrator

4 - 5 years

3 - 6 Lacs

Posted:5 hours ago| Platform: Naukri logo

Apply

Work Mode

Work from Office

Job Type

Full Time

Job Description

Job Summary:

PostgreSQL Database Administrator (DBA)

Key Responsibilities:

  • Install, configure, upgrade, and maintain PostgreSQL database servers.
  • Monitor database performance, implement changes, and apply new patches and versions when required.
  • Ensure high availability, backup, and disaster recovery strategies are in place and tested.
  • Perform regular database maintenance tasks including re-indexing, vacuuming, and tuning.
  • Manage database access, roles, and permissions securely.
  • Write and maintain scripts for automation of routine database tasks.
  • Work closely with developers to optimize queries and schema design.
  • Troubleshoot and resolve database-related issues promptly.
  • Implement and monitor replication strategies (logical and physical replication).
  • Perform regular security assessments and apply best practices to secure data.
  • Participate in on-call rotation and provide production support as needed.

Required Skills:

  • Minimum 4 years of hands-on experience with PostgreSQL administration.
  • Strong experience in performance tuning and query optimization.
  • Experience with database backup, restore, and disaster recovery planning.
  • Good understanding of PostgreSQL internals.
  • Familiarity with tools like

    pgAdmin

    ,

    pgBouncer

    ,

    pgBackRest

    , or

    Patroni

    .
  • Knowledge of Linux/Unix systems for managing PostgreSQL on those platforms.
  • Experience with shell scripting and automation tools.
  • Basic understanding of cloud platforms like AWS/GCP/Azure (RDS, Aurora, etc.) is a plus.
  • Knowledge of monitoring tools like

    Prometheus

    ,

    Grafana

    , or similar.

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
VMAX India logo
VMAX India

Software Development

Hyderabad Telangana

RecommendedJobs for You