Job
- Level
- Experienced
- Location
- Dresden
- Working Model
- Onsite
- Job Field
- Database
- Employment Type
- Full Time
- Contract Type
- Permanent employment
Job Summary
In this role, you analyze existing Oracle databases, identify performance issues, and develop proactive monitoring solutions to ensure stability and scalability.
Job Technologies
Your role in the team
- Analysis and evaluation of existing Robotron systems (Oracle-based) regarding performance, stability, and scalability.
- Identification, analysis, and sustainable resolution of performance issues at the database and application level.
- Development, enhancement, and operation of proactive performance and database monitoring (e.g., plan changes, SQL runtimes, SGA/PGA utilization, CPU, I/O, and wait analyses).
- Conducting and analyzing performance assessments using AWR, ASH, SQL Monitor, and other Oracle tools.
- Analysis, evaluation, and optimization of SQL statements, PL/SQL components, and execution plans, as well as support for the product development squads.
- Investigation of plan changes and development of sustainable solutions for root cause elimination together with the development squads; use of plan stabilization (e.g., SQL Plan Management) exclusively as an emergency measure.
- Definition of best practices, standards, and architecture guidelines for Oracle databases and database-related developments.
- Advising and supporting product development on database-related issues, as well as actively contributing optimization potentials.
- Development of recommendations for database baseline setups, statistical concepts, and performance specifications for new and ongoing developments.
- Close collaboration with development, architecture, and operations to sustainably improve application performance.
- Participation in projects for performance optimization and technical development of the platforms.
- Support of incident and problem management in critical performance or stability issues.
This text has been machine translated. Show original
Our expectations of you
Qualifications
- In-depth knowledge of Oracle Database (preferably 19c and higher).
- Excellent knowledge of SQL and PL/SQL.
- Excellent knowledge in reading, understanding, and optimizing Oracle execution plans.
- Knowledge in the areas of SGA, PGA, Shared Pool, Memory Management as well as Database and Operating System Monitoring.
- Ability to analyze performance issues in a structured manner and develop sustainable solutions.
- Strong communication skills as a liaison between operations, development, and architecture.
- Independent, analytical, and solution-oriented working style.
- Knowledge of Oracle Exadata, RAC, Data Guard, or OCI.
- Knowledge of Linux as well as Shell Scripting.
Experience
- Several years of experience as an Oracle DBA, Application DBA, or Oracle Performance Engineer.
- Extensive experience in analyzing AWR, ASH, and SQL Monitor data.
- Experience with Oracle Optimizer, statistics, histograms, bind peeking, cursor sharing, and plan stability.
- Experience in building and developing monitoring and alerting solutions.
- Experience with DevOps and automation approaches in the database environment.
- Experience in the environment of mission-critical applications with high availability requirements.
This text has been machine translated. Show original
Benefits
Work-Life-Integration
Health, Fitness & Fun
Topics You Will Work On
Job Locations
About Your Employer
Robotron Datenbank-Software GmbH
As an Oracle Platinum Partner, Robotron is particularly specialized in the area of Engineered Systems and offers high performance capabilities. We design and implement highly available high-performance systems based on Engineered Systems.
Description
- Company Size
- 50-249 Employees
- Company Type
- Established Company
- Working Model
- Hybrid, Onsite
- Industry
- Internet, IT, Telecommunication
Application DBA with a focus on performance
- Location
- Dresden
- Working Model
- Onsite
- Diversity
- Open for all genders
