{bc}
indeed

Oracle PL/SQL Developer

COZMALABS
Doha, QAT
Fulltime
3 months ago
ScalaSQL
Free

Job Fit Check

Base Career helps you apply smarter for this job.

?%
Ready to Scan

Key skills for this role

ScalaSQL
Smart Apply

Full Job Posting

Job Summary**

The Oracle PL/SQL Developer will design, development, optimization, and maintenance of Oracle database applications using PL/SQL.

This role requires deep expertise in Oracle database technologies, and strong problem-solving skills.

The candidate will collaborate with cross-functional teams to deliver scalable, high-performance database solutions that meet business requirements.

Database Development**

  • Design, develop, and implement complex PL/SQL programs, stored procedures, functions, packages, triggers, and views to support business applications.
  • Write efficient, optimized, and maintainable SQL and PL/SQL code for data manipulation, reporting, and ETL processes.
  • Develop and maintain database schemas, tables, indexes, and partitions to ensure performance and scalability.

Performance Optimization**

  • Analyze and optimize SQL queries and PL/SQL code to improve performance and reduce execution time.
  • Implement partitioning, indexing, and materialized views to enhance database performance.

System Integration**

  • Collaborate with application developers to integrate Oracle databases with front-end applications, middleware, or third-party systems.
  • Develop and maintain APIs, database interfaces, and data migration scripts for seamless integration.
  • **Documentation and Standards**:
  • · Create and maintain technical documentation, including data flow diagrams, ERDs, and code documentation.
  • · Adhere to coding standards, version control practices, and change management processes.

Collaboration**

· Work closely with business analysts, project managers, and stakeholders to gather requirements and translate them into technical solutions.

Required Skills and Qualifications**

  • **Education**: Bachelor’s degree in Computer Science, Information Technology, or a related field (or equivalent experience).
  • **Experience**:
  • 5+ years of experience in Oracle PL/SQL development.
  • Proven expertise in Oracle Database versions (e.g., 11g, 12c, 19c, or higher).
  • Experience with large-scale, high-transaction database environments.
  • **Technical Skills**:
  • Advanced proficiency in writing and optimizing complex PL/SQL code (stored procedures, packages, triggers, etc.).
  • Strong knowledge of SQL query optimization, indexing, and performance tuning techniques.
  • Familiarity with Oracle tools like SQL Developer, TOAD, or SQL*Plus.
  • Experience with data modeling tools (e.g., ERwin, Toad Data Modeler).
  • Knowledge of Oracle features like partitioning, materialized views, and advanced queuing.
  • Understanding of database security, roles, and privileges.
  • Familiarity with ETL processes, data warehousing, and tools like Oracle Data Integrator (ODI) or Informatica (a plus).

Apply for this job in 1 click

Skip the repetitive application forms

Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.

Sarah M.James T.Maya R.

Trusted by over 500,000 job seekers on Base Career

Start Free Today

More from this employer

More jobs at COZMALABS