Database Developer with DB2 to PostgreSQL Migration -- C2C -- Remote at Remote, Remote, USA |
Email: [email protected] |
From: sakthi, Vy [email protected] Reply to: [email protected] Your responsibilities in this role will include: Conduct a thorough assessment of existing DB2 databases. Develop a comprehensive migration plan, including timelines, resource requirements, and risk management strategies. Collaborate with stakeholders to understand business requirements and database usage patterns. Convert DB2 schemas, tables, views, stored procedures, and other database objects to PostgreSQL equivalents. Develop and implement data migration strategies to ensure data integrity and minimal downtime. Optimize and fine-tune PostgreSQL databases post-migration for performance and scalability. Create and maintain scripts for data extraction, transformation, and loading (ETL). Automate migration processes wherever possible to increase efficiency and reduce errors. Develop and execute comprehensive testing plans to ensure data accuracy and completeness. Perform performance testing and troubleshooting to identify and resolve any issues. Validate the successful migration of all database components and data. Document all migration processes, configurations, and settings. Provide training and support to database administrators and development teams on the new PostgreSQL environment. Provide post-migration support and troubleshooting to ensure a smooth transition. Implement monitoring and maintenance plans for the PostgreSQL databases. Rgds, Sakthi 408-520-9394 Keywords: Database Developer with DB2 to PostgreSQL Migration -- C2C -- Remote [email protected] |
[email protected] View all |
Thu Jun 06 21:16:00 UTC 2024 |