Quick Details:
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.
Need Immediate Joiner
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.
- Strong 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: ₹526,883.27 - ₹1,863,974.49 per year
Work Location: In person
