Consultancy - Ms Access Database Specialist and

2 weeks ago


مصر, Egypt Palladium Group, Inc. Full time

**Consultancy - MS Access Database Specialist and Programmer**

***Primary Duties and Responsibilities**:
The main purpose of this assignment is assisting the MEL team to move from an MS Excel based system to an MS Access based system. Moreover, and due to MS Access’s comparative advantage in managing data in a format that can be accessed by multiple simultaneous users, the contracted specialist will build a database structure on MS Access to enable the project to migrate its data from MS Excel tabulations to the MS Access database, including the incorporation of code to automate data processing.
The consultant will undertake the following tasks:

- Review of the current project database and the project’s information needs:

- Kick-off meeting with the MEL team to go through the current structure and determine the way forward.
- Review current MEL tabulations and indicators’ structure.
- Develop preliminary report on approach and database structure.
- Develop database (with sample data).
- Delivery of database and presentation summarizing the database structure:

- Conduct a detailed presentation of the database’s workflow, including the methodology used for data migration, query design, and data processing automation code.
- Present possible database maintenance needs and mitigation measures.
- Modifications to database by consultant based on feedback.
- Data migration from current Excel tabulations to the new Access databases (by consultant), including the implementation of code to automate data processing.
- Modifications to database structure after a one-month trial period.

**Deliverables**
- Submit preliminary report on approach and database structure.
- Submit draft database with sample data and deliver presentation.
- Submit final database.
- Migrate data from Excel tabulations to the final database.
- Brief consultancy report in English that contains the purpose of the consultancy, progress achieved, observations, issues and / or problems encountered, and details of expected follow-on activities by USAID TRADE or its counterparts.

Period of Performance: on/about April 15, 2023, to o/a May 14, 2023
Total LOE: 21 person days

**Required Qualifications**:

- Experience in building and maintaining large-scale (more than 10,000 records) MS Access databases.
- Experience in developing and implementing code to process data through MS Access.
- Microsoft Access certification by Microsoft is a plus.

**Project Overview and Role**:
USAID’s Trade Reform and Development in Egypt (TRADE) project builds on decades of U.S. investments in Egyptian businesses and economic policy with the aim of substantially increasing Egyptian exports from Small and Medium Enterprises (SMEs). The TRADE project focuses on six selected sectors: engineering products, food processing, home têxtiles, ready-made garments, chemicals, and building materials. Through the project, USAID works with the Government of Egypt to improve the trade and investment policy environment and reduce barriers to trade. USAID also partners with business associations and export councils to strengthen the trade services ecosystem for small
- and medium-sized exporters, as well as with private companies to help them access new international markets to increase export sales. TRADE tackles many trade and investment-related issues to sustainably increase Egyptian exports and drive economic growth.

