Database Administrator at M-Kopa
M-KOPA Solar, headquartered in Nairobi, Kenya, is the global leader of “pay-as-you-go” energy for off-grid customers.
The company was founded in 2011 by former executives behind M-PESA (the world’s leading mobile payment platform) on the belief that mobile technology could revolutionize energy services in emerging markets the same way it has already revolutionized the delivery of communications and financial services.
Database Administrator
M-KOPA is seeking a skilled and motivated Database Administrator to help manage M-KOPA’s database servers and applications.
Location: Nairobi, Kenya
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
Remuneration: The position comes with a competitive and generous salary package reflective of the candidate’s experience and skills.
To Apply
To apply, send an updated detailed copy of your well named and labelled CV and a cover letter expressing why you feel you would be an excellent candidate for the role to applications@m-kopa.com with only the subject “Database Administrator” in the title.
