Job Description

Roles & Responsibilities

Context :

As part of a strategic data merger and migration program, our client, a major player in the Moroccan insurance sector, is looking for technical profiles specializing in PL/SQL and T-SQL to strengthen its teams.

• Duration: 6 months, renewable
• Location: Casablanca, Morocco
• Start date: ASAP

Missions :

• Development of procedures, functions, views and packages in PL/SQL (Oracle) and T-SQL (SQL Server)
• Optimizing query performance (analyzing execution plans, indexing, refactoring)
• Analysis and correction of anomalies in databases
• Participation in data migration projects (integration scripts, consistency scripts)
• Drafting of technical documentation and operating files
• Collaboration in an Agile environment

Comp tences techniques :

• PL/SQL (Oracle) : proc dures, fonctions, packages, triggers
• T-SQL (SQL Server) : requ tes complexes, optimisation
• ETL tools (such as Talend, SSIS, ODI) are appreciated
• Version control (Git, SVN) is a plus

Expected deliverables:

• Scripts PL/SQL et T-SQL document s
• Performance optimization reports
• Technical and operational documentation
• Anomaly tracking and corrections

Desired Candidate Profile

Minimum 3-5 years of experience in PL/SQL and T-SQL development

• Excellent knowledge of Oracle and SQL Server databases
• Experience in data migration (a strong asset)
• Experience in IT transformation or merger projects (appreciated)
• Ability to work in a team and in an Agile environment
• Autonomy, rigor and organizational skills