A DAY IN THE LIFE OF A DATABASE ADMINISTRATOR or DBA

[@shirayan-zn9ch]

That's a great presentation. I think that a Database Administrator must do all round things of business systems, SQL, Trouble shooting, System Backup, Database Tuning...

[@itschriscash]

Last 2 years as a DBA here: most of my daily time is spent in Teams meetings where they think they need a DBA but really don't, then a half hour trying to login to retrieve password to login to Oracle through a jumpserver. Another half hour reading through emails to see if one pertains to me. The remainder of the day may be spent doing mundane activities on 10 year old servers still on version 11G.

[@ITCareerGuide]

Thanks for being so open. I think it is important for people to know about this side of the job, too.

[@Alva_Nguyen]

so you mean coding skills may not be pivotal for this role? Only strong knowledge about Oracle to work with?

[@aguafria9565]

@@Alva_Nguyen of course it is not coding, unless you are talking about coding the automation of roll out and configuration, or automating daily tasks like index optimisations. You need to know the DBMS architecture like you built the system yourself, you work with Oracle? You need to know how that beast works, since you are the specialist. Likewise the same with Postgres or SQL Server.

[@oracam437]

Thanks for making this video. Love the fact you stayed on the Topic and did not over talk like many videos on You-Tube. It definitely made a difference.

[@ITCareerGuide]

Thank you. Your comment means a lot to me. :-)

[@zomgoose]

Currently a Sys Admin w/network training looking at converting to being a DBA. Your insight into the field is appreciated. I am further intrigued. Thank you!

[@ITCareerGuide]

Best of luck!

[@jaaaazzzyyy]

This is what I want as a career! I’m already have experience with SQL I just need a strong background in IT

[@FilipinaMuslima]

This is what I want as a career as well. SQL seems so fun for me. I’m going to uni for administration and concentration information systems and technology

[@mwagle]

i Am a fresher starting a job in IT soon! Great video.. Loved the explanation!

[@GongXiFaCai_]

Someone snoring 😴

[@ITCareerGuide]

My dog is often in the room when I record videos ;-). She snores like crazy sometimes.

[@drago6568]

@@ITCareerGuide o my gosh I'm so happy to know that

[@behrad9712]

Yea😁

[@priscillarbanda6731]

My dog does that all the time

[@kensimba7868]

I've paused several times thinking it's someone in my house 😂

[@shubhamgaikwad6227]

I am learning Oracle DBA to get job in IT :)

[@ITCareerGuide]

That is cool. Oracle is a great track to be in.

[@amadeusarshilava4976]

I don’t know whether to study Data Analyst or Database Administrator. It’s important to me to learn one of these as quickly as possible? "After studying, which of these two has a better chance of helping me land my first job? In other words, which one can be learned faster, and with which one can I get a job more quickly?"

[@tanmaysrivastav]

Started working as a DBA L1, straight out of college...thank you for your video...got great insights into the things I'd be working on.

[@ITCareerGuide]

You're very welcome.

[@TonyMontana-pe6vf]

I have a question. Is it true that database administrator roles are on the decline? I am considering to switch my career into database, but I am not sure at this stage.

[@ITCareerGuide]

What makes you think they are on a decline? If you look at this role in the traditional way, yes - one could say it is on the decline, but on the other side the role - as so many in information technology - is evolving and looks different compared to what it was 10 years ago. Just think about data and how much data is being collected everywhere these days. That data needs to be housed somewhere and it needs to be maintained. It also needs to be worked with, made available, analyzed, and so on. If you are considering the move, I would suggest you take a look at Amazon AWS and their DBA related certifications and then find job postings on Indeed and LinkedIn. Look at what these employers are searching for and what they want from a person that would work such a role. Gives you a good indicator and how to upskill accordingly.

[@zigssarmiento7969]

