Dear Friends, I have written a fresh piece which covers all the basic information about DBA. If you are a beginner and want to know from basic, please go through my article and i am sure you will quickly become better Database Administrator than you ever thought possible. Let’s explore DBA.
A DBA is a person responsible for the design, implementation, and maintenance and fixed the database issues .The goal of the DBA is to keep the database server up to all times and measure pertaining to the management, security. The DBA makes sure that the database is protected in case of failure data lose is minimal by implementing the healthy backup/restore techniques.
Type of DBA
There are many types of DBA
In here we will discuss about Logical DBA and Physical DBA according two famous authors.
- Craig S. Mullins :
Craig S. Mullins has been written popular book of (Book: Database Administration: The Complete Guide to Practices and Procedures) (http://www.CraigSMullins.com), (http://media.techtarget.com/digitalguide/images/Misc/DBA_types.pdf)
System DBA (Physical)
System DBA is maintains the servers and databases and keeps them running. It is responsible for DBMS installation, operating system configuration, OS tuning, storage management, Concerned with backups, security patching and etc. System DBAs are rarely involved with actual implementation of databases and application.
Database Architect/Data Modeler (Logical/Physical)
Database Architects works on building table’s indexes, data structures and relationships, SQL queries, stored procedures; and so on this is the equivalent of the programmer, but specializing in database development. Database Architect typical tasks are Creating a logical data model and Translating logical data models into physical database designs, and implementing efficient databases, including specifying physical Characteristics, designing efficient indexes, and mapping database objects to Physical storage devices.
Data Modeler: A data modeler is usually responsible for a subset of the DA’s responsibilities. The role of the DA goes into planning the infrastructure of information system in terms of
- Business Objectives
- Business Intelligence
- Geographic Distribution of Data
Application DBA (Logical)
DBA focuses on database design and the current support and administration of databases for a specific application or applications. The application DBA is likely to be an expert at writing and debugging complex SQL and understands the best ways to join database requests into application programs. The application DBA must also be capable of performing database change management, performance tuning.
Performance Analyst (Logical/Physical)
A performance analyst must understand the details and nuances of SQL coding for Performance and be able to design databases for performance. A performance analyst will have very detailed technical knowledge of the DBMS so that he can make appropriate changes to DBMS and system parameters when required. The performance analyst is usually the most skilled, senior member of the DBA staff.
Data Warehouse Administrator (Logical/Physical)
Data Warehouse Administrator responsible for merging data from multiple sources into a data warehouse. It can be design the data warehouse as well as cleaning up and standardizing the data before loading using specialist data loading and transformation tools.
Data warehouse administration requires experience with the following:
- Business intelligence, query, and reporting tools
- Database design for read-only access
- Data warehousing design issues such as star schema
- Data warehousing technologies such as OLAP (including ROLAP, MOLAP,
- and HOLAP)
- Data transformation and conversion
- Data quality issues
- Data formats for loading and unloading of data
OLAP DBA (Logical/Physical)
OLAP DBA Builds multi-dimensional cubes for decision support or OLAP systems. The primary language in SQL Server is MDX, not SQL.
2. Brad McGhee:
Brad McGhee has been written lot of books, one of the popular books of
(Book: How to become an Exceptional DBA) (http://bradmcgehee.com), (https://lucianasampaio.files.wordpress.com/2013/03/exceptional-dba-2nded.pdf )
DBA System Administrator (Production DBA)-Physical
it would be responsible for server-level operations likes- security, backup/restore operations, Disaster Recovery/backward compatibility for backups, maintenance plans, performance monitoring (but probably not tuning), database growth VS disk space available, audits, resource monitoring (I/O bottlenecks, memory pressure, CPU use). Production DBA wouldn’t touch data modeling, normalization, database architecture, T-SQL coding, securing dynamic SQL, index planning, file stream, etc.
DBA Database Designer (Logical/Physical)
It is directly work on creating new Database Schemas and develop logical or physically database designs based on user needs requirements.
DBA Developer (Logical)
DBA Developer works on building queries, stored procedures and functions, CLR (Common Language Runtime) objects, etc. that meet business needs. This is the equivalent of the programmer. You primarily write T-SQL.
DBA High Availability Specialist (Logical/Physical)
High Availability DBA is responsible for the housing and storage of your company’s data. It’s work on disaster environment in protection server.
Now High availability specialist DBA focus work on SQL server features on production servers which are following
- SQL Server Failover Clustering
- SQL Replication
- SQL Mirroring
- SQL Log Shipping
- SQL 2012 Always On Availability Groups
- Disaster recovery
DBA Business Intelligence Specialist (Logical/Physical)
It design, create, and maintain data warehouse and OLAP (Online Analytical Process) cubes so that data can be more easily be retrieved and analyzed by an organizations. This involves developing BI-based application. They also design or configure Business Intelligence tools use by end user-users.
DBA Report Writer (Logical)
Report Writer DBA responsible for design and create reports in order to extract data from databases in meaningful formats
According to Craig S. Mullins and Brad McGhee, the Logical DBA is creating developing, design, debugging, etc. the Logical things for the database and the Physical DBA is responsible for configuration, maintenance, physical design, etc.
Roles and responsibilities of the DBA
- Installation, configuration and upgrading of Microsoft SQL Server/MySQL/Oracle server software etc.
- It evaluates MSSQL/MySQL/Oracle features.
- It Maintain sound backup and recovery policies and procedures.
- Database design and implementation.
- It also define and maintain database security (create and maintain users and roles, allot privileges).
- It most important task is Database tuning and performance monitoring.
- Application tuning and performance monitoring.
- Setup and maintain documentation and standards.
- Plan to growth and changes (capacity planning) of databases.
- Work as part of a team and provide 7×24 supports when required.
- It works on trouble shooting and also give works consultation to development teams.
Who can be DBA?
To be DBA, you should have basic knowledge of Database and T-SQL. You can observe some criteria profile person can be DBA.
- System administrator
- Software engineer
- Fresher as well
I hope you will enjoy these knowledge’s about DBA in SQL Server. I would like to have feedback from my blog readers. Your valuable feedback, question, or comments about this article are always welcome.