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.
- Strong 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.
- Strong knowledge of query optimization and PostgreSQL performance tuning.
- Experience migrating a

📌 Data Engineer (Hyderabad)
🏢 Lagran Software Solutions
📍 Hyderabad