PLSQL Developer

Key Responsibilities:

• Design, write, and maintain

  PL/SQL code

  , including stored procedures, functions, packages, and triggers.
• Optimize and tune complex SQL queries for high performance.
• Work closely with business analysts and application developers to understand data requirements.
• Develop and maintain

  ETL processes

  , data interfaces, and data migration scripts.
• Perform

  code reviews

  , troubleshoot database-related issues, and implement best practices.
• Ensure

  data integrity

  , security, and performance across systems.
• Document database designs, code logic, and solutions clearly and effectively.
• Participate in

  unit testing

  ,

  system integration testing

  , and support UAT efforts.

Required Skills & Experience:

• Proficient in

  Oracle PL/SQL

  ,

  SQL

  , and

  Oracle Database (12c/19c)

  .
• Experience writing complex queries, joins, and optimization techniques.
• Strong knowledge of

  data modeling

  ,

  normalization

  , and

  relational database concepts

  .
• Experience in

  performance tuning

  and

  query optimization

  .
• Familiarity with database tools like

  Toad

  ,

  SQL Developer

  , or

  Oracle Enterprise Manager

  .
• Solid understanding of

  SDLC

  and Agile methodologies.
• Working knowledge of

  Unix/Linux shell scripting

  is a plus.

Nice to Have:

• Experience with

  Oracle APEX

  ,

  Forms/Reports

  , or

  BI tools

  .
• Familiarity with

  ETL tools

  like Informatica, Talend, or Oracle Data Integrator (ODI).
• Exposure to

  cloud-based databases

  (e.g., Oracle Cloud, AWS RDS).
• Knowledge of version control systems like

  Git

  or

  SVN

  .