Job Description – Senior PostgreSQL Developer | Migration Project

Position: Senior PostgreSQL Developer / Database Migration Engineer
Overall Experience: 7+ Years
Mandatory PostgreSQL Experience: Minimum 6+ Years
Project Type: Database Migration
Employment Type: Contract / Project-Based
Company: Lagran Software Solutions Pvt. Ltd.

Job Summary

We are looking for a highly experienced PostgreSQL Developer for a database migration project.

Mandatory Requirement: Candidate must have a minimum of 6 years of hands-on PostgreSQL development experience. Candidates without 6+ years of relevant PostgreSQL experience will not be considered.

Key Responsibilities
Design and execute complex database migration activities to PostgreSQL.
Analyze existing database schemas, tables, functions, procedures, triggers, views, and dependencies.
Develop complex SQL and PL/pgSQL queries, functions, procedures, and migration scripts.
Perform schema and large-volume data migrations.
Handle data type conversions and database compatibility issues.




Perform pre-migration and post-migration data validation and reconciliation.
Optimize SQL queries, indexes, execution plans, and overall PostgreSQL performance.
Troubleshoot migration failures, data inconsistencies, and performance bottlenecks.
Develop automation scripts for migration and validation.
Support UAT, production migration, cutover, rollback, and post-production activities.
Coordinate with DBA, application, DevOps, QA, and infrastructure teams.

Mandatory Skills
Minimum 6+ years of hands-on PostgreSQL experience – MUST HAVE.
7+ years of overall database/development experience.
Solid hands-on expertise in PostgreSQL, SQL and PL/pgSQL.
Proven experience working on database migration projects.
Robust experience with functions, stored procedures, triggers, views, indexes, sequences, constraints, and partitions.
Robust knowledge of query optimization and PostgreSQL performance tuning.
Experience migrating a

📌 Data Engineer Hyderabad
🏢 Lagran Software Solutions
📍 Hyderabad