5 Pl Sql Developer jobs in Egypt

Requirements and responsibilities

• Design, develop, and maintain PL/SQL code for Oracle databases.
• Create and manage complex database structures including tables, indexes, views, and stored procedures.
• Optimize database performance through tuning and query optimization.
• Provide support and troubleshooting for database-related issues.
• Work with application developers to integrate database functionality into applications.
• Ensure data integrity and security through effective data management practices.
• Develop and implement data migration and data transformation processes.
• Lead and manage database projects from inception through completion.
• Collaborate with cross-functional teams to ensure project success.
• Prepare comprehensive documentation for database designs, configurations, and procedures.
• Generate reports and provide insights based on database analysis.
• Ensure database systems comply with industry standards and organizational policies.
• Implement and promote best practices in database development and management.

• Extensive experience with PL/SQL programming including writing and optimizing complex queries, stored procedures, triggers, and functions.
• Strong knowledge of Oracle database architecture, administration, and management.
• Experience with Oracle tools such as SQL*Plus, SQL Developer, and Oracle Enterprise Manager.
• Expertise in performance tuning and optimization of PL/SQL code and database queries.
• Familiarity with Oracle performance tuning tools and techniques.
• Proficient in database design and data modeling techniques.
• Experience with ERD tools and data modeling software.
• Advanced knowledge of SQL and relational database management systems (RDBMS).
• Experience with complex joins, subqueries, indexing strategies, and query optimization.
• Familiarity with version control systems such as Git or SVN for managing database scripts and changes.

• Strong analytical and problem-solving skills.
• Ability to analyze complex business requirements and translate them into technical solutions.
• Excellent verbal and written communication skills.
• Ability to effectively communicate with technical and non-technical stakeholders.
• Proven ability to work collaboratively in a team environment.
• Experience leading or mentoring junior developers.
• Strong organizational and project management skills.
• Ability to manage multiple projects simultaneously and meet deadlines.
• High attention to detail and accuracy in work.
• Strong commitment to delivering high-quality code and solutions.
• Ability to adapt to changing technologies and evolving business requirements.
• Willingness to learn and implement new tools and techniques.
• Proactive and self-motivated with the ability to work independently.
• Strong work ethic and a commitment to continuous improvement.

Advansys is a dynamic solutions provider focused on delivering smart, modular, and sustainable technology solutions that enhance operations, improve customer experiences, and drive business modernization. With over 400 skilled engineers, we serve 100+ enterprise customers across 14 countries. Specialized in a wide array of premium services including Business Automation, Industrial Digitization, Low code Development, Cloud Services, Warehouse Automation & Strategic Outsourcing.

Founded in 2014, Advansys is part of the INTRO Group, a private conglomerate established in 1980 with diverse investments across different business areas, oil and gas, real estate, specialized engineering, financial investment, Food & manufacturing.

We are seeking an experienced and highly skilled RAID Developer to work on complex data-related projects. The ideal candidate should have a strong background in SQL & PL/SQL, experience with Hive DB, hands-on knowledge of Apache Spark, and proficiency in Python programming. You will be responsible for developing, optimizing, and maintaining robust data pipelines, implementing high-performance SQL queries, and integrating data systems to ensure reliable and scalable solutions.

Job description:

• Develop and maintain SQL-based solutions, including complex queries and PL/SQL procedures for efficient data handling and reporting.
• Design and implement scalable data processing systems using Apache Spark and Hive DB to process large-scale data efficiently.
• Build and optimize data pipelines and ETL processes using Python for automation, data extraction, transformation, and loading.
• Work with large datasets, ensuring efficient querying and manipulation through Spark and Hive, providing seamless integration across various data sources.
• Collaborate with data scientists, analysts, and engineers to understand business requirements and translate them into technical solutions.
• Perform troubleshooting and optimization of SQL queries, PL/SQL stored procedures, and Spark jobs for improved performance.
• Monitor and ensure the performance and scalability of data systems, implementing proactive measures to handle data growth.
• Ensure adherence to best practices in code quality, security, and testing for data systems.
• Contribute to the design and architecture of data pipelines that support business intelligence and reporting applications.

Requirements:

• Familiarity with additional big data technologies (e.g., Hadoop, Kafka, etc.).
• Experience with Linux.
• Knowledge of data warehousing concepts and architecture.
• Strong communication skills to effectively interact with cross-functional teams and stakeholders.

To Apply Please submit your resume

As a MySQL Database Developer at Müller's Solutions, you will be responsible for designing, developing, and maintaining MySQL databases that meet the specific needs of our organization and clients. You will work closely with cross-functional teams to gather requirements, optimize database performance, and ensure data integrity and security. Your expertise in MySQL development will be crucial in supporting the development and deployment of high-quality software applications.

Responsibilities:

• Design and develop MySQL databases based on business requirements and best practices.
• Create database schemas, tables, and stored procedures.
• Optimize database performance, including query tuning, index management, and caching.
• Ensure data integrity and implement database security controls.
• Collaborate with application developers to design and implement efficient database architectures.
• Troubleshoot and resolve database issues, working closely with technical teams to identify and implement solutions.
• Perform data migration and integration between MySQL databases and other systems.
• Stay updated with the latest MySQL technologies, updates, and best practices.

Requirements

Requirements:

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Proven experience as a MySQL Database Developer, with expertise in designing and developing MySQL databases.
• Strong understanding of MySQL database architecture and performance optimization.
• Proficiency in SQL programming and query optimization.
• Experience with database design, including normalization, indexing, and stored procedures.
• Knowledge of database security best practices and access controls.
• Familiarity with data migration and integration between databases and systems.
• Excellent problem-solving and analytical skills.
• Ability to work independently and collaboratively in a team environment.
• Strong communication and interpersonal skills.

As a Senior MySQL Database Developer at Müller's Solutions, you will lead in designing, developing, and maintaining MySQL databases that drive critical business processes and applications.

Responsibilities:

• Lead the design and development of complex MySQL database systems, based on business requirements and best practices.
• Create and manage advanced database architectures, including partitioning, replication, and clustering.
• Optimize database performance through query tuning, index management, caching, and advanced techniques.
• Ensure data integrity and security by implementing proper access controls, authentication mechanisms, and data encryption.
• Collaborate with application developers and system architects to design and implement highly scalable and efficient database solutions.
• Troubleshoot and resolve complex database issues, working closely with technical teams to identify and implement solutions.
• Perform backup, recovery, and disaster recovery planning for MySQL databases.
• Mentor and guide junior database developers, ensuring adherence to best practices and quality standards.
• Stay updated with the latest MySQL technologies, updates, and trends, and evaluate their applicability to improve database performance and scalability.

Requirements

Requirements:

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Proven experience as a MySQL Database Developer, with a focus on complex database development and optimization.
• In-depth knowledge of MySQL database architecture, advanced features, and performance optimization techniques.
• Strong proficiency in SQL programming and query optimization.
• Experience in database administration, including backup, recovery, and disaster recovery planning.
• Expertise in designing highly scalable and efficient database architectures.
• Knowledge of database security best practices and experience implementing access controls and encryption.
• Experience with database replication, clustering, and partitioning.
• Excellent problem-solving and analytical skills, with the ability to troubleshoot and resolve complex database issues.
• Strong leadership and mentoring skills.
• Ability to work independently and collaboratively in a team environment.
• Excellent communication and interpersonal skills.

Benefits

Why Join Us:

Opportunity to work with a talented and passionate team.

Competitive salary and benefits package.

Exciting projects and innovative work environment.