Senior Oracle PL/SQL Developer

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.

Key Responsibilities:

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).

Job Type: Full-time