IT Infrastructure Management - Database DeveloperWe are looking for an experienced Migration DBA/DB Engineer to migrate our legacy, large database from DB2 platform to PostgreSQL platform. The candidate would be responsible for assessing the current DB2 environment, designing and implementing the migrating strategy and ensure a smooth transition to PostgreSQL environment with minimal downtime.ResponsibilitiesVery strong hands-on experience with heterogeneous database migration from DB2 to PostgreSQLDatabase Design and determine a best approach for Database migration, including data conversion, schema changes and any application modifications with stored procedures, functions etc.Analyze current query patterns and create an efficient indexing strategy for performance optimization on PostgreSQL.Develop and execute Migration planMigrate Database, schemas, data and permissions.Test and validate the migrated database for data consistency, data integrity, schema consistency and application functionality.Troubleshoot, resolve, and document migration issuesCollaboration with Application teams.Requirements10+ years of Strong experience with DB2 and PostgreSQL5+ years of Database Migration experience, both homogenous and heterogenous.Experience w/ Data Migration tools like pg_dump or pg_restore or pg_admin10+ years of DBA experience on Linux based platforms.Expert skills on DB backup/restore, database monitoring, security, access for both DB2 and PostgreSQL.Excellent problem-solving and troubleshooting skills.QualificationsA bachelor's degree10+ years of Experience in database administration of PostgreSQL and DB2