PostgreSQL Database Developer

0 years

0 Lacs

Posted:3 days ago| Platform: Linkedin logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

We are looking for a highly skilled PostgreSQL Database Developer with deep expertise in designing, developing, and optimizing PostgreSQL databases. The ideal candidate will have hands-on experience with PL/pgSQL, performance tuning, and ensuring the reliability, scalability, and security of large-scale database systems.


Key Responsibilities

  • Design, develop, and maintain PostgreSQL databases, schemas, tables, indexes, and partitions.
  • Develop efficient stored procedures, functions, triggers, and views using PL/pgSQL.
  • Optimize complex queries and ensure overall database performance and scalability.
  • Implement and maintain database health practices including MVCC, VACUUM, ANALYZE, and advanced indexing strategies.
  • Support and optimize ETL pipelines and data integration processes across systems.
  • Develop and execute robust backup, restore, replication, and disaster recovery plans.
  • Monitor database health, troubleshoot issues, and proactively resolve performance bottlenecks.
  • Collaborate closely with application developers, data architects, and BI teams to meet business and technical requirements.
  • Enforce best practices around data security, access control, and data governance.

Required Skills & Qualifications

  • Strong hands-on experience with PostgreSQL 11+ in both development and administration roles.
  • In-depth knowledge of PL/pgSQL, triggers, constraints, indexes, and partitioning.
  • Strong understanding of MVCC, vacuuming, replication, and transaction management.
  • Expertise in query optimization, indexing strategies, and interpreting execution plans.
  • Experience with PostgreSQL backup and recovery using pg_dump, pg-restore, and Point-in-Time Recovery (PITR).
  • Exposure to cloud-hosted PostgreSQL services such as:
  • AWS RDS
  • Azure Database for PostgreSQL
  • Google Cloud SQL

Familiarity with ETL tools and frameworks (e.g., Pentaho, Talend, or Python-based solutions).

Mock Interview

Practice Video Interview with JobPe AI

Start Python 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 Python Skills

Practice Python coding challenges to boost your skills

Start Practicing Python Now
Smart Source logo
Smart Source

Information Technology

Tech City

RecommendedJobs for You

Salt Lake, Kolkata, West Bengal

Mumbai, Bhopal, Bengaluru, Bangalore/Mumbai/Bhopal