The sustainability of groundwater aquifers requires evaluating several parameters, the most important of which are hydraulic parameters. Therefore, the essential aim of this research is to develop a management plan for the Moghra aquifer in order to prevent the expanding of water level decline and degradation of groundwater quality due to overexploitation and scarcity of recharge. To achieve this goal, all aquifer hydraulic parameters such as transmissivity, hydraulic conductivity, radius of interference, specific capacity, resulted drawdown, well loss, formation loss, well efficiency, and optimum safe yield had been measured for 40 groundwater wells drilled in the new reclaimed areas of Moghra Oasis. Based on geographic information system (GIS), hydrogeological cross sections and thematic maps for all parameters were created such as aquifer thickness, water table, groundwater flow direction, drawdown and groundwater salinity maps. The results revealed that clay and shale beds separated the three water-bearing formations of the Moghra aquifer. The aquifer-saturated thickness ranged from 30 and 102 m, and the groundwater level was below the mean sea level for all wells (ranges from − 72 to − 26.6 m). The calculated hydraulic parameters based on the analysis of long-duration pumping tests indicated that the studied aquifer has a wide variety of transmissivity (T) between 631 and 3768 m2/day, hydraulic conductivity (K) between 13.4 and 104.6 m/day, radius of influence from 126.3 to 581.3 m and specific capacity between 377.14 and 883.72 m2/day. On the other hand, the evaluation of existing drilled wells performance based on the results of step tests showed that well loss coefficient ranges between 0.0004749 and 0.0676 (h2/m5), formation loss coefficient varies from 3.34 × 10–8 to 4.80 × 10–6 (h/m2), well efficiency (γ) ranged from 50.53 to 98.08%, and optimum safe yield ranged from 40 to 98 (m3/h). Results of aquifer mapping and pumping tests can be more important for solving water scarcity issues, non-polluting water issues, health issues, and source of fresh water on the surface of the earth. The characterization of aquifer parameters in the study area, however, should be a significant component in the scientific planning and sustainability of groundwater.