We are seeking a detail-oriented SQL specialist for a short-term project at 360 IT Professionals. Your task will be to assist in migrating data between two legacy database systems. This involves writing complex SQL queries, creating transformation scripts, and verifying data integrity post-migration. This is a fast-paced project ideal for someone with strong SQL skills and an eye for detail.

This is a focused, high-impact hourly project focused on a critical data migration initiative. The project's success hinges on the accurate and efficient transfer of data from an older SQL Server database to a newer PostgreSQL instance. You will be the primary technical resource responsible for the execution of this migration.

Project Scope

• Analyze the source and target database schemas to identify data mapping requirements and potential inconsistencies.
• Develop, test, and execute SQL scripts for data extraction, transformation, and loading (ETL).
• Write complex queries, joins, and stored procedures to handle intricate data relationships.
• Implement data validation checks to ensure integrity and accuracy throughout the migration process.
• Work closely with a project manager to report progress, identify risks, and resolve any issues that arise.
• Document the migration process, including all scripts and mapping logic.

This role is perfect for a database professional who enjoys hands-on, technical challenges. You must be comfortable working independently and capable of managing your tasks to meet tight deadlines. Strong problem-solving skills and a meticulous approach to data handling are essential for success in this role.

• 2+ years of hands-on experience with SQL, including writing complex queries and scripts.
• Proven experience with at least one major RDBMS (e.g., SQL Server, PostgreSQL, MySQL).
• Experience with data migration projects is highly desirable.
• Strong analytical and problem-solving abilities.
• Ability to work independently and manage time effectively.

• Sharpen your data migration and ETL skills.
• Fully remote, short-term engagement.
• Opportunity to work with both SQL Server and PostgreSQL.