Core skills: Based on job listings we looked at, employers want Database Administrator with these core skills. If you want to work in this field, focus on the following.
- Should have working experience MySQL Databases
- Should be able to do performance tuning to database (MySQL) through configuring DB as per requirement and Indexing columns
- Working experience in AWS DBMS is added advantage
- Maintain user for different database and experience in Master Slave Architecture is advantage
- Knowledge about creating database function and procedures for performance improvement is an advantage
- Should be able to establish the needs of users and monitoring user access and security
- Should monitor performance and managing parameters to provide fast responses to front-end users
- Should be able to map out the conceptual design for a planned database
- Should be able to refine the logical design so that it can be translated into a specific data model
- Further refining the physical design to meet system storage requirements
- Installing and testing new versions of the DBMS
- Writing database documentation, including data standards, procedures and definitions for the data dictionary (metadata)
- Controlling access permissions and privileges
- Developing, managing and testing back-up and recovery plans
- Maintains quality service by establishing and enforcing organization standards