Private-sector style career development in a growing social enterprise
An excellent career development opportunityIndustry: Nonprofit/International Development
Function: SQL Server administration/systems administration, training
Employer: One Acre Fund
Job Title: SQL Server Administrator
Job Location: East AfricaDuration: Minimum 2 years commitment, full-time jobMost 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 growing NGO in Kenya, Rwanda, Burundi, and Tanzania that is innovating a new way of helping farm families to achieve their full potential. Instead of giving handouts, One Acre Fund 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 50-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 eight years, we have grown to serve 180,000 farm families with more than 2000 full-time field staff. Our approach has won widespread validation, winning grants from The MasterCard Foundation and Gates Foundation.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 ResponsibilitiesThe SQL Server Administrator will perform the following and other duties as assigned:Server maintenance and securityCreate and maintain security policies for developers connecting to SQL serverIn addition to database security monitor firewall settings and prevent intrusion attemptsMonitor and test automated backups, ensure offsite storage and perform consistency checksEvaluate Server performance and make recommendations for improvementsAnticipate scaling needsCreate disaster recovery and emergency failover proceduresCommunicate with our developers and field operations teamAct as gatekeeper for direct data manipulation/cleaning requestsCreate scripts for setting up a test environment with production data for developersCreate and maintain a training environment tailored to different country program needsAssist with database architecture changes and staging data migrationsSupportMaintain and improve client installation scriptsMonitor client database performanceMonitor replication performanceAssist local IT staff with troubleshooting in case of connectivity problems with the databaseNew country setupProvide trainings for our main database tools to new Country Directors and BookkeepersAssist new countries with hiring local IT staffOtherOur IT needs keep growing and the SQL Server Administrator may be asked to help out in other areas occasionally.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.The successful candidate will have:Excellent communication skills. The person in this position will have to communicate with team members remotely on a regular basisKnowledge of SQL server and replication, strong scripting skills, and the ability to create clear documentationPrevious experience with server/network administration a plusEnglish required; French a strong plusThe following personal attributes are desired:A deep and genuine commitment to serving the poorA passion for One Acre Fund’s programA tremendous attention to detailHumility and positive attitudeHealth insurance, immunizations, flight, room and board.Sponsor International CandidatesComplete this form (http://myjotform.com/form/40471746260553). You will be prompted to submit your CV and cover letter. You may also be asked to submit work samples for some positions. Returned Peace Corps Volunteers (RPCVs), please submit a copy of your Description of Service (DOS) in the appropriate section.
0 Comments