Use ProQuest Congressional to search for confirmation/nomination hearings. Limit to hearings and to the time period of interest for e.g. secretary of the Dept. of Homeland Security: (confirmation OR nomination) AND secretary AND ("homeland security" OR DHS)
Lists of positions
United States Government Policy and Supporting Positions (Plum Book) (via govinfo)