Thank you, currently practicing this role (a role I accepted recently). I have mostly database, AWS EC2/RDS and SQL experiences in the past but is still working on learning a couple of more skills for this new job position so hopefully I can keep this position in this company. Struggling currently to choose which skills, tutorials, what order to follow, where to get these tutorials to improve myself in this career as I want to pursue this career for good now. I'm glad I somehow get the picture of most of the things you discussed.

[@classictremonti7997]

I have many years experience with Microsoft SQL Server and SSIS but have been out of the field for over 5 years. What are current "modern" tools and environments that would be beneficial to focus on to get back up to speed? Also, for someone that is learning from home, what are some ways to get started with these tools? Any advice would be greatly appreciated!

[@ITCareerGuide]

Certifications offer a structured approach. You can use it to your advantage. You may not have to get the certification, but just use the learning path and expand on that - especially if you have prior experience.

[@50tigres79]

Azure, NoSQL big data

[@Stoneface_]

Mongodb, dynamodb

[@courtneejackson8530]

@@ITCareerGuidewhat cents would you suggest?

[@bryanstark324]

Based on your description, it doesn't sound like a person can set their sights on becoming a DBA but it's a long path from help desk to sys admin and maybe maybe maybe someday if you say your prayers, take your vitamins and never forget to train you might be lucky enough to be hired as a DBA. It sounds impossible to learn.

[@Stoneface_]

We all have different career path. It'd take some of us 5 years to be DBA and some, less than 2 years. Many systems/network administrators do deal with data bases so that can count as some experience.

[@aguafria9565]

bro, the thing with being a DBA is that managers are scared to let someone who doesn't know what they're doing start playing around with the DB, because if someone makes a mistake, the whole system can be irretrievably lost. Like the time a DevOps guy took down the whole system because he isn't a DBA, but is still given responsibility over the DB. To start in that career you want to begin in a small company that runs a few DBs, but they aren't really that important (they're not running critical infrastructure), meaning like a sales DB for a restaurant or hotel, etc, not a DB managing a manufacturing business, production line where downtime equals a $100,000 loss per hour. Once you've learned the ropes on those small systems, you have enough knowledge to start working on bigger systems. The other entry path is going into a big shop and being an intern, but that path seems harder to find. I also see these kind of hybrid roles where a lot of companies don't have a DBA, but they're instead letting their Devs take that responsibility, those are the places without any best practices, so I don't really know if that is a good place to start, unless, you, want to clean up their mess.

[@blaisemethos9479]

I want to thank you because you share all the things related to IT and because of this many questions gets clear. Thank u

[@ITCareerGuide]

Thank you for your kind words and support. I appreciate it.

[@dylboy385]

Hello quick question, I’m interested in becoming a dba but I don’t quite know what I should major? Should I go for something along the lines of computer science ? Or is there something you’d recommend? Thanks!

[@ITCareerGuide]

Take a look at a bachelors in information technology. There are probably then options to go towards database management or design or administration. Keep in mind you need to understand operating systems and other related topics. I would also make sure that being a DBA is exactly what you want to do and not lock yourself into an area that suddenly turns out not to be what you had expected. So, a somewhat generic information technology or CS degree and then majoring (or a masters) in database administration would be a good way.

[@SufiKingdom]

Trying to make career transition, that’s why I’m here.

[@ITCareerGuide]

Welcome and please feel free to ask questions or what other type of videos I can make for you.

[@nextgenerationacademy4058]

I want to choose a carer in dba. Where do I start

[@jatinsondhi9244]

@@ITCareerGuide Is Computing and Information Systems same as information technology.

[@Talmurid]

I have a question; how difficult, or rather is it even possible to get a job as a systems administrator, or a DBA by just doing IT certifications? I've heard that most companies require at least one employee to have the certifications to be able to do business. Will companies care if I did not go to college, or will they look exclusively at prospective employees with degrees in Information Systems? Thanks for any advice.

[@ITCareerGuide]

There are plenty of companies that do not care if you are certified or not. There is no requirement to have anyone on the team certified. Will there be at least one person that is certified? Often the answer is yes. Managed Services Providers or consulting companies - that could be a different story.

[@havocc611]

Just wanted to reply here since it is relevant to me… I recently got hired as a jr. oracle database administrator. I really only have computer hardware experience, although I do have a degree in cyber security. I have no background in database management but this company has 18 employees including myself, in an office located across the street from where I grew up. Just apply to everything you can and attend interviews, never know who might hire you.

[@Talmurid]

@@havocc611 Thank you for sharing, this helps

[@andiuptown1711]

@@havocc611How was this job btw?!

[@XwoooahX]

A day in the life of a DBA: Start with a walk through a server room with a tablet and look at the blinking lights.... LOL

[@clonker8337]

That sounds more like network admin lol

[@ramsay9912]

Best 'A Day In Life Of a *' video I have ever watched! 👏

[@ITCareerGuide]

Thank you :-)

