stylish ji:
Yes I agree with acbel ji. Lots of guys think DBA is easier then Developer considering only using GUI tools and wizards, in fact it’s true in some way but when you get real problems in DBA, you have to solve it immediately but as far for Developer they get certain deadlines for specific task. And DBA jobs are more responsible and risky job too.
If you have developer experience you can move into DBA easily DBA-Dev is not so easy. In MS SQL the main Tasks are:
- Installing and upgrading SQL Server
- Monitoring the database server's health and tuning it accordingly
- Using storage properly
- Backing up and recovering data
- Managing database users and security
- Establishing and enforcing standards
- Performing data transfer
- Setting up and maintaining data replication
- Setting up server scheduling
- Providing 24-hour access
- Working with development teams
But if you chose as MS SQL developer you have 3 major fields make you carrier:
- Report Developer
- ETL(Integration service) developer
- Data Analyst
The main Responsible for developer as vary on their job but basically the following main tasks are:
- Write a function and store procedures.
- Quarry tuning
- Develop , maintain and deploy packages(for ETL dev)
- Develop , maintain and deploy Cubes and dimension (for Analyst)
- Develop , maintain and deploy Reports( for Reporter)
I would suggest you go for reporting. Its best way to start of SQL developer. And job market for Report developer is really good.
So all the best….