Job Description:

We are seeking an experienced Oracle Developer to design, develop, and maintain Oracle-based solutions that meet business and technical requirements. The ideal candidate will have strong expertise in PL/SQL programming, Oracle database design, and data integration. You will work closely with analysts, architects, and other developers to ensure high-performance and scalable database systems that support mission-critical applications. This role requires a solid understanding of relational databases, stored procedures, performance tuning, and experience with data migration and integration tasks.

Key Responsibilities:

• Design, write, and optimize complex SQL and PL/SQL code (procedures, functions, triggers, and packages).

• Analyze requirements and translate business logic into database solutions.

• Develop and maintain Oracle database objects such as tables, indexes, views, sequences, and synonyms.

• Perform query tuning and optimize SQL performance using explain plans and indexing strategies.

• Collaborate with application developers to integrate backend logic with front-end interfaces.

• Manage and execute data migrations, transformations, and ETL processes.

• Support and troubleshoot existing database solutions to resolve issues and improve efficiency.

• Follow coding best practices, version control, and ensure database security and compliance.

• Assist in data modeling and design of new or existing systems.

• Document technical designs, architecture, and procedures.

Professional Skills:

• Proficiency in Oracle SQL and PL/SQL

• Experience with Oracle Database (11g, 12c, 19c)

• Familiarity with Oracle development tools (e.g., SQL Developer, TOAD)

• Strong understanding of RDBMS concepts, normalization, and data integrity

• Performance tuning using Explain Plan, AWR reports, indexing, and partitioning

• Experience with data integration tools (e.g., Oracle Data Integrator, Informatica, custom ETL scripts)

• Basic scripting knowledge (Shell, Python, or PowerShell) for automation

• Experience with Oracle APEX or Forms & Reports is a plus

• Understanding of database security, roles, grants, and audit practices

• Strong analytical and problem-solving skills

• Good verbal and written communication abilities

• Ability to work both independently and collaboratively in cross-functional teams

• Detail-oriented with a commitment to data accuracy and quality

• Familiarity with Agile/Scrum or Waterfall development methodologies

• Proactive approach to identifying issues and proposing solutions.