This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
A Senior Oracle PL/SQL Developer with 10-12 years of experience is expected to function as a technical expert and a key contributor to application development projects. Their responsibilities go beyond basic coding to encompass design, optimization, and leadership.
Job Responsibility
Develop, test, and debug sophisticated PL/SQL packages, procedures, functions, and triggers to implement complex business logic within the database and support L2/L3 team for production issues
Act as a mentor to other developers, providing technical guidance, sharing knowledge, and fostering a culture of continuous improvement
Define and document database development standards, best practices, and reusable code libraries to improve team productivity and code quality
Work closely with frontend and backend developers, business analysts, and project managers to understand requirements and deliver integrated solutions
Act as a subject matter expert for troubleshooting complex production issues related to the database, providing timely resolution and root cause analysis
Requirements
Candidate must have at least 8-10 years of relevant experience in Oracle, plSQL, Oracle data modeling
Candidate should have worked on at least one data modeling tool – e.g. IBM Infosphere or ERWin or Toad etc
Candidate should conceptual, logical, and physical data models
Ensure data integrity, stability, and security across databases
Optimize and tune data models for performance
Identify each entity's characteristics and properties and ensure that the entities can be differentiated within the model
Develop a logical data model and validate the model to ensure that it meets the business and functional requirement
Collaborate with the BI and Analytics teams on creating the optimized, reusable semantic model, complete with metadata and lineage information
Candidate must be hands-on in plsql procedure, function, packages and trigger
Candidate must be hands-on in analytical, hierarchical queries, Aggregate Functions – especially usability
Candidate must have hands-on in various type of joins/partition/Index, views, MVs and how to maintain
Candidate must have hands-on in writing complex Queries like Nested queries, inline views, co-related subqueries etc
Bachelor's degree/University degree or equivalent experience