SQL Server offers various job roles such as Administrators, Developers, and Business Analysts etc. Companies are hiring professionals who have strong knowledge of Microsoft® SQL Server administration and development as well.
Most of the recruiter will look for if you to have the complete hands on knowledge on SQL Server BI (Business Intelligence) along with SQL Development knowledge.
Thus if you are planning to choose a career in SQL, our best recommendation would be to learn it completely instead of picking one between Admin, Developer or BI role.
This will maximize the chances of securing job with top organizations, and ensuring long term career growth.