One Acre Fund SQL Server Database Administrator - Jobs in Uganda
One Acre Fund SQL Server Database Administrator - Jobs in UgandaJob Description
One Acre Fund has several applications implemented in a SQL server merge replicated architecture using web synchronization to a hosted server.
There are nearly 100 locations in 8 different countries, which communicate with our main production server through merge replication.
In addition, we are using transactional replication to other hosted servers for various database loads.
As the number of locations and countries grows over time, we are seeking an exceptional professional to serve as SQL Server Developer/Administrator who can build and improve on our current database 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.Database backups and security
The SQL Server Administrator will perform the following and other duties as assigned:
Create and maintain security policies for developers connecting to SQL server.
Monitor and test automated backups, ensure offsite storage, and perform consistency checks.
Evaluate server performance and make recommendations for improvements to the server administrator
Maintain and test disaster recovery and emergency failover procedures.
Database architecture ownership and performance tuning
Make recommendations on the database schema to meet business objectives
Make recommendations on database structure to conserve space and ensure sustainable storage requirements
Monitor indexes and query execution plans and suggest improvements
Implement archiving strategies
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.
SupportMaintain and improve field location database maintenance scripts.
Monitor field location database performance.
Monitor replication performance.
Assist local IT staff with troubleshooting in case of connectivity problems with the database.
OtherOur IT needs keep growing and the SQL Server Administrator may be asked to help out in other areas occasionally.
We are seeking an exceptional professional with 5 years of work experience and ideally a demonstrated passion for our mission. Candidates who fit the following criteria are strongly encouraged to apply:
Excellent communication skills.
The person in this position will have to communicate with team members remotely on a regular basis.
Strong previous experience in database administration
Experience with database optimization strategies, query plan analysis and resource profiling
Experience with replication a plus
Expert T-SQL skills, strong scripting skills, and the ability to create clear documentation.
Previous experience with server/network administration a plus.
English required; French a plus.
A tremendous attention to detail
How to Apply
Interested and qualified candidates should apply online by 9th June 2019
For more information and job application details, see; One Acre Fund SQL Server Database Administrator - Jobs in Uganda
Find jobs in Uganda. Jobs - Uganda jobs. Search our career portal & find the latest Ugandan job positions, career opportunities & jobs in Uganda.
Jobs in Uganda - banking jobs, IT jobs, accounting jobs, NGO jobs, business administration, ICT, UN jobs, procurement jobs, education jobs, hospital jobs, human resources jobs, engineering, teaching jobs, and other careers in Uganda.
Find your dream job from 1000s of vacancies in Uganda posted and updated daily - click here!
Click here to post comments
Join in and write your own page! It's easy to do. How? Simply click here to return to Jobs in Uganda.