[@azhari7968]

Hi this video is very helpful. Do you think there's a chance to change my career to data analytics if I have the experience in DBA?

[@JohnCena-zr8oz]

Sir,, Iam fresher I want to join oracle dba course Is it possible to get into dba as a fresher. Help me sir..

[@gowine504]

is there some one snoring in the background?

[@AMoistBum]

I thought it was my own breathing lol

[@Ganeshay-996]

Coding not there but troubleshooting and maintainnce and responsibilities dba job

[@50tigres79]

What you describe is not a typical day. It's more about what a DBA does. Title is misleading.

[@baimonerakabilangan2020]

Does BS in Information Systems course best choice if I want to become a database administrator?

[@blackaura9757]

Great video! I am looking for my first job in it and watching this videos helps me a lot

[@ITCareerGuide]

Glad it was helpful!

[@mobetta2092]

Update?

[@amadoufashion2762]

I have no experience on IT. But I would like to get into the field. Where should I start?

[@ITCareerGuide]

I would need to know of where your interests are, but take a look at this video of mine. kzbin.info/www/bejne/b3OWloGZrqaXgbM

[@suryab9077]

I am working as a tester since 8 years. Testing using sql server, using informatica mdm and cadis. Now I want to become a dba either in sql server or oracle dba. How will it b and how will b my career from db testing to dba role. Please suggest

[@maxwelldumont8168]

9:27 when the boss is walking past

[@shalamander4337]

I am gonna be in my 3rd year of BSc in physics. But I want to become a DBA. Is it possible to become one without a CS or IT degree? Please help

[@ITCareerGuide]

It is definitely do-able, but it requires work experience in IT. Your first step should be towards system administration and then add relevant online courses and potentially certifications to your skillset. A college degree with a focus on database administration will be the other option, but it sounds like would not work for you at the moment.

[@shalamander4337]

@@ITCareerGuide alright. Thank u

[@Ellerudd1989]

So the entry level job is systems administrator?

[@ITCareerGuide]

It can be. But even an entry-level system administrator may already be an experienced helpdesk technician.

[@ndz7372]

Wow, this is so rich in information..thanks a bunch

[@ITCareerGuide]

Glad it was helpful! Thank you for watching.

[@Ganeshay-996]

I think you have more experience about dba

[@krishnavardhanreddygajjala2405]

Sir I'm fresher I got job as DBA trainee I want to know dba is good in future or not

[@ITCareerGuide]

Long-term perspective for the DBA is good, but it also requires you to be constantly learning new technologies and new ways of working. I am happy for you that you found a job as a trainee. Best of luck!!!!

[@krishnavardhanreddygajjala2405]

@@ITCareerGuide thank you for information Sir

[@murderface941]

Currently a junior trying to specialize in systems admin, what kind of internships should I be looking at for summer 2022?

[@ITCareerGuide]

Do you have any work experience at this point (in IT)?

[@murderface941]

@@ITCareerGuide No I do not

[@ITCareerGuide]

@@murderface941 It depends on what internships are being offered of course, but I would consider anything in IT other than help desk. Not that help desk is a bad role, but I think the value of an internship may get lost on you. Pre-pandemic we had interns in our cybersecurity group. I have seen other postings for system administration, and some other related roles. I would not tie myself too much the sys admin role for the internship. Get an internship in an IT function and take it from there. Neither the industry or size of the company matters too much.

