PostgreSQL Database Developer

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.