Job Summary

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.

  • Minimum Qualification: Bachelor
  • Experience Level: Mid level
  • Experience Length: 2 years

Job Description/Requirements

POSITION:Database Administrator
DEPARTMENT:Information Technology

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.

REPORTS TO
Head of IT Infrastructure

DIRECT REPORTS
None

KEY RELATIONSHIPS
Internal – IT team members
External – Key client contact persons.

WHAT WORK WILL BE DONE IN YOUR ROLE
Innovation Work: To be agreed with the supervisor
Improvement Work: To be discussed and agreed with supervisor

DUTIES & RESPONSIBILITIES

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

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

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

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

COMPETENCIES, SKILLS, QUALIFICATIONS, EDUCATION & EXPERIENCE

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.

KEY PERFORMANCE INDICATORS
• Data protection measures taken, successfully tested.
• Data retrieval performance measurable improvement.
• Turnaround of business requests within Metropol IT SLA.
• Any other as discussed with your supervisor.

Important Safety Tips

1. Do not make any payment without confirming with the BrighterMonday Customer Support Team. 2. If you think this advert is not genuine, please report it via the Report Job link below.

Share Job Post

Log In to apply now

Activate Notifications Stay productive - get the latest updates on Jobs & News
Activate
Deactivate Notifications Stop receiving the latest updates on Jobs & News
Deactivate
Nairobi
| Contract |
KSh 45,000 - 60,000
Job Function: Software & Data
1mo
Nairobi
| Full Time |
KSh Confidential
Job Function: Software & Data
1mo
Nairobi
| Full Time |
KSh 30,000 - 45,000
Job Function: Software & Data
1mo
Nairobi
| Contract |
KSh 45,000 - 60,000
Job Function: Software & Data
1mo