[@amaanullah13]

@@ITCareerGuide Dear Sir how to find internships currently I am in 3rd year of my college but I haven't enrolled in any internships though I have applied for it. All I get is a blank response. It would be really helpful for me if you help me secure a good internship. I am into Software Engineering and open to developer kinda work, even DBA will work. Thankyou Again Sir For reading out this comment.

[@fredharvey2720]

Your license plate collection is missing Colorado denim

[@ITCareerGuide]

I know. Time go back and work on that :-)

[@harmeetkaur1929]

which is the best certification to get a job as dba

[@ITCareerGuide]

Depends on which database technology you want to specialize in. I would probably look at Oracle.

[@pedroagma4417]

I swear, I hear something snoring in the background.

[@ITCareerGuide]

haha - that is my Yellow Lab doggie. She always hangs out with me when I am recording videos. That's so funny that you noticed. :-)

[@pedroagma4417]

@@ITCareerGuide Hihi! I thought no one had mentioned it, but someone mentioned it two months ago. It was hard to miss, with my earphones. I paused to make sure that it was coming from the video. hehe! Thank you! :-)

[@urscordially8427]

Hello sir ...i worked as an junior web developer in startup company for 1.3 yrs ..but now iam not interested towards developing .but iam keen towards database administrator roles..to gain job in this area what all i should follow up step by step..

[@ITCareerGuide]

Startup environments can be very different from a more established company. You may want to give that a try as well and see if it fits your style more. Depending on the startup, the workload can be brutal but that is not the standard in many other places.

[@urscordially8427]

@@ITCareerGuide Thanks alot sir!How can i start my career as Database administrator..present iam into non technical feild..How to switch my career to DBA..How long will it take?Where to start?..Any best institution in india?

[@50tigres79]

Learn everything what the video describe and apply for a DBA position.

[@memewala8337]

In sql dba, sql developer, and etl roles which is more fresher friendly

[@2021noname]

Can you explain what is an ETL role?

[@hc6008]

IT admin here.Im torn part between oracle and sql server. The number of jobs for sql server on prem and cloud dba is more compare to oracle here in ph but I am much verse on oracle.

[@ITCareerGuide]

You could use SQL as a stepping stone and then "upgrade" into Oracle. Gain work experience, then move up.

[@Momentumunboun]

Is it just me or do I hear someone snoring in the background?

[@ITCareerGuide]

lol - that is my dog. She is more into treats and not information technology :-)

[@HaHA-tn3bf]

which is better DBA or app developer or web developer. Please give your suggessions

[@michaelcdarby]

I have been a software developer for 4 years now and work with databases with every software I’ve built. I’ve grown to love databases and am thinking of a career change. How hard of a transition do you think it would be? I’ve been looking at the DP-900 certification

[@johnczech7074]

Excellent! Thank you sir!!

[@ITCareerGuide]

You are welcome, John.

[@plecturaproductions5816]

Great video! But call me crazy, I feel like I hear someone snoring...

[@NazmulAlom]

if i choose master's in Information Technology or Information Management. is it possible to go this carrier path?

[@123italiano321]

I am looking to get a sql certification and build on out from there on. I had a course and I'm self studying the basics of selects, joins and subquerys. We have an Oracle environment but we are looking to go Microsoft in a few years. What are good certificates to go for now? I am not necessarily Oracle bound, it seems like a logical option though, I am a bit concerned their path is way more difficult then something like Microsoft

[@TheInternetFan]

I'm in your same boat -- Oracle or MSSQL? Both are pushing their respective cloud platform (for e.g. DP-300 for Microsoft and OCI Autonomous DB for Oracle).

[@123italiano321]

@@TheInternetFan Exactly! Those are ones I am currently looking in to. We have a lot of IT guys that manage the Microsoft environment and they have a lot of knowledge that might assist me in my Microsoft journey. But Oracle would be a good step for me as well. I just have a feeling Oracle will be way harder especially because I have no one to throw idea's and knowledge back and forth.

