Database Optimization Expert

Who we are:
Pillar is an Israeli and Ukrainian company. Since 2015, we provide outsourcing and out staff services to world-class companies all over the world.

Every day we partner across functional areas: logistics, medicine, education, tourism, the game industry, utilities, data storage, etc.
We work in a flexible environment where there is an opportunity to achieve results, receive feedback for learning, improve ways of working by developing both soft and hard skills, and contribute to a corporate culture focused on people.

Our team is highly experienced, and all the projects we work on are solid and long-term as our clients appreciate our expertise and stay with us for a long time.
We are also keen on learning from each other, which is why we cheerfully meet people who bring a new set of experiences and backgrounds to our team.

About the project:
As Bhutan gears toward becoming a fully digitally transformed nation, it is critical to
look at the IT application systems from the Whole-of-Government (WOG) approach.
Although in the last decade and a half, the Government has initiated the development
of ICT systems to automate many government services with the aim to provide systematic services, improve efficiency and increase productivity, these systems triggered the need for process automation of public service delivery in Bhutan.

Further, several targeted reforms and initiatives after 2014 such as the e-Government
Master Plan, e-Government Interoperability Framework (e-GIF), e-Gov Management System, and sectoral EA by a few agencies particularly the Ministry of Health and the Ministry of Economic Affairs have brought renewed coordination and collaboration
among service delivery agencies.

However, the constant advancement of technology and its trends and rising demands for
public services from the citizens on the one hand, and the existence of multiple fragmented systems still in the ecosystem on the other hand has not brought in the much-needed efficiency gain in the RGoB. Thus, the need for a WoG (Whole of Government) perspective was felt ever crucial.

The purpose of embracing the WoG approach is to develop integrated systems that cut across various sectors, sub-sectors, and activities. Such a holistic approach can help break existing sectoral barriers and silos by re-architecting common government services as a single system which could improve overall governance and efficiency and create values for the citizens.
Considering the above issues in our existing systems, the Department requests proposals from qualified individuals to assess and perform comprehensive Solution Architecture for Application Systems in the Royal Government of Bhutan (RGoB) that are developed on different platforms, in order to achieve an integrated common ecosystem so that the system functions in an ERP-like model – From planning to HR to payroll to procurement and expenditure on one hand and delivery of one-stop citizens services on the other hand.

About the role:

The Bhutan Government are looking for a Database Engineer with 6+ years of solid hands-on database design and development experience with one or more of the following database technologies: PostgreSQL/MySQL, to help them in assessing the current (300+) systems in the country, and to advise what should be changed in those systems (complete rewrite or nothing) to make them better and solid. The Database Engineer is supposed to be involved in the project for up to 2 years and work according to Bhutan Standard Time (+6 GMT).

What you’ll do:

• Optimize Database design during development and DB currently in the production environment.
• Designing DB clusters. 
• High Availability (HA).
• Knowledge transfer to Local team.
• Rectify the issues/ errors and challenges accordingly.
• On-site visits with the management to optimize, train, and develop the technical set-up and the local development team.

What you’ll need:

Must:

• Good level of English: B2 (speaking and writing).
• 6+ years of solid hands-on database design and development with one or more of the following database technologies: PostgreSQL/MySQL.
• Any experience with Oracle DB.
• Any experience with NoSQL (MongoDB).
• Any experience with Scripting languages: Python, Bash.
• Expertise in database server specification, performance tuning, analysis, and optimization.
• Demonstrated ability to solve complex database administration problems.
• Ability to work with database developers, engineers, and different operations and applications engineering teams to help them to identify, analyze, and resolve database performance issues.
• Team player, flexible, and able to work in a fast-paced environment.

Nice to Have:

• Experience with Load Balancer: Any hardware-based load balancer.
• Experience in the Public Sector is preferred.