Oracle to SQL Migration Specialist

Job description

SSIS / SQL Developer – Data Migration

Position Details

Job Title: SSIS / SQL Developer – Data Migration

Reports To: Director – Geo Practice Lead

Experience Required: 7+ Years

Location: Remote

Job Summary

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.

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 and 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, including star schema, snowflake schema, and 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.