I use these three sources, all are subscription services
American Civil War Research Database, Historical Data Systems, Inc. @ http://www.civilwardata.com
Fold3 @ http://www.fold3.com/
Ancestry.com
And, as a last resort, try a Goggle or Bing search Confederate Soldier Archer Avary