Description
Database administrators test, implement and administer computer databases. They use their expertise in database management systems to plan, coordinate and implement security measures to safeguard computer databases. They also use scripts and configuration files to tailor a database to users' needs.
EssentialOptional
Theoretical Knowledge
distributed computingdata storagedomain name servicedatabase management systemsquery languagesinformation structuredata modelssystem backup best practicedatabase development toolsdata quality assessmentresource description framework query languageOpenEdge DatabaseMicrosoft AccessMDXMySQLPostgreSQLTripleStoreDB2business intelligenceIBM InformixTeradata DatabaseLINQN1QLdata engineeringXQueryonline analytical processingSQL ServerFilemaker (database management systems)ObjectStoreOracle Relational DatabaseLDAPquality assurance methodologiesSPARQLMarkLogic
Practical Skills
design database schemeinterpret technical textsmaintain database performancebalance database resourcesadminister ICT systemapply company policiesdesign database backup specificationsuse databasesperform backupsoperate relational database management systemuse scripting programmingcreate data modelsmanage databasedefine database physical structureuse an application-specific interfacemaintain database securityperform ICT troubleshootingprovide ICT supportimplement anti-virus softwareexecute ICT auditsestimate duration of workimplement ICT security policiesdesign database in the clouduse automatic programmingprotect personal data and privacyuse back-up and recovery toolsimplement a firewallprovide technical trainingmanage cloud data and storagesupport ICT system usersuse different communication channelsremove computer virus or malware from a computeruse spreadsheets software