The job of a DBA is quite unique in any organization. A large organization might hire anywhere from three to six or more DBAs, but in a small- to mid-sized organization, there’s often a single DBA who’s putting on a one-person show for one or many databases.
What does a DBA do?
Speaking very broadly, a DBA is responsible for managing the security, performance and integrity of a database system. The DBA should get involved in database management from the planning and development phase going forward. Once the database is set up and in use, the DBA needs to make sure that the data is clearly defined and remains consistent, that data security, recovery and backup processes are in place, and that users are given support with troubleshooting issues that they come across in their day-to-day work. (This is only a general explanation of what a DBA is supposed to do.) You can find a more in-depth discussions in blog posts: What Does a DBA Do? 22 DBA Responsibilities You Should Know About: Part 1 and What Does a DBA Do? 22 DBA Responsibilities You Should Know About: Part II
The generalists vs. the specialists
Database management involves a lot of different disciplines. Summarized in a nutshell, those would include: logical database design, physical design, performance analysis and tuning, data warehousing, auditing and logging, server configuration, troubleshooting, and monitoring. Some DBAs prefer to get involved in all of these on a general level, doing a little bit of everything. Others specialize in one or two areas, learning and practicing those disciplines in depth.
In a larger organization, where there can be many database systems and related tasks, it would be difficult for one or two DBAs to handle everything. This could also be the case when the database system is the core business of the organization, such as in organizations that sell data or provide analytics solutions. In such cases, the organization may hire several DBAs who are specialized in the most critical database disciplines used by the organization.
On the other hand, when an organization is small and can’t afford to have multiple DBAs, or the database accounts only for the supportive functions of the core business, it’s more likely to hire a DBA with a generalized skill set. Since the capacity in each discipline will be relatively lower, a DBA with a good skill set and expertise should be able to handle it well.
Types of specialized DBAs
There are several accepted database disciplines in which a DBA can specialize, as outlined below.
Database Architect is involved in the overall design and implementation of database systems. A database architect needs to gauge the business requirements and decide how best to design the database to cater to the business needs. They are only involved in the design and implementation of the database.
System DBA focuses on the administration-related activities of the database system. This includes server configuration, installations and upgrades, managing of support technologies, etc.
Application DBA focuses on database design, development and writing SQL functions to perform CRUD operations for database applications. They are responsible for change management and performance tuning of the database for the particular applications they’re working on.
Performance Analyst focuses on database performance. Performance analysts constantly monitor the database for performance bottlenecks, including the SQL coding that results in performance issues, and handle performance-tuning tasks. They must have a good understanding and technical knowledge of advanced database concepts.
Which types of DBA skills are needed for your organization? It is important to assess this, especially if you are hiring multiple specialized DBAs. To learn in detail about the different types of DBAs and their responsibilities, download The Many Different Types of DBAs, a white paper recently released by Datavail. This will help you make sure that you are investing in the right set of people who can take your organization to the next level.
To learn more about each of these DBA types,you can also contact Datavail. With more than 600 database administrators worldwide, Datavail is the largest database services provider in North America. As a reliable provider of 24×7 managed services for applications, BI/Analytics, and databases, Datavail can support your organization, regardless of the build you’ve selected.
The “ORA-12154: TNS:could not resolve the connect identifier specified” Oracle error is a commonly seen message for database administrators.