Oracle to SQL Migration Specialist

Kamayi · Lahore, Lahore District; Punjab, Pakistan

JOB DESCRIPTION SQL/SSIS and Oracle Developer | Oracle to SQL Migration Specialist

POSITION OVERVIEW

We are seeking a highly skilled SSIS / SQL Developer with proven expertise in data migration, particularly in migrating large-scale enterprise data from Oracle to Microsoft SQL Server. The ideal candidate will be responsible for designing, developing, and optimizing ETL pipelines using SQL Server Integration Services (SSIS), writing complex T‑SQL queries, and ensuring data integrity throughout the migration lifecycle.

POSITION DETAILS

Job Title

SSIS / SQL Developer – Data Migration Reports To

Director – Geo Practice Lead Experience Required

7+ Years Location

Remote Posting Date

KEY 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.

REQUIRED QUALIFICATIONS & SKILLS

Core Technical Skills

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 working 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.

Tools & Technologies

SQL Server Management Studio (SSMS) and Visual Studio (SSDT)

Oracle SQL Developer or TOAD

Microsoft SQL Server Migration Assistant (SSMA) for Oracle

SSIS Catalog, SQL Server Agent for job scheduling

Git / Azure DevOps / TFS for version control (preferred)

SSRS / Power BI for reporting integration (advantageous)

Soft Skills & Competencies

Strong analytical and problem‑solving skills with attention to detail.

Excellent written and verbal communication skills for technical documentation and cross‑functional collaboration.

Ability to manage multiple tasks and priorities in a fast‑paced project environment.

Self‑motivated with the ability to work independently and as part of a team.

PREFERRED / NICE-TO-HAVE QUALIFICATIONS

Microsoft Certified: Azure Data Engineer Associate or equivalent SQL Server certification.

Experience with Azure Data Factory (ADF) or other cloud‑based ETL platforms.

Familiarity with data warehousing concepts (star schema, snowflake schema, slowly changing dimensions).

Exposure to Azure cloud environments.

Experience with Agile/Scrum methodologies.

Knowledge of data lineage and metadata management tools.

EDUCATIONAL REQUIREMENTS

Bachelor's degree in Computer Science, Information Technology, Software Engineering, or a related field.

Equivalent professional experience and certifications will be considered in lieu of a formal degree.