Oracle DBA
Job description
- Database Administration: Oversee the installation, configuration, maintenance, and upgrades of Oracle databases (latest versions) on various operating systems.
- Performance Tuning: Utilize tools like AWR, ADDM, and SQL tuning to monitor and enhance database performance and optimize SQL queries.
- Backup and Recovery: Implement and maintain robust backup and recovery strategies using RMAN and Oracle Data Pump to ensure data integrity and availability.
- High Availability and Disaster Recovery: Configure and manage Oracle Data Guard, RAC, and other high availability solutions to ensure minimal downtime.
- Security Management: Ensure database security in compliance with industry standards; manage user access, roles, and privileges.
- Database Monitoring: Use Oracle Enterprise Manager and other monitoring tools to proactively identify and resolve database issues.
- Database Development Support: Assist developers with database design, efficient SQL coding, and data loading processes.
- Automation and Scripting: Develop and maintain automation scripts for routine database maintenance tasks using Shell scripting or PL/SQL.
- Documentation: Maintain accurate documentation for database configurations, processes, and changes.
- Incident Management: Quickly troubleshoot and resolve complex database issues, ensuring minimal impact on production.
Qualifications
- Bachelor's degree in Computer Science or a related field.
- Proven experience as an Oracle DBA with expertise in PL/SQL development.
- Proficient in Oracle tools such as Oracle SQL*Loader, SQL Developer, Oracle Data Pump, RMAN, Oracle Grid Infrastructure (ASM), and Oracle Enterprise Manager (OEM 13c or higher).
- Experience with Oracle RAC, Data Guard, and ASM for high availability.
- Strong understanding of database security, backup, and recovery best practices.
- Advanced knowledge of performance tuning methodologies using tools like STATSPACK, AWR, ADDM, and TKPROF.
- Excellent problem-solving skills and ability to perform root cause analysis for performance or system issues.
- Strong communication skills for working with cross-functional teams and documenting technical processes.
- Level of English: Upper-Intermediate or higher.
- German language at a conversational level.
Benefits
- 25 days of fully paid vacation annually.
- 3 sick days plus paid sick leave.
- A transparent and well-structured salary review process.
- Annually performance and salary reviews.
- A strong team of like minded people in knowledge and experience sharing environment.
- A cohesive team, actively sharing knowledge and experience through internal TechTalks both within and outside the project scope.
- Family celebration bonuses.
- Medical insurance after probation period.
- Flexible working hours.
