Senior Database consultant 27 views

Job Description

EthSwitch S.C is a technology and payments company established to play a critical role in modernization of Ethiopia’s currently emerging payment system by instituting and operating the country’s retail payments scheme, ensuring interoperability of payments among payment services providers and providing shared infrastructure. The mission of the Company is “Making Payments Simple and Affordable”, and the Vision of the Company “To be best in class Payments Network in Africa”. We are looking for professionals to fill the following vacant positions for our offices of the Program Management Office (PMO).EthSwitch is currently implementing a range of projects/activities including the Real Time Retail Payment Platform which is funded by the Bill and Melinda Gates Foundation.

The senior database consultant delivers the design, setting-up and maintaining of databases resided at the DC and DR. S/he is expected to monitor, test the performance of the databases and do performance tuning. S/he must have a strong understanding of database technologies, database design principles and software engineering practices. S/he is also responsible for the high availability of the databases, automatic backups, building models, reports and dashboards.

Job Requirements

Qualifications/Skills and Experience

  •  BSc Degree in Computer Science, Computer Engineering, Electrical Engineering, and other related fields plus minimum of 8 years relevant experience out of which 1 year successful leadership in database implementation and monitoring. Additionally, it requires a strong hands-on/ technical knowledge on database design, data structures, computer programming, algorithms and operating systems.

Key responsibilities:

  •   Designing and developing database architecture using various structured and unstructured data types such as text, images, audio or video files.
  •  Developing and maintaining database security protocols to ensure that data is not compromised by unauthorized users.
  •  Designing and implementing data storage structures such as tables and indexes to improve performance of database applications
  •   Monitoring database performance to identify problems that require intervention by database specialists
  •   Design, build data models to support structured and unstructured data.
  •   Design, build and deploy scalable high-volume data pipelines to move data across systems.
  •   Build centralized data lake, data warehouse and visualizations that support multiple use cases across different products.
  • Build and manage Data Guard Physical/Logical Standby Databases using Data Guard Broker
  •  Design and develop software and data solutions that help business team to make data-driven          decisions.
  • Experience in data warehouse space.
  •  Experience in custom ETL/ELT design, patterns for efficient data integration.
  •  Query writing (SQL & NoSQL), schema design, normalized data model and dimensional model.
  •  Analyzing large volumes of data to provide data driven insights and gaps.
  • Create high available databases and build automatic backups.
  •  Support automated deployment and operation of MySQL and Oracle instances in a high-availability environment
  •  Optimize and tune database schemas, stored procedures, triggers, and dynamic queries
  •    Build data pipelines for data analytics.
  •  Document technical designs and program logic
  •  Participate in functional and technical reviews

Knowledge & Skills required:

  •  Strong hands-on/ technical knowledge on database management skills including but not limited to creating, monitoring, and tuning of oracle, MySQL, PostgreSQL and MongoDB databases.
  •   Strong experience in configuring, patching, upgrading, and optimizing database software and related products.
  •  Strong experience in security, backup/recovery, replication, architecture, networking, and administration for database disciplines.
  •  Participates and/or assists the team in the development, maintenance, testing, implementation, and support of assigned database technologies and associated software products.
  •   Proactively monitor and troubleshoot database issues escalated by the business team and internal monitoring in a timely manner with strong skills to drive to root cause and remediation of issues.
  • Strong understanding with the creation and implementation of data definition language (DDL) to support development efforts.
  •  Intermediate to strong performance and tuning skills with the ability to identify, respond and resolve database performance issues; communicates database performance resolution to technical teams.
  •  Strong documentation skills to contribute to the information technology processes and procedures.
  •   Experience in IT Project Management.

Qualified candidates are invited to submit their application with non-returnable CV, Cover Letter and Supporting Documents from November 23 –  30 2022 between 8:00 A.M and 5:00 P.M from Monday to Friday and from 8:00 A.M to 12:00 P.M on Saturday to the address provided below or E-mail it at [email protected] by clearly stating the position title on the subject line. Applications from qualified women are encouraged.

EthSwitch S.C.

Location: Kazanchis Super Market Area (Opposite to Zemen Bank), Nega City Mall – 4th Floor, Room No 410; Addis Ababa. Only short-listed applicants will be contacted by phone.

More Information

  • This job has expired!

Leave your thoughts

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Share this job
Company Information
Contact Us