Database Administrator
Current- Responsible for the continuity of database server operations from the company's product in the form of SIMRS.- Perform dumps on the entire database and ensure that the dump runs according to a prearranged and defined schedule.- Acts as super admin on the database server whose job is to monitor and control all activities carried out by users on the database.- Create, manage and control replication servers so that all data on operational servers is always replicated in real-time on backup servers.- As the control holder of access rights from the database server, so users need confirmation and permission when making changes to tables (DDL) or records (DML) from the database.- Perform routine maintenance and tuning of databases in the form of: Reorganize, Partition Tables, and Switch Servers to ensure that the performance of the database is always optimal and efficient in operations.- Creating a new database to meet operational needs and user requests.- Load database according to user request.- Fulfilling user requests when requesting data for a certain period by batching data and submitting it in the form of an excel file.
