How many DBA's do we need?

Philip Jacobs

How many DBA's do we need?
I am looking for guidelines or best practices for how to calculate how many z/OS DB2 DBA's are needed to support x number of application databases. I have found a couple of helpful articles through Google, any opinions?

Thank You,
Phil

Philip Jacobs
Senior Manager, z/OS DB2 - HCL / HCSC Chicago
HCL America, INC.
office) 312-653-4549
mobile) 708-421-0585
[login to unmask email]<mailto:[login to unmask email]>
[login to unmask email]<mailto:[login to unmask email]>

HCSC Company Disclaimer

The information contained in this communication is confidential, private,
proprietary, or otherwise privileged and is intended only for the use of
the addressee. Unauthorized use, disclosure, distribution or copying is
strictly prohibited and may be unlawful. If you have received this
communication in error, please notify the sender immediately at
(312)653-6000 in Illinois; (800) 447-7828 in Montana;
(800)835-8699 in New Mexico; (918)560-3500 in Oklahoma;
or (972)766-6900 in Texas.

Phil Grainger

How many DBA's do we need?
(in response to Philip Jacobs)
The usual answer to "How many DBA's do we need?" is "More than you have or are likely to get"

It's not just about how many applications or databases, but how VOLATILE they are. If metadata is pretty static, most DBA tasks can be automated

If there are a lot of changes to make, in a lot of environments, with some rollbacks thrown in for good measure, the number of DBAs you need starts to increase almost exponentially

And what about investment in tooling? The more/better tools you have, the fewer DBAs you can survive with

I guess where I'm heading is "It Depends"

________________________________

Phil Grainger

Enablement Manager

[login to unmask email]

Direct



+44 (0)118 921 8000

Mobile



+44(0)7808 643 479


E2, Eskdale Road
Winnersh
Berkshire
RG41 5TS


[http://media.cms.bmc.com/images/corp_signature_bmclogo_2014.jpg] http://www.bmc.com

[cid:[login to unmask email]






From: Philip Jacobs [mailto:[login to unmask email]
Sent: 19 October 2017 12:40
To: [login to unmask email]
Subject: [DB2-L] - How many DBA's do we need?

I am looking for guidelines or best practices for how to calculate how many z/OS DB2 DBA's are needed to support x number of application databases. I have found a couple of helpful articles through Google, any opinions?

Thank You,
Phil

Philip Jacobs
Senior Manager, z/OS DB2 - HCL / HCSC Chicago
HCL America, INC.
office) 312-653-4549
mobile) 708-421-0585
[login to unmask email]<mailto:[login to unmask email]>
[login to unmask email]<mailto:[login to unmask email]>


HCSC Company Disclaimer

The information contained in this communication is confidential, private,
proprietary, or otherwise privileged and is intended only for the use of
the addressee. Unauthorized use, disclosure, distribution or copying is
strictly prohibited and may be unlawful. If you have received this
communication in error, please notify the sender immediately at
(312) 653-6000 in Illinois; (800) 447-7828 in Montana;
(800)835-8699 in New Mexico; (918)560-3500 in Oklahoma;
or (972)766-6900 in Texas.

-----End Original Message-----
BMC Software Limited Registered Office: Building E2, Eskdale Road, Winnersh, Wokingham, Berkshire, United Kingdom, RG41 5TS Registered in England No. 1927903 The content of this email is confidential. If you are not the addressee, you may not distribute, copy or disclose any part of it. If you receive this message in error, please delete this from your system and notify the sender immediately.
Attachments

  • image001.jpg (8k)
  • image002.png (5.9k)

Lockwood Lyon

How many DBA's do we need?
(in response to Philip Jacobs)
Phil,

Much depends upon what "DBA" means in your context. In my opinion,
the number of applications is irrelevant; far more important is the
level and complexity of DBA tasks.

Here are some questions to ponder:

Are the DBA(s) on-call for production problems? If so, better have
at least three in your rotation (allowing for vacations, etc.), more
if you split your DBAs based upon their expertise on specific
applications. (Ex: You have an enterprise data warehouse on z, and
expect a separate cadre of DBAs to support it.)

Do your zDBA(s) participate in disaster recovery? If so, you'll need
at least some on-call for production while others participate in DR
Exercises.

Do you split out DBAs into application-related (SQL tuning,
application performance monitoring, etc.) and system-related (buffer
pool tuning, capacity planning, utilities, etc.). If so, sounds
like you need two sets of DBAs for that.

Do you have (or expect to have) non-on-site DBAs in the mix?
(Contractors, off-shore, etc.). If so, you'll need to do succession
planning for when budgets get cut or there is turnover. Which DBAs
will support mission-critical stuff, which will support basic object
creation, etc.

Do you expect a mix of DBA technical experience? If so, you need to
do task planning for the generalists and specialists in your mix,
with additional planning for expected new-hires and upcoming
retirements and turnover.

Do you have any specific DB2 issues or constraints? (High CPU usage
driving high MLC costs; lots of "bad" SQL; real memory constraints
and paging; users with high perceived transation times; historical
issues with version migrations). If so, maybe you need a small team
of DBA + z/OS + user specialists to continually address resource
issues.

In summary, your total IT environment dictates how your DBAs are
spending their time, and how you prioritize and allocate that time
across a set of DBAs with varying levels of experience detemines how
many you need.

- Lock Lyon


From: Philip Jacobs [mailto:[login to unmask email]
Sent: Thursday, October 19, 2017 7:40 AM
To: [login to unmask email]
Subject: [DB2-L] - How many DBA's do we need?

I am looking for guidelines or best practices for how to calculate
how many z/OS DB2 DBA's are needed to support x number of
application databases. I have found a couple of helpful articles
through Google, any opinions?

Thank You,
Phil

Philip Jacobs
Senior Manager, z/OS DB2 - HCL / HCSC Chicago
HCL America, INC.
office) 312-653-4549
mobile) 708-421-0585
<mailto:[login to unmask email]> [login to unmask email]
<mailto:[login to unmask email]> [login to unmask email]

_____