Senior Oracle Database Developer

  • Advansys
  • 6th of October City, Giza Governorate, Egypt
  • Full-time

وصف الوظيفة

We are in search of a highly skilled Senior Oracle Database Developer with over 4 years of substantial experience in Oracle Database development, PL/SQL programming, and ETL processes. The successful candidate will be instrumental in designing, executing, and preserving effective database solutions while ensuring optimal performance and scalability.<\/p>

Key Responsibilities:<\/strong><\/p>

  • Develop, design, and maintain intricate PL/SQL scripts, stored procedures, functions, and triggers.<\/li>
  • Lead the development of database solutions tailored for enterprise-level applications.<\/li>
  • Perform database performance tuning, optimization, and debugging tasks.<\/li>
  • Engage with cross-functional teams to assess requirements and architect efficient database structures.<\/li>
  • Maintain data integrity, uphold security standards, and align with organizational compliance.<\/li>
  • Guide and mentor junior developers, offering expertise in best practices.<\/li> <\/ul>

    Essential Qualifications:<\/strong><\/p>

    • Possession of a Bachelor’s degree in Computer Science, Information Technology, or a related discipline.<\/li>
    • Over 4 years of hands-on experience in Oracle database development and PL/SQL programming.
    • Thorough comprehension of relational database principles, normalization techniques, and data modeling.
    • Proficient with Oracle utilities like SQL*Plus, TOAD, or SQL Developer.
    • Extensive experience in database performance tuning, indexing strategies, and query optimization.
    • Exceptional problem-solving capabilities, along with strong communication and leadership skills.<\/li> <\/ul>

      Preferred Skills:<\/strong><\/p>

      • Familiarity with database migration and ETL methodologies, as well as other database platforms.
      • Proficiency in Agile development practices.
      • Understanding of advanced database notions such as partitioning, materialized views, and replication techniques.<\/li> <\/ul>

متطلبات الوظيفة

Responsibilities:

  • Design, develop, and maintain complex PL/SQL scripts, stored procedures, functions, and triggers.
  • Lead the implementation of database solutions for enterprise-level applications.
  • Conduct database performance tuning, optimization, and troubleshooting.
  • Collaborate with cross-functional teams to analyze requirements and design efficient database architectures.
  • Ensure data integrity, security, and compliance with organizational standards.
  • Mentor junior developers and provide technical guidance on best practices.

Requirements:

  • Bachelor’s degree in Computer Science, Information Technology, or a related field.
  • 4+ years of professional experience in Oracle database development and PL/SQL programming.
  • Deep understanding of relational database concepts, normalization, and data modeling.
  • Proficiency in Oracle tools like SQL*Plus, TOAD, or SQL Developer.
  • Strong experience in database performance tuning, indexing, and query optimization.
  • Excellent problem-solving, communication, and leadership skills.

Preferred Qualifications:

  • Experience in database migration, ETL processes, or other database platforms.
  • Familiarity with Agile development methodologies.
  • Knowledge of advanced database concepts like partitioning, materialized views, and replication.