[@niksatan]

Basically you need both programming AND system knowledge for being DBA ?

[@razehal-shawea5191]

what the fuck is that snoring sound??? it didn't make me focus!!!

[@ks8411]

this was very helpful

[@michaelrichard9661]

How do I become DBA if most companies ask for 3-5 years of experience ? I am looking to become DBA now

[@Ganeshay-996]

Good one impressive and thanks for very brief information

[@dontbelasagna5968]

Hello sir, may i know what is the career path like, after i got to be a database administrator, what's next? What role to be promoted into after that

[@ITCareerGuide]

Senior Database Administrator. Think less about promotion, but where you want to go after that. The job title may stay the same for the longest time, but your work and your income can be significantly different. Move from a small company to large company. Move from an on-prem environment into a cloud environment. Look for challenges and how you can address them. What gets you excited about the work? The type of challenges? The type of scale/size? Imagine supporting the AMAZON.com website as a DBA - very different challenge compared to databases for a healthcare company. But if you want to move out of the DBA role, you could become an architect or move into middle management or upper management. Start your own company and become a consultant. So many options, but it all starts with gaining experience in different environments and situations.

[@dontbelasagna5968]

@@ITCareerGuide Wah.. thank you so much, sir.. i have been working as dba for 1 year, and i felt like im not gaining much experience as this is a small to medium company, there's not much going on but i love being in this field so i wasnt sure where to go from here.. thank you for your advice, sir :D

[@AlainCorona]

Very interesting. What would you say are the biggest challenges on a day to day basis?

[@av91_wk]

Great explanation. Well structured, to the point and relevant.

[@Robotin-el1wx]

I'm learning SQL Server DBA

[@ITCareerGuide]

Very cool. Are you already in the field or just getting started in general?

[@Prinnypiepie]

You must have a sleeping doggo in the room with you

[@ITCareerGuide]

Yes, indeed. Shelby is Yellow Lab. :-) Follow her on Instagram if you like. instagram.com/shelbyoclock/

[@Prinnypiepie]

@@ITCareerGuide aweee cutie! Will do.

[@Stiddo]

I want to get into IT so bad but don't know what specifically it is that I want to do in IT

[@fredharvey2720]

Do these jobs get outsourced a lot?

[@ITCareerGuide]

Not as much as others, but it always depends. Sorry for the vague answer, but it depends on each individual employer.

[@jim43597]

Hello Sir , does DBA role required coding/programming knowledge ??

[@ITCareerGuide]

Not necessarily, but it is becoming a skill that can help in many different IT roles.

[@jim43597]

@@ITCareerGuide Thank you for your valuable time .

[@XwoooahX]

@@jim43597 Be able to write and tune SQL statements and stored procedures for performance

[@abdulkhaleqkhamoosh5664]

Thanks a lot, it was really helpful❤

[@aksharsolanki328]

I'm currently working in Tech Sales for a large Telcom company in Canada. Company has partnered with Oracle to support their database needs. I'm naturally a problem solver, looking forward to build a career in database programming. Thanks for your valuable insights

[@ITCareerGuide]

You're welcome 😀

[@meella332]

who's sleeping?

[@ITCareerGuide]

My dog is always around when I record videos ;-)

[@rajatshetty10]

I work as a technical support executive in IT & looking forward to have a change in my path to becoming a DBA. Will I get a salary hike? Will my work experience here counted? What are the basics skills required in becoming a DBA? & how much time does it take to become a Jr. DBA if I start from scratch now?

[@ITCareerGuide]

Don't expect a salary hike if you change careers within IT. It is possible, but if you switch to a different career in IT it does not always work that way. Take a look at my video here: kzbin.info/www/bejne/iWPUmniEebafpq8

[@rajatshetty10]

@@ITCareerGuide Thank you!! 😊

[@mayagamage]

