PostgreSQL Database Developer

5 years

0 Lacs

Posted:5 days ago| Platform: Linkedin logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

Job Title: PostgreSQL Database Developer

Location:

Experience:

Employment Type:

Notice Period:


About the Company:

Our client is a trusted global innovator of IT and business services, present in 50+ countries. They specialize in digital & IT modernization, consulting, managed services, and industry-specific solutions. With a commitment to long-term success, they empower clients and society to move confidently into the digital future.



Must have skills:

  • PostgreSQL
  • Advanced SQL
  • Query Optimization
  • Performance Tuning
  • PL/pgSQL
  • PostgreSQL Internals
  • Explain Plans


Minimum Qualifications:

  • Bachelor’s degree in BE / B.Tech / MCA or a related technical field.
  • 5+ years of hands-on experience working with PostgreSQL in a production environment.
  • Strong experience in SQL query writing, optimization, and performance tuning.
  • Experience with PostgreSQL internals, execution plans, and troubleshooting performance issues.


Preferred Qualifications:

  • Expertise in writing PL/pgSQL functions, procedures, and triggers.
  • Experience with data migration techniques using COPY, FDW, and data loading tools.
  • Strong understanding of indexing strategies, constraints, and transaction isolation levels.
  • Experience working with other RDBMS such as Oracle or MySQL and migration strategies.
  • Knowledge of schema design, table partitioning, and materialized views.
  • Experience writing ETL scripts and batch jobs for data transformation and processing.


Responsibilities:

  • Design, develop, and maintain complex SQL queries, stored procedures, triggers, and functions in PostgreSQL.
  • Perform performance tuning and optimization of PostgreSQL queries and indexing strategies.
  • Collaborate with application developers, data engineers, DevOps teams, and architects to design efficient data models and access paths.
  • Migrate data from legacy systems or other databases (e.g., Oracle, DB2) to PostgreSQL.
  • Create and maintain ETL processes and batch jobs for large-scale data processing.
  • Assist in schema design, table partitioning strategies, and creation of materialized views.
  • Proactively monitor and resolve slow queries, long-running transactions, and performance bottlenecks.


Important Note (Please Read Before Applying

Do NOT apply if:

You have less than 5 years of PostgreSQL experience

You do not have hands-on experience with PostgreSQL performance tuning

You are from a purely support or non-database background

You are not comfortable working from Shimla, Himachal Pradesh

Apply ONLY if you meet ALL criteria above.

Irrelevant or random applications will not be processed.

Mock Interview

Practice Video Interview with JobPe AI

Start DevOps 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

Salt Lake, Kolkata, West Bengal