Database Administrator DBA Job Description

The Database administrator is basically defined as the IT professional that oversees all aspects of a business database.

This would including anything from initial database architecture design through implementation, administration, monitoring, tuning, backup, migration, and support.

Other common job titles that similar to DBA: Data Architect, Data Modeler, Data Administrator, Database Designer, Database Manager.

Common Responsibilities for Database Administrator (DBA)

  1. Design and document database architecture. Data Modeling.
  2. Design Data Warehousing and Business Intelligence platform
  3. Build database scheme, tables, procedures and permissions
  4. Set up data sharing and disk partitioning
  5. Develop database utilities and automated reporting
  6. Create shell scripts for task automation
  7. Create, test and execute data management languages
  8. Analyze and sustain capacity and performance requirements
  9. Analyze, consolidate and tune database for optimal efficiency
  10. Monitor systems and platforms for availability.
  11. Oversee backup, clustering, mirroring, replication and failover
  12. Restore and recover corrupted databases
  13. Install and test upgrades and patches
  14. Implement security and encryption
  15. Provide 24/7 support for critical situations
  16. Evaluate and recommend new database technologies

Common IT Hardware, Software and Systems Knowledge

Oracle, DB2, SQL Server, Sybase, Shell (C, Korn, Bourne, KSH), AUP, OLTP, Linux, UNIX, AIX, Solaris, T-SQL, PL/SQL, SSIS, SSAS, SSRS, RAID, SAN, DTS, ETL, RMAN, Tivoli, Veritas, Legato