One Acre Fund SQL Server Database Administrator - Jobs in Uganda

One Acre Fund SQL Server Database Administrator - Jobs in Uganda


Job 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.

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

  • Database backups and security
  • 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.

    Support

  • Maintain 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.

    Other

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

    Qualifications
  • 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.

    Scholarship 2019/20

    Undergraduate Scholarships 2019/2020
    Masters Scholarships,
    PhD Scholarships,
    International Scholarships.