In the Flintstones live-action films, he was portrayed by John Goodman.
Fred was a caveman, living in the prehistoric fictional city of Bedrock with his wife Wilma and their infant daughter Pebbles. His next-door neighbors were Barney Rubble, his wife Betty, and their toddler son Bam-Bam. Barney was his best friend.
He worked at a quarry preparing and cutting the stones that were used for just about everything in his "modern stone-age" city. Barney worked at the quarry with Fred.
His catch phrase was "Yabba Dabba Doo!" He worked for Mr. Slate at the quarry.