PostgreSQL Database Developer

Smart Source

0 years

0 Lacs

patna bihar india

Posted:3 days ago| Platform:

Apply

Skills Required

postgresql database developer tuning reliability scalability security design indexes analyze indexing strategies support etl data integration backup restore replication resolve governance development constraints management query optimization aws azure sql pentaho talend python

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).

More Jobs at Smart Source

BPO Hiring For Voice Process Australian Shifts Salary 4.00 LPA Gurgaon

Gurgaon/Gurugram

1 - 6 yrs

INR 1 - 4 Lacs

BPO Hiring For Voice Process Australian Shifts Salary 4.00 LPA Gurgaon

Gurgaon/Gurugram

1 - 6 yrs

INR 1 - 4 Lacs

BPO Hiring For Customer Service Voice And Chat Process - GGN 5.80 LPA

Gurugram

2 - 6 yrs

INR 4 - 6 Lacs

Airline Help Desk Staff

Mumbai, Mumbai (All Areas)

3 - 6 yrs

INR 3 - 4 Lacs

BPO- Hiring For Domestic Tech. Voice Process - 4.00 LPA- GGN

Gurgaon/Gurugram

Experience: Not specified

INR 1 - 4 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview

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.