Database developer (PostgreSQL)

8 years

0 Lacs

Posted:2 days ago| Platform: Linkedin logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

Position:

Experience:

Location:

Environment:

About the Role

PostgreSQL DBA cum Developer

Key Responsibilities

  • Administer and manage PostgreSQL databases on

    Linux/openSUSE

    environments.
  • Design and optimize complex SQL queries, stored procedures, functions, and triggers.
  • Perform

    database performance tuning, indexing, query optimization, and partitioning

    .
  • Manage and optimize very large datasets (1–2 TB).
  • Work extensively with

    TimescaleDB

    for time-series data.
  • Monitor, troubleshoot, and resolve database performance issues.
  • Implement

    backup, recovery, replication, and high availability

    strategies.
  • Collaborate with application developers to optimize schema and queries.
  • Ensure

    database integrity, security, and compliance

    .
  • Automate repetitive DBA tasks using scripts and tools.

Required Skills & Qualifications

  • 8+ years of experience in

    PostgreSQL database administration and development

    .
  • Strong knowledge of

    performance optimization

    for large-scale datasets (1–2 TB).
  • Expertise in

    TimescaleDB

    and PostgreSQL toolkits.
  • Solid understanding of

    normalization, indexing, and query execution plans

    .
  • Experience in

    Linux/openSUSE environments

    .
  • Proven ability to handle

    large data volumes (300 GB+ to multi-TB)

    .
  • Strong troubleshooting and analytical skills.
  • Excellent communication and problem-solving skills.

Good to Have

  • Experience with

    replication, sharding, and partitioning

    for high availability.
  • Exposure to

    NoSQL systems (MongoDB, Redis)

    alongside PostgreSQL.
  • Familiarity with

    cloud-hosted PostgreSQL (AWS RDS, Azure, GCP)

    .

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

RecommendedJobs for You