Job Opportunity- SQL Server Database Administrator at One Acre Fund

Company: One Acre Fund 

Post: SQL Server Database Administrator



We are seeking a Database expert with 5+ years of experience in Database Administration, Development and scaling of distributed databases.


LOCATION: Rwanda, 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.

Career Growth and Development

We have a strong culture of constant learning and we invest in developing our people. You’ll have weekly check-ins with your manager, access to mentorship and training programs, and regular feedback on your performance. We hold career reviews every six months, and set aside time to discuss your aspirations and career goals. You’ll have the opportunity to shape a growing organization and build a rewarding long-term career.

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

Preferred Start Date

ASAP

Compensation

Commensurate with experience.

Benefits

Health insurance, housing, annual flights, and other quality of life benefits.

Sponsor International Candidates 

Yes

Apply Now: https://oneacrefund.org/work-with-us/job-openings/g/?gh_jid=1263449

Job Opportunity- Data Scientist at One Acre Fund

Company: One Acre Fund 

Post:

Data Scientist

Seeking a data scientist to leverage One Acre Fund's central data warehouse to drive core business functions like repayment collection, client enrollment and retention, product adoption, and supply chain optimization.



LOCATION: Rwanda, Uganda

Job Description

One Acre Fund is seeking a Data Scientist to leverage our central data warehouse to drive core business functions like repayment collection, client enrollment and retention, product adoption, and supply chain optimization. A successful candidate in this role will be a pro-active and independent worker able to manage numerous internal and external relationships, scope and organize project needs, and communicate effectively with stakeholders along the full spectrum of data fluency. S/he will build relationships and learn 1AF operations to utilize the appropriate local context to design scalable and accessible decision support tools. The role will also support internal agronomic research efforts and provide support for using data to improve decision making across the organization.

• Improving accuracy and efficiency of core business functions - One Acre Fund collects information on what clients purchase, payment behavior, and client retention over seasons. A successful data scientist will leverage these data to build predictive models to support business decisions such as, “how do we proactively seek out defaulters?” and “how can we tailor our product marketing most effectively?” Success will be measured by empowering country programs to reach impact and scale targets with greater efficiency.
• Exploration – The Business Intelligence team manages the organization’s core data reporting system; we are tasked with identifying new impact opportunities for country research teams (Innovation Teams and field teams ) to assess and scale. A successful Data Scientist will deeply understand the ins and outs of the  field program so s/he can propose new global research programs, change the way that we approach existing analyses, and identify new avenues by which One Acre Fund can deliver data-driven impact to smallholder farmers.
• Adapting agronomic elements of the program to heterogeneous conditions – The Data Scientist will be responsible for working with internal and external agricultural scientists to analyze field crop yield gap drivers and develop agronomic hypotheses to be tested through on-farm trials. This will involve aggregation of weather, soil, pest and disease, and agronomic data to analyze the magnitude of various sources of yield variation in different areas of program operation. It will also involve coordinating with field teams to collect the data we need and setting and executing analysis plans.
• Capacity building and advising – We are looking for someone with experience and willingness to teach others and advise on organizational data and analytical decisions. A successful Data Scientist will enable and improve the analyses of other analysts both within the Business Intelligence Team, Agricultural Research Team, and in other departments. The data scientist will seek to use their experience and influence as an organizational data leader to affect how the organization at large utilizes data for decision making. Support topics may include questionnaire design and execution, efficient data cleaning, outlier management, model selection and interpretation, and predictive analyses.

Career Growth and Development

We have a strong culture of constant learning and we invest in developing our people. You’ll have weekly check-ins with your manager, access to mentorship and training programs, and regular feedback on your performance. We hold career reviews every six months, and set aside time to discuss your aspirations and career goals. You’ll have the opportunity to shape a growing organization and build a rewarding long-term career.

Qualifications

We are seeking an exceptional professional with 3+ years of experience, a demonstrated passion for development work, and a very strong knowledge of analysis and data science. Candidates who fit the following criteria are strongly encouraged to apply:

• MSc or PhD in a highly quantitative field such as data science, statistics, econometrics, computer science, or applied mathematics required.
• Knowledgeable in predictive and causal analyses in Python and R including:
  • Knowledge and experience in supervised and unsupervised machine learning  techniques: statistical tests, regression, Random Forest, Boosting, PLS, DNN, K-means clustering, etc.
  • Experience querying databases with SQL.
  • Experience visualizing/presenting data using ggplot, matplotlib, or seaborn.
  • Experience with field experiments and experimental design preferred. A successful candidate will understand how to derive causal estimates from structured experiments as well as other causal inference methods (e.g. regression adjustment, propensity score stratification), or quasi-experimental methods (e.g., instrumental variables, regression discontinuity, interrupted time series) and the appropriate statistical methods.
