Job
In this role, you analyze existing Oracle databases, identify performance issues, and develop proactive monitoring solutions to ensure stability and scalability.
This listing has been machine translated. Show original
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.
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.
Benefits
Work-Life-Integration
Health, fitness & fun
Topics you will work on
Job locations
About your employer
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.
- 50-249 Employees
- Established Company
- Onsite, Hybrid
- Internet, IT, Telecommunication
More jobs
These jobs might also interest you
The role As a Forward Deployed AI Engineer, you go directly into our specialist departments, understand the processes, and develop production-ready AI and automation solutions that will fundamentally change the way the entire GGW Group operates. You do...
Hello, let's say WE! We - the HUK-COBURG Insurance Group - are among the top 10 in Germany. Founded over 90 years ago, we are now the leading insurer for private households with over 13 million customers and the largest German auto insurer. Our...
Anyone who joins here not only designs software – they bring machines to life that are recognizable on real construction sites. Software Developer (m/f/d) Basic Engineering Our client is an internationally leading manufacturer of technically...
