- Database Environment.
- Information Technology (IT) Department.
- Database Administrator.
- Database Administration Categories (DBA).
- Responsibilities of a Database Administrator.
- Daily tasks of a database administrator.
- Skills require to become a database administrator.
1.0 Database Environment.
A database environment is a collective system of components that comprise and regulates the group of data, management, and use of data, which consist of software, hardware, people, techniques of handling database, and the data also.
Here, the hardware in a database environment means the computers and computer peripherals that are being used to manage a database, and the software means the whole thing right from the operating system (OS) to the application programs that include database management software like M.S. Access or SQL Server. Again, the people in a database environment include those people who administrate and use the system. The techniques are the rules, concepts, and instructions given to both the people and the software along with the data with the group of facts and information positioned within the database environment.
1.1 Information Technology (IT) Department.
An IT organization (information technology organization) is the department within a company that is charged with establishing, monitoring, and maintaining information technology systems and services.
In a large organization, the IT organization may also be charged with strategic planning to ensure that all IT initiatives support business goals. IT organizational structures vary and can be centralized or decentralized depending upon the needs of the company. In a large enterprise, the IT organization is typically managed by a Chief Information Officer (CIO). Smaller IT organizations might report up to an IT director or operations manager.
1.2 Database Administrator.
A database administrator (DBA) is a specialized computer systems administrator who maintains a successful database environment by directing or performing all related activities to keep the data secure. The top responsibility of a DBA professional is to maintain data integrity. This means the DBA will ensure that data is secure from unauthorized access but is available to users.
A database administrator will often have a working knowledge and experience with a wide range of database management products such as Oracle-based software, SAP and SQL, in addition to having obtained a degree in Computer Science and practical field experience and additional, related IT certifications.
1.3 Database Administrator Categories (DBA).
There exist several Categories of DBAs, some of which and their roles are:
1.3.1 Administrative DBA.
Work on maintaining the server and keeping it running. Concerned with backups, security, patches, High Availability, Disaster recovery migration, upgrading and everything that concern the actual server software.
1.3.2 Development DBA.
Concerned with building stored procedures, building queries, writing codes that meet business needs. This is the equivalent of a programmer.
1.3.3 Database Architect.
Design schemas, build tables, Primary keys, Foreign keys. They work to build a structure that meets the business in general. The design is then used by developers and development DBAs to implement the actual application.
1.3.4 Data Warehouse DBA.
Responsible for merging data from multiple sources into a data warehouse. May have to design warehouse, but cleans, standardize, and scrubs data before loading. In SQL server this DBA will use Data Transformation Service (DTS) oftentimes.
1.4 Responsibilities of a Database Administrator.
The following are some key responsibilities of a database administrator.
- Installation, configuration and upgrading of Microsoft SQL Server and related products.
- Implement and maintain database security (create and maintain users and roles, assign privileges, masking, Transparent Data Encryption, Always Encrypted)
- Implement Disaster Recovery (establish and maintain sound backup and recovery policies and procedures)
- Ensure high availability (Always On availability groups, clustering)
- Database tuning and performance monitoring.
- Take care of the database design and implementation.
1.5 Daily tasks of a database administrator.
The following are some of the daily activities of a database administrator.
- Attend meetings with other team members for the implementation of new applications.
- Review emails and ticketing system.
- Answer users request.
- Review monitoring tools for potential issues.
- Work on projects.
1.6 Skills require to become a database administrator.
Below are list of skills required to become database administrators:
- Knowledge of database queries
- Knowledge of database theory
- Knowledge of database design
- Knowledge about the RDBMS itself, e.g. Microsoft SQL Server or MySQL
- Knowledge of structured query language (SQL), e.g. SQL/PSM or Transact-SQL
- General understanding of distributed computing architectures, e.g. Client–server model
- General understanding of operating system, e.g. Windows or Linux
- General understanding of storage technologies and networking
- General understanding of routine maintenance, recovery, and handling failover of a database.