• NEVER pay for any job, interview, certification, visa or any other fee to any employer or individual. If you need any clarification, email us: services@myjobmag.co.ke
  • Database Administrator at Metropol Corporation Ltd

  • Posted on: 19 July, 2019 Deadline: Not Specified
  • View Jobs in ICT / Telecommunication View All Jobs at Metropol Corporation Ltd
  • Subscribe to free job alerts
  • Metropol was established in Kenya in 1996 as a business Information and credit management company. In 2006 Metropol partnered with GCR to provide credit rating services that enable corporates to raise capital and meet their financing needs.

    Database Administrator

     

    Job Description

    REPORTS TO: Head of IT Infrastructure

    DEPARTMENT: Information Technology 

    KEY RELATIONSHIPS

    1. Internal – IT team members
    2. 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:

    • 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:

    • 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:

    • 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:

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

    Method of Application

    Applications should be sent their CVs to hr@metropol.co.ke

    Email subject as the position they are applying for.

  • ❮ Back to All Jobs
  • Know more about Metropol Corporation LtdSimilar Jobs
  • Search for jobs by keyword
  • Health and Wellness Consultant at Samasource
  • Technical Business Development Manager at IWayAfrica
  • Enterprise Client Account Manager at CloudFactory
  • Finance Manager at Pula
  • Health Informatics Specialist at ICF Incorporated
  • Operations Entrepreneur at WellPower Technologies, Inc.
  • Account Manager at WIPRO
  • Senior Deal Manager - Contracts Management at Oracle
Advertise your training programs and courses on MyJobMag
  • Filter Jobs
  • County | Search by region instead
    Field

    Industry

    Education

    Experience


    Also include jobs without defined experience

    Job Title

Display your company or industry jobs on your website or blog Get Started
 
 
Send your application through

Yahoomail Gmail Hotmail