Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

The Exceptional DBA’s Code of Conduct

This is a reprint of chapter 11 of my book, How to Become an Exceptional DBA, 2nd Edition, which is available as a free e-book here.

Physicians, attorneys, accountants, engineers, realtors, and many other professionals have written guidelines designed to discourage misconduct and illegal activity, and to promote the ethical conduct of their members. In fact, according to the Sarbanes-Oxley act, all public companies in the United States are required to create and follow their own code of conduct.

However, despite the fact that DBAs are essentially protectors of an organization’s knowledge, and privy to much confidential information, there is no clearly defined set of rules, values, standards, and guidelines to help govern and guide their behavior.

In this chapter, I define what a code of conduct is, explain how it can be useful to DBAs and the organizations they work for, and consider if and how it could be enforced. Finally, I offer my take on a “Code of Conduct” for the Exceptional DBA. Rather than be prescriptive, my goal is simply to offer advice to DBAs on how they might conduct themselves within the bounds of the professional responsibilities of their job.

What is a Code of Conduct?

Generally speaking, a code of conduct is a set of formal, written rules, policies, standards, guidelines, obligations, behaviors, expectations, and principles that are voluntarily adhered to by a group of people with similar goals, values, and responsibilities. While other definitions exist, this one will serve our purpose well enough, as we seek to define the standards of conduct to which a DBA should adhere while carrying out their professional duties.

For different perspectives on this topic, you can explore these websites and their take on professional ethics:
- The Association for Computing Machinery (ACM) at www.acm.org/about/code-of-ethics
- The Association of Information Technology Professionals (AITP) at www.aitp.org/organization/about/ethics/ethics.jsp

How Can a Code of Conduct be Useful to DBAs?

To many people, a “Code of Conduct” means one thing: more rules. Most DBAs, myself included, would consider themselves mature enough to make their own decisions and choices, and are naturally resistant to the idea of someone telling them what to do and how to do it.

If this is the case, then why have I written this chapter? Well, first, my intent is not to offer a set of rules that have to be followed but, instead, a set of guidelines that can be useful for DBAs who want to fully understand and appreciate the nature and scope of their duties and responsibilities. In other words, it is intended to be educational.

At a fundamental level, most DBAs believe they understand what it means to behave “ethically”. In my experience, instances of willful negligence, or blatantly unethical behavior, are relatively scarce in our profession. However, there are many “grey” areas where a DBA, especially a less experienced DBA, can find themselves unsure of where their responsibilities end, and how exactly they should respond to a potentially compromising situation.

For example if, as a DBA, you identify criminal behavior within your organization, what do you do? Hopefully, your answer would be that you’d report it. However, is that the end of your responsibilities? What if the company you work for does not respond appropriately? What further action should you take, if any?

It’s a sad fact that many organizations don’t fully understand and appreciate the true role of a DBA. In their attempts to save money, they sometimes cut corners that can directly affect the integrity of their data, and so unwittingly place the guardians of their data in a difficult dilemma. If you find yourself in this situation then, hopefully, this code of conduct may help convince your organization of the importance of the role of the DBA, and the need to employ experienced DBAs to safeguard their business data. For example, if you are having difficulty convincing your manager to adhere to government regulation that affects the data you manage, then referring the manager to this Code of Conduct might be useful.

Perhaps above all else, the “Exceptional DBA’s Code of Conduct” can be a source of pride to all of us who choose to adhere to it, and give us more confidence that we are doing the best we can at our jobs.

How Should a Code of Conduct be Implemented and Enforced?

Whenever the topic of a “code of conduct” is discussed, one of the first questions to be asked is: how can it be enforced? After all, if the code is not enforced in any way then, it is argued, who is it benefiting? There is no straightforward answer to the question of how to enforce such a code, or even if it should be enforced, rather than be voluntary

One suggestion is that the code be enforced by an independent, professional organization, such as the ACM, AITP, or PASS. Anyone who fails to follow the established code of conduct could have their membership of the organization revoked. On the assumption that most businesses would regard membership of the organization a key requirement in their hiring process, then it could, in theory, prove an effective deterrent to malpractice.

