Sustainable energy supply, which is defined as the production of the energy required by social life through uninterrupted, reliable, timely, clean and economical ways and its supply at the most affordable prices, is of great importance for developed and developing countries. Hydroelectric power plants which is the most advanced renewable energy technology with approximately 20% share of the world energy mix has critical importance for the realization of sustainable energy supply in Turkey as well as all over the world. Hydroelectric power plants have a shift work schedule as in all electricity generation power plants. It is important that scheduling the personnel, who ensure to keep from longterm failures that can occur and to continue uninterrupted generation in these continuous production facilities analytically in line with the demands of the company and legal obligations. Starting from this, in this study, the problem of scheduling of personnel working in a hydroelectric power plant has been addressed. For the solution of the problem, the model in which constraint programming and goal programming are integrated has been proposed for the first time in the literature. As a result of the solution of this integrated model created with real data, an optimal 31-day schedule was obtained for 28 staff working in 3 shifts. The demands of the company and the satisfaction of the personnel were ensured by making a fair and balanced appointment among the shift teams in the new schedule.