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.
- Strong experience with functions, stored procedures, triggers, views, indexes, sequences, constraints, and partitions.
- Strong knowledge of query optimization and PostgreSQL performance tuning.
- Experience migrating and validating large-volume datasets.
- Solid understanding of PostgreSQL backup, restore, replication, and database administration concepts.
- Experience with migration/ETL tools.
- Scripting experience using Python/Shell is preferred.
- Strong troubleshooting and problem-solving skills.

Preferred Migration Experience

Experience in one or more of the following is highly preferred:

Oracle → PostgreSQL | SQL Server → PostgreSQL | MySQL → PostgreSQL | PostgreSQL → PostgreSQL

Screening Criteria

PostgreSQL Experience: 6+ Years – Mandatory
Overall Experience: 7+ Years
Database Migration Experience: Mandatory
SQL / PL/pgSQL: Mandatory
Performance Tuning: Mandatory
Immediate / Short Notice Joiners: Preferred

Pay: From ₹1,000,000.00 per year

Benefits:

- Provident Fund

Work Location: In person

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