One Acre Fund ,QL Server Administrator Jobs in Rwanda

Job description

Job Description

One Acre Fund has several
applications implemented as a SQL server merge replicated architecture using
web synchronization to a hosted server. There are nearly 40 locations in 5
different
countries which communicate with our main production server. In
addition we are replicating data to a separate hosted server for business reporting.

As we expect the number of
locations and countries to grow over time, we are seeking an exceptional
professional to serve as SQL Server Administrator who can build and improve on
our current server architecture, as well as plan ahead for future scaling. In
addition the SQL Server Administrator will assist with trainings when One Acre
Fund expands to new countries.

The SQL Server Administrator will
start off in one of our field countries for the first 12 months, after which
they can negotiate relocating. During the initial period some general IT
administration tasks will be required and there will be the opportunity to
understand the technical constraints a lot of our field offices are under.

Primary Duties and
Responsibilities The SQL
Server Administrator will perform the following and other duties as assigned:

Server maintenance and security.

Create and maintain security
policies for developers connecting to SQL server.
In addition to database security,
monitor firewall settings and prevent intrusion attempts.
Monitor and test automated backups,
ensure offsite storage and perform consistency checks.
Evaluate Server performance and make
recommendations for improvements.
Anticipate scaling needs.
Create disaster recovery and
emergency failover procedures.

Communicate with our developers and field operations
team.

Act as gatekeeper for direct data
manipulation/cleaning requests.
Create scripts for setting up a test
environment with production data for developers.
Create and maintain a training
environment tailored to different country program needs.
Assist with database architecture
changes and staging data migrations.

Support.

Maintain and improve client
installation scripts.
Monitor client database performance.
Monitor replication performance.
Assist local IT staff with
troubleshooting in case of connectivity problems with the database.

New country setup.

Provide trainings for our main
database tools to new Country Directors and Bookkeepers.
Assist new countries with hiring
local IT staff.

Other

Our IT needs keep growing and the
SQL Server Administrator may be asked to help out in other areas
occasionally.

Career Growth and
Development One Acre
Fund invests in building management and leadership skills. Your manager will
invest significant time in your career development. We provide constant,
actionable feedback delivered through mentorship and through regular management
consulting-style career reviews. We also have regular one-on-one meetings,
where we listen to and discuss career goals, and work collaboratively to craft
roles that each person can be passionate about. Because of our rapid growth, we
constantly have new high-level roles opening up and opportunities in many
functions. This results in fast career growth for our staff.

Qualifications

Professional Qualifications
and Attributes

The successful candidate will
have:

Excellent communication skills. The person in this
position will have to communicate with team members remotely on a regular
basis.
Knowledge of SQL server and replication, strong
scripting skills, and the ability to create clear documentation.
Previous experience with server/network administration a
plus.
Language: English required; French a strong plus.

Personal Attributes

The following personal attributes
are desired: