this post was submitted on 04 Nov 2023
17 points (87.0% liked)

PostgreSQL

668 readers
1 users here now

The world's most advanced open source relational database

Project
Events
Podcasts
Related Fediverse communities

founded 1 year ago
MODERATORS
Ategon
starman
jnovinger
17
If you are DBA, how many hours per day in average you do actual work? (self.postgresql)
submitted 1 year ago by rinsler to c/postgresql
2 comments fedilink hide all child comments
 

I understand that there are times with critical issues and outages when DBA are to work until all is fixed, which may take up to 20 hours.

But if things are stable and settled, out of a standard 8-9-hour work day, how many hours are actually needed to finish daily routine work?

top 2 comments
sorted by: hot top controversial new old
[โ€“] [email protected] 7 points 1 year ago

I sit next to a DBA and it can be really feast or famine for him. If there are patches to install or a failure of some sort he may work a 12 hour day. Other times he is just monitoring systems and reviewing performance reports, maybe 4 hours work. If he is involved with a development effort, then it is more engaging work and more of an 8 hour day.

[โ€“] [email protected] 2 points 1 year ago

We have a DBA but with an augmented job description. They write ad hoc reports which some will be passed to the development team to be codified with filters and export options.

I remember DBAs with just database experience in the '90s and they were really busy especially when drive storage and RAM was very expensive.

But today, both are cheap and databases are easier to configure and support, I suppose their job descriptions are more expanded.