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 data stores.

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.

Qualifications

Academic Background:

• Bachelor’s degree in Computer Science or equivalent.


• Training in Mongo DB is an added advantage.

Certification

• · Certification in any relational database system.

Experience

• Provable two years of experience working with NoSQL data stores (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.


• Proficient in using Git.


• Familiar with tools that aid with profiling server resource usage and optimizing it.


• Capable of configuring popular relational database systems and orchestrating clusters as necessary.

Skills:

• Proven ability to work under pressure and meeting tight deadlines


• Flexible and mature approach with ability to work unsupervised


• Ability to write code in any contemporary language is an added advantage.


• Ability to plan resource requirements from high level specifications