• Strong, independent self-starter with an emphasis on delivering results and communicating proactively with management and collaborators.
• Excellent written and verbal communication skills for coordinating across teams.
• Experience and comfort with geospatial analysis preferred.
• Professional or research experience in agriculture and/or development preferred. Interest in learning more about needs of smallholder farmers a must.
• Fluency in English required, Kiswahili and/or French a plus.
• A willingness to live and work in East Africa for at least two years.

Preferred Start Date

Early 2019

Compensation

Commensurate with experience.

Benefits

Health insurance, housing, annual flights and other quality of life benefits.

Sponsor International Candidates 

Yes. East Africans are strongly encouraged to apply.


Apply now: https://oneacrefund.org/work-with-us/job-openings/g/?gh_jid=1478717

Job Opportunity- Software Developer in One Acre Fund

Company: One Acre Fund 

Post: Software Developer

Use your programming skills and knowledge of database concepts to improve our existing technical systems.


LOCATION: Rwanda, Uganda

JOB DESCRIPTION 

One Acre Fund relies on a home-grown Client Management Information System to help us manage our field program information. As we grow our organization, we need to continually improve this system and facilitate its integration with third party tools. Currently, our Client Management Information System handles the enrollment of 180,000-300,000 smallholder farmers spread over multiple countries, records farm supply orders, manages the delivery of seed, fertilizer, and solar lights to clients, tracks millions of payment transactions, and creates a wide variety of business intelligence reports. 

Our database uses a distributed client/server model where field offices can perform data entry and run reports offline while syncing with a central server as needed (e.g., during times of poor internet connectivity). On the backend, the technologies used are SQL server 2014 with merge replication to field offices, while on the front end we use MVC.Net, Breeze.js, and Angular.js. As we are growing, we are looking to: 

• Improve our existing tools to capture a wide variety of program configurations per country and provide functionality for a multitude of field product and process innovations.  
• Provide central management and reporting tools while maintaining a focus on field usability. 
• Build out efficient bulk data entry functionality with a heavy focus on data quality control, as well as field-facing mobile and tablet data entry, and reporting where appropriate. 

The Developer will be based in Jinja, Uganda. S/he will be responsible for the following: 

• Producing a field-facing, mission-critical Program Management System. 
• Participating in the continued development of our mission-critical custom database, which impacts every aspect of the organization’s operations. 
• Developing features allowing for flexibility in the way individual countries run their operations, while still focusing on reusability across countries. 
• Maintaining a long-term perspective when faced with urgent operational demands.
• Working together with our small team of developers. 
• Maintaining coding standards and participating in peer code reviews. 
• Technology experimentation: Experimenting with a variety of technologies to improve operations. Investigating appropriate solutions for deploying upgrades, database scaling, and interacting with 3rd party software providers. 
• Operational insight: Becoming familiar with every aspect of our field operations and identifying areas for improvement in the tools we develop to support the field. 
• Other tasks: We are a young organization that is growing rapidly, which means all staffers pitch in to ensure we are providing the very best support and services to both our team and clients. 

CAREER GROWTH AND DEVELOPMENT 

We have a strong culture of constant learning and we invest in developing our people. You’ll have weekly check-ins with your manager, access to mentorship and training programs, and regular feedback on your performance. We hold career reviews every six months, and set aside time to discuss your aspirations and career goals. You’ll have the opportunity to shape a growing organization and build a rewarding long-term career.

QUALIFICATIONS 

We are seeking an exceptional professional with 2+ years of experience, solid programming skills, and a knowledge of database concepts to improve our existing technical systems. Candidates fitting the following profile are strongly encouraged to apply: 

• 2+ years of work or internship experience in a professional environment.
• Solid programming skills. C#/MVC.Net/Breeze.js/Angular.js preferable, but not required. 
• Knowledge of database concepts and SQL/Linq.
• Very strong self-manager. After an initial six-month period of heavy mentorship, supervision will consist of one weekly check-in. Accordingly, we need someone who is very well-organized and can manage their work independently. 
• Willingness to commit to the position for at least two years. 
• Experience living in a developing country is desired, but not a requirement.  
• Language: English required, French is a plus. 

PREFERRED START DATE 

ASAP 

LOCATION

Jinja, Uganda or Kigali, Rwanda

DURATION

Full-time job.

COMPENSATION 

Commensurate with experience.

BENEFITS 

Health insurance, housing, annual flights, and other quality of life benefits.