Another suggestion is that organizations that offer DBA certifications, such as Microsoft, should enforce some code of conduct. Again, any DBA who fails to follow the established code could have their certification rescinded. Obviously, this would only be an effective measure for organizations that require certification as part of their terms of employment. On the other hand, if Microsoft were to attempt this, what about the Oracle and MySQL DBAs? Would they need a separate code that is tied to their certifications?

Another option is to have a DBA Code of Conduct enforced on a per organization basis. After all, many organizations already require their employers to abide by a “code of conduct,” often in the form of an  employee handbook. Such a code could be expanded to incorporate conduct specific to DBAs. On the other hand, if a company creates a separate code of conduct for DBAs, wouldn’t it also have to create different codes of conduct for other job titles? Again, this is not a great solution.

In light of the numerous complications of implementing and enforcing a DBA’s Code of Conduct, I suggest that following such a code, or not, is the personal choice of the individual DBA. As I noted earlier, I regard such as code as being primarily educational in nature, with the rewards for following it being a successful, rewarding, long-term, and satisfying career as a DBA. For those who choose not to follow it, well, who knows how their career will turn out? They might get lucky and survive over the long haul, but I doubt if they will ever fall into the Exceptional DBA category.

The Exceptional DBA’s Code of Conduct

This section contains my suggestions for the core items that should comprise “The Exceptional DBA’s Code of Conduct”. My focus is on providing general guidelines that will help any DBA become more successful in their career.

I won’t be so presumptuous as to imply that these guidelines are ideal or exhaustive, but they should hopefully get you thinking and be a useful guide to you in your role as a DBA.

Protection and Disclosure of Data

1. DBAs shall never intentionally do anything that contributes to the corruption or loss of an organization’s data. While this should be a no-brainer, I am including the obvious, just to cover all the bases.

2. Above all else, the DBA is the guardian, or protector, of an organization’s data. The responsibilities of the DBA in this regard include, but are not limited to:

  • Preventing data corruption (from applications, hardware, and people).
  • Provide high data availability, as defined by the organization’s policy.
  • Develop, and regularly test, a disaster recovery plan to minimize unexpected downtime, as defined by the organization’s policy.

3. DBAs shall take all reasonable precautions to ensure that changes to a production server have no detrimental consequences. All proposed changes should be thoroughly tested on a test server prior to deployment to production.

4. DBAs shall proactively take all the necessary steps to ensure that data can only be accessed by authorized users. This may include, but is not limited to: SQL Server security, Windows Authentication security, encryption, SQL injection attack prevention, auditing, or other such security policies, as defined by their organization.

5. DBAs generally have full access to all the data in a database. This presents two important points:

  • DBAs shall only view data in a database if they need to access it to perform their job duties. For example, a DBA may need to access data to optimize a query or create a report. But if the DBA doesn’t need to access and view data for job-related tasks, then DBAs shall not snoop through the data for the sake
    of viewing it.
  • If, during the course of their required job duties, DBAs do view confidential data, DBAs shall not share any sensitive or confidential information with any unauthorized users.

6. DBAs shall provide full cooperation with both inside and outside audits, providing truthful and factual information.

7. If the DBA learns that contractors, co-workers, or managers are making poor choices that could negatively affect the integrity or security of the organization’s data, then the DBA should notify the appropriate persons within their organization.

8. If a DBA discovers misuse of an organization’s data, then the DBA should report this behavior to the appropriate persons within their organization.

9. The DBA should maintain proper and complete documentation for all servers and processes for which he or she is responsible. The documentation should be of a form and standard that will allow a qualified peer to undertake the task, in the DBA’s absence. The DBA  should never protect (hide) information from their organization that would prevent another person from easily taking over his or her position, should the need arise.

DBAs and the Law

1. Often, the data under the care of a DBA is subject to laws and regulations of one or more governing bodies. The DBA shall become familiar with these laws and regulations, and adhere to them.

2. The DBA shall abide by all software licensing agreement with vendors, and notify the proper people in the organization if any breech is discovered.

3. If the DBA becomes aware of illegal activity within their organization, the DBA shall notify the proper people in their organization, or the appropriate law enforcement agency.

Dealing With Third-Parties

