Senior Oracle Developer

TCrew
  • Brussels
  • Post Date: October 6, 2024
  • 12344
  • Applications 0
  • Views 3
Job Overview

We are seeking a skilled and experienced Oracle Developer to join a cross-functional team, which includes business analysts, product managers, software engineers, and test engineers. Oracle is used as the main database for a Java application. As an Oracle Developer, you will be responsible for designing, developing, maintaining, and deploying Oracle database solutions in a production environment. The ideal candidate will have a strong background in Oracle database development, SQL programming, and PL/SQL scripting. While database administration experience is highly desirable, it is not the primary focus of this role.The successful candidate should be familiar with developing and releasing in an Agile environment. Attention to detail, problem-solving skills, and the ability to work in a fast-paced environment are essential for success in this role. Responsibilities:Analyze and understand the impact of Oracle database patches and upgrades on project databases and act as the Oracle subject matter expert.Collaborate with business analysts and software engineers to analyze user requirements and translate them into technical specifications.Develop and optimize SQL queries for efficient data extraction and manipulation. Write and debug PL/SQL scripts and stored procedures for data transformation and business logic implementation.Perform database performance tuning and optimization to ensure efficient query execution and data retrieval in a distributed architecture.Ensure data integrity and security by implementing proper data validation and access controls.Conduct thorough testing and debugging of Oracle applications to identify and resolve defects.Participate in code reviews to ensure adherence to coding standards and best practices.Collaborate with database administrators to monitor and maintain the health and performance of Oracle databases.Prepare, test, present for review, and execute changes in production (requires physical presence in the office at least 2 days/week).Stay up-to-date with the latest Oracle technologies, tools, and trends to suggest improvements and drive innovation in database development. Requirements:Bachelor’s degree in Computer Science, Information Systems, or a related field (or equivalent work experience).Proven experience as an Oracle Developer or in a similar role, with a strong understanding of Oracle database concepts, architecture, and data modeling.Proficiency in SQL programming and database design principles is essential.Strong experience in PL/SQL scripting and stored procedure development is required.Experience with Oracle security features such as Database Vault and data encryption is required.Experience with Oracle Partitioning is required.Familiarity with Java-related development and the ability to work with Java developers is required.Knowledge of performance tuning tools and techniques to optimize database queries and operations, such as Explain Plan, Autotrace, and AWR.Familiarity with Oracle tools and technologies, such as Oracle Enterprise Manager, SQL Developer, DataPump, and Oracle Text.Ability to work both independently and collaboratively in a team environment.Strong communication skills to effectively collaborate with cross-functional teams and stakeholders at all levels.Ability to work in a fast-paced environment and handle multiple tasks simultaneously.Oracle certifications (e.g., Oracle Certified Professional) are desirable but not required.Knowledge of Docker, OpenShift, and Python is a plus.Experience with Agile methodologies is an asset.

Job Detail
Shortlist Never pay anyone for job application test or interview.