SPONSOR INTERNATIONAL CANDIDATES

Yes

East Africans strongly encouraged to apply.

Apply Now: https://oneacrefund.org/work-with-us/job-openings/g/?gh_jid=79552

Job Opportunity- Senior Software Developer in One Acre Fund

Company: One Acre Fund 

Post: Senior Software Developer

Looking for experienced developers to build solutions in C#/Angular that empowering our field team to enroll and deliver high-quality inputs to smallholder farmers in East Africa and across the world.

LOCATION: Rwanda, Uganda

JOB DESCRIPTION 

One Acre Fund relies on a custom Client Management and ERP Information System to help us manage our field program information. Currently, our Client Management Information System handles the enrollment of almost a million smallholder farm families spread over multiple countries, records farm supply orders, manages the delivery of seed, fertilizer, and solar lights to clients, tracks millions of payment transactions, and creates a wide variety of business intelligence reports.

The Senior Software Developer will be based in rural, Eastern Uganda. S/he will be responsible for the following:

• Writing, testing, and deploying as part of a collaborative team for our MS-SQL/C#/Angular stack.
• Participating in the continued development of our mission-critical custom database, which impacts every aspect of the organization’s operations.
• Developing features allowing for flexibility in the way individual countries run their operations, while still focusing on reusability across countries.
• Maintaining coding standards and participating in peer code reviews.
• Operational insight: Becoming familiar with every aspect of our field operations and identifying areas for improvement in the tools we develop to support the field.
• Other tasks: We are an organization that is growing rapidly, which means all staffers pitch in to ensure we are providing the very best support and services to both our team and clients.

CAREER GROWTH AND DEVELOPMENT 

We have a strong culture of constant learning and we invest in developing our people. You’ll have weekly check-ins with your manager, access to mentorship and training programs, and regular feedback on your performance. We hold career reviews every six months, and set aside time to discuss your aspirations and career goals. You’ll have the opportunity to shape a growing organization and build a rewarding long-term career.

QUALIFICATIONS 

We are seeking an exceptional professional with 5+ year(s) of work experience and ideally a demonstrated passion for our mission. Candidates who fit the following criteria are strongly encouraged to apply:

• Strong work experiences. Examples include a demanding professional work experience, or successful entrepreneurial experience, e.g. starting a field program in a developing country, leading a conference, starting a business, solid Volunteer Service Organization accomplishments.
• Leadership experience at work, or outside of work. Multiple years team management experience a plus
• Experience with enterprise systems a plus.
• Professional experience with at least two of: C# (ASP.NET MVC), MS-SQL and T-SQL, or Angular/AngularJS. Demonstrable full-stack experience a plus.
• A willingness to commit to living in rural areas of East Africa for at least two years.
• Language: English required in all locations.

PREFERRED START DATE 

ASAP

LOCATION

Jinja, Uganda and Kigali, Rwanda

DURATION

Full-time job.

COMPENSATION 

Commensurate with experience.

BENEFITS 

Health insurance, housing, annual flights, and other quality of life benefits.

SPONSOR INTERNATIONAL CANDIDATES

Yes

East Africans strongly encouraged to apply.

Apply Now: https://oneacrefund.org/work-with-us/job-openings/g/?gh_jid=525857

Unlimited Photos and Videos backup free in Google Photos

Unlimited Photos and Videos backup free in Google Photos

In this video I have shown how you can Back up Photos and Videos from Mobile to Google Photos.

Please watch till the end of the video, I hope you will enjoy it.

If you have enjoy  the video, please go ahead and like it.

Write us in comment how helpful this video for you. If you think this might be helpful for your friends, Please share the video with your friends.

If you have any question, regarding the video, Please write us through comments.

Please join in our community through subscription of channel and subscription of video notification.

In triksbuddy channel, you will get different interesting tech stuffs that will help you enrich your technology knowledge. Please subscribe our channel to get updates of our videos. Subscription link: https://goo.gl/GE4g8v

Please subscribe in below link and like our video.

Subscription URL: https://goo.gl/GE4g8v
Channel URL: https://goo.gl/VYi58K
Most Recent Videos: https://goo.gl/hXFN4w
Most Popular Video: https://goo.gl/7u7B1x


Social:
Facebook: https://www.facebook.com/triksbuddy/
Linked in: https://www.linkedin.com/company/triksbuddy/
Blog: https://triksbuddy.blogspot.com/
Tumblr: https://www.tumblr.com/blog/imrulquaes89
RSS Feed: https://www.youtube.com/feeds/videos.xml?channel_id=UCKFouta2JOolZmAmHeo3ZKw

Convert PDF To JPG with zamzar.com