PostgreSQL Developer L2

4 - 5 years

6 - 7 Lacs

Posted:5 days ago| Platform: Naukri logo

Apply

Work Mode

Work from Office

Job Type

Full Time

Job Description

PostgreSQL Developer L2
  • Home
  • Database
  • PostgreSQL Developer L2

Job Title: PostgreSQL Developer L2
Experience: 4 to 5 Years
Job Type: Full-time
Job Summary:
We are seeking a skilled and experienced PostgreSQL Developer (Level 2) with 4 5 years of hands-on experience in database development and optimization. The ideal candidate will be responsible for developing, maintaining, and improving PostgreSQL-based database solutions, supporting high-performance applications, and assisting with architecture and automation initiatives.
Key Responsibilities:
Design, develop, and optimize complex SQL queries, stored procedures, triggers, and PL/pgSQL functions.
Collaborate with architects and application developers to define efficient schema designs and data models.
Perform advanced performance tuning using EXPLAIN, ANALYZE, pg_stat_statements, and indexing strategies.
Implement and maintain ETL processes for structured and semi-structured data.
Manage large-scale data migrations and version-controlled schema deployments.
Conduct capacity planning and monitoring to maintain database health and scalability.
Implement and manage backup/restore policies, disaster recovery testing, and high availability configurations.
Work with DevOps teams to integrate database changes into CI/CD pipelines.

Mentor junior developers and participate in peer code reviews.

Technical Skills Required:
Strong expertise in PostgreSQL SQL and PL/pgSQL programming.
In-depth understanding of PostgreSQL internals: query planner, indexing, vacuum/analyze, and WAL.
Experience with partitioning, parallel queries, table inheritance, and advanced types (JSONB, ARRAY).
Proficient with performance tuning, database normalization/denormalization, and query optimization.
Experience with replication mechanisms: streaming replication, logical replication, or BDR.
Good knowledge of PostgreSQL backup and recovery strategies using pg_basebackup, pgBackRest, or Barman.

Experience with monitoring tools like pg_stat_activity, pgBadger, Prometheus + Grafana, or Zabbix.

Preferred/Additional Skills:
Scripting experience (Bash, Python, or Shell) for automation tasks.
Familiarity with cloud-native PostgreSQL (AWS RDS, Aurora, GCP Cloud SQL, Azure PostgreSQL).
Exposure to Kubernetes-managed database environments.
Experience working in Agile environments and participating in Scrum ceremonies.
Soft Skills:
Excellent problem-solving and root cause analysis capabilities.
Strong written and verbal communication.
Ability to work independently and as part of a cross-functional team.
Mentorship and collaboration with junior team members.

Customer-focused and able to manage multiple priorities in a fast-paced environment.

Education:
Bachelor s degree in Computer Science, Information Technology, or related discipline.
PostgreSQL certifications (optional but a plus).

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

RecommendedJobs for You

pune, chennai, bengaluru