Sponsored Links
-->

Monday, April 16, 2018

Database Administrator - What does a DBA do | Skills | Pro & Cons
src: mentoryes.com

Database administrators (DBAs) use specialized software to store and organize data.

The role may include capacity planning, installation, configuration, database design, migration, performance monitoring, security, troubleshooting, as well as backup and data recovery.


Video Database administrator



Skills

List of skills required to become database administrators are:

  • Communication skills
  • 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

Database administrators benefit from a bachelor's degree or master's degree in computer science. An associate degree or a certificate may be sufficient with work experience.

Certification

There are many certifications available for becoming a certified database administrator. Many of these certifications are offered by database vendors themselves. Database administrator certitifications may be earned by passing a series of tests and sometimes other requirements. Schools offering Database Administration degrees can also be found.

For example:

  • IBM Certified Advanced Database Administrator - DB2 10.1 for Linux, Unix and Windows
  • IBM Certified Database Administrator - DB2 10.1 for Linux, Unix, and Windows
  • Oracle Database 12c Administrator Certified Professional
  • Oracle MySQL 5.6 Database Administrator Certified Professional
  • MCSA SQL Server 2012
  • MCSE Data Platform Solutions Expert

Maps Database administrator



Duties

A database administrator's responsibilities can include the following tasks:

  • Installing and upgrading the database server and application tools
  • Allocating system storage and planning future storage requirements for the database system
  • Modifying the database structure, as necessary, from information given by application developers
  • Enrolling users and maintaining system security
  • Ensuring compliance with database vendor license agreement
  • Controlling and monitoring user access to the database
  • Monitoring and optimizing the performance of the database
  • Planning for backup and recovery of database information
  • Maintaining archived data
  • Backing up and restoring databases
  • Contacting database vendor for technical support
  • Generating various reports by querying from database as per need
  • Managing and monitoring data replication

Acting as liaison with users


So, You want to be a Database Administrator รข€
src: i1.wp.com


See also

  • Comparison of database tools

Q&A - Database Administrator | What they do - YouTube
src: i.ytimg.com


References


Elegant database administrator looking at the screen and pointing ...
src: c8.alamy.com


External links

Source of article : Wikipedia