Location: Toronto, Ontario, Canada
Category: Information Technology
Salary: 75,000 - 95,000 CAD / yearly
Full-time
Tata Consultancy Services (TCS) is seeking a Database Developer/DBA to assist in the migration of DB2 databases to PostgreSQL in a GCP Environment.
- Conduct thorough assessment of existing DB2 databases and develop migration plan.
- Convert DB2 schemas, tables, views to PostgreSQL equivalents in GCP Environment.
- Implement data migration strategies ensuring data integrity and minimal downtime.
- Optimize PostgreSQL databases post-migration for performance and scalability.
- Create and maintain ETL scripts for data extraction, transformation, and loading.
- Develop and execute testing plans to ensure data accuracy and completeness.
- Perform performance testing and troubleshooting to resolve issues.
- Bachelor's degree in Computer Science or related field.
- Proven experience in database migration from DB2 to PostgreSQL.
- Strong knowledge of ETL processes and data migration strategies.
- Experience with performance testing and optimization of databases.
- Excellent communication and collaboration skills.
- Competitive salary and benefits package.
- Opportunities for career advancement and professional development.
- Dynamic and inclusive work environment.
- Be part of a global organization committed to diversity and inclusivity.
- Work on challenging projects with cutting-edge technologies.
- Opportunity to grow and expand your skills in a supportive environment.