Description
Most of the world’s
poor are farmers, representing the largest and most uniform group of poor
people in the world. One Acre Fund is a start-up NGO in Kenya, Rwanda, and Burundi
that is innovating a new way of helping farm families to achieve their full
potential. Instead of giving handouts, One Acre invests in farmers to generate
a permanent gain in farm income. We provide farmers with a “market
bundle” that includes education, finance, seed and fertilizer, and market
access. Our program is proven impactful – every year, we weigh thousands of
harvests and measure more than 100% average gain in farm income per acre. We
have laser-like focus on generating better lives for the people that we serve.
We are growing
quickly. In six years, we have grown to serve 130,000 farm families with more
than 1000 full-time field staff. In three more years, we will at least
quadruple in size, while adding several new countries. Our approach has won
widespread validation, winning grants from the highly competitive Echoing Green
and Skoll Foundations, and the global Financial Times/ IFC award for
“basic needs financing” in 2010 and 2011. Website: www.oneacrefund.org
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.
Professional
Qualifications
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 - English
required; French a strong plus
Personal
Attributes
The following personal
attributes are desired:
- A deep
and genuine commitment to serving the poor - A
passion for One Acre Fund’s program - A
tremendous attention to detail - Humility
and positive attitude - A sense
of humor
Preferred
Start Date:
Flexible
Compensation: Commensurate with
experience.
Benefits: Health cover, immunizations,
flights. Career
development: Bi-annual management consulting-style career
reviews, and significant investment in career development. Your manager will
invest significant time in your career development.
How
to apply
To Apply
- Complete
this form. - Email
cover letter and resume to Itjobs@oneacrefund.org
(Subject line: “SQL Server Administrator Search” + name of the
site that referred you). - If you
are a Returned Peace Corps Volunteer (RPCV), please submit a copy of your
Description of Service (DOS).
