Oracle Database Developer

Riyadh, KSA

Responsibilities:

• Develop, optimize, and maintain JPQL (Java Persistence Query Language) queries to interact with the Oracle database effectively.
  
• Design and implement complex SQL queries, stored procedures, functions, triggers, and views to support application development and data integration needs.
  
• Ensure high performance and responsiveness of Oracle database operations, optimizing query performance and reducing execution times.
  
• Implement best practices for database management, including indexing strategies, query optimization, and efficient data retrieval techniques.
  
• Perform database tuning and maintenance activities, including partitioning, data archiving, and backup/recovery strategies.
  
• Develop and maintain documentation for database designs, queries, procedures, and other technical specifications.
  
• Troubleshoot database-related issues, providing timely resolution and ensuring minimal disruption to services.

Qualifications:

• Bachelor’s degree in Computer Science, Software Engineering, or a related field.
  
• 5+ years of experience as an Oracle Developer.
  
• Strong proficiency in Oracle SQL and PL/SQL for writing complex queries, stored procedures, functions, and triggers.
  
• Solid understanding of Oracle database architecture, including performance tuning, indexing, and query optimization techniques.
  
• Familiarity with Oracle tools and utilities such as Oracle SQL Developer, Oracle Enterprise Manager, and Oracle Data Pump.