The document discusses how to become a database administrator (DBA). It begins by defining a DBA as someone responsible for the design, implementation, maintenance and repair of databases. It then discusses different types of DBAs like system DBAs, development DBAs, and data warehouse DBAs. The roles and responsibilities of a DBA are also outlined, including installing and configuring SQL Server, monitoring performance, implementing backups, and more. Finally, it provides tips for becoming a DBA, such as understanding database concepts, getting certifications, practicing skills, and constantly learning.
The document discusses how to become a database administrator (DBA). It begins by defining a DBA as someone responsible for the design, implementation, maintenance and repair of databases. It then discusses different types of DBAs like system DBAs, development DBAs, and data warehouse DBAs. The roles and responsibilities of a DBA are also outlined, including installing and configuring SQL Server, monitoring performance, implementing backups, and more. Finally, it provides tips for becoming a DBA, such as understanding database concepts, getting certifications, practicing skills, and constantly learning.
The document discusses how to become a database administrator (DBA). It begins by defining a DBA as someone responsible for the design, implementation, maintenance and repair of databases. It then discusses different types of DBAs like system DBAs, development DBAs, and data warehouse DBAs. The roles and responsibilities of a DBA are also outlined, including installing and configuring SQL Server, monitoring performance, implementing backups, and more. Finally, it provides tips for becoming a DBA, such as understanding database concepts, getting certifications, practicing skills, and constantly learning.
The document discusses how to become a database administrator (DBA). It begins by defining a DBA as someone responsible for the design, implementation, maintenance and repair of databases. It then discusses different types of DBAs like system DBAs, development DBAs, and data warehouse DBAs. The roles and responsibilities of a DBA are also outlined, including installing and configuring SQL Server, monitoring performance, implementing backups, and more. Finally, it provides tips for becoming a DBA, such as understanding database concepts, getting certifications, practicing skills, and constantly learning.
Copyright:
Attribution Non-Commercial (BY-NC)
Available Formats
Download as PDF, TXT or read online from Scribd
Download as pdf or txt
You are on page 1/ 9
SQLDBPool.
com Email: jugal.shah@sqldbpool.com Chat: Jshah.sqldbpool@gmail.com Site: http://www.sqldbpool.com/
3 How to be DBA?
2 DBA Roles and Responsibiliteis
1 What is DBA?
By Jugal Shah
What is DBA? A database administrator (DBA) is a person responsible for the design, implementation, maintenance and repair of the database. The main goal of the DBA is to keep the database server up at all times and make it available for the authenticated users. The DBA makes sure that the database is protected and in case of any failure data loss is minimal by implementing the high availability or by designing the robust backup/restore techniques.
Who can be DBA?
I have been posted with the number of queries as to how to become DBA or what exactly needs to be done that to be DBA. Anyone who has basic knowledge of database and T-SQL can be SQL DBA
-System Administrator -Software Engineer -Programmer -College Fresher as well
System DBA- System DBAs are the DBA whose Primary skill is System Administration. System DBA is responsible for DBMS installation, Operating System Configuration, OS Tuning, Storage management, Patching and more.. Development DBA - works on building queries, stored procedures, etc. that meet business needs. This is the equivalent of the programmer. You primarily role is write T-SQL. Database Architect Design schemas. Build tables, FKs, PKs, etc. Work to build a structure that meets the business needs in general. The design is then used by developers and development DBAs to implement the actual application Data Warehouse DBA - is responsible for merging data from multiple sources into a data warehouse. DW DBA design warehouse, but cleans, standardizes, and scrubs data before loading into warehouse. In SQL Server, this DBA would use DTS/SSIS heavily. OLAP DBA Builds multi-dimensional cubes for decision support or OLAP systems. The primary language in SQL Server is MDX, not SQL here
2 3 4 5 6
Application DBA DBAs straddle the fence between the DBMS and the application. He is responsible for ensuring that the application is fully optimized for the database and vice versa.
DBA Roles and Responsibilities
Installation and Configuration of SQL Server
Up-gradation of SQL Server from lower version to higer version
Migration of SQL Server Database from One Server to Another Server
Applying patch and hot fix to SQL Server
Monitoring SQL Server Health
Monitoring Operating System Health
Troubleshooting the MSSQL, Database and Operating System Pefromance issue
Setting Up SQL Server Level, Database Level and Operating System Alerts
DBA Roles and Responsibilities
Capacity Planning for the hardware requirement
Designing and Implementing Backup/Recovery Strategies
10
12
Implementing HA Solutions (Replication, Mirroring, Clustering and Log Shipping)
Managing Logins, Users and Security
13
14
Establishing and Enforcing Standards
Implementation of robust maintenance plan (Index Defrag, Stats Update, DBCC)
15
16
T-SQL Tuning
Creating and Scheduling Jobs
17
DBA Roles and Responsibilities
18
Expert in troubleshooting the SQL Server and Database Issues
Documentation of any implementation and change
19
20
Expert level knowledge of SQL Server Architecture
Co-ordination with third party vendor for any product related issue
21
22
Knowledge of ITIL standards
Knowledge of Operating System
23
24
Knowledge of all the SQL versions and newer features.
Closely work with Developer
25
How to be DBA?
SQL Server Architecture
SQL Server Services System Databases Recovery Models DMVs System Objects Pages/Extents Internal Storage ACID Properties Isolation Levels Locking Architecture T-Log Architecture Memory Protocols
Database Administration Performance & Tuning Backup/Restore Maintenance Plan HA Setup DBCC Blocking/Deadlock Capacity Planning SQL Profiler DTA SQL Configuration Best Practice Security Setup Databaes Design
SQL Server Installation & Configuration
Cluster & Standalone SQL Server Installation RAID Levels SPN Active Directory SP, Patches and Hot fixes SQL Server Editions SQL Server Versions Server level config. Third Party Tools installation & config.
Support
Troubleshooting Alerts Setup DB Mail Setup 7 X 24 Support Ticketing System ITIL Knowledge
How to be DBA?
1 2 3 4 5
If your aim is to become a database administrator, you need to understand the underlying concepts of database and the responsibilites mentioned in the previous slides. A programming background is helpful. Any programming knowledge is highly recommended but knowledge of T-SQL is a must for a DBA. Get books, read magazines, use Internet resources, participate in DBA related forums and news groups and start from there. Attend SQL DBA Courses
Visit relevant websites and talk with real DBAs. Go for Linked In site and increase your network Look for opportunities to practice your DBA Skills
6 7 8
Go for the Microsoft SQL Server Certification Becoming a DBA involves more than getting a certification. It requires intensive study, constant learning, practice and most importantly the creation of opportunities for work experience.
All the Best I wish you all the best in your DBA Career
