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

Download "Why Your MySQL Needs Redis" and discover how to extend your current MySQL or relational database to a Redis database.

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.

Read "Developing Apps Using Active-Active Redis Enterprise" and discover the advantages over other active-actve databases.

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 }}