Consultancy - Maintaining and modifying SQL-driven database - USAID TRADE

We are searching for an experienced Consultancy - Maintaining and modifying SQL-driven database - USAID TRADE at our Egypt facility.

Primary Duties and Responsibilities:

PROJECT DESCRIPTION

Trade Reform and Development in Egypt (TRADE) is a USAID-funded project whose objective is to increase Egypt’s international trade by increasing exports from small and medium-sized enterprises (SMEs) in the activity’s “selected sectors”; Engineering Products, Food Processing, Home textiles, Ready Made Garments, Chemicals, Printing and Packaging, and Building Materials
The TRADE Activity will achieve the following three Results:
1) Enhanced Export Capacity of SMEs, in particular New and Expanding Export- Ready Enterprises (NEEREs)[1] in the Selected Sectors.
2) Strengthened Public and Private Trade-Support Institutions (e.g., Trade Associations, Export Councils, etc.); and
3) Improved Trade and Investment Policy, Regulatory and Institutional Environment

ASSIGNMENT BACKGROUND


The project's performance data was successfully transferred from an MS Excel-based system to one based on SQL. Given the growing volume of project data and the desire to mitigate transcription errors while upholding data integrity, implementing the SQL system furnishes the Monitoring, Evaluation and Learning (MEL) team with an automated mechanism for processing and analyzing data. This substantially enhances their ability to measure progress toward targets in a more streamlined and effective manner and enhances the project’s ability to visualize the relevant data. In response to the changes in the project’s monitoring system and information needs, which are expected to continue to evolve as the project continues implementation, modifications to the system need to be regularly implemented.

USAID TRADE is seeking to hire a short-term consultant to assist the Monitoring, Evaluation and Learning (MEL) and Result I and Result 2 teams in implementing changes to the system based on the evolving information needs of the project and address any database issues when needed.

TASKS

• Maintain and troubleshoot any technical difficulties related to the system.

• Present possible database maintenance needs and mitigation measures.

• Add new features and make changes to the project’s databases (SQL-driven database, attendance system, and NEEREs information system developed by the project) to reflect changes in the project’s information needs, including the development of all needed interfaces and queries to facilitate future data processing and developing custom report templates and making relevant changes to the databases’ structure.

• Handing over the modified source code after every change made.

DELIVERABLES

• Brief USAID consultancy report describing the purpose of the consultancy, progress achieved, observations, issues and problems encountered, and details of expected follow-on activities by USAID TRADE or its stakeholders.

EXPECTED OUTCOMES

• The database system continues to be operational in an optimal state.

• The database system is in line with the projects and USAID’s evolving information needs.

Required Qualifications:

• A degree in computer science, information technology, or a related field.
• Minimum of 5 years of relevant experience.
• Proficiency in database management systems.
• Understanding of database security practices and protocols.
• Strong analytical and problem-solving skills to address database issues and improve system performance.
• Excellent verbal and written communication skills.
• Experience with USAID projects is preferred.

Consultants
Month
0.00 - 0.00

Our company provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics.