Oil will bottom in the mid-$40s and Saudi Arabia will begin to curb production "pretty soon," Rocky Mount Resources CEO Chad Brownstein told CNBC Thursday.

That means there is an opportunity now for investors to dip their toe in the water and buy certain names in the oil services sector, he said.