Description
Summary 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. 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.