Remote Oracle-to-SQL Data Migration Specialist

Kamayi

Lahore

Remote

PKR 1,800,000 - 3,200,000

Full time

14 days+

Application generator

Stand out for this role — generate a tailored resume and cover letter in about a minute.

Get past ATS filters

Job summary

Kamayi is seeking an experienced SSIS/SQL Developer focused on data migration from Oracle to SQL Server. You will design, develop, and optimize ETL pipelines, review Oracle schemas, and re-engineer objects in T-SQL for seamless SQL Server compatibility.

The role requires 7+ years of hands-on experience with SSIS, SQL Server, and Oracle, plus strong data quality and migration tooling. Remote posting supports distributed teams across time zones, with a focus on robust data governance and

Qualifications

7+ years of hands-on experience building and managing SSIS packages, including control flow, data flow, event handlers, and error handling.
Strong proficiency in Microsoft SQL Server (2016/2019/2022), including T-SQL, query optimization, indexing, and database design.
Solid experience with Oracle (10g/11g/12c/19c), including PL/SQL, Oracle data types, sequences, and schema management.
Proven experience in executing Oracle-to-SQL Server migrations including schema conversion, data mapping, and validation.
Expertise in building scalable ETL pipelines for large datasets with strong data quality and transformation logic.

Responsibilities

Design, develop, and maintain robust SSIS packages for ETL workflows, data transformation, and automated data loads.
Analyze Oracle database schemas, stored procedures, functions, and packages and re-engineer them in T-SQL for SQL Server compatibility.
Develop complex T-SQL queries, stored procedures, views, triggers, and functions to support business logic and reporting requirements.
Perform data profiling, cleansing, validation, and reconciliation to ensure accuracy and completeness during migration.
Collaborate with business analysts, DBAs, and project managers to gather requirements and translate them into technical solutions.
Conduct unit testing, integration testing, and performance tuning of ETL pipelines and SQL scripts.
Document migration strategies, data mapping specifications, ETL workflows, and technical runbooks.
Monitor and troubleshoot ETL job failures, data discrepancies, and performance bottlenecks in production and staging environments.
Optimize SQL queries and SSIS packages for performance using indexing strategies, query plans, and execution profiling.
Ensure compliance with data governance, security policies, and regulatory requirements throughout the migration process.
Provide post-migration support, including issue resolution and performance monitoring.