**Company Overview**:
**About Palladium** - Palladium is a global leader in the design, development and delivery of Positive Impact - the intentional creation of enduring social and economic value. We work with governments, businesses, and investors to solve the world's most pressing challenges. With a team of more than 3,000 employees operating in 90 plus countries and a global network of over 35,000 experts, we help improve economies, societies and, most importantly, people's lives.



  • مصر, Egypt Palladium Group, Inc. Full time

    **Consultancy - SQL Database Consultant** **Project Overview and Role**: The USAID’s Trade Reform and Development in Egypt (TRADE) Activity aims to boost Egypt’s international trade by increasing exports from Egyptian Small and Medium Enterprises (SMEs), and New and Expanding Export-Ready Enterprises (NEEREs1). To achieve the Activity’s goal, the...

  • Database Specialist

    4 weeks ago


    مصر, Egypt IQVIA Full time

    A database specialist is a technical professional who designs and maintains databases for storing and accessing important information. Database Specialist typically develop knowledge of database programming languages, information security and network administration to help companies collect, analyze, store and access sensitive data that supports business...


  • مصر, Egypt SANTECHTURE Full time

    **Role Summary**: DBA (or Database administrators) is responsible for implementation and maintenance of Database server (or servers). DBA also responsible to keep the integrity and security of databases and database servers. DBAs own the database servers and responsible to keep them intact at any circumstances, as well as in troubleshooting any issues on...


  • مصر, Egypt Johnson & Johnson Full time

    **Johnson & Johnson Janssen** is recruiting for **MS Product Specialist **to be located in **Cairo, Egypt **. **Summary of the job**: To be a therapeutic area scientific expert, responsible for discussing our Therapeutic areas, patients’ treatment trends and studies in the therapeutic areas in which we are involved, on a peer-to-peer basis with a defined...

  • Database Consultant

    1 month ago


    مصر, Egypt Orange Business Full time

    **About the role**: Deploy and operate Oracle IT systems within the Equant MHS Data centers. Perform regular day to day database operations including; Problem Resolution, Upgrades and Maintenance, Backups, Performance Monitoring and Tuning. Incident Management Maintain physical integrity (i.e. managed by the database engine) of databases ; this includes...

  • Database Engineer

    1 month ago


    مصر, Egypt b_labs Full time

    b_labs is the transformation and digitization arm of B.TECH, on a mission to change the industry as we know it. We spearhead tech innovation at B.TECH, an organization that has been a cornerstone of the Egyptian retail industry. We are the engine powering B.TECH in achieving its goal of becoming the leading omni-channel platform for consumer electronics and...


  • مصر, Egypt Seintiv talent solutions Full time

    Responsibilities Take a part in support and development of implemented D365 F&O solution as Operations support consultant from customer side, including: - Work with ITSM solution (Jira) to track and keep under control all assigned tickets - Resolve user issues on the first support line with the best quality within tight deadlines in agile multitasking...

  • Data Entry Specialist

    1 month ago


    مصر, Egypt Pillars Consultancy Full time

    Entering data to update and maintain company information on computer systems. Responsibilities include collecting and entering data into databases and maintaining accurate records of valuable company information. **Requirements**: - Proven data entry work experience, as a data entry operator - Ability to work with Microsoft Excel and data programs -...


  • مصر, Egypt اورنچ مصر Full time

    About the job Senior, Database Administration **Purpose of the job** A professional database administrator (DBA) will keep the database up and running smoothly 24/7. The goal is to provide a seamless flow of information throughout the company, considering both backend data structure and frontend accessibility for end-users. **Duties and...


  • مصر, Egypt 00E1 - Grifols Egypt Plasma Der Full time

    Would you like to join an international team working to improve the future of healthcare? Do you want to enhance the lives of millions of people? Grifols is a global healthcare company that since 1909 has been working to improve the health and well-being of people around the world. We are leaders in plasma-derived medicines and transfusion medicine and...


  • مصر, Egypt SSC Egypt Full time

    Experience with relational database management systems including SQL Server. - Manage SQL Server databases. - Configure and maintain database servers and processes. - Monitor system's health and performance. - Ensure high levels of performance, availability, sustainability and security. - Analyze, solve, and correct issues in real time. - Refine and automate...

  • IT Specialist

    4 weeks ago


    مصر, Egypt FlairsTech Full time

    Details Required Experience 5 Department Digital Solutions Career Level Position Location Cairo **Skills**: - Windows Excel English Networks troubleshooting Technical Support Team Work AWS Word MS Outlook Microsoft Office Active Directory Helpdesk Internet research and analysis Critical Thinking Azure SharePoint Microsoft Azure Requirements and...


  • مصر, Egypt اورنچ مصر Full time

    About the job Database Administration, Supervisor **Purpose of the job** A professional database administrator (DBA) will keep the database up and running smoothly 24/7. The goal is to provide a seamless flow of information throughout the company, considering both backend data structure and frontend accessibility for end-users. **Duties and...


  • مصر, Egypt Orange Full time

    **Purpose of the job** A professional database administrator (DBA) will keep the database up and running smoothly 24/7. The goal is to provide a seamless flow of information throughout the company, considering both backend data structure and frontend accessibility for end-users. **Duties and responsibilities** - Build database systems of high availability...


  • مصر, Egypt Palladium Group, Inc. Full time

    **Communications Specialist** ***Primary Duties and Responsibilities**: Under the supervision of the Communications Manager, the Communications Specialist will assist the Communications Manager in drafting, researching, editing, translating, copying, formatting and preparing materials needed by staff or consultants in preparation for TRADE events,...


  • مصر, Egypt Nissan Full time

    We are looking for an Indirect Purchasing Specialist who will be mainly responsible for procuring goods and services with competitive prices that meets the required specifications, quality level and delivery time. In addition to create and maintain good relationships with key suppliers. **Responsibilities**: Purchase goods, indirect materials and services...


  • مصر, Egypt itialuS Full time

    **Responsibilities**: AWS Database Management: Deploy, configure, and manage database instances using AWS services such as Amazon RDS, Amazon Aurora, and Amazon DynamoDB. Monitor and optimize database performance, ensuring high availability and reliability. Performance Tuning and Optimization: Identify and resolve database performance bottlenecks,...

  • Security Consultant

    1 month ago


    مصر, Egypt IBM Full time

    Introduction IBM Systems Expert Labs is a Professional Services Team under IBM Technology Expert Labs. IBM Technology Expert Labs has the proven expertise to help leaders plan, design and implement the essential IT infrastructure for what comes next. We offer a wide range of IT infrastructure services for IBM Power Systems, IBM Z® and IBM LinuxONE...


  • مصر, Egypt Vodafone Full time

    **Role purpose**: Manage the daily Server/DB build requirement and troubleshooting related to the physical and Virtual server DB build. **Key accountabilities and decision ownership**: - Install & configure MS SQL 2012/2016/2019 - Hands on experience of configuring SQL cluster based of Microsoft Windows - Configuration MSSQL AAG cluster - Troubleshooting...

  • National Consultant

    4 weeks ago


    مصر, Egypt United Nations Development Programme (UNDP) Full time

    **LOCATION**: Cairo, EGYPT **TYPE OF CONTRACT**: Individual Contract **STARTING DATE**: **APPLICATION DEADLINE**: 07-Mar-24 (Midnight New York, USA) **POST LEVEL**: National Consultant **DURATION OF INITIAL CONTRACT**: One Year **TIME LEFT**: 15d 8h 54m **LANGUAGES REQUIRED**: Arabic English **EXPECTED DURATION OF ASSIGNMENT**: **Background**: UN...