Which tasks were implemented
- Regular backups to prevent data loss and ensure fast recovery options
- Efficient allocation and monitoring of storage space to optimize system performance
- Continuous monitoring of system resources to detect performance problems at an early stage
- Implementation of strict access policies to secure sensitive data and systems
- Precise definition and assignment of user rights to increase system security
- Systematic evaluation of log files for error detection and security monitoring
- Detailed investigation of system errors to quickly rectify and prevent future problems
- Effective resolution of operational and technical problems to maintain operations
- Checking and controlling automated processes to ensure correct execution
- Incident and service request processing (2nd / 3rd level) in ITSM
- Systematic handling and resolution of recurring problems to improve system stability (problem management)
- Careful planning and implementation of changes to minimize disruptions and risks (change processing)
- Implementation of regular software maintenance (patch management)
- Proactive monitoring of the individual services
- Reactive monitoring of the individual services
- Creation and updating of documentation
- Installing / uninstalling new databases
- Carrying out and checking backups
- Carrying out restores and restore tests to verify the procedures used or at the customer’s request
- Evaluation of monitoring and events for fault prevention
- Performance analysis on customer request
- New or further development of the database service
- File system management (archive log, trace and log file housekeeping)
- Monitoring and adjustment of database storage areas to optimize performance and capacity (tablespace management)
- Performance checks
- Database export / import on customer request
- Execution of a penetration test against the database environment
- Execution of planned fail-over tests to check the Dataguard functionality
Which technologies were used
- Oracle Database 19c
- Oracle SQL und PL/SQL
- Windows Server 2019
- MS Office 365
- ITILv4
- Industry software