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.
M-KOPA is seeking a
skilled and motivated Database Administrator to help manage M-KOPA’s database
servers and applications.
The Position: 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
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:
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.