Consultancy- SQL Database Consultant

3 days ago


مصر, 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 project seeks to attain the following three Results:

- Enhanced Export Capacity of SMEs, NEEREs, in selected sectors
- Strengthened public and private Trade-Support Institutions (e.g., Trade Associations, Export Councils, etc.)
- Improved trade and investment policy, regulatory, and institutional environment

To achieve those targets, TRADE is working to help NEEREs in the sectors of Food processing, Engineering, Ready-made garments (RMG), Home têxtiles, Chemicals, Building Materials, Printing and Packaging.

***Primary Duties and Responsibilities**:
**Purpose**:
The main purpose of this assignment is to assist the MEL team to move from an MS Excel based system to a SQL based system. Considering the increasing amount of project data and to avoid challenges related to transcription errors and maintain data integrity, the SQL system will enable the MEL team to have an automated system to process and analyse data in order to measure progress towards targets in a more efficient manner. Moreover, and due to SQL’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 SQL to enable the project to migrate its data from MS Excel tabulations to the SQL database, including the incorporation of code to automate data processing.

**Milestones and Timeline**:
**Task**

**Duration**

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 a preliminary report on the approach and database structure
- 4 days
- Develop database (with sample data)
- 4 days

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.
- 1 Day
- Modifications to the database by consultant based on feedback.
- 2 Days
- Data migration from current Excel tabulations to the new SQL databases (by consultant), including the implementation of code to automate data processing.
- 4 Days
- Develop all needed queries to facilitate future data processing and develop custom report templates.
- 2 Days
- Modifications to database structure after a one-month trial period.
- 4 Days

**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

**Required Qualifications**:

- Experience in building and maintaining large-scale (more than 10,000 records) SQL databases.
- Experience in developing and implementing code to process data through SQL.

**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.


  • Database Consultant

    7 days 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...


  • مصر, 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...

  • Consultant, Tech

    4 weeks ago


    مصر, Egypt Novasyte Full time

    The Consultant will support the Senior Consultant in the timely and high quality delivery of support services and contracted managed services in the Patient Costing and Care Pathway analysis service sector. Also support the Consultant/Senior Consultant responsible for timely and quality implementations of IMS Patient Costing and related systems projects to...


  • مصر, Egypt Premier Services & Recruitment Full time

    **Job Description & Specification**: **Job Title**: Microsoft SQL Database Senior Administrator **Experience Needed**: 6-9 years **Job Description**: Appropriate actions to maintain computer, network, and database operations. Builds database scheme, tables, procedures and permissions. Creates, tests, and executes data management languages. Develops...

  • Senior BI Consultant

    4 weeks ago


    مصر, Egypt Teradata Full time

    Teradata helps businesses unlock value by turning data into their greatest asset. We’re the cloud data analytics platform company, built for a hybrid multi-cloud reality, solving the world's most complex data challenges at scale. Collectively, we endeavour to serve equal parts innovator and contributor. Because our mission isn’t just about the collection...


  • مصر, Egypt Easy2hire Full time

    As a Senior Business Intelligence Consultant, you form the backbone of our consulting pool. You will be exposed to a little bit of everything, with a strong focus on databases, ETL, and data visualization tools. **Responsibliites** - Design and develop BI Strategies to include assisting with ETL, data modeling, data warehousing, cloud solutions, and...


  • مصر, Egypt Black Tie Consultancy Full time

    **Responsibilities** - Design and implementation of database schemas - Analyzing data access and modification requirements to ensure efficient SQL and optimal database design - Investigate operational or systematic problems and user queries as required - Supervision of modifications to any existing database software to meet the needs of their employer -...


  • مصر, Egypt SSC Egypt Full time

    Acts as the first line of support for all Oracle Database Admins - Supervises & coordinates with the Technical Manager to ensure that the necessary operating system and server has been installed, prepared the customer environment and made all the necessary communications for the installation and set-up of the databases and the development tools and oracle...

  • BI Lead Consultant

    4 weeks ago


    مصر, Egypt Teradata Full time

    Lead Business Intelligence Operations The Lead BI consultant specializes in the maintenance and operations of the Business Intelligence Environment to ensure it operates efficiently and continues to meet the needs of the customer. Operating as a senior member of the Managed Services team, the Lead BI consultant will be responsible for maximising the...

  • Property Consultant

    3 days ago


    مصر, Egypt The Address Investment Full time

    _**Responsibilities **_ - Finding buyers in need of consultancy services through cold-calling, advertising, and business presentations. - Consulting with clients to identify their needs, preferences, and financial concerns. - Maintaining an extensive database of all property for sale. - Arranging advertising to promote the property. - Sending out details of...


  • مصر, Egypt Siemens Digital Industries Software Full time

    Siemens Digital Industries Software in Egypt is looking for a Senior Database Engineer with hands-on knowledge in maintaining, supporting, and improving developer experience and production operations to join the Smart Infrastructure - Brightly Software segment. **Who we are** Brightly, the global leader in intelligent asset management solutions, enables...


  • مصر, Egypt Siemens Digital Industries Software Full time

    Siemens Digital Industries Software in Egypt is looking for a Senior Database Engineer with hands-on knowledge in maintaining, supporting, and improving developer experience and production operations to join the Smart Infrastructure - Brightly Software segment. **Who we are** Brightly, the global leader in intelligent asset management solutions, enables...


  • مصر, Egypt FlairsTech Full time

    Details Required Experience 5 Department Digital Solutions Career Level Position Location Cairo / Alexandria **Skills**: - Oracle Oracle CLoud PLSQL Requirements and responsibilities **Job Summary**: **What Will You Do?** - Analyze User Requirements and translate into database requirements - Design data models and articulate development plans through...


  • مصر, Egypt Siemens Full time

    Siemens Industry Software in Egypt is looking for a Senior Database Engineer with hands-on knowledge in maintaining, supporting, and improving developer experience and production operations to join the Smart Infrastructure - Brightly Software segment. **Who we are** Brightly, the global leader in intelligent asset management solutions, enables...


  • مصر, Egypt FlairsTech Full time

    Details Required Experience 4 - Department R&D - Career LevelSenior Position Location Cairo / Alexandria **Skills**: Implementation Implementation Consultant Requirements and responsibilities The Solutions Consultant (SC) position is responsible for implementing small scale solutions and assisting Solutions Architects on projects for large-scale...


  • مصر, Egypt FlairsTech Full time

    Details Required Experience 4+ Department R&D Career Level Position Location Cairo / Alexandria **Skills**: - Implementation Implementation Consultant Requirements and responsibilities Roles & Responsibilities The Solutions Consultant (SC) position is responsible for implementing small scale solutions and assisting Solutions Architects on projects for...


  • مصر, Egypt Luxoft Full time

    **Project** Description**: We are launching several projects in Finastra Treasury space, including greenfield implementation, extension to back-office and new products and features implementation. This includes both internal projects and client engagements for clients in Europe and Middle-East. **Responsibilities**: - Technical configurations and...


  • مصر, Egypt Thales Full time

    About Us A career at Hitachi Rail will help create a legacy. With operations in every corner of the world, our work goes to the cutting-edge of digital transformation and technology. From the multi-cultural strength of our global organisation to the sustainable and innovative ways we work to bring people together, there’s something for everyone to get...


  • مصر, Egypt Antal International Full time

    Job Title: Oracle NetSuite Consultant with Fusion Experience Location: Cairo, Egypt Company Description: We are a leading global consulting firm specializing in enterprise software solutions. We have a passion for innovation and excellence and are dedicated to providing our clients with world-class services and solutions. **Job...


  • مصر, 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...