Job description
Company culture :
CGI Technologies and Solutions Morocco is characterized by a predominantly collaborative culture, placing people, trust and teamwork at the core of its operations. A close management approach fosters guidance, empowerment and skills development within a supportive environment. This dynamic is reinforced by a structured organizational culture, ensuring process rigor, reliability and operational efficiency. It is complemented by an innovation dimension that encourages adaptability and initiative, while a more moderate competitive component supports a balanced results-driven mindset.
Job :
As part of our growth, we are recruiting an Oracle Forms/Report technical expert.
Duties and Responsibilities:
Design, develop Forms/Report pages, and maintain stored procedures, functions, and PL/SQL packages.
Optimize SQL queries to ensure high performance.
Design and evolve relational data models.
Manage batch processes (loads, extractions, data migrations).
Diagnose and fix performance issues (execution plans, indexing, hints, etc.).
Contribute to the technical documentation of applications.
Participate in testing phases: unit, integration, performance.
Collaborate with application, business, and infrastructure teams.
Adhere to good development practices, coding standards, and quality standards.
Required profile :
Qualities required to succeed in this role:
Oracle Forms/Report (senior, 8 years exp)
Oracle PL/SQL (expert level)
Advanced SQL (subqueries, CTE, windowing, complex aggregations)
Oracle Database (11g, 12c, 19c...)
SQL optimization & performance tuning
Execution plan analysis (EXPLAIN PLAN, AUTOTRACE)
CGI is an inclusive employer and pays attention to applications from people with disabilities and to the career development of men and women.