What type of music is string bass used in?

In the concert band, string basses are often found doubling the tubas, given their ability to sustain notes indefinitely, as well as provide a more percussive pizzicato sound than the tubas can. In transcriptions, they often play highly technical orchestral bass parts that can't be reasonably reproduced on a brass instrument.