Job Vacancies at Metropol Corporation Limited

Job Purpose

To manage the performance, security and integrity of Metropol’s database infrastructure. You will be instrumental in the planning and enhancement of the database environment for the future.

Duties & Responsibilities

Database Performance:

       Main Activities

• Monitor performance and manage parameters in order to provide fast response to queries.
• Use automated tools effectively to interpret the state of databases and extract areas of improvement.
• Take charge of writing and optimizing in-application database statements.
• Write and optimize queries to retrieve data from MongoDB.
• Implement a strategy for speedy data retrieval that combines relational and NoSQL datastores.

Planning:

  Main Activities

• Map out the conceptual design for a planned database, considering both backend organization of data and front-end accessibility for clients.
• Refine the physical design to meet storage system requirements.
• Carry out capacity planning for the database.

Reporting:

   Main Activities

• Implement a data warehousing strategy
• Write database documentation, including data standards, procedures and definitions for the data dictionary (metadata)
• Generate daily, weekly and monthly reports as discussed with your supervisor.
• Communicate regularly with technical and operational staff to ensure database integrity and security.

Data Security:

       Main Activities

• Control access permissions and privileges on production databases.
• Maintain the data recovery aspects of a database.
• Refine the logical design of the databases so that it can be translated into a specific data model.
• Maintain data standards, including adherence to any data protection legislation.

JOB SPECIFICATIONS

Competencies:

• Capable of configuring popular relational database systems and orchestrating clusters as necessary.
• Ability to plan resource requirements from high level specifications
• Familiar with tools that aid with profiling server resource usage and optimizing it.
• Proficient in using Git.
• Provable two years of experience working with NoSQL datastores (MongoDB preferred)
• Provable four years of experience working with PostgreSQL.
• Skilled at optimizing large complicated SQL statements.
• Knowledge of best practices when dealing with relational and NoSQL databases.

Skills:

• Proven ability to work under pressure and meeting tight deadlines
• Flexible and mature approach with ability to work unsupervised

Education, Qualifications & Experience:

• Bachelor’s degree in Computer Science or equivalent.
• Certification in any relational database system.
• Training in Mongo DB is an added advantage
• Ability to write code in any contemporary language is an added advantage.

go to method of application »

JOB PURPOSE

Participating in product development, from receiving requirements, developing, testing and beyond. Work on groundbreaking products, fix issues and improvements that are critical to the success of the organization. Work with the data team to make the organization’s product smarter and more intuitive to use. Work with the broader business team to maintain and help optimize existing systems.

REPORTS TO

Head of Software Development

DIRECT REPORTS NONE

KEY RELATIONSHIPS Internal – Software Developers, Software Test Analyst External

Innovation Work: Optional To be agreed

Improvement Work: Optional To be agreed

Duties & Responsibilities

• Develop software application and integration solutions, generally for the business units. Solutions include enhancements and interfaces, functions and features.
• Work on mission-critical, complex enterprise-wide applications.
• Creating database schemas that represent and support business processes
• Implementing automated testing platforms and unit tests
• Compose solutions that incorporate RESTful Web components,
• Work with NoSQL data frameworks, and large–scale database systems to drive insights from vast amounts of structured and semi-structured data. Maintain quality and ensure responsiveness of applications.
• Engage with business analysts to comprehend client challenges, prototype new ideas and new technologies, and help to create solutions to drive the next wave of innovation.
• Maintain integrity and organization ethics.

Academic, Professional & Experience

• Bachelor’s Degree in Computer Science, Information Technology, Software Engineering or similar.
• 3+ years of experience with software design, implementation, and testing
• 3+ years of experience with using best practices and design patterns for writing clean, reusable, and highly organized code
• Experience with developing service APIs for external consumption
• Proficient understanding of OWASP security principles
• Experience with project and issue tracking tools (JIRA) Experience of Agile Scrum / Kanban framework
• Proficient understanding of code versioning tools such as Git

Technologies

• HTML / CSS / JavaScript
• Java / Spring framework / Hibernate / JAVA RESTful web services development
• Python / Django framework / Django Rest Framework
• Apache Tomcat, JBoss, or Jetty
• XML, JSON
• Linux / Unix
• MySQL, SQL Server, Mongo DB, Redis and PostgreSQL

Desirable Skills

• Communication Skills
• Excellent time management, organizational skills and strong problem solving skills
• Good written and communication skills and high attention to detail
• Ability to acquire knowledge to make process improvement recommendations