As a database administrator (DBA) primary job is to ensure that data is available, protected from loss and corruption, easily accessible as needed. DBA needs to know potential weaknesses of the database software and the company’s overall system and work to minimize risks. The DBA needs to know how large the database currently is and how fast it is growing in order to make predictions about future needs.
● Installing and upgrading the database server and application tool
● Allocating system storage and planning 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 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
● 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
● Understanding concept and architecture of Cluster Database ( Galera Cluster, MongoDB Cluster, SQL/NoSQL Cluster )
● Understanding backup and recovery concept of Database (Full Backup, Incremental Backup, PITR)
● Understanding concept of building effectiveness of SQL query. (Tuning and Security)
● Ability to use multiple scripting
● Experienced on linux platform
● Experienced on storage and OS layer administration
● Experienced on OpenShift (Docker and Container)