Database Developer

Job Title:

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.

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

NOT apply

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

ONLY if