Job Title: PostgreSQL Database Developer
Location: Shimla(6days WFO)
Experience: 5–6 Years (STRICTLY)
Employment Type: Permanent
Notice Period: Immediate Joiners Only
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
- 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.
Mandatory Skills
- 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/PostgreSQL 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.
Important Note (Please Read Before Applying)
🚫 Do NOT apply if:
- You have less than 5 years or more than 6 years of experience
- You do not have hands-on PostgreSQL Database Developer
- You are on a notice period longer than 15 days
- You are looking for remote only (role is 6days work from office in Shimla)
- You are a fresher or unrelated background (e.g., support, testing only, non-database developer roles)
✅ Apply ONLY if you meet ALL criteria above.
Random / irrelevant applications will not be processed.