Database Administrator
M-KOPA is a mobile technology company that uses mobile payments to offer consumer financing for energy products and services, targeted at off-grid users. The M-KOPA payment system uses mobile payments as a way to pay slowly for renewable energy for a range of applications such as solar lighting or mobile charging.
M-KOPA is seeking a skilled and motivated Database Administrator to help manage M-KOPA’s database servers and applications.
The following video will help understand what M-KOPA is all about:
The following video demonstrates what it is like to work at M-KOPA:
The Position
Title: Database Administrator
Location: Nairobi, Kenya
Start Date: ASAP
Reporting to: Head of Technology
Responsibilities Include:
Contributing to the design and implementation of SQL Server installations and SQL Based
applications both on-premises and cloud-hosted.
Continuous performance improvement through the analysis and possible modification of stored
procedures, indexes, views, compression and other tuning activities.
Configuration and maintenance of SQL Server installations supporting the M-KOPA cloud platform
and business services. Ensuring that the business’s Recovery Point Objectives (RPO) and
Recovery Time Objectives (RTO) can be met through the use of cloud services and high
availability schemes.
Troubleshoot SQL Server operational issues as they occur, including after-hours and weekends
Configure SQL Server monitoring utilities to minimize false alarms
Maintaining operational documentation related to the company’s database environment
Manage M-KOPA’s Windows servers
Provide M-KOPA application support to end users
Build and deploy new Windows servers
Willingness to work shifts that may cover weekends and holidays
Skills & Experience
Required:
3 years or more in a lead database administrator role for SQL Server
Hands-on experience of working with SQL Server 2012 and above
Experience working with Windows server and Active Directory in the context of SQL Server
installation and operation.
Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler
and other related monitoring and troubleshooting tools.
Experience in troubleshooting and resolving database issues such as database integrity,
performance, blocking and deadlocking, replication amongst others.
Experience with backups, restores and recovery models.
Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.
Knowledge of indexes, index management, and statistics.
Ability to write and troubleshoot TSQL and design (stored procedures, functions, tables, views,
triggers, indexes, constraints)
Ability to effectively communicate and work closely with M-KOPA staff to determine needs and
assist with systems requirements.
Excellent written and verbal communication skills
Desirable:
Experience in SQL Server 2014 and In-memory databases
Experience in the installation and configuration of Windows Server 2012
Experience in building and maintaining applications using the .NET framework
Working in a web application development environment
Experience managing virtual servers using VMWare or HyperV platforms
Microsoft SQL DBA Certification will be considered a big plus
MCSE certification will be considered a plus
Knowledge in a scripting language like PowerShell will be a plus
Experience working with monitoring tools such as PRTG
Experience of SQL Server in a cloud-hosted environment and/or SQL Azure
Contacts:
To apply, please go to the Jobs section on the M-KOPA website and submit your application by September 30th 2014. Only candidates who can demonstrate sufficient competence will be shortlisted and contacted.
M-KOPA is a mobile technology company that uses mobile payments to offer consumer financing for energy products and services, targeted at off-grid users. The M-KOPA payment system uses mobile payments as a way to pay slowly for renewable energy for a range of applications such as solar lighting or mobile charging.
M-KOPA is seeking a skilled and motivated Database Administrator to help manage M-KOPA’s database servers and applications.
The following video will help understand what M-KOPA is all about:
The following video demonstrates what it is like to work at M-KOPA:
The Position
Title: Database Administrator
Location: Nairobi, Kenya
Start Date: ASAP
Reporting to: Head of Technology
Responsibilities Include:
Contributing to the design and implementation of SQL Server installations and SQL Based
applications both on-premises and cloud-hosted.
Continuous performance improvement through the analysis and possible modification of stored
procedures, indexes, views, compression and other tuning activities.
Configuration and maintenance of SQL Server installations supporting the M-KOPA cloud platform
and business services. Ensuring that the business’s Recovery Point Objectives (RPO) and
Recovery Time Objectives (RTO) can be met through the use of cloud services and high
availability schemes.
Troubleshoot SQL Server operational issues as they occur, including after-hours and weekends
Configure SQL Server monitoring utilities to minimize false alarms
Maintaining operational documentation related to the company’s database environment
Manage M-KOPA’s Windows servers
Provide M-KOPA application support to end users
Build and deploy new Windows servers
Willingness to work shifts that may cover weekends and holidays
Skills & Experience
Required:
3 years or more in a lead database administrator role for SQL Server
Hands-on experience of working with SQL Server 2012 and above
Experience working with Windows server and Active Directory in the context of SQL Server
installation and operation.
Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler
and other related monitoring and troubleshooting tools.
Experience in troubleshooting and resolving database issues such as database integrity,
performance, blocking and deadlocking, replication amongst others.
Experience with backups, restores and recovery models.
Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.
Knowledge of indexes, index management, and statistics.
Ability to write and troubleshoot TSQL and design (stored procedures, functions, tables, views,
triggers, indexes, constraints)
Ability to effectively communicate and work closely with M-KOPA staff to determine needs and
assist with systems requirements.
Excellent written and verbal communication skills
Desirable:
Experience in SQL Server 2014 and In-memory databases
Experience in the installation and configuration of Windows Server 2012
Experience in building and maintaining applications using the .NET framework
Working in a web application development environment
Experience managing virtual servers using VMWare or HyperV platforms
Microsoft SQL DBA Certification will be considered a big plus
MCSE certification will be considered a plus
Knowledge in a scripting language like PowerShell will be a plus
Experience working with monitoring tools such as PRTG
Experience of SQL Server in a cloud-hosted environment and/or SQL Azure
Contacts:
To apply, please go to the Jobs section on the M-KOPA website and submit your application by September 30th 2014. Only candidates who can demonstrate sufficient competence will be shortlisted and contacted.