I'm a university student from Sri Lanka..so I'm reading for my business administration degree (bachelor) so after 2 years I can choose my specialization area..so now I hope to do as my specialization area business analytic or management information systems.. After completing this bachelor, I hope to immigrate to Australia. So, can I know what to do for the specialization area? And in what areas is it very possible to get PR? I hope to immigrate to Australia to do my master's program.

[@lindamngqibisa7851]

Greetings, Got 11 years IT tech experience. Can I immediately get into dba after completing my Bcom it management and oracle?

[@wifeybaby4001]

Is a DBA associate degree enough?

[@BT-hp8qo]

Can I work as a Database Administrator with a CS Degree or should I change my degree? I haven't graduate yet

[@EliteNormie]

CS as in... Computer Science? Isn't that the perfect degree to do to get Database Administration as a job?

[@black5254]

What is this noise on the BG???

[@milcatakou6561]

Is it possible to become a part-time DBA Does that exist? Like 20-30 hours per week?

[@ITCareerGuide]

Not as your primay goal.

[@gykg3202]

Danke Schon! Greetings from Hungary.

[@goatcheese3537]

Really glad I found this channel

[@ITCareerGuide]

Thank you.

[@jolodelacruise]

i hear someone snoring

[@CuongTran-nz1wx]

Hay quá

[@mr.kjw738]

Very Helpful Thank You

[@ITCareerGuide]

You're welcome!

[@thuyhoang1301]

Hay quá

[@MeckeDuli]

Darth Vader in the background?

[@ITCareerGuide]

lol - that is my dog Shelby. She was sleeping/snoring in the room when I was recording the video. :-) You can follow her on Instagram instagram.com/shelbyoclock/

[@LuigiZambetti]

Better salary for SQL Server DBA or Oracle DBA? For the same years experience.

[@Ganeshay-996]

Both but oracle dba more u will get

[@thuyngo3851]

Hay quá

[@quanghale7274]

thanks you for your video!

[@Kevin-rk4qu]

DBA pay in the bay area around $28-29 /hr

[@ITCareerGuide]

I highly doubt that is the average pay rate for a DBA.

[@florenbaron7111]

Very helpful.

[@somethingnew3338]

✌✌✌✌

[@leonardopinzon8679]

He is great!

[@DarthInfoSec]

good vids 🤓

[@j.maginnenu6291]

Nice video snip showing the systems environment with the DBA inspecting the whole infrastructure, walking through personally, herself there.

[@ITCareerGuide]

Stock photography made it possible. So-called B-roll to make videos more appealing to watch. ;-)

[@nishanthshetty32]

Is this job repetitive(routine) or dynamic?

[@ITCareerGuide]

There is a certain number of tasks you could label as repetitive, but what is not repetitive or a day to day activity that is part of a job. As a sys admin for any type of systems you need to do things daily or weekly to maintain system health and to keep them running smoothly. It also depends on where you work and how large the environment is and what your specific role is.

[@thatbeardedvlogger3202]

How difficult is it to become a DBA?

[@ITCareerGuide]

Become a sys admin first, then a DBA. It's not difficult if you have a good understanding of technology, but that does not mean it is easy. There are certain base concepts you need to learn and understand. If those come to you easy and you thrive on the other work - the world is yours. Sorry, if that is a vague answer, but you might get there just to realize it is not what you expected (or it is exactly what you expected). I would work on some personal side projects at the same time, build a table structure, create an index, load SQL, and all that stuff to see if you like it. I messed around in Wordpress databases, phpMyAdmin, did crazy modifications inside the database, and stuff like that. It may not have been a structured approach, but I developed a good level of respect for the work that goes into database design and administration.

[@includestdio.h8492]

Nice video!

[@ITCareerGuide]

Thanks! And welcome to my channel. Please feel free to leave video suggestions in the comments.

[@Po0pypoopy]

is it possible to become a DBA without any bachelors in CS or software engineering? I am getting an associate's degree in computer programming changing my career from Biology

[@ITCareerGuide]

Yep, absolutely. But you have to work a little harder to get that initial first step done.