JOB PURPOSE

The IT Operations Assistant will assist as database developer on the following:

• SQL Procedure Development and Maintenance
• Database Structure Maintenance and Creation
• Database System Design
• Scripting for Data Extraction, Movement and Loading
• Documentation
• Performance Monitoring and Tuning
• Full Stack Development including Python backend, Frontend, and Mobile Application Development with proficiency in Odoo Framework.

KEY ACCOUNTABILITIES (not all-inclusive)

1. SQL Procedure Development and Maintenance
2. Develop, implement, and maintain SQL stored procedures, functions, and triggers.
3. Collaborate with developers to align SQL procedures with solution logic, providing insights based on previous experience.
4. Optimize SQL code for enhanced performance and efficiency.
5. Independently troubleshoot and debug SQL code to promptly resolve issues.
6. Database Structure Maintenance and Creation
7. Maintain existing database structures in various environments.
8. Collaborate with the team to ensure database structures align with application and advanced data warehousing requirements.
9. Database System Design
10. Actively contribute to the design of high-performance, high-availability database systems, incorporating advanced data warehousing components.
11. Collaborate with system architects to ensure database designs align with overall system architecture, especially emphasizing data warehousing considerations.
12. Contribute to the development and implementation of database design best practices for data warehousing.
13. Stay informed about emerging trends and technologies in database system design, particularly in the context of data warehousing
14. Scripting for Data Extraction, Movement, and Loading
15. Develop and optimize PowerShell scripts for transactional data extraction independently.
16. Develop scripts to facilitate the loading of transactional data into the database, providing insights on data warehousing requirements.
17. Collaborate with data analysts to ensure scripts align with advanced data extraction and loading requirements.
18. Documentation
19. Maintain documentation on development and production configurations, including advanced data warehousing components.
20. Document logical and physical database designs, emphasizing considerations for both transactional and data warehousing needs.
21. Capture metadata information for all database objects, with a focus on advanced data warehousing structures.
22. Performance Monitoring and Tuning
23. Independently monitor database performance, including advanced data warehousing components, and identify areas for improvement.
24. Implement tuning strategies to optimize database performance, especially for data warehousing workloads.
25. Collaborate with the operations team to ensure optimal hardware configurations for both transactional and data warehousing needs.
26. Full Stack Development
27. Develop backend systems using Python, ensuring robustness, scalability, and security.
28. Design and implement frontend components using modern web technologies such as HTML, CSS, and JavaScript, ensuring a responsive and intuitive user experience.
29. Develop mobile applications using relevant frameworks and technologies, ensuring cross-platform compatibility and performance optimization.
30. Proficiency in the Odoo framework is a huge plus, including customization, module development, and integration with backend systems.

Skills

STANDARD MINIMUM QUALIFICATIONS

Education: Secondary Education with an additional Diploma in computer science, engineering, mathematics, science, or any other relevant qualification is required. Bachelor’s degree in the same areas mentioned above is a strong advantage. 

Experience: At least five (5) years of experience in SQL Programming at the international, national level or in the private sector.

Languages: Fluency in English and Arabic is required. 

DESIRED EXPERIENCES FOR ENTRY INTO THE ROLE

• Experience in Data warehouse projects and requirements gathering is required.
• Experience in shell scripting desired.
• Strong analytical skills needed for gap analysis and source-to-target mapping.
• Experience in understanding the identified gaps and providing solutions, translating them to technical efforts, and estimating the work.
• Experience in conducting code reviews ensuring quality of development and testing procedures and protocol.