Senior Oracle Applicative Developer – PL/SQL

6 hours ago

Petah Tikva Center District, Israel ONE datAI Full time ₪80,000 - ₪160,000 per year

Company Description

ONE datAI, a division of One Technologies, specializes in delivering professional Data and AI solutions, including strategic consulting, data infrastructure, automation, and advanced analytics. Established in 2006, the company is a leader in Israel's data landscape and serves a diverse range of industries such as finance, retail, healthcare, public defense, and more. With a team of over 200 skilled experts, ONE datAI leverages innovation and excellence to transform complex data challenges into strategic opportunities. Trusted by hundreds of organizations, we are committed to driving growth and creating lasting impact through data-driven solutions.

Profile Summary & Interpersonal Skills

  • Desired Role:
    Senior Oracle Applicative Developer with deep expertise in database performance tuning.
  • Experience:
    5+ years of proven experience in developing and maintaining Oracle-based systems.
  • Teamwork & Collaboration:
  • Strong ability to work as part of a development team, collaborating closely with cross-functional teams (including C#/Web teams).
  • Ability to understand code written in other languages (significant advantage for candidates with C# knowledge) to identify system-level bottlenecks across both application and database layers.
  • Initiative & Ownership:
    A proactive problem-solver who takes ownership, suggests performance improvements, and consistently meets deadlines and quality standards.

Technical Expertise – Development & Optimization
1. Core Oracle Development (PL/SQL)

  • Advanced Proficiency:
    Deep and comprehensive mastery of PL/SQL and SQL.
  • Packages & Procedures:
  • Expert in developing, maintaining, and optimizing complex Procedures and Packages.
  • Ability to implement efficient, scalable business logic directly within the database.
  • SQL Mastery:
  • Extensive experience with complex queries including Window Functions, CTEs, and transaction management.
  • Batch Processing:
  • Hands-on experience designing long-running, mission-critical batch processes while ensuring high stability and performance.
  • No Web Development Required.

2. Performance Tuning Expertise

  • SQL Tuning:
  • Skilled in analyzing and optimizing slow or business-critical queries.
  • Strong ability to read and interpret Execution Plans.
  • Strategic use of indexes (including functional and multi-column).
  • Identifying and resolving locks, contention, and session-level bottlenecks.
  • PL/SQL Tuning:
  • Optimization of loops, I/O operations, and procedural logic to improve runtime and reduce CPU/I/O consumption.
  • Monitoring Tools:
  • Hands-on experience with AWR, TKPROF, and other advanced Oracle performance diagnostics tools.

Additional Skills & Cross-Development Collaboration

  • Application Code Understanding:
  • Practical/theoretical understanding of server-side application structure (C# is a strong advantage), enabling:
  • Effective technical communication with application developers.
  • Identification of performance issues caused by non-optimized application-to-database interactions.
  • Database Architecture:
  • Strong understanding of Oracle architecture (SGA, PGA, Redo Logs), statistics, and DB object behavior and how they impact performance.

  • PL/SQL Developer

    7 hours ago

    Rehovot, Center District, Israel Logica-IT Full time ₪50,000 - ₪70,000 per year

    לארגון גדול ומוביל דרוש/ה מפתח/ת APEX בעל/ת ניסיון מוכח בפיתוח על גבי בסיסי נתונים Oracle ויכולות פיתוח חזקות בשפות SQL ו-PL/SQL.תיאור התפקיד:‐ פיתוח ותחזוקת יישומים בסביבת Oracle APEX‐ עבודה שוטפת עם בסיסי...

  • DBA Oracle and/or SQL Server

    6 hours ago

    Givat Shmuel, Center District, Israel Experda Full time ₪180,000 - ₪240,000 per year

    Nice to meet you — we're ExperdaAt Experda, we believe data is a strategic asset. We deliver a unique mix of professional services and end-to-end solutions in database and data management — from automation and system optimization to architecture design and crisis support.We're hiring a DBA (Application & Infrastructure) to join our dynamic team and help...

  • BI Back-End Developer

    6 hours ago

    Petah Tikva, Center District, Israel ONE datAI Full time ₪60,000 - ₪120,000 per year

    We're looking for a BI Back-End Developer to join a dynamic BI team within a large organization that's embracing advanced and innovative technologies.The team is responsible for the full BI lifecycle — from design, implementation, and maintenance to deployment — leading major organizational projects.Key Responsibilities:Develop BI systems and ETL...

  • ETL Developer

    7 hours ago

    Netanya, Center District, Israel entrypoint Full time ₪60,000 - ₪120,000 per year

    ETL Developer – Leading Technology CompanyJob Description:A leading technology company is seeking a talented and experiencedETL Developerto join our Data Engineering team.This role involves designing, developing, and maintaining complex ETL processes and data pipelines within a large-scaleData Warehouseenvironment. You will be working closely with system...

  • ETL Developer For Leading company 5337

    6 hours ago

    Center District, Israel INGIMA Full time ₪60,000 - ₪80,000 per year

    An exciting opportunity for an ETL Developer with experience inData Stageto join a team leading significant data projects. If you have experience working with Oracle, PL/SQL, and are seeking your next challenge, this is the role for youWhat's required?At least 2 years of experience working with Data Stage in an Oracle environmentExperience writing...

  • Large Account Manager

    6 hours ago

    Petah Tikva, Central District, Israel Oracle Full time ₪120,000 - ₪180,000 per year

    DescriptionLarge Account Manager With a presence in over 175 countries, we are one of the biggest technology companies on the planet, operating with the ingenuity of a start-up. We believe in diversity and inclusion to drive innovation beyond what has been done before. We empower researchers to discover the secrets of our universe and help the world's...

  • ETL Developer for an Enterprise Company 5323

    7 hours ago

    Center District, Israel INGIMA Full time ₪90,000 - ₪120,000 per year

    Maintain existing ETL interfaces and data processesDevelop new ETL workflows and data pipelinesCollaborate with various stakeholders, including system analysts, QA teams, and frontend teamsParticipate in on-call rotations as neededRequirements:Mandatory: At least 2 years of hands-on experience with Informatica PowerCenterMandatory: Minimum 2 years of...

  • Senior Oracle ERP Financial Consultant

    7 hours ago

    Yaqum, Center District, Israel ValueTech LTD Full time ₪120,000 - ₪180,000 per year

    Join the ERP team of a large, well-established retail group that operates hundreds of points of sale nationwide and is in the midst of a strategic digital transformation—including a migration from Oracle E-Business Suite to Oracle Cloud ERP.We are looking for aSenior Oracle ERP Financial Consultant.This position combines hands-on implementation of...

  • Applicative SQL Server DBA

    7 hours ago

    Petah Tikva, Center District, Israel UR Tech Jobs Full time ₪80,000 - ₪120,000 per year

    We're looking for a skilled Applicative SQL Server DBA with a strong background in system design, SQL Server development, and a deep understanding of data architecture.This position is a key role within our Data Department, which supports critical business decisions and manages complex financial processes — including reporting for...

  • Principal Cloud Architect HPC/GPU

    7 hours ago

    Center District, Israel Oracle Full time ₪120,000 - ₪180,000 per year

    Job DescriptionAbout the RoleAs a Principal Cloud Architect, you will be at the forefront of designing and implementing next generation accelerated computing and AI solutions on Oracle Cloud Infrastructure (OCI). You will engage directly with startup to strategic customers, helping them architect and deploy complex HPC and GPU clusters, AI platforms, and...