Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

Tips for Getting Along With Your DBA

DZone's Guide to

Tips for Getting Along With Your DBA

Here are tips on what you, the developer, can do to foster a strong, collaborative and highly productive relationship with your DBA.

· Database Zone ·
Free Resource

Databases are better when they can run themselves. CockroachDB is a SQL database that automates scaling and recovery. Check it out here.

Developers and DBAs: can't we all just get along?

Sure, we can!

We just have to break out of the old routine of:

  • Developer: Hey, DBA, add twelve indexes to make my code run faster!
  • DBA: Hey, Developer, tune your code to make it run faster!

That is, finger-pointing.

Instead, we need to work together, and developers I am not the least big reluctant to say:

It's up to us, not the DBAs, to take the first steps.

So here are tips on what you, the developer, can do to foster a strong, collaborative and highly productive relationship with your DBA.

1. Ask Your DBA for Advice

"I want to make my code run faster. What do you think I should do?"

There's no better to improve a relationship than to show some humility and express interest in the opinions — and knowledge — of others.

2. Do the Right Thing

Learn about the performance-related features of PL/SQL (and SQL) and apply them. Here are some links to help get started:

3. Give Your DBA a Heads Up When Your Pattern of Writing Code Changes

Utilizing new and different features of PL/SQL can have a ripple effect on memory consumption and overall application performance. Don't blindside your DBA.

For example, you learn about executing bulk SQL from PL/SQL. So cool! So powerful! And potentially a big PGA memory suck, through the use of collections.

Or you discover the Function Result Cache. Another very exciting enhancement added in 11.1. "Hey, I'm going to add the RESULT_CACHE clause to 100 functions. So easy!" Yes, but you might kill overall database activity with latch contention.

Databases should be easy to deploy, easy to use, and easy to scale. If you agree, you should check out CockroachDB, a scalable SQL database built for businesses of every size. Check it out here. 

Topics:
database ,dba ,work culture ,ethics

Published at DZone with permission of

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}