Azure certification for SQL DBA

Question

Azure certification for SQL DBA

TJDBA

Default port

Points: 1490
More actions
October 30, 2016 at 3:48 pm

#318486

Hello,
I know this is an off topic post, but please help me out.
I am a sql server dba with 10 years exp. I wanted to expand my skillset as I find that the sql DBA scope is getting narrower.
I am thinking of doing Azure certification, but i am not sure if that is the right career path for a DBA.
Please help me with suggestions in the right direction in this regard.
Thanks
T

Viewing 15 posts - 1 through 15 (of 15 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004600 More actions · Answer 1

tauseef.jan (10/30/2016)
Hello,
I know this is an off topic post, but please help me out.
I am a sql server dba with 10 years exp. I wanted to expand my skillset as [font="Arial Black"]I find that the sql DBA scope is getting narrower.[/font]
I am thinking of doing Azure certification, but i am not sure if that is the right career path for a DBA.
Please help me with suggestions in the right direction in this regard.
Thanks
T

What is it that you think a DBA does or should be doing?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

TJDBA Default port Points: 1490 More actions · Answer 2

hi,

maybe i did not make myself clear. I wanted to ask that is 70-533 (implementing and deploying azure ) the right career path to take

T

Jeff Moden SSC Guru Points: 1004600 More actions · Answer 3

tauseef.jan (10/30/2016)
hi,
maybe i did not make myself clear. I wanted to ask that is 70-533 (implementing and deploying azure ) the right career path to take
T

Understood and you made yourself clear. I'm asking what you think a DBA actually does before I try to answer your question. The reason I want to know is (for example), I've done nothing with Azure but get 1-4 calls from recruiters every week.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

TJDBA Default port Points: 1490 More actions · Answer 4

hi,

As a DBA I am involved with devising and implementing backup/restore plans, HA/DR solutions, migrating of servers, performance tuning etc.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

tauseef.jan (10/30/2016)
I am thinking of doing Azure certification, but i am not sure if that is the right career path for a DBA.

Up to you. You can look at the cloud side, you can look at the dev side, you can look at the BI side, you can look at the machine learning side, etc. I generally recommend that people get a broad understanding of what's around their field, if for no other reason than when someone comes and asks about 'technology X', you can give them a high level view and you know where to get more information.

Personally, I would say that getting at least familiar with the Cloud side of the DB business is important, you'll likely get inquiries about whether to move databases to one cloud or another, whether to implement new systems in one cloud or another or earthed, about what features of the vendors cloud offerings will be of use to the business (and there are a lot of features and offerings).

On the Azure side, MS has made it clear that they're working cloud-first, new features go into Azure and later into the earthed SQL product (and there are some nice new features coming)

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Jeff Moden SSC Guru Points: 1004600 More actions · Answer 6

tauseef.jan (10/30/2016)
hi,
As a DBA I am involved with devising and implementing backup/restore plans, HA/DR solutions, migrating of servers, performance tuning etc.

I have to agree with Gail and, in that vein and based on what you've been doing, it would be very worthwhile to take the 70-533 course. I'll also state that if you get really good at T-SQL and indexing so really sharpen your skills in the performance-tuning area, then you'll 1) not have much of a problem with your career at all (especially if you can mentor others you work with) and 2) it'll help you in many other areas that also touch on (sometimes lean on) T-SQL.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 7

tauseef.jan (10/30/2016)
hi,
maybe i did not make myself clear. I wanted to ask that is 70-533 (implementing and deploying azure ) the right career path to take

I haven't taken the exam, but I recently attended the related 5 day course (Implementing Microsoft Azure Infrastructure Solutions) , and in all that time we probably spent about 20 minutes on database-related tasks. It's not a database certification. That's not to say there's no value in it, but I thought you should know before you get too far down the line.

TJDBA Default port Points: 1490 More actions · Answer 8

Thanks a lot gentlemen. I really appreciate each one of you for taking out time to answer my query.

I am now looking forward to start and infact have started on 70-533.

Thanks a lot again

SM Newbie Points: 1 More actions · Answer 9

Hello TJDBA...I am now in the same dilemma as yours and wondering whether the Sql Azure certification 70-533 would help me to expand my career path in SQLDBA role in future.

Can you please advise on how did it work out for you?

rlsublime SSC Enthusiast Points: 165 More actions · Answer 10

Hello,

The new Microsoft Certified: Azure Database Administrator Associate is great for a SQL DBA. It requires one exam to pass the certification and measures the following skills:

Plan and implement data platform resources

Implement a secure environment

Monitor and optimize operational resources

Optimize query performance

Perform automation of tasks

Plan and implement a High Availability and Disaster Recovery (HADR) environment

Perform administration by using T-SQL

Download certification skills outline

Additional info can be found here: https://docs.microsoft.com/en-us/learn/certifications/azure-database-administrator-associate

Michele C. Schweiger Newbie Points: 2 More actions · Answer 11

TJDBA wrote:

Hello,
I know this is an off topic post, but please help me out.
I am a sql server dba with 10 years exp. I wanted to expand my skillset as I find that the sql DBA scope is getting narrower.
I am thinking of doing Azure certification, but i am not sure if that is the right career path for a DBA.
Please help me with suggestions in the right direction in this regard.
Thanks
T

I believe Azure certification is the right way for a DBA. Therefore, I wish you good luck! You should only study this question a little better and you will succeed!

Follow the link to see my website.

lekhanani Newbie Points: 1 More actions · Answer 12

I know this has been asked, but I couldn’t locate a recent answer. What is a good certification for SQL? The Microsoft certifications are going away. I’m doing the Udemy boot camp and will follow that up with more studying after I locate what cert to direct that towards.

I have a Masters degree so I can get interviews, but I haven’t done SQL in years. So I want to be able to have tangible evidence of my knowledge in it.

Also, after I do this what direction would you recommend to go for more certifications? Are there other SQL related objectives I could pursue? I debated on Python as I see that is in high demand now, but unsure if that would help get an analyst job.

Thank you for your assistance.

Ant-Green SSC Guru Points: 113544 More actions · Answer 13

Microsoft certifications are not going away, they are just shifting the focus onto other places.

This is the equivalent to the old MCSA/MCSE for the DBA route

https://learn.microsoft.com/en-us/certifications/exams/dp-300

This is the new data engineer certification

https://learn.microsoft.com/en-us/certifications/exams/dp-203/

Data Science certification

https://learn.microsoft.com/en-us/certifications/exams/dp-100

Data Analyst / Power-BI

https://learn.microsoft.com/en-us/certifications/exams/dp-500

And now the split out Cosmos DB cert (this was part of DP-300) but moved to its own cert now

https://learn.microsoft.com/en-us/certifications/exams/dp-420

The world of data is changing fast, and so must the certifications to keep up with the vast shifts in the data landscape.

Additionally just because most of these new certifications from MSFT contain the word Azure, doesn't mean that they are all focused on the Azure platform. the DP-300 certification contains so many questions in relation to the On-Prem version of SQL as it would have to, for you to run it on an IaaS VM in any cloud platform, that it is still totally relevant to DBA's even if they use AWS/GCP/On-Prem and not Azure due to the vast cross overs that SQL has in all of the different locations still.

thomass Newbie Points: 1 More actions · Answer 14

Hi there,

In considering "Azure certification for SQL DBA,

a person may contemplate the potential benefits and opportunities it presents. They might weigh the advantages of acquiring specialized skills in managing SQL databases within the Azure cloud environment. They could envision enhanced career prospects, increased marketability, and the ability to leverage the latest technologies for efficient data management and analytics. Ultimately, they might see it as a strategic investment in their professional growth and future success in the evolving field of database administration.

Azure certification for SQL DBA

Cookies on SQLServerCentral