Database Developer

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 .