Oracle Developer

Role Title: Oracle Developer

Reports To:

To design, develop, and maintain Oracle-based database solutions that support business applications. The Oracle Developer is responsible for writing efficient PL/SQL code, optimizing queries, and ensuring data integrity and performance across enterprise-level systems.

Key Responsibilities:

PL/SQL Development

• Design, write, and optimize

  stored procedures

  ,

  functions

  ,

  packages

  , and

  triggers

  .
• Debug and refactor complex PL/SQL scripts.

Data Modeling & Design

• Design and update

  data models

  ,

  ER diagrams

  , and

  schemas

  based on business requirements.
• Create and manage

  tables

  ,

  indexes

  ,

  views

  , and

  constraints

  .

Performance Tuning

• Analyze and tune

  SQL queries

  for optimal performance.
• Use tools like

  Explain Plan

  ,

  SQL Trace

  ,

  TKPROF

  , and

  AWR reports

  to identify bottlenecks.

ETL and Data Integration

• Develop and manage

  data extraction, transformation, and loading (ETL)

  processes.
• Integrate Oracle DB with external systems using tools like

  Oracle Data Integrator (ODI)

  or

  custom PL/SQL scripts

  .

Application Support

• Collaborate with application developers to provide

  database support

  for Java applications.
• Investigate and resolve production issues involving database performance or data integrity.

Automation

• Implement

  audit trails

  ,

  data archival

  , and

  logging mechanisms

  .

• Documentation & Code Reviews

• Maintain clear documentation for database objects and procedures.
• Participate in

  peer reviews and

  follow

  change management processes

  .

Skills (What the personcan do)

• Expert in

  PL/SQL programming

  , stored procedures, functions, and triggers
• Skilled in

  SQL performance tuning

  and query optimization
• Experience with

  ETL development

  using Oracle Data Integrator or custom scripts
• Competent in

  data modeling

  , schema design, and normalization
• Comfortable with

  Git

  for version control and CI/CD tools
• Proficient in using Oracle tools like

  SQL Developer

  ,

  TOAD

  , and

  SQL*Plus

Knowledge (What the personknows)

• Deep understanding of

  RDBMS concepts

  , indexing, partitioning, and materialized views
• Knowledge of

  Oracle architecture

  and memory management
• Understanding of

  data lifecycle

  , archival, and backup strategies
• Awareness of

  software development life cycle (SDLC)

  and Agile methodologies
• Good grasp of

  compliance requirements

  (e.g., data protection, audit logs)

Traits (Behavioral

• Detail-oriented

  : Pays close attention to syntax, data integrity, and edge cases

• Logical thinker

  : Strong analytical and troubleshooting skills

• Persistent

  : Doesnt give up until the root cause is identified

• Organized

  : Manages scripts, schemas, and documentation systematically

• Calm under pressure

  : Handles production issues or performance bottlenecks without panic

Motive (What drives the person)

• Driven by the

  desire to build robust, error-free systems

• Motivated to

  solve complex problems

  with clean, efficient code
• Gains satisfaction from

  system stability, performance

  , and successful deployments
• Enjoys

  collaborating with cross-functional teams

  to deliver solutions
• Seeks opportunities to

  learn and implement new database features or tools