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)
- Design and document database architecture. Data Modeling.
- Design Data Warehousing and Business Intelligence platform
- Build database scheme, tables, procedures and permissions
- Set up data sharing and disk partitioning
- Develop database utilities and automated reporting
- Create shell scripts for task automation
- Create, test and execute data management languages
- Analyze and sustain capacity and performance requirements
- Analyze, consolidate and tune database for optimal efficiency
- Monitor systems and platforms for availability.
- Oversee backup, clustering, mirroring, replication and failover
- Restore and recover corrupted databases
- Install and test upgrades and patches
- Implement security and encryption
- Provide 24/7 support for critical situations
- 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