PostgreSQL Database Developer

Job Title: PostgreSQL Database Developer

Location: Shimla, Himachal Pradesh

Experience: 5+ Years (STRICTLY)

Employment Type: Permanent

Notice Period: Immediate Joiners Preferred

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.

Job Description

Must have skills:

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

Minimum Qualifications:

• Bachelors 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 )