出海雷达

SQL/SSIS 和 Oracle 开发工程师

SQL/SSIS and Oracle Developer

开发工程限定地区（需当地身份）与中国几乎无重叠，需长期倒时差
公司OZ
薪资未公开
工作地点Argentina
地域资格限定地区（需当地身份）
时区要求与中国几乎无重叠，需长期倒时差
用工类型Full Time
发布时间21 天前
数据来源Himalayas
前往 Himalayas 查看并投递 →
注意地域限制：该职位明确限定在 Argentina 招聘。如果你是位于中国大陆的求职者，通常需要当地工作身份才能投递，或需与雇主确认是否接受独立合同（Contractor）形式合作。
作息提示：与中国几乎无重叠，需长期倒时差。

我们正在寻找一位经验丰富的SSIS/SQL开发人员，具备在将大型企业数据从Oracle迁移到Microsoft SQL Server方面的实际经验。理想的候选人将负责使用SQL Server Integration Services（SSIS）设计、开发和优化ETL流程，编写复杂的T-SQL查询，并在整个迁移生命周期中确保数据完整性。

关键职责

  • 设计、开发和维护用于ETL工作流、数据转换和自动化数据加载的稳健SSIS包。
  • 分析Oracle数据库模式、存储过程、函数和包，并将其重新工程为适用于SQL Server兼容性的T-SQL。
  • 开发复杂的T-SQL查询、存储过程、视图、触发器和函数，以支持业务逻辑和报告需求。
  • 执行数据剖析、清洗、验证和对账，以确保迁移过程中的准确性和完整性。
  • 与业务分析师、DBA和项目经理合作，收集需求并将其转化为技术解决方案。
  • 对ETL流程和SQL脚本进行单元测试、集成测试和性能调优。
  • 编写迁移策略、数据映射规范、ETL流程和技术操作手册。
  • 监控和排查生产环境和测试环境中的ETL作业失败、数据差异和性能瓶颈。
  • 使用索引策略、查询计划和执行分析优化SQL查询和SSIS包性能。
  • 在整个迁移过程中确保符合数据治理、安全策略和法规要求。
  • 提供迁移后的支持，包括问题解决和性能监控。

要求
核心技能

  • 5年以上实际构建和管理SSIS包的经验，包括控制流、数据流、事件处理程序和错误处理。
  • 熟练掌握Microsoft SQL Server（2016/2019/2022），包括T-SQL、查询优化、索引和数据库设计。
  • 具备Oracle（10g/11g/12c/19c）的实际经验，包括PL/SQL、Oracle数据类型、序列和模式管理。
  • 有执行Oracle到SQL Server迁移的实际经验，包括模式转换、数据映射和验证。
  • 在构建可扩展的ETL流程方面有专长，能够处理大规模数据集并具备强大的数据质量和转换逻辑。

工具与技术

  • 熟练使用SQL
查看英文原文

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.

Requirements
Core Technical Skills

  • 5+ 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 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

  • Proficiency with SQL Server Management Studio (SSMS) and Visual Studio (SSDT).
  • Proficiency with Oracle SQL Developer or TOAD.
  • Experience with Microsoft SQL Server Migration Assistant (SSMA) for Oracle.
  • Experience with SSIS Catalog and SQL Server Agent for job scheduling.
  • Experience with Git, Azure DevOps, or TFS for version control is preferred.
  • Experience with SSRS or Power BI for reporting integration is advantageous.

PREFERRED / NICE-TO-HAVE QUALIFICATIONS

  • Microsoft Certified: Azure Data Engineer Associate or an 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.
  • Experience working with Azure cloud environments.
  • Experience with Agile or Scrum methodologies.
  • Experience with data lineage and metadata management tools.

EDUCATIONAL REQUIREMENTS
· Bachelor's degree in Computer Science, Information Technology, Software Engineering, or a related field is preferred.
Originally posted on Himalayas

本页面信息整理自 Himalayas，版权归原发布方所有。职位可能随时关闭，投递请以原始页面为准。 本站只做信息聚合展示，不参与招聘流程，也不向求职者收取任何费用。

← 返回全部职位