In response to the requirements of a domestic aluminum deep-processing enterprise for a stacker crane to lift heavy aluminum coils in an automatic stereoscopic warehouse, a design for a hoisting mechanism suitable for hoisting super heavy weight cargo is proposed, that significantly enhances the conventional dual-column stacker crane, with a specific focus on improving its capability to lift super heavy aluminum coils. This structure, featuring symmetrically arranged double set of pulley systems paired with a dual hoisting drive, is designed for narrow aisle spaces and meets all design requirements. The pulleys in each set arranged in pairs on the same axis, and the hoisting drive design effectively reduces radial forces to ensure the safety and stability of the hoisting mechanism. Finally, the structure was optimized through a compact design that effectively reduced the stacker crane’s slenderness ratio. Parametric modeling and finite element analysis were used to optimize the size parameters of the upper crossbeam, achieving a 7.84% reduction in weight and effectively light weighting the structure. The design and optimization results provide theoretical references for the production and practical application of super heavy load stacker crane hoisting mechanisms.