1. DBAs shall not accept gifts or favors from vendors if the purpose of the gift or favor is to influence, or to reward, the DBA’s choice of purchasing goods and services from the vendor. More specifically:

  • The DBA shall proactively learn their organization’s policies about gifts, so they know what they can or cannot accept. For example, company policy might allow a vendor to take a DBA to dinner, or to receive a free gift at a conference or a user’s group meeting. On the other hand, an organization’s policy
    might limit the amount of the gift to a maximum value, such as $50.00.
  • The acceptance of a gift, even if allowed by the organization, should not influence the behavior of the DBA in regards to potential purchase of the vendor’s products and services.
  • Whenever a DBA purchases, or influences the purchase of goods or services, the DBA should only purchase those good or services because they are the ones that best meet the needs of the organization.

General Conduct

1. The DBA shall conduct himself, or herself, professionally in all relationships with the people they deal with on a daily basis, including managers, co-workers, vendors, and their “internal customers.” Favoritism and discrimination of any sort is to be
avoided.

2. If a DBA makes a mistake, and all DBAs make a mistake at one time or another, the mistake should be fixed as soon as is practical, and the DBA should inform everyone who might be negatively affected by the mistake as soon as possible. In addition:

  • Mistakes should never be covered up.
  • DBAs should take full responsibility for all their decisions.

3. If a DBA has management responsibilities, the DBA should mentor those who need help accomplishing their objectives, and allow those with experience and enthusiasm to succeed and flourish within the environment he or she provides for them.

4. The DBA will do their job to the best of his or her ability, developing and implementing best practices as appropriate, to help ensure the smooth and successful operations of the organization’s databases.

5. IT technology changes quickly. It is the responsibility of the DBA to proactively keep up on all technical areas that directly affect their job.

6. If the DBA has agreed to a SLA (Service Level Agreement) for the servers under their care, then they will abide by those agreements. If they are not technically able to abide by the agreed upon SLA (for whatever reason), the DBA needs to contact the SLA owner and work out how to resolve the problem.

7. Occasionally, the DBA may find that there is no established policy with regard to a particular aspect of their duties. For example, perhaps an organization doesn’t have a policy that defines the desired level of uptime, or that defines who can access what data. In areas where policies should be established (to ensure the protection and
integrity of the organization’s data), but are not established, the DBA shall proactively identify the areas of need, make recommendations, and present them to the organization’s management so they can make appropriate decisions.

Dealing with Grey Areas

It is impossible to provide advice to guide a DBA through every aspect of their duties and responsibilities as a DBA, and there are many “grey areas”. What does the DBA do when they notify the appropriate persons of an important issue that could negatively impact the organization’s data, and no action is taken to rectify the issue? Where do a DBA’s responsibilities end with regard to uncovering illegal activity within an organization? What does a DBA do when a cost-cutting measure means they feel they can’t fully adhere to their own code of conduct? These are all difficult questions for any employee, not just a DBA.

If you, as a DBA, feel “pressured” to do something you are uncomfortable doing, then the best advice I can give is to talk to people. In most cases, the first step is to tell your manager, co-worker, project manager, or whoever is causing the problem, that you feel uncomfortable with their request, action or inaction, and explain why. If they don’t want to listen, your next option is to escalate the issue to their manager. You may, or may not, receive management support for your case. If not, then you have to decide to “give in”, or to find another job.

The key thing is that the DBA needs to keep cool and not take any rash action. Before making an important decision that could potentially hurt your career, talk over the issue with people you trust in order to get their feedback and input. Only take action once you have clearly and thoughtfully considered the consequences of your choices. This might mean keeping quiet and not making trouble, escalating the issue to higher levels of management, reporting a crime to an enforcement agency, or finding a new job.

Exceptional DBAs are Defined by their Actions

My goal in suggesting an “Exceptional DBA’s Code of Conduct” is to provide advice and guidance for those DBAs wanting to learn more about what it takes to become an Exceptional DBA. Is the code complete or perfect? Of course not. Consider it a working, educational document; it is certainly not intended to be an absolute set of rules that every DBA must always follow. My hope is that it serves as a foundation for all those entering the profession with ambitions to become Exceptional DBAs.

Comments

No comments.

Leave a Comment

Please register or log in to leave a comment.