Job Title: Database Administrator
Location: Nairobi, Kenya
Start Date: ASAP
Reporting to: Head of Technology
Company Description: A leading international company (setting up an
office in Nairobi) - Digital agency.Location: Nairobi, Kenya
Start Date: ASAP
Reporting to: Head of Technology
Job Details:
- 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 company's 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 the company's Windows servers
- Provide the company's application support to
end users
- Build and deploy new Windows servers
- Willingness to work shifts that may cover
weekends and holidays
Skills & Experience
Requirements:
Requirements:
- 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
- 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
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.
Strictly: Only those candidates who meet the above mentioned qualifications should submit their resumes to apply@dumaworks.com with the subject line DATABASE ADMINISTRATOR , your name and phone number. (Candidates to be contacted before Jan 9th, 2015)
Strictly: Only those candidates who meet the above mentioned qualifications should submit their resumes to apply@dumaworks.com with the subject line DATABASE ADMINISTRATOR , your name and phone number. (Candidates to be contacted before Jan 9th, 2015)