Skip to content

Open nowPosted 12 days ago

SQL/SSIS and Oracle Developer

Workable (global search)109,826 open roles

Where
Argentina
Work mode
Remote
Get the CV for this job

From $25 per CV, paid once. No subscription.

Your applicationOpen nowSQL/SSIS and Oracle DeveloperWorkable (global search) · Argentina
  1. YouYes, apply to this one.

  2. CV RocketCV written for this posting.

  3. 25 readersRecruiter, hiring manager, skeptic. Round after round.

  4. CV RocketApplied on Workable (global search)'s own form.

The reply lands in your private mailbox

3×more interviews than doing it yourself with ChatGPT.

The clock on this job

Early applications get read.

7.9% of postings close within 7 days. Measured by our own scanner across the market. Workable (global search) postings stay open a median of 2 days.

Share of postings closed within
  1. 1.6%1 day
  2. 3.6%3 days
  3. 7.9%7 days
  4. 14.9%14 days
  5. 34.0%30 days
This job: posted 12 days ago

Workable (global search) median: 2 days open

The posting

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 ODI (Oracle Data Integrator).
  • 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.
From $25, paid onceGet the CV for this job

What happens when you press

One press. We do the rest.

  1. A CV for this posting

    Written against Workable (global search)'s own wording, from every piece of relevant proof in your profile.

  2. 25 readers review it

    Recruiter, hiring manager, skeptic and more read every draft, round after round. You get the best round.

    The review screen in CV Rocket: how each CV was read, round by round.
  3. We apply on Workable (global search)'s form

    Our application engine gets through the hardest forms there are. Where a question needs you, AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

    An application in CV Rocket: every answer filled in on the employer's form.
  4. Every reply, sorted

    Workable (global search)'s answer lands in your private mailbox, and we classify it on arrival: interview, question, rejection.

    The CV Rocket inbox: each employer reply classified as an interview, an action or a rejection.
  5. Reply with AI

    AI helps you write the email, checks it and sends it. We show you whether the recruiter read it.

  6. The interview in your calendar

    Full integration with your calendar. The invitation goes straight in.

    An interview invitation in the CV Rocket inbox, added to the candidate's calendar.
Get the CV for this job

From $25 per CV, paid once. No subscription.

Why it works

3×

more interviews than doing it yourself with ChatGPT.

ChatGPT writes a CV and never learns what happened to it. We see every reply. For each CV we know:

  • How it was written, and how the review scored it
  • When we applied, and how long after the posting went up
  • Which posting, which company, which city
  • Who got the interview, and who heard nothing

That is how we know which CVs get called.

Get the CV for this job

From $25 per CV, paid once. No subscription.

The numbers game

More applications. More interviews.

Every application goes out with its own CV, written for that posting and paid once. Send enough of them and the law of large numbers finds you the job.

By hand5–10
With CV Rocket100
applications a day

Nearby

Live postings like this one

Same employer first, then the same role elsewhere.

Before you press

Straight answers

Get the CV for this job

From $25 per CV, paid once. No subscription.

What if my background isn't good enough?

We make the most of the background you have. The CV uses every piece of relevant proof your profile holds, and one of the 25 readers reads your whole profile and flags what the CV left out.

Do you really apply for me?

Yes, on the employer's own form, the hardest ones included. Where a question needs you, you answer it right there and AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

Is it a subscription?

No. You pay once per CV, from $25. Every application goes out with its own CV, written for that posting.

One job. One CV.
Paid once.

Pick the posting you want. We write for it, apply for you and catch the reply.

Get the CV for this job

From $25 per CV, paid once. No subscription.