Search by job, company or skills

P

Postgres Database developer

People Prime Worldwide
Shimla
5-6 Years
new job description bg glownew job description bg glownew job description bg svg
  • Posted 3 hours ago
  • Be among the first 10 applicants
Early Applicant
Quick Apply

Job Description

  • 5+ years of hands-on experience with PostgreSQL in a production environment.
  • Strong SQL skills, including query optimization and performance tuning.
  • Experience with PostgreSQL internals and explain plans.
  • Proficiency in writing PL/pgSQL functions, procedures, and triggers.
  • Exposure to data migration, including use of COPY, FDW, and data loaders.
  • Understanding of indexes, constraints, and transaction isolation levels.
  • Knowledge of other databases (Oracle, MySQL) and migration strategies.

Key Responsibilities

  • Design and develop complex SQL queries, stored procedures, triggers, and functions in PostgreSQL.
  • Perform performance tuning and optimization of PostgreSQL queries and indexing strategies.
  • Work closely with application developers, data engineers, and architects to implement efficient data structures and access paths.
  • Migrate data from legacy systems or other RDBMS (e.g., Oracle, DB2) into PostgreSQL.
  • Write ETL scripts and batch jobs for data processing and transformation.
  • Assist in schema design, table partitioning, and materialized view creation.
  • Proactively address slow queries and long-running processes

More Info

Job Type:
Permanent Job
Industry:
Consulting, Information Services
Role:
Software Developer
Function:
IT/Software Development - Application Programming/Maintenance
Employment Type:
Full time
Open to candidates from:
Indian

About Company

People Prime Worldwide

At People Prime Worldwide, we deliver innovative IT solutions that drive business success. Our comprehensive suite of services include IT Consulting & Implementation, Staff Augmentation (T&M), and Managed Teams & Managed Services and is designed to help organisations optimise their workforce, streamline operations, and enhance technological capabilities. With a focus on agility, efficiency, and cost-effectiveness, we provide expert consulting, skilled talent, and end-to-end IT management to ensure seamless project execution. Whether you need cutting-edge IT solutions, flexible workforce expansion, or fully managed IT services, we are your trusted partner in navigating the digital landscape. IT Consulting and Implementation Services - Transforming Businesses with Scalable IT Solutions: We provide expert IT Consulting and Implementation Services, enabling businesses to optimize their technology infrastructure and streamline operations. Our specialized services cover SAP, Salesforce, ServiceNow, and Cloud Migration, helping enterprises modernize their digital ecosystem. Staff Augmentation (T&M) - IT Resources As A Service: We offer Time & Materials (T&M) Staff Augmentation, ensuring businesses can access the right talent at the right time. Whether it's short-term project support or long-term IT staffing, we provide skilled professionals to meet your requirements. Managed Teams and Managed Services - End-to-End IT Operations Without the Hassle: We provide Managed Teams and Managed Services, allowing businesses to focus on their core objectives while we handle IT operations efficiently.

Job ID: 137693333

Jobs by Skill - IT
Jobs by Skill - Non IT
International Jobs
Last Updated: 02-01-2026 05:32:48 AM
Homejobs in ShimlaPostgres Database developer