Upgrading MY Preformance

Hello all! I'm a newly appointed database administrator and have been
struggling with my consious about what would make me an excellent
database administrator. I've worked in Access for years and know that
if your comfortable with:
1. writing expressions
2. writing some VBA
3. the basics with Tables, Forms, Queries and Reports.

and you'd be sitting pretty. SQL Server is a little more robust than
Access and i'm not sure where I should start.

I'm comfortable with writing T-SQL statments, backing up, and creating
users. but other than that, i'm a little lost on what else i should
know.

thanks.