Oracle DBA with ExaCC Knowledge (BPM037335)

Maintenance and support of day-to-day business in the database team.

DBA-tasks:

• Maintenance and support of day-to-day business in the database team
• Implementation of database services after commissioning
• Create new databases and environments in an extended RAC environment
• Set up services for applications considering specifics such as not RAC capable
• Guarantee reliability or proactive participation in measures to avoid production downtime
• Solving production downtimes competently and promptly
• Conversion of Oracle CDB/ PDB databases
• Analyzing and defining cardinalities for old applications on RAC
• Participation in release assignments
• Provision of participation services from the database team in projects, e.g. Move2Cloud and in regulatory requirements as well as POCs
• Systematically analyze security gaps and develop solutions
• Analyze and fix performance issues
• Optimize database monitoring
• Set up backup and ensure fast recovery times through regular testing during environment setup
• Onboarding new DB users to CyberArk
• Support of the Oracle Apex application as well as participation in the patching of these
• Participation and further development of the Database Information System (DBI)
• By arrangement, in exceptional cases, readiness for weekend assignments and on-call duty required

• Automatisierungs-tasks:
• Support in the automation of pseudonymization of data after a database rebuild by means of ETL development
• Systematically evaluate the DB parameters across all databases and script necessary changes to further automate
• Provide Views and Selects for database information systems to implement systematic quality checks
• Further develop Ansible scripts for inline patching and extend them for PDB
• Participation in patching Oracle databases and, if necessary, other DB technologies
• Ensure Git versioning
• Standardize Oratab and Oracle Home settings
• Adapting existing scripts for Cloud Move
• Further automation for environment setups