The ideal candidate is a self-motivated, multi-tasker, and demonstrated team-player. You will be a lead developer responsible for the development of new software products and enhancements to existing products. You should excel in working with large-scale applications and frameworks and have outstanding communication and leadership skills.

Job Title: Senior Software Engineer - PLSQL

Years of Experience: 6 to 10 Years

Location: Cairo, Egypt

Role Summary:

We are seeking a highly skilled and experienced Senior PL/SQL Developer with over 6 years of hands-on experience in Oracle database development. The ideal candidate must have strong expertise in building complex database objects and working on high-performance transactional systems. You will be responsible for developing, maintaining, and optimizing PL/SQL code, performing data migrations, and supporting reporting and integration needs.

What will you do?

• Design, develop, and maintain complex PL/SQL packages, procedures, functions, triggers, and cursors.
• Implement autonomous transactions, exception handling, and ensure optimal error logging and recovery.
• Work with external tables, materialized views, and schedulers for automated data processes.
• Perform data extraction, data migration, and data loading activities using optimized scripts and tools.
• Conduct performance tuning of PL/SQL code, queries, and database operations.
• Integrate and manipulate XML and JSON data formats using Oracle libraries and tools.
• Design and generate BIRT reports, ensuring accuracy and performance.
• Work on analytical functions and complex queries for reporting and data analysis.
• Debug and troubleshoot PL/SQL code using advanced techniques and tools.
• Collaborate with DBAs to execute database-level operations and functions, including maintenance and optimization.
• Follow best practices for version control, code documentation, and deployment.

What skills required?

• 6+ years of hands-on experience in PL/SQL development in Oracle environments.
• Strong knowledge and working experience with:
• Procedures, Functions, Packages, Triggers
• Autonomous Transactions
• External Tables, Materialized Views
• Oracle Schedulers
• Cursors, Exception Handling
• Data Extraction, Migration, Loading
• BIRT Reports (Business Intelligence Reporting Tool)
• Analytical SQL Functions
• XML and JSON data types and Oracle libraries
• Performance Tuning and Debugging Techniques
• DBA-level utilities and database operations
• Good understanding of relational database concepts, data normalization, and design.
• Strong problem-solving and analytical skills.
• Ability to work independently as well as collaboratively in a team environment.